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, 1964🔥, 0💬
Popular Posts:
How To Copy Array Values to a List of Variables in PHP? If you want copy all values of an array to a...
Where to find tutorials on Using Azure API Management Developer Portal? Here is a list of tutorials ...
How to add images to my EPUB books Images can be added into book content using the XHTML "img" eleme...
How to install "The Windows SDK version 8.1"? I need to build my Visual Studio C++ applications. If ...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....