How To Create Prepared Statements using odbc_prepare()?
Submitted by: AdministratorIf 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:
Submitted by: Administrator
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:
Submitted by: Administrator
<?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
Submitted by: Administrator
$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
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | How to download and install the scaled-down database AdventureWorksLT? |
☺ | How To Execute the Cursor Queries with "OPEN" Statements? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | How To Convert a Numeric Expression from One Data Type to Another? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |