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, 1501🔥, 0💬
Popular Posts:
How to use "xsl-transform" Azure API Policy Statement? The "xsl-transform" Policy Statement allows y...
How to build a PHP script to dump Azure AD 2.0 Authentication Response? If you are use the Azure-AD-...
Where to find tutorials on API Management Services at Azure Portal? Here is a list of tutorials to a...
How to use the Atom Online Validator at w3.org? w3.org feed validation service is provided at http:/...
How to install "C++/CLI Support" component in Visual Studio? I need to build my Visual Studio C++/CL...