note 118828 deleted from function.sqlsrv-query by peehaa
| From: | peehaa@php.net | Date: | Thu, 11 Aug 2016 08:25:52 +0000 |
| Subject: | note 118828 deleted from function.sqlsrv-query by peehaa | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-206260@lists.php.net to get a copy of this message | ||
Note Submitter: francis dot rechtenstein at free dot fr
----
Exécution dâune requête de procédure stockée sur SQL SERVEUR(v12) par PHP(5.4) avec
les Pilotes SQLSRV(32)
exemple: SQL: EXEC SP_COLUMNS t_tickets_Pilotes2
Programme:
$conn=sqlsrv_connect($server, $Cnxopt);
$tabl='t_tickets_Pilotes2';
$params = array();
$options = array("Scrollable" => SQLSRV_CURSOR_CLIENT_BUFFERED);
$pstock="EXEC SP_COLUMNS $tabl";
$result = sqlsrv_query($conn,$pstock, $params, $options);
if (!$result) {die ('<br>Erreur1(result): '.print_r(sqlsrv_errors(),true));}} else
{echo '<br>retour de : '.sqlsrv_num_rows($result).' ligne(s). ';}
if (sqlsrv_num_rows($result) > 0) {
while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
if( $conn === false ) {die( print_r( '<br>Erreur2 Fetch: '.sqlsrv_errors(),
true));}
$rescol[] = $row["COLUMN_NAME"];
}
} else {echo '<br>Pas de résultat.';}
sqlsrv_free_stmt($result);
sqlsrv_close($conn);