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 is the use of pdo?
What is the difference between BLOB AND TEXT?
Where the database is stored in mysql?
How do I rename a procedure?
How do you start MySQL on Linux?
What are the critical issues you have resolved in your company
What is row level locking in access?
Do you need a license for mysql?
How many tables will create when we create table, what are they?
How do I tune a mysql query?
How to escape special characters in sql statements?
What are the method you will follow while sql installing
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)