:::
1-1 index.html
1-2 save.php
<?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;
