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, 1539🔥, 0💬
Popular Posts:
Where to see resource detailed information of my API Management Service on Azure Portal? Once you ha...
How to extend json.JSONEncoder class? I want to encode other Python data types to JSON. If you encod...
What Azure AD App Registration Manifest? Azure AD App Registration Manifest is JSON file that contai...
How To Break a File Path Name into Parts in PHP? If you have a file name, and want to get different ...
How to search for the first match of a regular expression using re.search()? The re.search() functio...