[請益] 如何上傳中文字串？

看板PHP作者ebliswu (□形的世界)時間16年前 (2007/12/19 22:13)推噓5(5推 0噓 10→)

留言15則, 5人參與討論串1/3 (看更多)

下面這段在用英文輸入時可正確上傳至資料庫。但無法用中文就上傳…請問要改哪？用的是utf8的編碼… <?php require("dbinfo.php"); // Gets data from URL parameters $name = $_GET['name']; $address = $_GET['address']; $lat = $_GET['lat']; $lng = $_GET['lng']; $type = $_GET['type']; // Opens a connection to a MySQL server $connection=mysql_connect ("localhost", $username, $password); if (!$connection) { die('Not connected : ' . mysql_error()); } // Set the active MySQL database $db_selected = mysql_select_db($database, $connection); if (!$db_selected) { die ('Can\'t use db : ' . mysql_error()); } // Insert new row with user data $query = sprintf("INSERT INTO markers " . " (id, name, address, lat, lng, type) " . " VALUES (NULL, '%s', '%s', '%s', '%s', '%s');", mysql_real_escape_string($name), mysql_real_escape_string($address), mysql_real_escape_string($lat), mysql_real_escape_string($lng), mysql_real_escape_string($type)); $result = mysql_query($query); if (!$result) { die('Invalid query: ' . mysql_error()); } ?> 感謝回覆 m(_ _)m -- 看不見你的笑我怎麼睡得著… 你的呻吟這麼近我卻抱不到… -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 220.133.220.195

推

yuan0258

12/19 22:15, , 1^F

12/19 22:15, 1^F

→

ebliswu

12/19 22:53, , 2^F

12/19 22:53, 2^F

→

ebliswu

12/19 22:55, , 3^F

12/19 22:55, 3^F