cybercookie72 Posted December 6, 2008 Share Posted December 6, 2008 Greetings all I was a little confused on where to post this question...so I hope no one shoots me if I start here. I am working on a web page that we want to have a login using a mysql db. I made a procedure that takes (user IN, password IN, role OUT, status OUT)..the user and password are in variables and the role and status are out variables...all are varchars of different lengths. in sql (toad is what I am using to look at the db) I made the procedure and tested it....it returns 'OK' and the role of the user when the user and password are good. now my problem comes in when I want to call this procedure from php...I really have no clue what I am doing or how to access the out variables after the procedure is called?? I can preform queries and fetch the results to a row type just fine but I am confused on the out variables. thank you for any help in advance Link to comment https://forums.phpfreaks.com/topic/135828-how-to-access-the-out-variables-of-a-mysql-procedure/ Share on other sites More sharing options...
gevans Posted December 6, 2008 Share Posted December 6, 2008 Paste the code you have so far, and we'll start from there! Link to comment https://forums.phpfreaks.com/topic/135828-how-to-access-the-out-variables-of-a-mysql-procedure/#findComment-708111 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.