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
Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:
Loop column after 2 results
Hello All.
Here is what I have:
Client ID Company name Clien
Email "$"
Hello!!
Any PHP guy with a bit of a knowledge in Flash ?
When I send a JPEG from flash
RFQ Configuration - can you make PLANT field an optional field in ME42
Is there a way to make the plant field on an RFQ optional in change mode (ME42)?
Dump with added_funcion cl_salv_table
Hi there, I'm having some troubles adding a self defined function to an ALV in fullscreen. The thing
search function
HI guys,
if anyone could point us in the right direction of how to do this, or provide some t
Doubles are giving me problems
Ok so, first of all i made a double = 0.05, but when running the debugger it shows up as 0.04999. I
Need a fuction to count entries in a field
Hi
I need a fuction to count how many times a email address is entered in to a field.
I ma
mysql_affected_rows() usage
Possibly a MySQL issue, but the function that is not behaving in the anticipated way is a PHP functi
array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h