Collections:
PHP ODBC - Creating a New Table
PHP ODBC - How To Create a New Table?
✍: Guest
If you want to create a table in the database connected through a ODBC DSN, you can run the CREATE TABLE SQL statement using the odbc_exec() function, as shown in the following sample script:
<?php $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); # creating a new table $sql = "CREATE TABLE fyi_links (" . " id INT NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)" . ", counts INT" . ", time DATETIME" . ")"; $res = odbc_exec($con, $sql); if (!$res) { print("Table creation failed with error:\n"); print(odbc_error($con).": ".odbc_errormsg($con)."\n"); } else { print("Table fyi_links created.\n"); } odbc_close($con); ?>
If you run this script for the first time and there is no existing table called fyi_links in the database, you will get:
Table fyi_links created.
If you run it again, you will get:
Table creation failed with error: S0001: [Microsoft][ODBC SQL Server Driver][SQL Server] There is already an object named 'fyi_links' in the database.
⇒ PHP ODBC - Inserting Data into an Existing Table
⇐ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2024-06-03, 1376🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...