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
No comments posted yet
Your Answer:
Login to answer
84
39
Other forums
Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t
Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si
CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones
Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th
image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai
Big O & time complexity ???
can you help me how to calculate the Big O & time complexity for any algorithm and c++ program pleas
Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently
Select Lists into MYSQL
Hello All, I am new to PHP @ 1 week. So borrowing code anywhere I can. I am making progress, but h
How to separate records and ORDER BY
Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and
Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the