naeembhatti Posted January 8, 2007 Share Posted January 8, 2007 hi friends h r u? i am new in stored procedures in mysqlplz can any body help mei need an example in which i can create simple stored procedure for select or insert records and how can i get these things in php?please help me out plz give me a brief example. Quote Link to comment https://forums.phpfreaks.com/topic/33325-how-to-create-stored-procedure-in-mysql-and-how-to-call-it-on-php/ Share on other sites More sharing options...
effigy Posted January 8, 2007 Share Posted January 8, 2007 http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.htmlOnce the SP is in MySQL, you run it by using "CALL [i]procedure_name[/i]" Quote Link to comment https://forums.phpfreaks.com/topic/33325-how-to-create-stored-procedure-in-mysql-and-how-to-call-it-on-php/#findComment-155790 Share on other sites More sharing options...
hassank1 Posted June 12, 2008 Share Posted June 12, 2008 I didn't know there's SP in mysql till now , I've developed my whole web app. using direct sql statements .. so do you advice using SP in my future work ? .. and does someone had problems using them or they work just fine ? Quote Link to comment https://forums.phpfreaks.com/topic/33325-how-to-create-stored-procedure-in-mysql-and-how-to-call-it-on-php/#findComment-563617 Share on other sites More sharing options...
naeembhatti Posted June 14, 2008 Author Share Posted June 14, 2008 no there are SP in mysql and they are perfect i used them in my application, i advise you to use them in future for best performance and your growth Quote Link to comment https://forums.phpfreaks.com/topic/33325-how-to-create-stored-procedure-in-mysql-and-how-to-call-it-on-php/#findComment-565501 Share on other sites More sharing options...
Barand Posted June 14, 2008 Share Posted June 14, 2008 Have you manged to get an SP to return a result set (without using mysqli in version 5)? Quote Link to comment https://forums.phpfreaks.com/topic/33325-how-to-create-stored-procedure-in-mysql-and-how-to-call-it-on-php/#findComment-565637 Share on other sites More sharing options...
naeembhatti Posted June 15, 2008 Author Share Posted June 15, 2008 no, i used mysqli for it Quote Link to comment https://forums.phpfreaks.com/topic/33325-how-to-create-stored-procedure-in-mysql-and-how-to-call-it-on-php/#findComment-566001 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.