<?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();//关闭连接
转载于:https://www.cnblogs.com/KennyHito/p/6897387.html
相关资源：JAVA上百实例源码以及开源项目