MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Create Prepared Statements using odbc_prepare()?

Answers:

Answer #1
If 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:

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


Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
How To Loop through Result Set Objects using odbc_fetch_row()?How To List All Tables in the Database using odbc_tables()?