[faisals999]

hi all,,,
I am trying to make a table in php Mu SQL database.. and i want to name it by using user input. means user has given some input and i have stored it in a variable flight. now i am using this query

'CREATE TABLE $flight (`name` VARCHAR(30) NOT NULL, `num_pass` INT(2) NOT NULL, `address` VARCHAR(30) NOT NULL, `contact` VARCHAR(21) NOT NULL,`flight_no` VARCHAR(30) NOT NULL,`pass_id` INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY)'

but it is not working...... please someone help me urgently........

[smithygotlost]

This will do it

PHP Code:

<?php
// REMOVE AFTER TESTING AND SET USING INPUT DATA
$fight = "test1";


if (isset($fight)) {
mysql_query("CREATE TABLE $fight (`name` VARCHAR(30) NOT NULL, `num_pass` INT(2) NOT NULL, `address` VARCHAR(30) NOT NULL, `contact` VARCHAR(21) NOT NULL,`flight_no` VARCHAR(30) NOT NULL,`pass_id` INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY)")or die(mysql_error());
} else {
    echo" Error";
}
?>

Tested and works.

[faisals999]

thanx but unfortunately it also is not working..........

[smithygotlost]

then you are setting it wrong, Ive tested this code.. something is wrong...

Has the mysql user got the right permissions ?
Is your database connect working correctly ?
What errors are you getting ?

To test for errors use this

PHP Code:

<?php
// REMOVE AFTER TESTING AND SET USING INPUT DATA
$fight = "test1";


if (isset($fight)) {
mysql_query("CREATE TABLE $fight (`name` VARCHAR(30) NOT NULL, `num_pass` INT(2) NOT NULL, `address` VARCHAR(30) NOT NULL, `contact` VARCHAR(21) NOT NULL,`flight_no` VARCHAR(30) NOT NULL,`pass_id` INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY)")or die(mysql_error());
  echo" Created";
} else {
    echo" Error Did not insert";
}
?>

if it shows created, then there is something wrong with database permissions.

Let me know outcome

Mike

[faisals999]

Sir basically i am trying to implement following code

PHP Code:

$flight=$_POST['flight'];

$name=$_POST['name'];

$pass=$_POST['no'];

$address=$_POST['address'];

$contact=$_POST['contactnumber'];







$query=mysql_query('CREATE TABLE \''.$flight.'\' (`name` VARCHAR(30) NOT NULL, `num_pass` INT(2) NOT NULL, `address` VARCHAR(30) NOT NULL, `contact` VARCHAR(21) NOT NULL,`flight_no` VARCHAR(30) NOT NULL,`pass_id` INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY)');



if(!$query)

{

    $insert=mysql_query('INSERT INTO \''.$flight.'\' VALUES ("$name","$pass","$address","$contact","$flight","")');

}

else

{

    $insert=mysql_query('INSERT INTO \''.$flight.'\' VALUES ("$name","$pass","$address","$contact","$flight","1")');

} 

but it also is not working... it is creating a table with name "$flight".. kindly do it right if possible.........
I will wait for your answer

[faisals999]

the code you have mentioned earlier is giving following error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-345 (`name` VARCHAR(30) NOT NULL, `num_pass` INT(2) NOT NULL, `address` VARCHAR' at line 1

[Nico]

Please, for the love of God, escape your user input.

PHP Code:

$flight = mysql_real_escape_string($_POST['flight']); 

READ THIS: PHP: mysql_real_escape_string - Manual

[faisals999]

I have tried this and its working............
thanx