Solutions: Q & A

What is Abstract class
What is Abstract method
How to declare Abstract method
Is Abstract method can or can't implement
If we have 3 methods defined in abstract class and implemented 2 methods of them is it work
What is Interfaces
Interfaces can implement the abstract method
Interfaces can implement in same class
How do we achieve multiple inheritance (Achieve by using Trait)
Difference between interfaces and abstract
Can we create abstract methods and interfaces methods in same class
Difference between mysql fetch array and row
Difference between mysql fetch array and object
Difference between mysql fetch array and mysql fetch assoc
Types of mysql Engine
Difference between MYISAM and INNODB
Why use MyIsam not InnoDB
Feature of MyIsam And InnoDB
Which engine support Foreign Key (InnoDb or MyIsam)
Difference between GET and POST
File upload by GET and POST
php.ini tel the file upload limit change variable Name
What is MVC
Why we use MVC
What is design patterns
Concept of design pattern
Types of design patterns
How do we achieve to create design patterns
Difference between set and unset
Difference between unset and destroy
Basic configuration of Cakephp

All of the mentioned functions will return an array, the differences between them is what values that are being used as keys in the returned object.

mysql_fetch_row

This function will return a row where the values will come in the order as they are defined in the SQL query, and the keys will span from 0 to one less than the number of columns selected.
mysql_fetch_assoc

This function will return a row as an associative array where the column names will be the keys storing corresponding value.
mysql_fetch_array

This function will actually return an array with both the contents of mysql_fetch_rowand mysql_fetch_assoc merged into one. It will both have numeric and string keys which will let you access your data in whatever way you'd find easiest.

It is recommended to use either _assoc or _row though.

Difference between MYISAM and INNODB

The main differences between InnoDB and MyISAM ("with respect to designing a table or database" you asked about) are support for "referential integrity" and "transactions".

If you need the database to enforce foreign key constraints, or you need the database to support transactions (i.e. changes made by two or more DML operations handled as single unit of work, with all of the changes either applied, or all the changes reverted) then you would choose the InnoDB engine, since these features are absent from the MyISAM engine.

Those are the two biggest differences. Another big difference is concurrency. With MyISAM, a DML statement will obtain an exclusive lock on the table, and while that lock is held, no other session can perform a SELECT or a DML operation on the table.

Those two specific engines you asked about (InnoDB and MyISAM) have different design goals. MySQL also has other storage engines, with their own design goals.

Solutions