MySQL stored queries/proc with PHP

GoneShootin

So now we have MySQL 5 and everyone is singing it's praises regarding the triggers/stored procedures etc etc.

Yet I'm having alot of trouble finding practical examples of using this new funtionality through PHP.

Can anyone point me in the right direction?

Hellm0

Seeing as I'm no expert on the mysql/php mixture, I cant really be of much help but the way I allways accessed the db from php was using the pear api's, I'de check them and see if they've done anything to facilitate this new feature.

kdouglas

havent used them at all yet, but at a guess, id say you could write a php script that you could input your stored procedure into, and this would then execute it.

then after that, just call the procedure as you would any normal mysql query?

Smoggy

Again not having used MYSQL for a long time Im not going to be a lot of help, but I do seem to remember that there was a comprehensive downloadable manual for it.

GoneShootin

There exists a great MySQL document for creating and using the stored stuff, but only from within MySQL. It doesn't go into how to use them from PHP, or any other language.

Code examples is what I'm after....