PHP从零开始（第四天）

参考资料：http://www.runoob.com/php/php-ajax-intro.html

31.PHP MySQL插入多条数据

function insertDatas($mysqli,$dbName){
    $sql = "INSERT INTO $dbName(name,age,sex) VALUES('老大','20','男');";
    $sql .= "INSERT INTO $dbName(name,age,sex) VALUES('老2','21','女');";
    $sql .= "INSERT INTO $dbName(name,age,sex) VALUES('老3','22','男');";

    if($mysqli->multi_query($sql) === true){
        echo "插入三条数据成功";
    }else{
        echo "插入三条数据失败";
    }
}

32.PHP MySQL预处理语句
注意： 如果你想插入其他数据（用户输入），对数据的验证是非常重要的。
MySQLi面向对象处理方式：
<?php
$mysqli = new mysqli("localhost", "root","","myDB");
if ($mysqli->connect_error) {
    die("连接失败" . $mysqli->connect_error);
}
echo "连接成功"."<br>";

$stmt = $mysqli->prepare("INSERT INTO user(name,age,sex) VALUES(?,?,?)");
$stmt->bind_param('sis',$name,$age,$sex);

$name = "呵呵";
$age = 22;
$sex = "男";
$stmt->execute();

$mysqli->close();
?>

33.PHP MySQL数据查询
<?php
$mysqli = new mysqli("localhost", "root", "", "myDB");
if ($mysqli->connect_error) {
    die("连接失败" . $mysqli->connect_error);
}
echo "连接成功" . "<br>";

$sql = "select name,age,sex from user";
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()){
        echo "name=".$row["name"]." ; "."age=".$row["age"]." ; "."sex=".$row["sex"]."<br>";
    }
}else{
    echo "0个结果";
}

$mysqli->close();
?>

34.PHP MySQL Where子句
语法：SELECT column_name(s) FROM table_name WHERE column_name operator value

$mysqli = new mysqli("localhost", "root", "", "myDB");
if ($mysqli->connect_error) {
    die("连接失败" . $mysqli->connect_error);
}
echo "连接成功" . "<br>";

$sql = "select * from user where name = '老大'";
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
    while($assoc = $result -> fetch_assoc()){
        echo $assoc['name'].";".$assoc['age'].";".$assoc['sex'].";<br>";
    }
}else{
    echo "0个结果";
}
$mysqli->close();

35.PHP  Order By关键词
用于对记录集中的数据进行排序，默认对记录进行升序排序。如果想要降序排序，使用DESC
语法：SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC

$mysqli = new mysqli("localhost", "root", "", "myDB");
if ($mysqli->connect_error) {
    die("连接失败" . $mysqli->connect_error);
}
echo "连接成功" . "<br>";

$sql = "select * from user order by age DESC";
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
    while($assoc = $result -> fetch_assoc()){
        echo $assoc['name'].";".$assoc['age'].";".$assoc['sex'].";<br>";
    }
}else{
    echo "0个结果";
}
$mysqli->close();

36.PHP  MySQL Update
用于修改数据库表中的数据
语法：UPDATE table_name SET column1=value, column2=value2,...
      WHERE some_column=some_value

$sql = "update user set age = 30 where name = '小王'";
$result = $mysqli->query($sql);
var_dump($result);
if ($result) {
    echo "更新成功<br>";
}

37.PHP MySQL Delete
Delete语句从数据库删除行
语法：DELETE FROM table_name WHERE some_column = some_value
注释：请注意 DELETE 语法中的 WHERE 子句。WHERE 子句规定了哪些记录需要删除。如果您想省去 WHERE 子句，所有的记录都会被删除！

$sql = "delete from user where name = '呵呵'";
$result = $mysqli->query($sql);
var_dump($result);
if($result){
    echo "删除成功";
}