what is difference between MySQL and mysqli ?

Question

About the project

Answer 1

Is that new syntax?

Answer 2

Prince PS Wow... while I always knew that the extension ending with "i" was the relatively newer version, I had no idea it stood for "improved." 😉👍

Answer 3

The "i" stands for "improved".

MySQLi is the OOP version of MySQL extension. In the end, MySQLi and MySQL accomplish the same thing: they are extension for interacting with MySQL from PHP. A lot of people still use the original MySQL extension instead of the new MySQLi extension because MySQLi requires MySQL 4.1.13+ and PHP 5.0.7+ .

Refer to these threads for more information :

https://www.quora.com/What-is-the-difference-between-MySQL-and-mysqli

https://stackoverflow.com/questions/14151458/difference-between-mysql-mysqli

Thanks

Answer 4

I think MySQLi and MySQL almost same and there's any little different syntax. Example :

For connection to mysql :
mysql_connect($host, $username, $password, $database);
For query syntax :
mysql_query('string query');

For connection to mysql using mysqli :
$conn = mysqli_connect($host, $username, $password, $database, TRUE);
For query syntax :
mysqli_query($conn, 'string query'); // here's different

For mySQLi, just add $conn as new one parameter
Thanks

Answer 5

Thank you

Answer 6

$conn=@mysqli_("localhost","root","db","");

Answer 7

yea