PHP/SQL how to create table automatic

Asked Mar 13 '17 at 08:43

Active Mar 13 '17 at 09:01

Viewed 50 times

How do I make this code work if I save it as a .php file it says: And I copied this code from my database and edited the names so I thought this code is fine.

Parse error: syntax error, unexpected 'TABLE' (T_STRING) in C:\xampp\htdocs\Informatica\tables\vraag2.php on line 2

CREATE TABLE `lotto`.`vraag4b` ( `VraagID2` INT NOT NULL AUTO_INCREMENT , 
`Vraag4B` VARCHAR(255) NOT NULL , `AntwA2` VARCHAR(255) NOT NULL , `AntwB2` 
VARCHAR(255) NOT NULL , `AntwC2` VARCHAR(255) NOT NULL , `AntwD2` VARCHAR(255) 
NOT NULL , PRIMARY KEY (`VraagID1`)) ENGINE = InnoDB;

edited Mar 13 '17 at 09:01

Tom

4,257
6
33
49

asked Mar 13 '17 at 08:43

Jelles D.

post your `vraag2.php` code specific to the sql query – Roljhon Mar 13 '17 at 08:45
2

You are seeing the error because it is not valid PHP script. – imprezzeb Mar 13 '17 at 08:46
1

This is SQL code not PHP. Use PDO or mysqli from PHP to connect with your local database. – Weenesta - Mathieu Dormeval Mar 13 '17 at 08:50

PHP/SQL how to create table automatic

0 Answers0