Search code examples
javascriptphpsqlmysqlicreate-table

How to use variable name as table name in sql create statement

I need to create a new table in sql database based on input given by user.I want something like this

$query = "CREATE TABLE . $POST['name'] . (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);";

The user enters name in input text box and submits.Then the above query is called.Is it possible to create table dynamically with variable name.I am trying to do it in mysql. I am new to sql.

Thanks in Advance

Solution

  • You could surround the variable with curly brackets, like this:

    $query = "CREATE TABLE {$_POST['name']} (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)";