|
Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - PHP ODBC - Creating an Identity Column
By: FYIcenter.com
(Continued from previous topic...)
PHP ODBC - How To Create an Identity Column?
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:
If you run this script, you will get something like this:
1, John King,
2, Nancy Greenberg,
- PHP ODBC - How To Create a New Table?
- PHP ODBC - How To Insert Data into an Existing Table?
- PHP ODBC - How To Insert Multiple Rows with a subquery?
- PHP ODBC - How To Get the Number of Affected Rows?
- PHP ODBC - What Is a Result Set Object Returned by odbc_exec()?
- PHP ODBC - How To Loop through Returning Rows?
- PHP ODBC - How To Update Existing Rows in a Table?
- PHP ODBC - How To Delete Existing Rows in a Table?
- PHP ODBC - How To Include Text Values in SQL Statements?
- PHP ODBC - How To Include Date and Time Values in SQL Statements?
- PHP ODBC - How To Display a Past Time in Days, Hours and Minutes?
- PHP ODBC - How To Perform Key Word Search in Tables?
- PHP ODBC - How To Query Multiple Tables Jointly?
- PHP ODBC - How To Create an Identity Column?
|