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, 1615🔥, 0💬
Popular Posts:
How to use the Atom Online Validator at w3.org? w3.org feed validation service is provided at http:/...
How to convert JSON Objects to PHP Associative Arrays using the json_decode() function? Actually, JS...
How to add request body examples to my Azure API operation to make it more user friendly? If you hav...
How to run PowerShell Commands in Dockerfile to change Windows Docker images? When building a new Wi...
Where to find EPUB Sample Files? Here is a list of EPUB sample files collected by FYIcenter.com team...