logo Online Learner
  • Home
  • Learning Paths
  • Development
    Frontend Development Backend Development
  • Study Notes
  • Free Resume Builder
  • About Us
  • Contact Us
  • Login
  • Sign Up
  1. Learning Paths
  2. TypeScript Tutorial
  3. TypeScript Interfaces

TypeScript Interfaces

A TypeScript interface describes the shape of an object. It lists the property names and their types, so the compiler can check that every object you create or pass around matches that shape. Interfaces are one of the most-used features in real projects because they document data and catch mistakes early.

This tutorial covers how to define interfaces, add optional and readonly properties, describe function types, use index signatures, extend one or more interfaces, merge declarations, and implement an interface in a class. You will also see a clear comparison of interface vs type alias and the common excess property check error.

What Is a TypeScript Interface?

A TypeScript interface is a named contract that defines which properties an object must have and what type each property holds. It exists only at compile time. When the code compiles to JavaScript, the interface disappears completely.

Here is a simple example:

interface User {
  name: string;
  age: number;
}

const user: User = { name: "Riya", age: 28 };
console.log(user.name);

// Output: Riya

The user object must have a name string and an age number. If you leave one out or use the wrong type, the compiler reports an error before the code runs.

How Do You Define Object Shapes with an Interface?

An interface body lists properties as name: type pairs, separated by semicolons. You can include as many properties as you need. This shape is then reused everywhere the object travels, from function parameters to array elements.

interface Product {
  id: number;
  title: string;
  price: number;
}

const item: Product = { id: 101, title: "Notebook", price: 60 };
console.log(item);

// Output: { id: 101, title: 'Notebook', price: 60 }

How it works: The Product interface describes three required properties. The object assigned to item must contain all three with the correct types. TypeScript does not create a class or a runtime object; it only checks the shape. The compiled JavaScript contains only the object literal.

How Do Optional and readonly Properties Work?

An optional property uses ? after the name and may be missing when you create the object. A readonly property cannot be reassigned after the object is created. Both are useful in real data, such as a nickname that may be empty or an id that must not change.

interface User {
  readonly id: number;
  name: string;
  nickname?: string;
}

const user: User = { id: 1, name: "Arjun" };
user.name = "Arjun Kumar";

// user.id = 2;
// Error: Cannot assign to 'id' because it is a read-only property.

console.log(user.nickname ?? "no nickname");

// Output: no nickname

How it works: The id is readonly, so any assignment after creation fails at compile time. The nickname? is optional, so the object is valid without it. Reading user.nickname gives string | undefined, and the ?? operator provides a fallback. This pattern is everywhere in real projects.

How Do You Write a Function Type Interface?

An interface can describe a function type by listing the parameter types and the return type inside a call signature. You then use the interface as the type of a variable that holds a function.

interface Formatter {
  (value: number): string;
}

const currency: Formatter = (value) => `Rs ${value}`;

console.log(currency(499));

// Output: Rs 499

How it works: The (value: number): string line is a call signature. Any function assigned to a Formatter must accept a number and return a string. The parameter value in the arrow function gets its type from the interface through contextual typing, so you do not need to write it again. If the function returned a number, the compiler would reject it.

What Are Index Signatures?

An index signature describes an object whose property names are not known in advance but whose values share a type. It looks like [key: string]: type. This is common for dictionaries, maps of settings, or lookup tables.

interface Scores {
  [subject: string]: number;
}

const marks: Scores = {
  maths: 92,
  science: 88,
  english: 75,
};

console.log(marks["science"]);

// Output: 88

How it works: The signature [subject: string]: number says every property key is a string and every value is a number. You can add any subject without changing the interface. A key with a non-number value would be rejected. Index signatures are useful, but they weaken type safety because a typo in a key still compiles, so use them for genuinely dynamic data.

How Do You Extend Interfaces?

An interface can extend another interface, which means it inherits all the properties and adds new ones. You can extend multiple interfaces at once, which lets you combine small pieces into a bigger shape. This keeps definitions focused.

interface Person {
  name: string;
  age: number;
}

interface Employee {
  company: string;
  salary: number;
}

interface Manager extends Person, Employee {
  teamSize: number;
}

const manager: Manager = {
  name: "Meera",
  age: 35,
  company: "Acme",
  salary: 90000,
  teamSize: 8,
};

console.log(manager);

// Output: { name: 'Meera', age: 35, company: 'Acme', salary: 90000, teamSize: 8 }

How it works: Manager extends both Person and Employee, so it must contain all five properties. If Person had an optional nickname, Manager would inherit that too. Multiple extension is a clean way to compose types without repeating property definitions.

What Is Declaration Merging?

Declaration merging means two interfaces with the same name in the same scope are combined into one. This is unique to interfaces; type aliases do not merge. It is used by libraries to let you add fields to an existing type.

interface Settings {
  theme: string;
}

interface Settings {
  fontSize: number;
}

const config: Settings = { theme: "dark", fontSize: 14 };
console.log(config);

// Output: { theme: 'dark', fontSize: 14 }

How it works: TypeScript sees two declarations of Settings and merges their properties. The resulting type has both theme and fontSize. This feature helps when you want to extend a library's interface from your own file without modifying the library. For most application code, prefer extends because merged declarations can be harder to track.

How Do Classes Implement Interfaces?

A class can implement an interface, which means the class promises to provide every property and method the interface describes. The compiler checks the class body against the interface.

interface Named {
  name: string;
  greet(): string;
}

class Student implements Named {
  constructor(public name: string) {}

  greet(): string {
    return `Hello, I am ${this.name}.`;
  }
}

const s = new Student("Anaya");
console.log(s.greet());

// Output: Hello, I am Anaya.

How it works: The implements Named clause tells TypeScript to check that Student has a name property and a greet method. The constructor(public name: string) shorthand creates the property automatically. If you removed greet, the compiler would report an error. You can learn more about class syntax in the Classes in TypeScript tutorial.

What Is the Excess Property Check Error?

When you assign an object literal to an interface-typed variable, TypeScript checks that every property in the literal is expected. This is called an excess property check. It catches typos and stale fields.

interface User {
  name: string;
  age: number;
}

// const user: User = { name: "Riya", age: 28, email: "r@x.com" };
// Error: Object literal may only specify known properties, and 'email' does not exist in type 'User'.

const user: User = { name: "Riya", age: 28 };
console.log(user.name);

// Output: Riya

How it works: The object literal includes email, which is not part of User. The compiler rejects the assignment. This check applies only to object literals. If the object comes from a variable of a wider type, extra properties are allowed by structural typing, because TypeScript only cares that the required properties exist. Add email to the interface if the field is legitimate.

Interface vs Type Alias: Which Should You Use?

Feature Interface Type Alias
Describe object shapes Yes Yes
Union types No Yes
Extend multiple shapes Yes (extends A, B) Yes (A & B)
Declaration merging Yes No
Implements in a class Yes Yes
Function types Yes (call signature) Yes
Best for Object contracts, public APIs Unions, mapped types, primitives

A practical recommendation: use an interface for object shapes that may be extended or implemented, especially in public APIs. Use a type alias when you need unions, intersections, or mapped types. Both are valid, and teams often use both. The Type Aliases & Union Types tutorial covers the other side in depth.

Common Mistakes and Best Practices

  • Using an interface for a union. Interfaces cannot represent "yes" | "no". Reach for a type alias when you need a union, and keep interfaces for object shapes.
  • Forgetting the ? on optional fields. A required property forces every caller to supply it. If a field is genuinely optional in your data, mark it with ? so callers are not forced to invent a value.
  • Assuming readonly prevents all changes. readonly blocks reassignment of the property, but if the value is an object or array, its contents can still change. Use readonly arrays or deep-freeze patterns when full immutability matters.
  • Relying on index signatures for known data. [key: string]: number accepts any key, so typos compile. Use explicit properties when the keys are known and reserve index signatures for dynamic maps.
  • Getting surprised by the excess property check. It only fires on object literals. Copying the same object into a variable first bypasses the check. Do not rely on this as a workaround; fix the interface instead.

Real-World Example: A User and Admin Model

This example brings together optional and readonly fields, interface extension, and the excess property error.

interface User {
  readonly id: number;
  name: string;
  email: string;
  nickname?: string;
}

interface Admin extends User {
  permissions: string[];
}

const basicUser: User = {
  id: 1,
  name: "Rohit",
  email: "rohit@example.com",
};

const admin: Admin = {
  id: 2,
  name: "Sana",
  email: "sana@example.com",
  nickname: "san",
  permissions: ["users:read", "users:write"],
};

function display(user: User): void {
  const nick = user.nickname ?? "none";
  console.log(`#${user.id} ${user.name} (${nick})`);
}

display(basicUser);
display(admin);

// const broken: User = { id: 3, name: "A", email: "a@x.com", role: "admin" };
// Error: Object literal may only specify known properties, and 'role' does not exist in type 'User'.

// Output:
// #1 Rohit (none)
// #2 Sana (san)

How it works, line by line. The User interface has a readonly id, required name and email, and an optional nickname. The Admin interface extends User and adds a permissions array. The basicUser object omits nickname, which is allowed. The admin object includes it. The display function accepts a User, and because Admin extends User, an Admin object is also accepted. Inside, user.nickname ?? "none" handles the optional field safely. The commented line shows the excess property error: role is not in User, so the compiler rejects the literal. If you genuinely need a role, add it to the interface instead of removing the check.

Summary

  • A TypeScript interface describes the shape of an object and disappears at compile time.
  • Optional properties use ?; readonly properties block reassignment after creation.
  • Interfaces can describe function types with a call signature and dynamic objects with index signatures.
  • Use extends to build larger interfaces from smaller ones, including multiple parents.
  • Declaration merging combines interfaces with the same name; classes can implement an interface.
  • Prefer interfaces for object contracts and public APIs; use type aliases for unions and advanced types.

Now that you can model object shapes, continue to the Type Aliases & Union Types tutorial to learn how to create flexible types that combine several possibilities.

Frequently Asked Questions

When should I use an interface instead of a type alias?

Use an interface when you are describing the shape of an object that may be extended or implemented by a class, especially in a public API. Use a type alias when you need a union, an intersection, or a mapped type. Both work for simple object shapes, so pick the one that matches your team's style.

Can an interface have optional methods?

Yes. Write the method with a ? after its name, such as greet?(): string. Callers must check that the method exists before calling it, usually with if (obj.greet). The compiler then narrows the type and allows the call. This is useful for optional callbacks in configuration objects.

Why does TypeScript complain about an extra property in my object?

That is the excess property check. When you assign an object literal directly to an interface-typed variable, TypeScript rejects properties that are not in the interface. It catches typos and stale fields. To fix it, either remove the extra property or add it to the interface if it is genuinely part of the shape.

What is the difference between interface and class in TypeScript?

An interface exists only at compile time and describes a shape. A class exists at runtime and can create objects with methods and a constructor. A class can implement an interface to promise it matches the shape. Use an interface to describe data and a class when you need runtime behavior or instances.

Can I extend a type alias with an interface?

No, an interface can only extend another interface or a type that is statically known, such as an object type alias. It cannot extend a union type alias. If you need to build on a union, use an intersection type with a type alias instead of an interface.

Practice Exercises

Exercise 1 (Easy): Define a Basic Interface

Create an interface called Book with title: string, author: string, and pages: number. Create one object that matches it and print the title.

Show solution
interface Book {
  title: string;
  author: string;
  pages: number;
}

const novel: Book = { title: "Wings", author: "A. Rao", pages: 320 };
console.log(novel.title);

// Output: Wings

The object must contain all three properties with the correct types, or the compiler reports an error.

Exercise 2 (Easy): Add Optional and readonly Fields

Extend the Book interface so subtitle is optional and isbn is readonly. Show that reassigning isbn produces an error.

Show solution
interface Book {
  readonly isbn: string;
  title: string;
  subtitle?: string;
}

const novel: Book = { isbn: "978-93-000", title: "Wings" };

// novel.isbn = "978-93-001";
// Error: Cannot assign to 'isbn' because it is a read-only property.

console.log(novel.subtitle ?? "no subtitle");

// Output: no subtitle

The optional subtitle can be omitted, and the readonly isbn cannot be reassigned after creation.

Exercise 3 (Medium): Extend an Interface

Create Person with name and age. Create Employee that extends Person and adds company. Build an Employee object and print all fields.

Show solution
interface Person {
  name: string;
  age: number;
}

interface Employee extends Person {
  company: string;
}

const emp: Employee = { name: "Nisha", age: 29, company: "Acme" };
console.log(emp.name, emp.age, emp.company);

// Output: Nisha 29 Acme

Employee inherits name and age from Person, so the object must include all three properties.

Exercise 4 (Challenge): Index Signature and Interface Implementation

Create an interface Config with an index signature [key: string]: string. Create a class Settings that implements Config and stores the values in an object. Add two keys and print one.

Show solution
interface Config {
  [key: string]: string;
}

class Settings implements Config {
  [key: string]: string;

  constructor(theme: string, lang: string) {
    this.theme = theme;
    this.lang = lang;
  }
}

const s = new Settings("dark", "en");
console.log(s.theme);

// Output: dark

The index signature allows any string key with a string value. The class uses the same signature and assigns two keys in the constructor.



Shaikh Abdul Shahid
Written by Shaikh Abdul Shahid

A Full-Stack Developer with experience in PHP, Laravel, JavaScript, and React.
Founder of Online Learner, sharing practical knowledge and programming tutorials.
Building and maintaining real-world web applications since 2017.

GitLab LinkedIn
X
0 likes
Your Feedback

Help us improve by sharing your thoughts.

IT and Digital Marketing
keyboard_arrow_left Previous
Next keyboard_arrow_right
Online Learner Logo

Online Learner helps developers master programming, database concepts, interview preparation, and real-world implementation through structured learning paths.

Quick Links

  • Frontend Development
  • Backend Development
  • Learning Paths
  • Notes
  • Free Resume Builder
  • Portfolio

Company

  • About Us
  • Contact Us
  • Terms & Conditions
  • Disclaimer

© 2023 - 2026 OnlineLearner.in | All Rights Reserved.

logo
  • code Frontend
  • storage Backend
  • live_help Interviews
  • work_outline PHP Frameworks
  • settings Routine Use
  • book Blogs
Frontend
  • HTML Tutorial
    • HTML Introduction
    • HTML Tags
    • HTML Elements
    • HTML Attributes
    • HTML Heading
    • HTML Paragraph
    • HTML Formatting
    • HTML Quotations
    • HTML Comments
    • HTML Styles
    • HTML Color
    • HTML CSS
    • HTML Images
    • HTML Favicon
    • HTML Links
    • HTML DIV
    • HTML Tables
    • HTML Table Size
    • HTML Table Head
    • Table Padding & Spa...
    • Table colspan rowspsn
    • HTML Table Styling
    • HTML Colgroup
    • HTML List
    • HTML Block & Inline
    • HTML Classes
    • HTML Id
    • HTML Iframes
    • HTML Head
    • HTML Layout
    • HTML Semantic Elements
    • HTML Style Guide
    • HTML Forms
    • HTML Form Attribute
    • HTML Form Element
    • HTML input type
    • HTML Computer code
    • HTML Entity
    • HTML Symbol
    • HTML Emojis
    • HTML Charset
    • HTML Input Form Att...
    • HTML URL Encoding
  • CSS Tutorial
    • CSS Introduction
    • CSS Syntax
    • CSS Selector
    • How To Add CSS
    • CSS Comments
    • CSS Colors
    • CSS Background color
    • CSS background-image
    • CSS Borders
    • CSS Margins
    • CSS Height, Width a...
    • CSS Box Model
    • CSS Outline
    • CSS Text
    • CSS Fonts
    • CSS Icon
    • CSS Links
    • CSS Tables
    • CSS Display
    • CSS Maximum Width
    • CSS Position
    • z-index Property
  • JavaScript Tutorial
    • What is JavaScript
    • JS Syntax
    • JS Variables
    • JS Data Types
    • JS Operators
    • JS Control Flow - IF
    • JS Control Flow - S...
    • JS Control Flow - Loop
    • JS Function
    • JS Object Methods
    • JS Anonymous Funct...
    • JS Recursive Function
    • JS Default Parameters
    • JS this Keyword
    • What is an Array in...
    • What are JavaScript...
    • Error Handling in J...
    • DOM Selection in Ja...
    • DOM Traversal in Ja...
    • Manipulating Elemen...
    • Event Handling in J...
    • JavaScript Event Li...
    • JavaScript Event Pr...
    • Form Handling in Ja...
    • Dynamic Styling in ...
    • JavaScript DOM Elem...
    • Window Object in Ja...
    • What is Local Storage?
    • Regular Expressions...
  • Jquery Tutorial
    • What is jQuery?
    • Benefits of using j...
    • Include jQuery
    • Selectors.
    • Methods.
    • The $ symbol and sh...
    • Selecting elements
    • Getting and setting...
    • Adding and removing...
    • Modifying CSS and c...
    • Binding and Unbindi...
    • Common events: clic...
    • Event delegation
    • Using .on() for dyn...
    • Showing and hiding ...
    • Fading elements in ...
    • Sliding elements up...
    • .animate()
    • Understanding AJAX
    • .ajax()
    • .load(), .get(), .p...
    • Handling responses ...
    • Parent
    • Chlid
    • Siblings
    • Filtering Elements
    • Using find
    • Selecting form elem...
    • Getting form values
    • Setting form values
    • Form validation
    • Handling form submi...
    • jQuery plugins
    • Sliders plugins
    • $.each()
    • $.trim()
    • $.extend()
    • Data attributes
    • Debugging jQuery code
  • Bootstrap 4
    • What is Bootstrap
    • Benefits of using
    • Setting up
    • Container
    • Row and Column
    • Grid Classes
    • Breakpoints
    • Offsetting Columns
    • Column Ordering
    • Basic Typography
    • Text Alignment
    • Text colors
    • Backgrounds
    • Display
    • Font Size Utilities
    • Buttons
    • Navs and Navbar
    • Forms
    • Cards
    • Alerts
    • Badges
    • Progress Bars
    • Margin
    • Padding
    • Sizing
    • Flexbox
    • Dropdowns
    • Modals
    • Tooltips
    • Popovers
    • Collapse
    • Carousel
    • Images
    • Tables
    • Jumbotron
    • Media Object
  • Git
    • Understanding Versi...
    • Download and Instal...
    • Git Configure
    • Git Initialize
    • Add Changes to Staging
    • Commit Changes
    • Branching
    • Merging
    • Remote Repository
    • Understanding Git C...
    • Stashing Changes
    • Viewing Commit History
    • Undoing Changes
  • Ajax Tutorial
    • Ajax Fundamentals
    • Ajax Working
    • XMLHttpRequest Fetch
    • Synchronous vs Asyn...
    • Ajax Advantages
    • Ajax Disadvantages
    • $.ajax() method
    • Ajax GET request
    • Ajax POST Request
    • Json Response
    • Ajax Errors
    • Ajax Form
  • React Tutorial
    • What is React? Begi...
    • React Environment S...
    • React Fundamentals:...
    • Functional vs Class...
    • Props in React Expl...
    • State and setState ...
    • React Event Handling
    • React Conditional R...
    • React Lists and Keys
    • Styling in React In...
    • Styling in React Us...
    • Styling in React Us...
    • Tailwind CSS with R...
    • Tailwind vs CSS Mod...
    • React Hooks
    • React useState Hook
    • React useEffect Hook
    • React useRef Hook
    • React useContext Hook
    • React useReducer Hook
    • Custom Hooks in React
    • React Router – In...
    • Installing React Ro...
    • React Router – Ro...
    • React Router – Ne...
    • React Router URL Pa...
    • React Router Protec...
    • React Router Redire...
    • State Management in...
    • Redux State Managem...
    • Redux Toolkit Expla...
    • Redux Toolkit vs Re...
    • Controlled vs Uncon...
    • Handling Form Input...
    • API Integration in ...
    • Axios in React – ...
    • Handling Loading an...
    • Async Await in Java...
    • Displaying API Data...
    • CRUD Operations in ...
    • React Performance O...
    • React Performance O...
  • Tailwind
    • Introduction to Tai...
    • Utility-First CSS E...
    • Tailwind CSS vs Boo...
    • When and Why to Use...
    • Real-World Use Case...
    • Tailwind CSS Instal...
    • Installing Tailwind...
    • Tailwind CSS with V...
    • Setting Up Tailwind...
    • Install Tailwind CS...
    • Tailwind CSS Colors...
    • Tailwind CSS Backgr...
    • Tailwind CSS Paddin...
    • Tailwind CSS Margin...
    • Tailwind CSS Width ...
    • Tailwind CSS Height...
    • Tailwind CSS Border...
    • Tailwind CSS Border...
    • Tailwind CSS Text S...
    • Tailwind CSS Box Sh...
    • Tailwind CSS Opacit...
    • Tailwind CSS Cursor...
    • Tailwind CSS Overfl...
    • Tailwind CSS Font S...
    • Tailwind CSS Font W...
    • Tailwind CSS Text A...
    • Tailwind CSS Line H...
    • Tailwind CSS Letter...
    • Tailwind CSS Text T...
    • How to Use Google F...
    • Flexbox with Tailwi...
    • Justify Content in ...
    • Align Items in Tail...
    • Flex Direction in T...
    • Gap in Tailwind CSS...
    • Flexbox with Tailwi...
    • Grid System in Tail...
    • Grid System in Tail...
    • Responsive Design i...
    • Positioning & Z-Ind...
    • Background Colors i...
    • Background Images i...
    • Gradients in Tailwi...
    • Image Object-Fit in...
    • Image Overlay Effec...
    • Buttons in Tailwind...
    • Hover & Focus State...
    • Buttons and Forms i...
    • Cards and Sections ...
    • Navbar and Footer D...
  • TypeScript Tutorial
    • TypeScript Introduc...
    • TypeScript Installa...
    • First TypeScript Pr...
    • TypeScript Basic Types
    • Type Inference and ...
    • TypeScript Arrays a...
    • TypeScript Enums
    • TypeScript Any, Unk...
    • TypeScript Interfaces
    • Type Aliases and Un...
    • Intersection Types
    • Literal Types
    • Functions in TypeSc...
    • Classes in TypeScript
    • Access Modifiers an...
    • Abstract Classes
    • TypeScript Generics
    • TypeScript Utility ...
Backend
  • PHP Tutorial
    • PHP Introduction
    • PHP Installation
    • PHP Syntax
    • PHP Comments
    • PHP Variable
    • PHP Echo
    • PHP Data Types
    • PHP Strings
    • PHP Constant
    • PHP Maths
    • PHP Number
    • PHP Operators
    • PHP if else & if el...
    • PHP Switch
    • PHP Loops
    • PHP Functions
    • PHP Array
    • PHP OOps
    • PHP Class & Object
    • PHP Constructor
    • PHP Destructor
    • PHP Access Modfiers
    • PHP Inheritance
    • PHP Final Keyword
    • PHP Class Constant
    • PHP Abstract Class
    • PHP Superglobals
    • PHP Regular Expression
    • PHP Interfaces
    • PHP Static Method
    • PHP Static Properties
    • PHP Namespace
    • PHP Iterable
    • PHP Form Introduction
    • PHP Form Validation
    • PHP Complete Form
    • PHP Date and Time
    • PHP Include Files
    • PHP - Files & I/O
    • File Upload
    • PHP Cookies
    • PHP SESSION
    • PHP Filters
    • PHP Callback Functions
    • PHP JSON
    • PHP AND Exceptions
    • PHP Connect database
  • PHP Functions
    • strlen
    • strtoupper
    • strtolower
    • ucfirst
    • ucwords
    • substr
    • str_replace
    • strpos
    • trim in php
    • explode
    • implode
    • count in php
    • array_merge
    • array_push
    • array_pop
    • array_shift
    • array_unshift
    • in_array
    • array_keys
    • array_values
    • array_filter
    • array_map
    • sort
    • asort
    • ksort
    • abs
    • round
    • ceil
    • floor
    • rand
    • mt_rand
    • max
    • min
    • pow
    • sqrt
    • date
    • time
    • strtotime
    • mktime
    • date_diff
    • getdate
    • fopen
    • fread
    • fwrite
    • fclose
    • file_get_contents
    • file_put_contents
    • file_exists
    • unlink
    • filesize
    • is_readable
    • is_writable
    • urlencode
    • urldecode
    • parse_url
    • http_build_query
    • isset
    • empty
    • is_numeric
    • is_array
    • is_string
    • filter_var
    • htmlspecialchars
    • md5
    • sha1
    • password_hash
    • password_verify
    • die
    • exit
    • var_dump
    • print_r
    • include
    • require
    • json_encode
    • json_decode
    • sleep
  • PHP and MySQL Functions
    • mysqli_connect
    • mysqli_select_db
    • mysqli_query
    • mysqli_prepare
    • mysqli_stmt_execute
    • mysqli_multi_query
    • mysqli_fetch_assoc
    • mysqli_fetch_array
    • mysqli_fetch_row
    • mysqli_fetch_object
    • mysqli_num_rows
    • mysqli_real_escape_...
    • mysqli_insert_id
    • mysqli_affected_rows
    • mysqli_error
    • mysqli_close
    • mysqli_commit
    • mysqli_rollback
  • Python Tutorial
    • What is Python?
    • Install Python on W...
    • Install Python on L...
    • Install Python on m...
    • IDE Setup
    • Python syntax
    • Python Comments
    • Python Indentation
    • Python Variables
    • Python Data Types
    • Python Numeric
    • Python Boolean
    • Python String
    • Python List
    • Python Tuple
    • Python Range
    • Python Dictionary
    • Python Arithmetic O...
    • Python Assignment O...
    • Python Comparison O...
    • Python Logical Oper...
    • Python Bitwise Oper...
    • Python if condition
    • Python if else cond...
    • Python For Loop
    • Python While Loop
    • Python break, conti...
  • MYSQL
    • SQL Introduction
    • Syntax
    • Select statement
    • Select Distinct
    • WHERE Clause
    • Order By
    • SQL AND Operator
    • SQL OR Operator
    • SQL NOT Operator
    • SQL LIKE
    • SQL IN
    • SQL BETWEEN
    • SQL INSERT INTO
    • SQL NULL Values
    • SQL UPDATE
    • SQL DELETE
    • SQL TOP, LIMIT, FET...
    • SQL MIN() and MAX()...
    • SQL COUNT() Function
    • SQL SUM()
    • SQL AVG()
    • SQL Aliases
    • SQL JOIN
    • SQL INNER JOIN
    • SQL LEFT JOIN
    • SQL RIGHT JOIN
    • SQL FULL OUTER JOIN
    • SQL Self Join
    • SQL UNION
    • SQL GROUP BY
    • SQL HAVING
    • SQL EXISTS
    • SQL ANY and ALL
    • SQL SELECT INTO
    • SQL INSERT INTO SELECT
    • SQL CASE
    • SQL NULL Functions
    • SQL Stored Procedures
    • SQL Comments
    • SQL Operators
    • SQL CREATE DATABASE
    • SQL DROP DATABASE
    • SQL BACKUP DATABASE
    • SQL CREATE TABLE
    • SQL DROP TABLE
    • SQL ALTER TABLE
    • SQL Constraints
    • SQL NOT NULL
    • SQL UNIQUE Constraint
    • SQL PRIMARY KEY
    • SQL FOREIGN KEY
    • SQL CHECK Constraint
    • SQL CREATE INDEX
    • SQL AUTO INCREMENT
    • SQL Dates
    • SQL Views
    • SQL Injection
    • SQL Hosting
    • SQL Data Types
  • Node Js
    • What is Node.js?
    • Why use Node.js?
    • Installing Node.js
    • First Node.js progr...
    • Event Loop
    • Understanding npm
    • What are Modules?
    • fs (File System)
    • Http Module
    • Path Module
    • Creating custom mod...
    • Exporting and impor...
    • Setting up a basic ...
    • Handling requests a...
    • Serving HTML
    • Serving CSS
    • Serving JavaScript
  • Python MySQL
    • Database Connection
    • Table Creation
    • Insert Query
    • Select Query
    • Update Query
    • Delete Query
    • Where Clause Query
    • Limit Clause Query
    • Join Tables
    • Order By Query
    • Group By Query
    • Aggregate Functions
    • Parameterized Query
  • Java Tutorials
    • Java Introduction
    • Java Installation
    • Java Syntax
    • Java Comments
    • Java Variables
    • Java DataTypes
    • Java Operators
    • Java Conditionals
    • Java Looping
    • Java Arrays
    • Java Methods
    • Java Classes
    • Java Objects
    • Java Constructors
    • Java Inheritance
    • Java Polymorphism
    • Java Encapsulation
    • Java Abstraction
    • Java Exception
    • Java Interfaces
    • Java File Handling
    • Java Threads
    • Java Access Modifiers
    • Java Static Keyword
    • Java Final Keyword
    • Java Nested Class
    • Java Synchronization
  • Docker
    • Introduction to Docker
    • Installing Docker
    • Docker Architecture
    • Docker Images
    • Docker Containers
    • Dockerfile Basics
    • Docker Volumes
    • Docker Networking
    • Docker Compose
    • Docker Hub & Registry
    • Multi-Stage Builds
    • Docker with Nginx
    • Docker with MySQL
    • Docker with PHP & L...
    • Docker Environment ...
    • Docker Logs & Debug...
    • Docker Security Bes...
    • Docker Swarm Basics
    • Docker vs Virtual M...
    • Real World Docker P...
Interviews
  • PHP Interviews
    • What is PHP?
    • What does PHP stand...
    • PHP Advantages
    • Difference between ...
    • Start a PHP script?
    • Commenting in PHP
    • Variable in PHP
    • Different types of ...
    • Different types of ...
    • Array in PHP
    • Difference between ...
    • Retrieve data from ...
    • PHP handle errors
    • Sessions in PHP
    • PHP Cookie
    • What are the main f...
    • What are the differ...
    • What are the differ...
  • Java Interview Questions
    • Java Basics – Wha...
    • What is the differe...
    • What are the OOP co...
    • Why is the main met...
    • What are the differ...
    • What is the differe...
    • What is Method Over...
    • What is the Differe...
    • What is the Constru...
    • What are the Access...
    • What is the this Ke...
    • What is the super K...
    • What is the static ...
    • What is the final K...
    • What is Exception H...
    • What are Checked an...
    • What is the Differe...
    • What are Multithrea...
    • What is the Java Co...
    • What is the Differe...
    • What is the Differe...
    • What is the Differe...
    • What is the Differe...
    • How Does HashMap Wo...
    • What is the Differe...
    • What is the Differe...
    • What is the String ...
    • What is the Differe...
    • What is Garbage Col...
    • What is the Differe...
    • What is a Lambda Ex...
    • What is the Stream ...
    • What are Optional C...
    • What is the Differe...
    • What are the Key Fe...
    • What is the Record ...
  • React Interviews
    • What is React.js
    • Help In Interviews
    • Features of React
    • What is JSX
    • React's Virtual DOM
    • State and Props
    • React handle data b...
    • React Component
    • setState() method.
    • Controlled Components
    • Lifecycle Methods
    • Significance of keys
    • What are the differ...
  • Laravel Interviews
    • What is Laravel?
    • What are the key fe...
    • Explain the concept...
    • What is a controlle...
    • What is Blade templ...
    • How does Eloquent O...
    • Explain the concept...
    • What are middleware...
    • How do you create a...
    • What is CSRF protec...
    • What is the purpose...
    • What is the purpose...
    • Explain the concept...
    • How do you create a...
    • What is the purpose...
    • How do you define r...
    • What are named rout...
    • Explain the use of ...
    • What is the purpose...
    • What are service pr...
  • SQL Interviews
    • What is SQL?
    • What are the differ...
    • What is the differe...
    • What is a primary key?
    • What is a foreign key?
    • What are the differ...
    • What is the differe...
    • What is the use of ...
    • What is the differe...
    • What is an index in...
    • What types of index...
    • What is a subquery?
    • How do you use the ...
    • How can you find th...
    • Explain the use of ...
    • What is a view?
    • What are the limita...
    • Write a query to fe...
    • Write a query to fe...
    • Write a query to co...
    • Write a query to fe...
    • Write a query to fe...
    • Write a query to fi...
    • Write a query to fe...
    • Write a query to re...
    • Write a query to ge...
    • Write a query to ge...
    • Write a query to li...
    • Write a query to fi...
    • Write a query to fi...
    • Write a query to ge...
    • Write a query to fi...
    • Write a query to co...
    • Write a query to fi...
    • Write a query to li...
    • Write a query to fe...
    • Write a query to fi...
    • Write a query to fe...
    • Write a query to ge...
    • Write a query to co...
    • Write a query to fe...
  • JavaScript Interview Questions
    • What Exactly is Jav...
    • What are the data t...
    • What is the differe...
    • JavaScript double e...
    • What is a Closure i...
    • What is Hoisting in...
    • Understanding "this...
    • What Are JavaScript...
    • Null vs Undefined i...
    • How Does JavaScript...
    • What is a Promise i...
    • Async/Await in Java...
    • Event Delegation in...
    • JavaScript Modules ...
    • How to Prevent a Fu...
    • JavaScript Intervie...
    • JavaScript Intervie...
    • What is bind() in J...
    • Event Bubbling vs. ...
    • Deep Copy vs Shallo...
    • What is the new Key...
PHP Frameworks
  • Laravel
    • Laravel Topics
    • Laravel 7 Installation
    • Install laravel 8
    • Laravel 8 Routing
    • Laravel Controllers
    • Views and Blade lar...
    • Database and Eloque...
    • Authentication and ...
    • CSRF Protection
    • Laravel Model
    • Database: Query Bui...
Routine Use
  • Linux
    • How to Delete a Fil...
    • Install lemp in ubu...
    • How to check packag...
    • Navigating the File...
    • Managing Files and ...
    • Viewing and Editing...
    • Managing Processes ...
    • Scheduling Tasks wi...
    • Disk Usage Analysis...
    • File and Directory ...
Blogs
  • Blogs
    • Free Hosting on AWS...
    • What is SEO?
    • Zoho Free Mail
    • Speed Up Your Appli...
    • What is a JavaScrip...
    • Laravel vs Lumen: T...
    • MySQL vs PostgreSQL...
    • Automate Free MySQL...
    • How to Use Google A...
    • What is n8n?
    • Cloud Platform Comp...
    • Top Common Mistakes...
    • PHP 8.5: The Pipeli...
    • Google Antigravity ...
    • How to Optimize Que...
    • React vs Angular vs...
    • Base44: Features, P...
    • Difference Between ...
    • HTTP Status Codes E...
    • Build Native Mobile...
    • Top 10 JavaScript F...
    • JIRA, Waterfall, an...
    • WebSockets in Moder...
    • A Complete Real-Wor...
    • Why Developers Shou...
    • Service-Based Compa...
    • Bootstrap vs Tailwi...
    • Direct Prompt vs St...
    • Top 25 SEO HTML Tag...
    • Docker Commands Che...
    • Authentication vs A...
    • Top AI Portals in 2...
    • What is Replit? Com...
    • Laravel 13 Released...
    • NEET Paper Leak Pre...