mint/app/term/term_post.php

<?php
require_once "../path.php";
require_once "../public/_pdo.php";
require_once '../public/function.php';

$respond=array("status"=>0,"message"=>"");
PDO_Connect("sqlite:"._FILE_DB_TERM_);

if($_POST["id"]!=""){
	#更新
    $query="UPDATE term SET meaning= ? ,other_meaning = ? , tag= ? ,channal = ? ,  language = ? , note = ? , receive_time= ?, modify_time= ?   where guid= ? ";
    $stmt = @PDO_Execute($query,array($_POST["mean"],
                                        $_POST["mean2"],
                                        $_POST["tag"],
                                        $_POST["channal"],
                                        $_POST["language"],
                                        $_POST["note"],
                                        mTime(),
                                        mTime(),
                                        $_POST["id"]
                                        ));
    if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
        $error = PDO_ErrorInfo();
        $respond['status']=1;
        $respond['message']=$error[2].$query;
    }
    else{
        $respond['status']=0;
        $respond['message']=$_POST["word"];
    }
}
else{
	#新建
	$parm[]=UUID::v4();
	$parm[]=$_POST["word"];
	$parm[]=pali2english($_POST["word"]);
	$parm[]=$_POST["mean"];
	$parm[]=$_POST["mean2"];
	$parm[]=$_POST["tag"];
	$parm[]=$_POST["channal"];
	$parm[]=$_POST["language"];
	$parm[]=$_POST["note"];
	$parm[]=$_COOKIE["userid"];
	$parm[]=0;
	$parm[]=mTime();
	$parm[]=mTime();
	$parm[]=mTime();
	$query="INSERT INTO term (id, guid, word, word_en, meaning, other_meaning, tag, channal, language,note,owner,hit,create_time,modify_time,receive_time ) 
	VALUES (NULL, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "; 
	$stmt = @PDO_Execute($query,$parm);
    if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
        $error = PDO_ErrorInfo();
        $respond['status']=1;
        $respond['message']=$error[2].$query;
    }
    else{
        $respond['status']=0;
        $respond['message']=$_POST["word"];
    }
}
    

    echo json_encode($respond, JSON_UNESCAPED_UNICODE);

?>