Creating a db with a query

Posted on 16th Feb 2014 07:03 pm by admin

Hello everyone.
I'm having troubles creating a db with a query.
I'm reading a book called PHP Bibles from Tim Converse
I get this error
Fatal error: Call to undefined function mysql_create_db() in /Applications/XAMPP/xamppfiles/htdocs/testing/10/ch22/weblog_db_create.php on line 8
Not sure why and help would be great.
Here is the code:
Code: <?php
// You'll probably have to be the root MySQL user to run this script.
// If you can't get that permission, you could alter the script below
// to create tables in your pre-existing database.
include("db_password.inc");

mysql_connect($hostname, $user, $password) or die("Failure to communicate");
$try_create = mysql_create_db("weblogs");
if ($try_create > 0) {
echo ("Successfully created database.<BR>n");
mysql_select_db("weblogs");
$query = "CREATE TABLE login (ID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(20), password VARCHAR(20))";
$result = mysql_query($query);
// Since we're not using the standard MySQL
// date format, store date as an integer
$query2 = "CREATE TABLE mylog (ID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, date INT(8), blogtext TEXT)";
$result2 = mysql_query($query2);
mysql_close();
if ($result > 0 && $result2 > 0) {
echo ("Successfully created tables<BR>n");
} else {
echo ("Unable to create tables.");
}
} else {
echo ("Unable to create database");
}
?>

Password for db_password.inc
localhost
nomad
nomad

Many thanks

Your Answer:

Login to answer

Other forums

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

Program with calculate Meteorologic measurements
Hello I'm a beginner and I want to make a program with calculate Meteorologic measurements:
ba

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 se

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r

Need help with some php code :)
Hey! I'm quite new to this whole thing, so please don't fire me with shait on this one =D

I'm

Ball movement
I want to move a ball from one point to another and it should hit a group of balls at the other end

Help pulling in 'id' with "read more" link
I'm trying to create snippets of my articles in the cms I'm creating, and then have them redirect to

apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?