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. 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]" 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 ? 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 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)? 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 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
Archived
This topic is now archived and is closed to further replies.