Tools, FAQ, Tutorials:
Creating a Table in PHP
How To Create a Table in PHP?
✍: FYIcenter.com
If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script:
<?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)" . ", counts INTEGER" . ", time TIMESTAMP DEFAULT sysdate()" . ")"; if (mysql_query($sql, $con)) { print("Table fyi_links created.\n"); } else { print("Table creation failed.\n"); } mysql_close($con); ?>
Remember that mysql_query() returns TRUE/FALSE on CREATE statements. If you run this script, you will get something like this:
Table fyi_links created.
⇒ Number of Rows Affected by a SQL Statement in PHP
⇐ Running a SQL Statement in PHP
2016-10-20, 1297👍, 0💬
Popular Posts:
What Is session_register() in PHP? session_register() is old function that registers global variable...
How to use the "rewrite-uri" Policy Statement for an Azure API service operation? The "rewrite-uri" ...
How Values in Arrays Are Indexed in PHP? Values in an array are all indexed their corresponding keys...
How To Control Vertical Alignment? By default, text in all table cells are aligned to the top vertic...
How to create a new API on the Publisher Portal 2017 version of an Azure API Management Service? If ...