What is the difference between mysql query and mysqli query

It probably should be answered by the manual, but it's not very clear there, and the text of the "not constructive" close reason doesn't seem to fit it at all. Yeah, this should definitely not be closed and especially for the reasons listed to close this. I just came here for this exact question and glad I'm did. Moderators need to seriously stop being so click happy when they see a "Close" link on a post.

SazzadHossainKhan I already did, but apparently was outvoted 3 to 2 when it was reviewed by other users there's a report here, but you can probably only see it with a high-rep account. I don't think The Duke of Marshall has the reputation to cast such a vote. I also request that this question be re-opened. I believe the question is perfectly valid, and well formed. I viewed the PHP manual before coming here, and was also stymied by the explanation.

Add a comment. Active Oldest Votes. Improve this answer. Bruno Vieira 3, 1 1 gold badge 22 22 silver badges 35 35 bronze badges. Thomas Thomas 2 2 gold badges 8 8 silver badges 14 14 bronze badges. Bgi Bgi 2, 11 11 silver badges 11 11 bronze badges. Your Common Sense k 35 35 gold badges silver badges bronze badges. Marco Marco 2, 4 4 gold badges 17 17 silver badges 26 26 bronze badges.

Does not support prepared statements. MySQLi supports prepared statements. MySQL provides the procedural interface. MySQLi provides both procedural and object-oriented interface.

MySQL extension does not support stored procedure. MySQLi supports store procedure. The functions are grouped around the object by their purpose.

However, there is no significant performance difference between both the approaches. You are free to choose the interface you feel comfortable with.

It is similar to a DOS console. The SQL instructions are given as commands and the results are displayed in tabular format in the console itself. You can give certain commands with button clicks and the results are displayed on a separate results page.

There is also a programmatic interface where you can code the commands leveraging the exposed APIs. A hacker injects malicious query in user input fields, which gets executed on the server.

This leads to the compromise of data security. This ensures that the transactions are accurate, complete every time and data integrity is not compromised with.

There are APIs for enabling or disabling the auto-commit mode, committing a transaction or rolling back a transaction.

MySQL allows sending multiple statements to the server at once for execution. This saves the round-trip time from the client to the server.

All the result sets returned from the server must be consumed by the client. MySQL database has prepared statements. A prepared statement is used to execute the same query multiple times with higher efficiency.