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

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

Probably Easy, Need help with Check Boxes in PHP Code
hello,

Thanks for looking this over and helping me out. My problem is I have a online store l

Two fgetcsv related questions ;D
First of im trying to get a file from a merchants server but the directory is protected, I know the

Regular expression tips or resources
Hello! I'm having some issues implementing the appropriate regex patter to eliminate unwanted charac

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

PHP5/Zend 2.0 - Resources
PHP5 Snapshots
http://snaps.php.net/

ZEND 2.0 Feature Overview and Design (PDF File

md5 is it unique
I know this is most likely one of many simple questions that can be found semi easily. But I'm press

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am

Email Script does not reach destination
Hey Guys look at this code snippet :
Code:
//read a line from the file

$myFile = "