CREATE DATABASE name' from config.php

saltedm8 · #1 Sep 21st, 2007, 16:53

i am having a little problem, i want to define the CREATE DATABASE 'name' inside the config.php, - i am going to build an install an hopefully have a form to be filled out to create all the config.php stuff after submission

PHP: Select all


<?php include 'config.php';?>
<?php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$db  = 'CREATE DATABASE saltyblog';
mysql_select_db($db);
$result = mysql_query($db);
$sql = mysql_select_db('saltyblog') or die('Cannot select database');
// Create a MySQL table in the selected database
       $sql="CREATE TABLE form (
        title TEXT NOT NULL,
        date VARCHAR(25) NOT NULL, 
        subject VARCHAR(30) NOT NULL, 
        blog_mes TEXT NOT NULL ) ";
   
  mysql_query($sql) or die (mysql_error());

mysql_close($conn);
?>

thank you ( please see attached image )

karinne · #2 Sep 21st, 2007, 16:55

Replace this

PHP: Select all


$db  = 'CREATE DATABASE saltyblog';

with this

PHP: Select all


$db  = 'CREATE DATABASE '.$dbname;

saltedm8 · #3 Sep 21st, 2007, 17:03

thats what i did, but the database created a database literly called $dbname, or is the dot important ?

saltedm8 · #4 Sep 21st, 2007, 17:18

hold on, i think this is the problem now

PHP: Select all


$sql = mysql_select_db('.$dbname') or die('Cannot select database');

alexgeek · #5 Sep 21st, 2007, 17:18

uh try
$db = "CREATE DATABASE '$dbname'";

karinne · #6 Sep 21st, 2007, 17:23

Quote:

Originally Posted by alexgeek

uh try
$db = "CREATE DATABASE '$dbname'";

No ... you need the . to tack on a variable

The code I posted above should work

PHP: Select all


$db  = 'CREATE DATABASE '.$dbname;

Makesure you put it AS IS!

saltedm8 · #7 Sep 21st, 2007, 17:23

database created i just cant select it now

tryed

PHP: Select all


$sql = mysql_select_db('.$dbname') or die('Cannot select database');

but its not working

alexgeek · #8 Sep 21st, 2007, 17:47

dont think you need a . here:
('.$dbname')

try
('$dbname')

karinne · #9 Sep 21st, 2007, 17:59

No .... the . is to attach a multiple variables together or to text... like

PHP: Select all


$name = $firstname.$lastname;

if you wanted a space in between you would do

PHP: Select all


$name = $firstname.' '.$lastname;

Then you could do

PHP: Select all


echo 'My name is '.$name;

When you are just referencing variables like you did just above, you don't put the .

hth

saltedm8 · #10 Sep 21st, 2007, 18:34

done

PHP: Select all


<?php include 'config.php';?>
<?php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$db  = 'CREATE DATABASE '.$dbname;
mysql_select_db($db);
$result = mysql_query($db);
 $db = mysql_select_db($dbname) or die('Cannot select database');
// Create a MySQL table in the selected database
       $db="CREATE TABLE form (
        title TEXT NOT NULL,
        date VARCHAR(25) NOT NULL, 
        subject VARCHAR(30) NOT NULL, 
        blog_mes TEXT NOT NULL ) ";
   
  mysql_query($db) or die (mysql_error());
mysql_close($conn);
?>

thank you for pointing me in the right direction

karinne · #11 Sep 21st, 2007, 18:41

No problem!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] php re-writing variables in config from form	Emzi	PHP Forum	2	Jan 22nd, 2008 07:58
[SOLVED] writing a config file	saltedm8	PHP Forum	2	Oct 13th, 2007 18:31
can create database but not tables	saltedm8	Databases	28	Sep 16th, 2007 19:31
config.xml	klimi73	Other Programming Languages	0	Nov 13th, 2005 06:30
newbie simple create database to record web page input	jfb130	Databases	3	Aug 28th, 2005 16:37

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
CREATE DATABASE name' from config.php