<?php
\n\/\/===== \u30d1\u30e9\u30e1\u30fc\u30bf\u8aad\u307f\u8fbc\u307f\uff08\u4ee5\u964dCFG_*\u306f\u5f53\u30d5\u30a1\u30a4\u30eb\u306b\u3088\u308a\u8a2d\u5b9a\u3055\u308c\u305f\u5b9a\u6570\uff09
\nrequire_once (‘include\/param.inc.php’);
\nrequire_once (‘include\/pear\/DB.php’);\t\/\/ \u2605\u2605\u2605
\n\/\/===== DB\u63a5\u7d9a
\n$db = DB::connect (“mysql:\/\/”.CFG_MYSQL_USERNAME.”:”.CFG_MYSQL_PASSWORD.”@”.CFG_MYSQL_HOST.”\/CFG_MYSQL_DBNAME”);\t\/\/ \u2605\u2605\u2605
\nif (DB::isError( $db )) {
\ndie($db->getMessage());
\n}\t\/\/ \u2605\u2605\u2605
\n\/\/===== \u6587\u5b57\u5316\u3051\u5bfe\u7b56
\n$sql = “SET NAMES utf8”;
\n$result = $db->query($sql);\t\/\/ \u2605\u2605\u2605
\n\/\/===== \u30a4\u30f3\u30b5\u30fc\u30c8\u7528\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf
\n$tmani_time = “\u6642\u9593”;
\n$tmani_from = “\u30d5\u30ed\u30e0”;
\n$tmani_subject = “\u6587\u5b57\u5316\u3051\u76f4\u3063\u3066\u308b\u3068\u3044\u3044\u306d”;
\n$tmani_body = “\u304a\u5143\u6c17\u3067\u3059\u304b\uff1f
how r u?”;
\n\/\/===== \u30af\u30a8\u30ea\u30fc\u6587\u306e\u8a2d\u5b9a
\n$stt=$db->prepare(“INSERT INTO\t“.CFG_MYSQL_TABPREFIX.”posts (
\npost_mail_from,
\npost_mail_subject,
\npost_mail_body)
\nVALUES (?,?,?)”);\t\/\/ \u2605\u2605\u2605
\n\/\/===== \u30af\u30a8\u30ea\u30fc\u6587\u306e\u5b9f\u884c
\n$res = $db->execute($stt,array($tmani_from,$tmani_subject,$tmani_body));\t\/\/ \u2605\u2605\u2605
\nif( $db->isError($return) ){
\n$db->rollback();
\ndie($res->getMessage());
\n}
\n\u3000\u3000\u3000\u3000\u3000\u3000\u3000$db->commit();
\n\/\/===== \u7d50\u679c\u8868\u793a
\n$post_id = mysql_insert_id();
\n$next_id = $db->nextid($res)\t\/\/ \u2605\u2605\u2605
\nif($res) {
\necho “\u6210\u529f\uff01 \\n res: “.$res.” \\n post-id: “.$post_id.” \\n next-id: “.$next_id;\t\/\/ \u2605\u2605\u2605
\n} else {
\necho “\u5931\u6557\u2193 \\n res: “.$res.” \\n post-id: “.$post_id.” \\n next-id: “.$next_id;\t\/\/ \u2605\u2605\u2605
\n}
\n\/\/===== DB\u30af\u30ed\u30fc\u30ba
\n$db->disconnect();\t\/\/ \u2605\u2605\u2605
\n?>
\n\u3053\u3093\u306a\u98a8\u306b
\n\u30d7\u30ea\u30b3\u30f3\u30d1\u30a4\u30eb\u6e08\u307f\uff33\uff31\uff2c\u306e\u5834\u5408\u306f\u3000prepare, excute \u3067\u884c\u3046
\n\u305d\u3046\u3067\u306a\u3051\u308c\u3070query\u3067\uff2f\uff2b<\/p>\n","protected":false},"excerpt":{"rendered":"
<?php \/\/===== \u30d1\u30e9\u30e1<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/comments?post=18"}],"version-history":[{"count":0,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/18\/revisions"}],"wp:attachment":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/media?parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/categories?post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/tags?post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}