<?php $db = new mysqli('localhost', 'root', '12345', 'test'); if ($db->connect_error) { die('無法連上資料庫:' . $db->connect_error); } $db->set_charset("utf8"); $type = $db->real_escape_string($_POST['sig'][0]); $content = $db->real_escape_string($_POST['sig'][1]); $sql = "INSERT INTO `canvas` (`type`, `content`) VALUES ('{$type}', '{$content}')"; $db->query($sql) or die($db->error); $sn = $db->insert_id; if (strpos($type, 'svg') !== false) { file_put_contents("{$sn}.svg", $_POST['sig'][1]); } else { $data = base64_decode($_POST['sig'][1]); file_put_contents("{$sn}.png", $data); } echo $sn;