Tools, FAQ, Tutorials:
Creating a Database in PHP
How To Create a Database in PHP?
✍: FYIcenter.com
A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are the administrator of the server, you can create and delete databases using the CREATE/DROP DATABASE statements. The following PHP script shows you how to create and drop a database called "fyi":
<?php $con = mysql_connect('localhost'); $sql = 'CREATE DATABASE fyi'; if (mysql_query($sql, $con)) { print("Database fyi created.\n"); } else { print("Database creation failed.\n"); } $sql = 'DROP DATABASE fyi'; if (mysql_query($sql, $con)) { print("Database fyi dropped.\n"); } else { print("Database drop failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
Database fyi created. Database fyi dropped.
⇒ Selecting an Existing Database in PHP
⇐ Connecting to a MySQL Server in PHP
2016-10-20, 1493🔥, 0💬
Popular Posts:
Where Can I get a copy of the RSS XML Schema? RSS XML Schema is an XML Schema that defines how an RS...
How To Read a File in Binary Mode in PHP? If you have a file that stores binary data, like an execut...
How to use the JSON to XML Conversion Tool at utilities-online.info? If you want to try the JSON to ...
How to use "link" command tool to link objet files? If you have object files previously compiled by ...
Can Two Forms Be Nested? Can two forms be nested? The answer is no and yes: No. You can not nest two...