469,963 Members | 2,084 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

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

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
1 3550
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.

Similar topics

1 post views Thread by James | last post: by
3 posts views Thread by Mario Protto | last post: by
7 posts views Thread by eholz1 | last post: by
1 post views Thread by Frank Moyles | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.