Short Notes For PHP

 PHP SHORT NOTES

Multidimensional Array :   An array that contains one or more arrays.

Syntax:

$array = array(
    array(val1, val2),
    array(val3, val4)
);

//or

$array = [
    array(val1, val2),
    array(val3, val4)
];






Comments

Post a Comment

Popular posts from this blog

SQL Questions

  SQL Interview Questions Only (Organized for Preparation) Beginner Level (20 Questions) What is SQL? What are the different types of SQL commands? What is the difference between DDL and DML? What is a Primary Key? What is a Foreign Key? What is a Unique Key? What is the difference between WHERE and HAVING clause? What is a NULL value in SQL? What is a constraint? What are indexes in SQL? How to fetch unique records from a table? What is the difference between DELETE and TRUNCATE? What is the purpose of the GROUP BY clause? What is a View in SQL? What is normalization? What are the types of normalization? What is the use of the ORDER BY clause? What are aggregate functions in SQL? What is a default constraint? What are aliases in SQL? Intermediate Level (20 Questions) What are the types of JOINs in SQL? Explain INNER JOIN with an example. Explain LEFT JOIN with an example. Explain RIGHT JOIN with an examp...
Read more

SQL Beginner Interview Preparation

 Level                  Type      Beginner                             Basics (Database, Tables, Basic Queries) 📌 Key Topics You Must Prepare for SQL: SQL Basics – What is SQL, Commands (DDL, DML, DCL, TCL, DQL) Tables and Keys – Primary Key, Foreign Key, Composite Key Basic Queries – SELECT, WHERE, ORDER BY, GROUP BY, HAVING Joins – INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN Subqueries – Simple and Correlated Constraints – NOT NULL, UNIQUE, CHECK, DEFAULT Normalization – 1NF, 2NF, 3NF Indexes – Clustered, Non-Clustered Transactions – COMMIT, ROLLBACK, SAVEPOINT, Isolation Levels Views – Virtual tables using SELECT queries Stored Procedures, Functions, and Triggers Optimization Techniques – Indexing, Query Tuning Window Functions – ROW_NUMBER(), RANK(), DENSE_RANK() Backup and R...
Read more

SQL Intermediate Interview Preparation

 Level               Type 1. Difference between INNER JOIN and LEFT JOIN? ➤ INNER JOIN returns matching rows, LEFT JOIN returns all rows from the left table. 2. What is a stored procedure? ➤ A saved collection of SQL statements that can be executed repeatedly. 3. What is a trigger? ➤ A trigger automatically performs actions in response to events on a table. 4. What is an alias in SQL? ➤ Temporary name for a table or column. 5. What is UNION and UNION ALL? ➤ UNION removes duplicates, UNION ALL includes all records. 6. How to prevent SQL injection? ➤ Use prepared statements and parameterized queries. 7. What is ACID property? ➤ Atomicity, Consistency, Isolation, Durability — ensures safe database transactions. 8. What is a transaction? ➤ A sequence of operations performed as a single logical unit of work. 9. How to update data in a table? ➤ Using UPDATE statement. 10. What is a composite key? ➤ A key made of two or more colum...
Read more