How to create a database with php and mysql

PHP/MySql part 3: Create Database

Written by: maffelu , 2009-04-17 07:33:25

Creating a database with PHP is not hard.

<?php

$host="localhost"; // Host name 

$username="MyUsername"; // Mysql username 

$password="MyPassword"; // Mysql password 



//The connection

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 



//The Mysql commandline

$sql = "CREATE DATABASE MyFirstDB";

//Send the question to the database

$result = mysql_query($sql);

//If everything went as planned...

if($result)

{

	echo "Database created!";

}

else

{

	echo "Database was not created... =(";

}

?>

That's about as easy as it gets...

There are 2 comments on this article.

markkk

2010-10-09 05:08:23

pls post a code that will create a simple games using php codes.thanks so much

Maffelu

2010-10-10 05:09:01

Well, you need more than just database handling to create a game.
Generally, making games in PHP requires you to reload the page for every game event, so flash games (ugh!) or javascript games are more suited for the web.

If you want an example, visit:
http://demo.morkalork.com/game/Flooder/

There I have a demo of a potential game you could make using javascript.

Leave a message!

If you have any question or just want to leave a message, just fill out the form below!

Your e-mail will not be visible in your post, it is for validation reasons only

Name:
E-mail:
Comment: