Difference between mysql and mysqli

[Hani1991]

Hello every one
whats the difference between mysql_.... and mysqli_.... functions in PHP???
Arent they both for mysql???

[rotten69]

They are both database langauages and I think the difference between them is to do with the version of PHP that is used in the application. For example, if you're using the latest version of PHP and that is php5, you will need to use mySQLi because it's the improved and newer version of mySQL. Therefore, mySQLi gives PHP developers new features to use such as

1-Object-oriented interface .

2-Support for Prepared Statements .

3-Support for Multiple Statements .

4-Support for Transactions .

5-Enhanced debugging capabilities .

6-Embedded server support .

For more information on the differences between them and what features they offer, here is a link for you

I hope this helps you.

Thanks,

[Hani1991]

Thanks a lot