我有以下代码从html表单中捕获值
if(isset($_POST['kk' ]) && isset($_POST['items'])) {
$tablename = $_POST['kk'];
$columns = $_POST['items'];
}
HTML表单
<input name = "kk" type="text" class = "form-control" Placeholder = "table name">
<input name = "items" Placeholder = "sql query" class = "form-control" type ="text" >
然后将值传递给此sql查询以创建包含列的表
$sql = "CREATE TABLE $tablename ( $columns )";
我在'items'输入表单字段中手动键入sql代码,如下所示
'id INT(6) ,firstname VARCHAR(20), lastname VARCHAR(20), PRIMARY KEY(id)'
现在,只要我已经删除了'items'表单字段并将其替换为3个输入表单字段,例如id,firstname和lastname .
以这种格式考虑它
<input name = "id" type ="text" > -> id INT(6)
<input name = "firstname" type ="text" > -> firstname VARCHAR(20)
<input name = "lastname" type ="text" > -> lastname VARCHAR(20)
我如何从上面的表单字段中获取值并将它们传递给sql查询以充当列名称(否则替换我最初使用的$ columns变量)?