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

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span

A little help needed passing hidden values to next page
I have a page that has hidden values in a form.

example
Code: <input name='signupID

update sql when refresh - php
hi
I have made a table (attachement)

the users can update the sql database using + or x bu

Checking if field is empty AND using !is_numeric
Hi lads,

Need to be able to display an error message (using isset?) that says "Cant lea

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat