การใช้ abdul ดึงข้อมูลจาก mysql ด้วย PHP มาแสดงใน Line chatbot โดยใช้ XJSON

Abdul

result  Line chatbot

Mysql

create table person

id ( int auto increament)

titleNameTHFULL(varchar)

nameTh(varchar)

surname (varchar)

DeparmentName(varchar)

groupname(varchar)

phonenumber(varchar)

php

///////////  connections.php //////

<?php

$Setup_Server = 'host';

$Setup_User = 'user_db';

$Setup_Pwd = ''password_db";

$Setup_Database = 'name_db';

mysql_connect($Setup_Server,$Setup_User,$Setup_Pwd);

mysql_query("use $Setup_Database");

mysql_query("SET NAMES UTF8");

?>

/////////////////

<?php

header('Access-Control-Allow-Origin: *');

header('Access-Control-Allow-Methods: GET, POST');  

include('connections.php');

$name = $_REQUEST['name'];

$sql = "SELECT  * from  person where name   LIKE '%".$name."%'  ";

$resource = mysql_query($sql);

$count_row = mysql_num_rows($resource);

if($count_row > 0) {

while($result = mysql_fetch_assoc($resource)){

$rows[]=$result;

}

$data = json_encode($rows);

$totaldata = sizeof($rows);

$results = '{"results":'.$data.'}';

}else{

$results = '{"results":null}';

}

echo $results;

?>

/////////////

test url result
http://url/bot.php?name=วิษณุ
////////// 


{
  "results": [
    {
   
      "titleNameTHFULL": "นาย",
      "nameTh": "วิษณุ",
      "surname": "รักชาติยิ่งชีพ",
      "DeparmentName": "สำนักสารสนเทศ",
      "groupname": "กลุ่มเครือข่ายคอมพิวเตอร์",
       phonenumber": " 0 1234 2367",
     }
  ]
}

///////////////////////////////////////////