MS SQL Server Concepts and Programming Question: Download Questions PDF
How To Create Prepared Statements using odbc_prepare()?
Answers:
Answer #1If you have a SQL statement that need to executed repeatedly many times with small changes, you can create a prepared statement object with parameters so it can be executed more efficiently.
There are two functions you need to use prepare and execute a prepared statement object:
$statement_object = odbc_prepare($connection,
$statement_string);
#- The $statement_string may have parameters represented
#- by "?".
$result_set = odbc_execute($statement_object $array);
#- The $array is used to supply values to parameters
#- defined in the statement object.
The tutorial PHP script below shows you how to insert 3 rows into a table with a prepared statement object with 2 parameters:
There are two functions you need to use prepare and execute a prepared statement object:
$statement_object = odbc_prepare($connection,
$statement_string);
#- The $statement_string may have parameters represented
#- by "?".
$result_set = odbc_execute($statement_object $array);
#- The $array is used to supply values to parameters
#- defined in the statement object.
The tutorial PHP script below shows you how to insert 3 rows into a table with a prepared statement object with 2 parameters:
Answer #2<?php
$con = odbc_connect('ggl_SQL_SERVER','sa','GlobalGuideLine');
$sql = "INSERT INTO ggl_rates (id, comment) VALUES (?,?)";
$statement = odbc_prepare($con, $sql);
$res = odbc_execute($statement, array(301, "Good"));
$res = odbc_execute($statement, array(302, "Average"));
$res = odbc_execute($statement, array(303, "Bad"));
$sql = "SELECT * FROM ggl_rates WHERE id>300";
$res = odbc_exec($con, $sql);
while (odbc_fetch_row($res)) {
print(" ".odbc_result($res,1));
print(", ".odbc_result($res,2)." ");
}
odbc_free_result($res);
odbc_close($con);
?>
If you this sample script, you will get:
301, Good
302, Average
303, Bad
$con = odbc_connect('ggl_SQL_SERVER','sa','GlobalGuideLine');
$sql = "INSERT INTO ggl_rates (id, comment) VALUES (?,?)";
$statement = odbc_prepare($con, $sql);
$res = odbc_execute($statement, array(301, "Good"));
$res = odbc_execute($statement, array(302, "Average"));
$res = odbc_execute($statement, array(303, "Bad"));
$sql = "SELECT * FROM ggl_rates WHERE id>300";
$res = odbc_exec($con, $sql);
while (odbc_fetch_row($res)) {
print(" ".odbc_result($res,1));
print(", ".odbc_result($res,2)." ");
}
odbc_free_result($res);
odbc_close($con);
?>
If you this sample script, you will get:
301, Good
302, Average
303, Bad
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Loop through Result Set Objects using odbc_fetch_row()? | How To List All Tables in the Database using odbc_tables()? |