By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,751 Members | 1,149 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,751 IT Pros & Developers. It's quick & easy.

mysql vs. mysqli, how to call stored procedure from php

P: n/a
Hello PHP Group,

Is there any advantages (or disadvantages) in using mysqli instead of
mysql (querys, connections to database, etc).

I am currently using mysql_connect, and things like this:
$result = @mysql_query("SELECT * FROM images3 WHERE id=" . $img . "
AND p=" .$p. "");

to access my database. I see that some people are using the
equivalent stuff but with the mysqli style, etc I know the 'i" stands
for "improved", Being new to this stuff, i wonder what the difference
might be.

Also, how do I call a stored procedure from PHP.

i have tried this, but I get errors: $result = @mysql_query("call
sp_max_records (100)");
this procedure returns the MAX(id) from my database.

Thanks for a great group - one of the most responsive.

eholz1

Feb 27 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
eholz1 wrote:
Is there any advantages (or disadvantages) in using mysqli instead of
mysql (querys, connections to database, etc).
Mysqli offers:
- Object-oriented interface
- Prepared statements
- Bound input and output parameters
- SSL connections
- Multi-query functions
- Designed to work with the version 4.1.3 or above of MySQL
Feb 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.