Page 1 of 1

PHP + loop + stored proc + text file

Posted: Sun Jul 26, 2009 11:55 pm
by lordrt
Hello all
I have a text file which contains mysql stored procedures, like, Call ImportArticles(1, Burger, 1.9)
I am trying to create a php script to read the procedure, compare the values it hold with a phpmyadmin DB in MYSQL 5.0, and accordingly do an insert or update operation using the script itself.
It has to be noted that 1 text file contains multiple stored procedures, each on a separate line, ending with a ';'

Anyone can plz send me a sample of how the code should be to call and do the necessary ops? Also the loop part when calling the SPs, am a newbie to PHP.

:banghead: