Create MySQL Database Programmatically using PHP

Submitted by carlojay.lacson on Thursday, October 3, 2013 - 09:14.

Language

Tools I used: -Notepad++ -Wamp server This program is use to connect to database and create database in wamp server. Create a new folder (any name) on www in wamp folder then paste the createdatabase.php code. Then voila congratulations you are connected! Code:

<html>
<body>
<?php
$con = mysql_connect("localhost", "root", ""); //tandaan laging may root dapat pagdefault
if (!$con) {
    die('Hindi makaconnect sa database');
}
 
if (mysql_query("CREATE DATABASE my_carlo", $con)) //mysql_query is tool for connecting to mysql
    { //kung ano yung database name mo palitan mo yung my_carlo
    echo "Congratulations! database created";
} else {
    echo "Error creating database";
}
 
?>
</body>
</html>

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Add new comment

81 views