Http://www.yinghualuowu.com/php/echart.html
CREATE TABLE sex with Name num
<?PHPIni_set(' Display_errors ', 1);//error Message Ini_set(' Display_startup_errors ', 1);//PHP startup error message error_reporting(-1); Ini_set(' Error_log ',dirname(__file__) . '/error3_log.txt ');//Print out all the error messages require("config.php"); $conn=Mysqli_connect($mysql _server_name,$mysql _username,$mysql _password) or die("Error Connecting"); Mysqli_query($conn, ' Set names UTF8 '); mysqli_select_db($conn,$mysql _database); $result=Mysqli_query($conn, "SELECT * from Sex"); $data=""; $array=Array(); classuser{ Public $name; Public $num; } while($row=Mysqli_fetch_array($result,Mysqli_assoc)) { //printf ("%s:%s", $row ["name"], $row ["num"]); $user=NewUser (); $user->name=$row[' Name ']; $user->num=$row[' Num ']; $array[]=$user; } $data=json_encode ($array); Echo $data;?>
In this way, we create a JSON file
<!DOCTYPE HTML><HTML><Head><MetaCharSet= "Utf-8"><title>Untitled Document</title><Scriptsrc=".. /js/echarts.min.js "></Script><Scriptsrc= "Https://apps.bdimg.com/libs/jquery/2.1.4/jquery.min.js"></Script></Head><Body><DivID= "Main"style= "height:400px"></Div><Scripttype= "Text/javascript"> varMyChart=Echarts.init (document.getElementById ('Main')); vararr1=[],ARR2=[]; functionarrtest () {$.ajax ({type:"Post", URL:"echart.php", DataType:"JSON", Async:false, data:{}, Success:function(Result) {if(Result) { for (varI= 0; I<result.length; I++) {Arr1.push (result[i].name); Arr2.push (Result[i].num); }}}, error:function(errormsg) {alert ("Data read failed"); } }) returnarr1,arr2; } arrtest (); Console.log (arr1[0]); varoption={tooltip: {show:true}, Legend: {data:['Num']}, Xaxis: [{type:'category', DATA:ARR1}], YAxis: [ {type:'value'}], series: [{ "name":"Num", "type":"Bar", "Data": arr2}] }; mychart.setoption (option); </Script></Body></HTML>
PHP and MySQL with Ajax and Echart synthesis