· 9 years ago · Nov 07, 2016, 06:04 PM
1INSERT INTO codes (`user_id`, `type`, `code`, `expires`) VALUES ($id, $type, $code, $expires);
2
3You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':14:43.000Z)' at line 1
4
5CREATE TABLE IF NOT EXISTS codes (
6`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
7`user_id` varchar(255) NOT NULL,
8`type` varchar(255) NOT NULL,
9`code` varchar(255) NOT NULL,
10`expires` DATETIME
11)ENGINE=InnoDB;
12
13INSERT INTO codes (user_id, type, code, expires) VALUES ($id, $type, $code, '$expires');