Jul 02
Make sure mysqli is supported.
If you are not able to successfully run stored procedure, please read this.
If you create a stored procedure from remote mysql it opens a record in information_schema database routines table with definer username@ip.You can not access this s.p. with php. if you create a s.p. from php my admin it opens a record in information_schema database routines table with definer username@localhost. If you create a s.p. from php, I mean a file from server it opens a record in information_schema database routines table with definer.a s.p. created from phpmyadmin can only be called from phpmyadmin.but a s.p. created from server (a file in public_html folder) can be called from web site
Recent Comments