forum

Home / DeveloperSection / Forums / There are some problem in creation of database

Ask Question

There are some problem in creation of database

Somesh 3631 26-Oct-2010
how we create database in mysql with php
please give syntex
thanks in advance
mysql mysql 
Updated on 08-Nov-2010
Somesh

Somesh

Follow

Can you answer this question?

Answer

1 Answers

Amit Singh

Amit Singh

08-Nov-2010
Create database between mysql and php
using syntax
Create database databaseName

we write syntax in php for creation of database
 Example
<?php
$con = mysql_connect("localhost","sa","sa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
if (mysql_query("CREATE DATABASE my_db",$con)) //Create database and check the condition
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
mysql_close($con);
?>
MindStick Training

Liked By