PHP ruft die gespeicherte MS SQL-Prozedur auf

在PHP中调用MS SQL存储过程

1. FunktiongenerateDocCode(){
2. $wf_id=self::WORKFLOW_ID;
3. $doc_code="";
5. $link=mssql_connect($this->cfg- >db->params->host,$this->cfg->db->params->username,$ dies->cfg->db->params->password)odersterben("Can'tconnectsqlserver");
6. mssql_select_db($this- >cfg->db->params->dbname,$link)oderdie("Selectdatabasefailure");
8. $stmt=mssql_init("GenerateDocCode",$link)odersterben( "initializestoredprocedurefailure");
9. mssql_bind($stmt," @wf_id",$wf_id,SQLINT4);
10. mssql_bind($stmt ,"@doc_code",$doc_code,SQLVARCHAR,true);
11. mssql_execute($stmt,false);
13. //print"DocCodeis:".$ doc_code;
14. return$doc_code;
15. }

先调用mssql_init语句用于初始化存储过程，而后调用mssql_bind语句指定存储过程参数,最后调用mssql_execute执行 🎜> 以上就介绍了PHP调用MS SQL 存储过程, 包括了存储过程, sqlserver方面的内容, 希望对PHP教程有兴趣的朋友有所帮助.