How to use php to call sql server’s stored procedures?

  mysql, question

How to use php to call sql server’s stored procedures in YI framework? For example, the method name of a stored procedure is pc_sms_send, with parameters, such as A, B, C, D. The call returns 1 successfully, and the failure returns 0. Seek the sample code

<?  Php
 /* Call a stored procedure with an INOUT parameter */
 $colour = 'red';
 $sth = $dbh->prepare('CALL puree_fruit(?  )');
 $sth->bindParam(1, $colour, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 12);
 $sth->execute();
 print("After pureeing fruit, the colour is: $colour");
 ?  >

PHPNET

Related Posts: