+ 2

what is difference between MySQL and mysqli ?

About the project

29th May 2019, 1:55 PM
sharukh
sharukh - avatar
7 odpowiedzi
+ 4
Is that new syntax?
29th May 2019, 3:59 PM
Rizki Rivaldi
+ 8
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." 😉👍
29th May 2019, 2:18 PM
David Carroll
David Carroll - avatar
+ 6
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
29th May 2019, 1:59 PM
Prince PS[Not_Active]
Prince PS[Not_Active] - avatar
+ 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
29th May 2019, 3:30 PM
Rizki Rivaldi
+ 2
Thank you
29th May 2019, 2:01 PM
sharukh
sharukh - avatar
+ 2
$conn=@mysqli_("localhost","root","db","");
29th May 2019, 3:33 PM
sharukh
sharukh - avatar
+ 1
yea
30th May 2019, 1:17 PM
sharukh
sharukh - avatar