Any could give me a PHP script on how to call or execute a MS SQL Server stored procedure, passing parameters to it and receiving a value from it using an Output parameter?
agrarian
0
Newbie Poster
Recommended Answers
Jump to Post// execute SQL Server store procedure function MsExecuteProcedure($procedure) { $proc = mssql_init($this->_db."..".$procedure); $rez = mssql_execute($proc) or die(mssql_get_last_message()); return $rez; } // function that adds a parameter to a SQL Server stored procedure function MsAddParameterToProcedure($procedure, $msParamName, $paramValue, $type, $output = null) { if(!$output) mssql_bind($procedure, $msParamName, $paramValue, $type); else …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.