{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
function create_guid()
{
$charid = strtoupper(md5(uniqid(mt_rand(), true)));
$hyphen = chr(45);
// "-"
$uuid = substr($charid, 0, 8) . substr($charid, 8, 4) . substr($charid, 12, 4) . substr($charid, 16, 4);
return $uuid;
}
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$comment = new ManagerComment();
$kind = test_input($_GET["kind"]);
// $helpcommentid=create_guid();
// $helpcommentid="061C0B9A01C488EB69AE";
// $kind = 'update';
// $nickname = 'wmy';
// $userid= '1D9C9163EA8B2D830267';
// $content = '帮助他人';
// // $helpcommentid = test_input($_GET["helpcommentid"]);
// $hasimage = 0;
// $hasvideo=0;
// $state='2';
// $helpid = 'A4098751E2D534584FA5';
// $useful='无用';
// $bonus=0;
// $useraction="乐山豪奢";
public function Insert_helps($helpid, $userid, $nickname, $helptype, $contenttype, $content, $title, $hasimage, $hasvideo, $city, $location, $locationy, $bonus, $contenttype, $tag, $createtime, $refreshtime, $state)
{
$datetime = date('Y-m-d H:i:s', time());
$file = 'F:\\wampserver\\setup\\wamp\\www\\manager_comment.txt';
$content = "\n测试事务\n";
file_put_contents($file, $content, FILE_APPEND);
$this->sql = "INSERT INTO helps (helpid, userid,nickname,helptype, contenttype,title,content,hasimage,hasvideo,city,location,locationx,locationy,bonus, tag,createtime, refreshtime,state)\n VALUES ('{$helpid}','{$userid}','{$nickname}', '{$helptype}','{$contenttype}','{$content}','{$title}','{$hasimage}','{$hasvideo}','{$city}','{$location}','{$locationy}', '{$bonus}','{$contenttype}','{$tag}','{$createtime}','{$refreshtime}','{$state}')";
if ($this->conn->query($this->sql) && $this->conn->query($this->sql2)) {
$comm = new Comment();
$comm->name = $username;
$comm->date = $datetime;
$comm->text = $content;
$comm->kind = "OK";
$comm->id = $eventcommentid;
$json = json_encode($comm);
echo "{$json}";
} else {
$comm = new Comment();
$comm->name = $username;
$comm->date = date('Y-m-d H:i:s', time());
$comm->text = $content;
$comm->kind = "failed";
$comm->video = $hasvideo;
$json = json_encode($comm);
echo "{$json}";
}
$this->conn->close();
}
}
$comment = new ManagerComment();
$comment->Query_helps();
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
function create_guid()
{
$charid = strtoupper(md5(uniqid(mt_rand(), true)));
$hyphen = chr(45);
// "-"
$uuid = substr($charid, 0, 8) . substr($charid, 8, 4) . substr($charid, 12, 4) . substr($charid, 16, 4);
return $uuid;
}
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$comment = new ManagerComment();
$kind = test_input($_GET["kind"]);
switch ($kind) {
case "userid":
$page = test_input($_GET["page"]);
$userid = test_input($_GET["userid"]);
$comment->querycommentByuserid($userid, $page);
break;
case "eventid":
$eventid = test_input($_GET["eventid"]);
// $eventid="2D9C9163EA8B2D830267";
$page = test_input($_GET["page"]);
$file = 'F:\\wampserver\\setup\\wamp\\www\\manager_eventcomment.txt';
$content = "eventid:" . $eventid . "**page" . " {$page}";
file_put_contents($file, $content, FILE_APPEND);
$comment->querycommentByeventid($eventid, $page);
