初学php+mysql,一些配置以及基本操作:记录一下学习之路
$servername = "localhost";
$username = "root";
$password = "root";
$db = "manager";
// 创建连接
$conn = new mysqli($servername, $username, $password,$db);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
};
// 查询表数据
// header('Content-Type:application/json');
// $sql = "SELECT * FROM user";
// $result = mysqli_query($conn, $sql);
// if (mysqli_num_rows($result) > 0) {
// // 输出数据
// while($row = mysqli_fetch_assoc($result)) {
// $arr =array("name"=>$row["name"],"pass"=>$row["pass"]);
// echo json_encode( $arr );
// }
// } else {
// echo "0";
// }
//插入数据
// $sql = "INSERT INTO user (name, pass) VALUES ('John', 'Doe')";
// if ($conn->query($sql) === TRUE) {
// echo "新记录插入成功";
// } else {
// echo "Error: " . $sql . "
" . $conn->error;
// };
//删除数据
// $sql = 'DELETE FROM user WHERE pass="a"';
// mysqli_select_db( $conn, 'manager' );
// $retval = mysqli_query( $conn, $sql );
// if(! $retval )
// {
// die('无法删除数据: ' . mysqli_error($conn));
// }
// echo '数据删除成功!';
//更新数据
mysqli_query($conn , "set names utf8");
$sql = 'UPDATE user SET pass="abcdefg" WHERE name="aaa"';
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法更新数据: ' . mysqli_error($conn));
}
echo '数据更新成功!';
?>