如何使用日期（'Y-m-d H：i：s'）; 函数值作为php中的列名？
问题描述：
I want to store date as column name in php.
I tried below code but its giving error.
<?php
$dbhost = "localhost";
$dbuser = "id788089_smartcollegeapp";
$dbpass = "smart123";
mysql_connect("$dbhost","$dbuser","$dbpass") or die(mysql_error());
mysql_select_db("id788089_smartcollegeapp");
$date = date('Y-m-d H:i:s');
$table = trim($array_not_present_student[0]) .
'_' . trim($array_not_present_student[1]) .
'_' . trim($array_not_present_student[2]) .
'_' . trim($array_not_present_student[3]) .
'_' . trim($array_not_present_student[4]);
$new ="ALTER TABLE " . $table . " ADD " . $date . " VARCHAR(255) NOT NULL";
mysql_query($new)or die(mysql_error());
?>
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2017-03-26 04:14:51 VARCHAR(255) NOT NULL' at line 1.
答
Try below query. It worked in MySQL. Added ` before $date.
$new ="ALTER TABLE ".$table." ADD `".$date."` VARCHAR(255) NOT NULL";