狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv

--

-- 表的結(jié)構(gòu) `tbl_customer`

--



CREATE TABLE `tbl_customer` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '//消息ID',

  `from_user` char(50) NOT NULL COMMENT '//消息發(fā)送者',

  `message` varchar(200) NOT NULL COMMENT '//消息體',

  `time_stamp` datetime NOT NULL COMMENT '//消息發(fā)送時間',

  PRIMARY KEY (`id`),

  KEY `from_user` (`from_user`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

function _query($_sql){

    if(!$_result = mysql_query($_sql)){

        exit('SQL執(zhí)行失敗'.mysql_error());

    }

    return $_result;

}

//引入數(shù)據(jù)庫處理函數(shù)

require_once 'sql.func.php';

function _record_message($fromusername,$keyword,$date_stamp){

    //調(diào)用_query()函數(shù)

    _query("INSERT INTO tbl_customer(from_user,message,time_stamp) VALUES('$fromusername','$keyword','$date_stamp')");

}

//引入回復(fù)文本的函數(shù)文件

require_once 'responseText.func.inc.php';

//引入記錄消息的函數(shù)文件

require_once 'record_message.func.inc.php';

    //處理文本消息函數(shù)

    public function handleText($postObj)

    {

        //獲取消息發(fā)送者，消息體，時間戳

        $fromusername = $postObj->FromUserName;

        $keyword = trim($postObj->Content);

        $date_stamp = date('Y-m-d H:i:s');

        if(!empty( $keyword ))

        {

            //調(diào)用_record_message()函數(shù)，記錄消息入數(shù)據(jù)庫

            _record_message($fromusername,$keyword,$date_stamp);

            

            $contentStr = $keyword;

            //調(diào)用_response_text()函數(shù)，回復(fù)發(fā)送者消息

            $resultStr = _response_text($postObj,$contentStr);

            echo $resultStr;

        }else{

            echo "Input something...";

        }

    }

//引入數(shù)據(jù)庫操作文件

require_once 'includes/sql.func.php';

//分頁模塊

global $_pagesize,$_pagenum;

_page("SELECT id FROM tbl_customer",15);        //第一個參數(shù)獲取總條數(shù)，第二個參數(shù)，指定每頁多少條

$_result = _query("SELECT * FROM tbl_customer ORDER BY id DESC LIMIT $_pagenum,$_pagesize");

<form>

    <table cellspacing="1">

        <tr><th>消息ID</th><th>發(fā)送者</th><th>消息體</th><th>消息時間</th><th>操作</th></tr>

        <?php 

            while(!!$_rows = _fetch_array_list($_result)){

                $_html = array();

                $_html['id'] = $_rows['id'];

                $_html['from_user'] = $_rows['from_user'];

                $_html['message'] = $_rows['message'];

                $_html['time_stamp'] = $_rows['time_stamp'];

        ?>

        <tr><td><?php echo $_html['id']?></td><td><?php echo $_html['from_user']?></td><td><?php echo $_html['message']?></td><td><?php echo $_html['time_stamp']?></td><td><a href="reply.php?fromusername=<?php echo $_html['from_user']?>&message=<?php echo $_html['message']?>"><input type="button" value="回復(fù)" /></a></td></tr>

        <?php 

            }

            _free_result($_result);

        ?>

    </table>

</form>

https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=ACCESS_TOKEN

{

    "touser":"OPENID",

    "msgtype":"text",

    "text":

    {

         "content":"Hello World"

    }

}

function _reply_customer($touser,$content){

    

    //更換成自己的APPID和APPSECRET

    $APPID="wxef78f22f877db4c2";

    $APPSECRET="3f3aa6ea961b6284057b8170d50e2048";

    

    $TOKEN_URL="https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=".$APPID."&secret=".$APPSECRET;

    

    $json=file_get_contents($TOKEN_URL);

    $result=json_decode($json);

    

    $ACC_TOKEN=$result->access_token;

    

    $data = '{

        "touser":"'.$touser.'",

        "msgtype":"text",

        "text":

        {

             "content":"'.$content.'"

        }

    }';

    

    $url = "https://api.weixin.qq.com/cgi-bin/message/custom/send?access_token=".$ACC_TOKEN;

    

    $result = https_post($url,$data);

    $final = json_decode($result);

    return $final;

}

function https_post($url,$data)

{

    $curl = curl_init();

    curl_setopt($curl, CURLOPT_URL, $url); 

    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, FALSE);

    curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, FALSE);

    curl_setopt($curl, CURLOPT_POST, 1);

    curl_setopt($curl, CURLOPT_POSTFIELDS, $data);

    curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

    $result = curl_exec($curl);

    if (curl_errno($curl)) {

       return 'Errno'.curl_error($curl);

    }

    curl_close($curl);

    return $result;

}

//引入回復(fù)消息的函數(shù)文件

require_once '../customer.php';

<form method="post" action="reply.php?action=reply">

    <dl>

        <dd><strong>收件人：</strong><input type="text" name="tousername" class="text" value="<?php echo $from_username?>" /></dd>

        <dd><strong>原消息：</strong><input type="text" name="message" class="text" value="<?php echo $message?>" /></dd>

        <dd><span><strong>內(nèi)　容：</strong></span><textarea rows="5" cols="34" name="content"></textarea></dd>

        <dd><input type="submit" class="submit" value="回復(fù)消息" /></dd>

    </dl>

</form>

if($_GET['action'] == "reply"){

    $touser = $_POST['tousername'];

    $content = $_POST['content'];

    $result = _reply_customer($touser, $content);

    

    if($result->errcode == "0"){

        _location('消息回復(fù)成功！', 'index.php');

    }

}