CREATE DATABASE name' from config.php

[saltedm8]

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]

Replace this

PHP: Select all

$db  = 'CREATE DATABASE saltyblog'; 

with this

PHP: Select all

$db  = 'CREATE DATABASE '.$dbname; 

[saltedm8]

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

[saltedm8]

hold on, i think this is the problem now

PHP: Select all

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

[alexgeek]

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

[karinne]

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]

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]

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

try
('$dbname')

[karinne]

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]

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]

No problem!