<?php
// echo "面向对象风格,连接数据库事例<br>";
$servername = "localhost";//服务器地址;
$username = "root";//mysql用户名;
$password = "";//用户密码,没有密码不用写;
$dbname = "php_test";//mysql数据库名称;
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// var_dump($conn);
//判断连接数据库是否成功
if ($conn->connect_error) {
die("连接失败:" . $conn->connect_error);//结束程序
}
//从MySQL数据库读取数据,设置编码
mysqli_query($conn, "SET NAMES utf8mb4");
//查询<* 代表查询所有字段,zrzf_bank为表名>
$sql = "SELECT * FROM zrzf_bank";
//执行sql语句?????: $conn->query($sql);这里query是方法,实例对象的方法;
$result = $conn->query($sql);
//判断是否有查询数据
if ($result->num_rows > 0) {
$dataArr = array();
while($row = $result->fetch_assoc()) {
// 保存数据
$result1= (array)$row;
$dataArr[] = $result1;
}
// 返回json数据
// var_dump($dataArr);
$backJson = array("data"=>$dataArr);
$jsonS = json_encode($backJson);
echo $jsonS;
}else {
echo "没有数据!";
}
//增加<zrzf_zkl为表名,zkl, type, time为表的字段>
$sql1 = "INSERT INTO zrzf_zkl (zkl, type, time) VALUES ('100', '3', '1495587058')";
if ($conn->query($sql1) === TRUE) {
echo "插入记录成功!<br>";
} else {
echo "插入记录失败! Error:".$sql1."<br>".$conn->error;
}
//删除<zrzf_zkl为表名,type为表的字段>
$sql2 = "DELETE FROM zrzf_zkl WHERE type='3'";
if($conn->query($sql2)==TRUE){
echo "删除记录成功!<br>";
}else{
echo "删除记录失败! Error:".$sql1."<br>".$conn->error;
}
//更新<zrzf_zkl为表名,type为表的字段>
$sql3 = "UPDATE zrzf_zkl SET zkl=36 WHERE type='2'";
if($conn->query($sql3)==TRUE){
echo "更新记录成功!<br>";
}else{
echo "更新记录失败! Error:".$sql1."<br>".$conn->error;
}
$conn->close();//关闭连接