[請益] textarea無法存進mysql的text??
我用PHP5 Mysql5.5
1.我在Mysql建立一個table,內涵一個column格式是text
2.我用a.php post textarea的資料到b.php (已經連結到mysql)
$textarea=$_POST["textarea"];
3.我試著將textarea的資料寫入Mysql
$add=insert into boards values('$textarea');
mysql_query($add);
我的疑問:
如果我輸入的資料是i'm xxx那sql指令會因為'符號的關係出錯是要如何避免這點呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.169.212.195
→
10/29 18:08, , 1F
10/29 18:08, 1F
→
10/29 18:10, , 2F
10/29 18:10, 2F
→
10/29 18:14, , 3F
10/29 18:14, 3F
→
10/29 18:14, , 4F
10/29 18:14, 4F
※ 編輯: NOXI 來自: 118.169.212.195 (10/29 18:16)
※ 編輯: NOXI 來自: 118.169.212.195 (10/29 18:17)
→
10/29 18:22, , 5F
10/29 18:22, 5F
推
10/29 21:37, , 6F
10/29 21:37, 6F
→
10/29 22:56, , 7F
10/29 22:56, 7F
→
10/29 22:58, , 8F
10/29 22:58, 8F
→
10/29 22:59, , 9F
10/29 22:59, 9F
→
10/29 23:29, , 10F
10/29 23:29, 10F
→
10/29 23:30, , 11F
10/29 23:30, 11F
→
10/29 23:32, , 12F
10/29 23:32, 12F
→
10/29 23:32, , 13F
10/29 23:32, 13F
→
10/30 00:06, , 14F
10/30 00:06, 14F
→
10/30 00:06, , 15F
10/30 00:06, 15F
→
10/30 00:06, , 16F
10/30 00:06, 16F
推
10/30 00:17, , 17F
10/30 00:17, 17F
→
10/30 00:17, , 18F
10/30 00:17, 18F
推
10/30 00:21, , 19F
10/30 00:21, 19F
→
10/30 03:42, , 20F
10/30 03:42, 20F
→
10/30 03:43, , 21F
10/30 03:43, 21F
推
10/31 00:18, , 22F
10/31 00:18, 22F
→
10/31 00:19, , 23F
10/31 00:19, 23F
→
10/31 00:20, , 24F
10/31 00:20, 24F
→
10/31 00:22, , 25F
10/31 00:22, 25F
→
10/31 02:50, , 26F
10/31 02:50, 26F
→
10/31 02:51, , 27F
10/31 02:51, 27F
→
10/31 02:52, , 28F
10/31 02:52, 28F
推
10/31 08:51, , 29F
10/31 08:51, 29F
→
10/31 09:08, , 30F
10/31 09:08, 30F
→
10/31 10:43, , 31F
10/31 10:43, 31F
→
10/31 13:30, , 32F
10/31 13:30, 32F
→
10/31 13:30, , 33F
10/31 13:30, 33F
→
10/31 13:36, , 34F
10/31 13:36, 34F
→
11/01 23:15, , 35F
11/01 23:15, 35F
→
11/01 23:35, , 36F
11/01 23:35, 36F
討論串 (同標題文章)
以下文章回應了本文 (最舊先)：
完整討論串 (本文為第 1 之 3 篇)：
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
