[請益] PHP INSERT 資料到mysql
估狗了很久
發現沒有這樣做
但實在很想試試看= =|||
我需要一次新增資料到3個表格
$SQL = " INSERT INTO stock";
$SQL = $SQL . " (stock_id, stock_nm, price) VALUES ";
$SQL = $SQL . " ('$stock_id', '$stock_nm','$price');";
$SQL = $SQL . " INSERT INTO pic";
$SQL = $SQL . " (pic_id, pic1) VALUES ";
$SQL = $SQL . " ('$stock_id','$pic1'); ";
$SQL = $SQL . " INSERT INTO standard";
$SQL = $SQL . " (std_id, epa) VALUES ";
$SQL = $SQL . " ('$stock_id','$epa') ";
結果出現
ERROR: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO pic (pic_id, pic1) VALUES
('abc123','http://images.ecarlist.com/p' at line 1 INSERT INTO stock
(stock_id, stock_nm, price) VALUES ('abc123', '2000 TOYOTA CAMRY','545');
INSERT INTO pic (pic_id, pic1) VALUES
('abc123','http://images.ecarlist.com/photos/995_278530/80/33.jpg'); INSERT
INTO standard (std_id, epa) VALUES ('abc123','aqwdeqd')
但是我直接把
INSERT INTO stock (stock_id, stock_nm, price) VALUES ('abc123', '2000 TOYOTA
CAMRY','545'); INSERT INTO pic (pic_id, pic1) VALUES
('abc123','http://images.ecarlist.com/photos/995_278530/80/33.jpg'); INSERT
INTO standard (std_id, epa) VALUES ('abc123','aqwdeqd')
再PHPMYADMIN輸進去
卻可以成功
想請問 到底是為甚麼呢?>"<
有沒有甚麼辦法可以解決@@
謝謝 (不知道問題有沒有很白目~"~)
--
C'est La Vie
http://www.wretch.cc/album/ringle
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 76.187.11.47
→
05/06 09:19, , 1F
05/06 09:19, 1F
→
05/06 10:07, , 2F
05/06 10:07, 2F
→
05/06 10:08, , 3F
05/06 10:08, 3F
推
05/06 10:43, , 4F
05/06 10:43, 4F
推
05/06 11:01, , 5F
05/06 11:01, 5F
→
05/06 11:36, , 6F
05/06 11:36, 6F
→
05/06 22:49, , 7F
05/06 22:49, 7F
推
05/06 23:59, , 8F
05/06 23:59, 8F
→
05/07 00:00, , 9F
05/07 00:00, 9F
討論串 (同標題文章)
以下文章回應了本文：
完整討論串 (本文為第 1 之 2 篇)：
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
