SQL Server FAQ - odbc_exec() - Executing SQL Statements

Home >> FAQs/Tutorials >> SQL Server FAQ

By: FYIcenter.com

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...)