Share information about php writing app interface and returning json data examples-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Share information about php writing app interface and returning json data examples

Aug 13, 2017 pm 02:10 PM

javascript json php

The following editor will bring you an example (share) of writing an app interface in PHP and returning json data. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look.

The first step: conn.PHP file, used to connect to the databaseAnd define the interface format, the code is as follows:

&lt;?php 
 header(&quot;charset=utf-8&quot;); 
 $servername=&quot;localhost&quot;; 
 $username=&quot;root&quot;; 
 $password=&quot;root&quot;; 
 $dbname=&quot;test&quot;; 
 $conn = mysql_connect($servername,$username,$password); 
 if(!$conn){ 
  echo &quot;数据库连接失败！&quot;; 
 } 
 mysql_select_db($dbname); 
 class Response{ 
  public static function json($code,$message=&quot;&quot;,$data=array()){ 
   $result=array( 
    &#39;code&#39;=&gt;$code, 
    &#39;message&#39;=&gt;$message, 
    &#39;data&#39;=&gt;$data 
   ); 
   //输出json 
   echo json_encode($result); 
   exit; 
  } 
 } 
 
?&gt;

Copy after login

Step 2: text.php, used to convert the data in the database into a json string and output:

&lt;?php 
 require_once(&#39;conn.php&#39;); 
 /* 
  *选择数据表 
  * */ 
 $sqla = &quot;SELECT * from user&quot;; 
 $result = mysql_query($sqla,$conn); 
 $dataarr = array(); 
 while($row = mysql_fetch_array($result)){ 
  $dataarr[]=$row; 
 } 
 $id=$_GET[&#39;id&#39;]; 
 if($id==1){ 
  Response::json(1,&#39;数据返回成功&#39;,$dataarr); 
 }else if($id==2){ 
  Message::json(0,&#39;失败&#39;); 
 } 
  
?&gt;

Copy after login

The third step: text.html, ajax loads json data and displays:

&lt;!DOCTYPE html&gt; 
&lt;html&gt; 
 &lt;head&gt; 
  &lt;meta charset=&quot;UTF-8&quot;&gt; 
  &lt;title&gt;&lt;/title&gt; 
  &lt;script src=&quot;jquery/2.0.0/jquery.min.js&quot;&gt;&lt;/script&gt; 
 &lt;/head&gt; 
 &lt;body&gt; 
  &lt;input id=&quot;text&quot; type=&quot;text&quot;/&gt; 
  &lt;input type=&quot;button&quot; id=&quot;tijiao&quot; value=&quot;提交&quot; /&gt; 
  &lt;p id=&quot;tex&quot;&gt;&lt;/p&gt; 
  &lt;script type=&quot;text/javascript&quot;&gt; 
   $(&quot;#tijiao&quot;).click(function(){ 
    var data={&quot;id&quot;:$(&quot;#text&quot;).val()} 
    $.get(&quot;text.php?flag=showmessage&quot;,data,function(res){ 
     res=JSON.parse(res);//&lt;span style=&quot;color:#cc0000;&quot;&gt;将json字符串转化为json对象&lt;/span&gt; 
     if(res.code==1){ 
      $(&quot;#tex&quot;).empty(); 
      $.each(res.data, function(x,y) { 
       $(&quot;#tex&quot;).append(&quot;id:&quot;+y.id+&quot;/姓名:&quot;+y.username+&quot;&lt;br&gt;&quot;); 
      }); 
     } 
    }) 
   }) 
    
  &lt;/script&gt; 
 &lt;/body&gt; 
&lt;/html&gt;

Copy after login

This can be achieved Use php to write json interface.

The above is the detailed content of Share information about php writing app interface and returning json data examples. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn