Creating a Database in PHP

Q

How To Create a Database in PHP?

✍: FYIcenter.com

A

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.

 

Working with MySQL Database in PHP

⇒⇒PHP Tutorials

2016-10-20, 250👍, 0💬