I want to create a table in the SQL statement in PHP based on user input parameters
For example, I now use $_get[' tablename '] to the user input values, I want to use SQL in PHP files to create a name called $_get[' tablename '] form, ask
CREATE TABLE [TableName] Here's tablename How to say this SQL statement is correct
I use CREATE table {. $_get[' tablename '].} Can't make it?
------Solution--------------------
$sql = <<
<>
CREATE TABLE {$_get[' tablename '}
...
SQL;
------Solution--------------------
= <<
HEREDOC syntactic structure:<<<. After the operator, provide an identifier, and then wrap the line. The next is the string itself, and finally the identifier defined earlier as the end flag.
$content = <<
Test
Blog
Fdipzone;
Echo $content;
?>
References: http://blog.csdn.net/fdipzone/article/details/24937669
------Solution--------------------
That's all you can do.
$sql =<<
<>
CREATE TABLE ' {$_get[' tablename '} ' (
' id ' int (ten) unsigned not NULL auto_increment,
' Name ' varchar (+) is not NULL,
' Age ' tinyint (4) unsigned not NULL,
' Addtime ' datetime not NULL,
PRIMARY KEY (' id ')
)
SQL;
mysql_query ($sql) or Die (Mysql_error ());