Hi All,
I'm quite new to all this so please bear with me if this is simple.......
I've been messing around with some tutorials which show how to insert into the db from a form using php and mysql but what I really want to do is create most of the table handler code on the Db (to keep it away from prying eyes) as it's easier to manage that way so what I need to know is what command do you use in PHP to execute a stored procedure in MySQL Db?
so instead of including this in my php:
$query = "INSERT INTO contacts VALUES ('','$first','$last','$phone','$mobile','$fax','$email','$web')";
I want to call, say, a procedure called insert_registration([parameters above]) from php which will call the db prc and insert the data.
How do I do this? Many thanks
Dave 😃