连接数据库的过程
<?php //1.创建数据库连接 //$连接变量 = mysqli_connect("地址","数据库用户名","密码","数据库","端口"); $con = mysqli_connect("localhost","root","123456","test","3306");//2.判断是否连接成功 if (!$con){ //如果连接不成功,则提示失败提示 die('Could not connect: ' . mysql_error()); //如果连接成功,则执行代码 }else{ //设置字符集 mysqli_set_charset($con,'utf8'); //3.执行SQL语句,如增删改查 //$结果 = mysqli_query(连接变量,SQL语句) $result = mysqli_query( $con, "SELECT * FROM `user`" ); //4.设置请求头,否则跨域会请求不成功 header('Access-Control-Allow-Origin:*'); //5.输出数据,以json的方式 echo json_encode(mysqli_fetch_all($result),JSON_UNESCAPED_UNICODE); }; //6.关闭连接 mysqli_close($con);?>