Collections:
PHP ODBC - Creating an Identity Column
PHP ODBC - How To Create an Identity Column?
✍: Guest
Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow SQL Server to automatically assign a new ID number for each new record, you can define the ID column with IDENTITY attribute as shown in the following sample script:
<?php $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); $sql = "CREATE TABLE fyi_users (" . " id INTEGER IDENTITY NOT NULL" . ", name VARCHAR(80) NOT NULL" . ", email VARCHAR(80)" . ", 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_users created.\n"); } odbc_close($con); ?>
If you run this script, a new table will be created with ID column defined as an identity column. It value will be auto-assigned each time a new record is inserted with an auto-incremented number. The sample script below inserts two records with ID values assigned by SQL Server:
<?php $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); $sql = "INSERT INTO fyi_users (name)" . " VALUES ('John King')"; $res = odbc_exec($con, $sql); $sql = "INSERT INTO fyi_users (name)" . " VALUES ('Nancy Greenberg')"; $res = odbc_exec($con, $sql); $sql = "SELECT id, name, time FROM fyi_users"; $res = odbc_exec($con, $sql); while ($row = odbc_fetch_array($res)) { print($row['id'].", ".$row['name'].", " . $row['time']."\n"); } odbc_free_result($res); odbc_close($con); ?>
If you run this script, you will get something like this:
1, John King, 2, Nancy Greenberg,
⇒ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
⇐ PHP ODBC - Query Multiple Tables Jointly
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2024-04-29, 1359🔥, 0💬
Popular Posts:
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...