首页 » 网站推广 » phpjsonmysql技巧_phpjsonmysql实现前后端分离

phpjsonmysql技巧_phpjsonmysql实现前后端分离

访客 2024-10-30 0

扫一扫用手机浏览

文章目录 [+]

如有欠妥之处,请给予示正

先来前真个

phpjsonmysql技巧_phpjsonmysql实现前后端分离

<<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <title>前后端分离</title></head><body><input type="button" value="获取数据" onclick="getdata()"> <script type="text/javascript"> function getdata(){ var xhr = new XMLHttpRequest(); xhr.onreadystatechange = function(){ if(xhr.readyState==4){ eval("backdata="+xhr.responseText); xuanran(backdata.json); console.log(backdata); } }; xhr.open('get','./text.php'); xhr.send(null); } function xuanran(data){ for(x in data){ for(y in data[x]){ document.write(data[x][y]); } } } </script></body></html>

后真个

phpjsonmysql技巧_phpjsonmysql实现前后端分离
(图片来自网络侵删)

<?phpheader('content-type:text/json');selectXiBu();function selectXiBu(){ $connection = mysqli_connect("localhost","root","","php"); if(!$connection){ echo "数据库连接缺点"; } else{ mysqli_query($connection,'set names utf8'); $selectSql = "select from student limit 50"; $result = mysqli_query($connection,$selectSql); $count=0; $aaaa=""; $json=""; while ($row = mysqli_fetch_array($result)){ $count++; $xh = $row['student'].$row['学号']; $xm = $row['student'].$row['姓名']; $sex = $row['student'].$row['性别']; $nl = $row['student'].$row['年事']; $dh = $row['student'].$row['电话']; $xb = $row['student'].$row['系部']; $zy = $row['student'].$row['专业']; $dz = $row['student'].$row['地址']; $key="s".$count; $value="\"学号\":\"$xh\",\"姓名\":\"$xm\",\"性别\":\"$sex\",\"年事\":\"$nl\",\"电话\":\"$dh\",\"系部\":\"$xb\",\"专业\":\"$zy\",\"地址\":\"$dz\""; $aaaa.="\"".$key."\"".":"."{".$value."}".($count<50?",":""); $json ="{\""."json"."\"".":{".$aaaa."}}"; } echo $json; }}?>

标签:

相关文章

Python编程从入门到精通,探索编程之美

编程已经成为现代社会的一项基本技能。Python作为一种简单易学、功能强大的编程语言,在我国教育领域备受关注。本文将从Python...

网站推广 2025-03-02 阅读1 评论0

Scum07代码编程之美与适用方法

编程已成为当今社会不可或缺的技能之一。Scum07代码作为一款经典的编程语言,在我国众多程序员中备受推崇。本文将深入解析Scum0...

网站推广 2025-03-02 阅读1 评论0

Linux环境下的前端代码运行优化与步骤

前端技术逐渐成为软件开发的核心。Linux操作系统因其稳定性、安全性、开放性等特点,成为众多开发者和企业青睐的运行环境。本文将从L...

网站推广 2025-03-02 阅读1 评论0