Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - odbc_exec() - Executing SQL Statements

By: FYIcenter.com

(Continued from previous topic...)

How To Execute a SQL Statement using odbc_exec()?

Once you have created an ODBC connection object, you can use the odbc_exec() function to send a SQL statement to the SQL Server linked to the connection object for execution.

Here is a simple PHP script that creates a new schema and a new table:

<?php
  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');

  # creating a new schema
  $sql = 'CREATE SCHEMA fyi';
  odbc_exec($con, $sql);
  
  # creating a new table
  $sql = 'CREATE TABLE fyi.center (name VARCHAR(80))';
  odbc_exec($con, $sql);

  odbc_close($con); 
?>

If you run this script for the first time, it will execute those two statements correctly for you. But if you run it again, you will some warning messages:

Warning: odbc_exec(): SQL error: [Microsoft]
[ODBC SQL Server Driver][SQL Server]
There is already an object named 'fyi' in the database., 
SQL state S0001 in SQLExecDirect in C:\test\fyi_center.php
on line 6

Warning: odbc_exec(): SQL error: [Microsoft]
[ODBC SQL Server Driver][SQL Server]
There is already an object named 'center' in the database.,
SQL state S0001 in SQLExecDirect in C:\test\fyi_center.php
on line 10

The messages are very clear and easy to understand.

(Continued on next topic...)

  1. What Are the Requirements to Use ODBC Connections in PHP Scripts?
  2. What Are Commonly Used ODBC Functions in PHP?
  3. How To Test ODBC DSN Connection Settings?
  4. How To Connect to a SQL Server using odbc_connect()?
  5. How To List All DSN Entries on Your Local Machine using odbc_data_source()?
  6. How To Execute a SQL Statement using odbc_exec()?
  7. How To Retrieve Error Messages using odbc_errormsg()?
  8. How To Turn Off Warning Messages during PHP Execution?
  9. How To Receive Returning Result from a Query?
  10. How To Loop through Result Set Objects using odbc_fetch_row()?
  11. How To Retrieve Field Values using odbc_result()?
  12. How To List All Tables in the Database using odbc_tables()?
  13. How To List All Columns in a Table using odbc_columns()?
  14. How To Create Prepared Statements using odbc_prepare()?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...