如何使用日期（'Y-m-d H：i：s'）; 函数值作为php中的列名？

Question

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.

Answer 1

Try below query. It worked in MySQL. Added ` before $date.

$new ="ALTER TABLE ".$table." ADD `".$date."` VARCHAR(255) NOT NULL";