Search DaTutorials:  
HOME
Php Tutorials
Articles
Basics
Date and Time
File Manipulations
Forms
Functions
General
Interactivity
MySql
Navigation
News,Shoutboxes and Blogs
Language Structure and Data Types
Searching
Security
String Manipulation
User Information and Stats
Search For a Tutorial
Php Reference

mysql_create_db

(PHP 3, PHP 4 , PHP 5)

mysql_create_db -- Create a MySQL database

Description

bool mysql_create_db ( string database_name [, resource link_identifier])

mysql_create_db() attempts to create a new database on the server associated with the specified link identifier.

Returns TRUE on success or FALSE on failure.

Example 1. MySQL create database example

<?php
$link
= mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!
$link) {
   die(
'Could not connect: ' . mysql_error());
}

if (
mysql_create_db('my_db')) {
   echo
"Database created successfully\n";
} else {
   echo
'Error creating database: ' . mysql_error() . "\n";
}
?>

For downwards compatibility mysql_createdb() can also be used. This is deprecated, however.

Note: The function mysql_create_db() is deprecated. It is preferable to use mysql_query() to issue a SQL CREATE DATABASE Statement instead.

Warning

This function will not be available if the MySQL extension was built against a MySQL 4.x client library.

See also mysql_query().



Copyright © 2001-2004 The PHP Group
All rights reserved.

     Charity | Loans | Personal Loan | Loans | Loan
Home     Link To Us     Ad With Us     Contact Us     Tell A Friend     Affiliates     Blog     MsOfficeHelp