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 current root password of mysql?
How to declare variable in mysql trigger?
How to show all tables with 'mysql'?
What are the different mysql database engines?
What is the difference between truncate and delete?
How many sql dml commands are supported by 'mysql'?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What are the disadvantages of mysql?
What is mysql root?
What is view? How can you create and drop view in mysql?
What is the difference between MyISAM Static and MyISAM Dynamic?
What is the difference between mysql_fetch_array and mysql_fetch_object?
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)