mardi 5 avril 2016

sqlite - Create table using variable in php

I have something like

$tableName = "table1";  
$sql ="CREATE TABLE "'.$table1.'"  
(ID INT PRIMARY KEY     NOT NULL,  
NAME           TEXT    NOT NULL,  
AGE            INT     NOT NULL,  
ADDRESS        CHAR(50),  
SALARY         REAL)";  

but it doesnt works

Edit: I already have answer it's

    $sql ="CREATE TABLE `".$tableName."`
  (ID INT PRIMARY KEY     NOT NULL,
  NAME           TEXT    NOT NULL,
  AGE            INT     NOT NULL,
  ADDRESS        CHAR(50),
  SALARY         REAL)";

Aucun commentaire:

Enregistrer un commentaire