Explain the difference between mysql and mysqli interfaces
in PHP?
Answers were Sorted based on User's Feedback
Answer / guest
mysqli is the object-oriented version of mysql library
functions.
| Is This Answer Correct ? | 96 Yes | 18 No |
Answer / thaha
Mysql and Mysqli(Mysql Improved) are two library functions
( or Extension) in the PHP which is used to acces mysql
database.Mysqli is the improved version of mysql which
support OOPS. The mysqli extension allows you to access the
functionality provided by MySQL 4.1 and above.
| Is This Answer Correct ? | 85 Yes | 8 No |
Answer / mohtashim
Mysqli is nothing but an improved version Mysql which
supports oops.
| Is This Answer Correct ? | 77 Yes | 16 No |
Answer / guruprasad k.m
mysqli is the improved version of mysql and it is mainly
used for object oriented and stored procedure applications
in php.
| Is This Answer Correct ? | 27 Yes | 3 No |
Answer / sakuki
Besides being OO , mysqli allows access to new features
added to Mysql 5.0 > .
For example for using "transactions" and to execute stored
procedures from php we need mysqli. The list is lengthy .
| Is This Answer Correct ? | 31 Yes | 9 No |
Answer / ravi soam
mysqli is advance compare to mysql, it support to OOPS concept, through mysqli we can access mysql library, while using mysql we can not access all features in mysqli.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / vijay
it is nothing it is making april fool....forget.yar.
| Is This Answer Correct ? | 8 Yes | 64 No |
What are the limitations of mysql?
What are the advantages of stored procedures, triggers, indexes?
Which mysql function is used to concatenate string?
What is the data source name for mysql?
What are slow queries?
How to get a list of all tables in a database?
How do I edit a trigger in mysql?
What?s the difference between query_cache_type 1 and 2?
How do I transfer data from one database to another in mysql?
Does mysql use t sql?
What is trigger in mysql with example?
Is mysql same as mariadb?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)