PHP入门1.9

• Mail邮件发送
  
  • 语法：mail(to,subject,message,headers,parameters)
• Mysql数据库连接
  
  • 语法 ：
  • $conn = new mysqli($servername,$username,$password);
• Example:

面向对象
<?php
    $servername = "localhost";
    $username = "root";
    $password = "root";
    //创建一个连接，连接到数据库
    $conn = new mysqli($servername,$username,$password);
    //判断是否连接成功
    if($conn->connect_error){
        die("Connect error:".$conn->connect_error);
    }
    echo "Connect successful!"
?>

• Example:

面向过程
<?php
    $servername="localhost";
    $username="root";
    $password="root";
    //连接到数据库
    $conn = mysqli_connect($servername,$username,$password);

    if(!$conn){
        die("Connection failed:".mysqli_connect_error());
    }
    echo "Connection successful!";

    ?>

• Example:

PDO面向实例
<?php
    $servername="localhost";
    $username="root";
    $password="root";
    try{
    //连接到数据库
    $conn = new PDO("mysql:host=$servername;dbname=sql",$username,$password);
    }catch(PDOException $e){
        echo $e->getMessage();
    }
?>

• 数据库关闭连接

面向对象的关闭方式:
    $conn->close();
面向过程的关闭方式:
    mysqli_close($conn);
面向PDO实例的关闭方式:
    $conn = null;

• 创建数据库

面向对象:
        $sql = "CREATE DATABASE myDB";
        if($conn->query($sql) === TRUE){
            echo "创建成功";
        }else{
            echo "创建失败：".$conn->error;
        }
        $conn->close();
(推荐使用)PDO实例:
<?php   
    $servername="localhost";
    $username="root";
    $password="root";
    $dbname="mydb";
    try{
    //连接到数据库
$conn = new PDO("mysql:host=$servername;dbname=sql",$username,$password);
$conn.setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    $sql = "CREATE DATABASE $dbname";
    $conn->exec($sql);
    echo $dbname."数据库创建成功";
    }catch(PDOException $e){
        echo $e->getMessage();
    }
    $conn = null;
?>

• PDO实例创建数据表

<?php
        $servername="localhost";
        $username="root";
        $password="root";
        $dbName="mydb";
        $Table="Mytable";
        try{
        //连接到数据库
            $conn = new PDO("mysql:host=$servername;dbname=$dbName",$username,$password);
        //设置错误异常，用于抛出异常
$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
        //创建sql语句
            $sql="
            CREATE TABLE $Table(
                id int(6) AUTO_INCREMENT PRIMARY KEY,
                name varchar(20) NOT NULL,
                email varchar(50) NOT NULL
            );";
            $conn->exec($sql);
            echo "创建表".$Table."成功";
        }catch(PDOException $e){
            echo $e->getMessage();
        }
        $conn = null;
    ?>

• PDO实例插入数据

<?php
$servername="localhost";
        $username="root";
        $password="root";
        $dbName="mydb";
        $Table="Mytable";
        try{
        //连接到数据库
            $conn = new PDO("mysql:host=$servername;dbname=$dbName",$username,$password);
        //设置错误异常，用于抛出异常
            $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
        /*
        创建表的sql语句
                        */
            // $sql="
            // CREATE TABLE $Table(
                // id int(6) AUTO_INCREMENT PRIMARY KEY,
                // name varchar(20) NOT NULL,
                // email varchar(50) NOT NULL
            // );";
        /*
        向表里插入多条数据的方法
                                */
            $conn->beginTransaction();//插入多条数据时，事务开始                           
            $conn->exec("INSERT INTO $Table VALUES('','EngineerZhong1','xunwu451@126.com');");
            $conn->exec("INSERT INTO $Table VALUES('','EngineerZhong2','xunwu451@126.com');");
            $conn->exec("INSERT INTO $Table VALUES('','EngineerZhong3','xunwu451@126.com');");
            $conn->commit();//提交事务，插入数据完成  
            // echo "创建表".$Table."成功";
            echo "插入数据成功";
        }catch(PDOException $e){

            $conn->rollback();//插入数据失败，回滚！！！
            echo $e->getMessage();
        }
?>

• PDO实例插入多条数据，预处理语句

<?php
        $servername="localhost";
        $username="root";
        $password="root";
        $database="mydb";
        try{
            //连接数据库
            $conn = new PDO("mysql:host=$servername;dbname=$database",$username,$password);
            //设置错误模式为异常
            $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
            //预处理语句
            $stmt = $conn->prepare("INSERT INTO mytable VALUES(:id,:name,:email);");
            $stmt->bindParam(":id",$id);
            $stmt->bindParam(":name",$name);
            $stmt->bindParam(":email",$email);

            $id="";
            $name="jay";
            $email="xunwu.com";
            $stmt->execute();

            $id="";
            $name="jolin";
            $email="zhongwenbin.com";
            $stmt->execute();

            $id="";
            $name="JJ";
            $email="zhongwenbin12.com";
            $stmt->execute();

            echo "插入多条数据成功！";   

        }catch(PDOException $e){
            echo "sql:"."<br>".$e->getMessage();
        }
        $conn = null;
    ?>

• 面向对象模式查询数据库数据（PDO不会，哈哈哈哈）

<?php
            //连接到数据库
            $conn = mysql_connect("localhost","root","root");
            if(!$conn){
                die("Connection field!".mysql_error());
            }
            //选择名为mydb数据库
            mysql_select_db("mydb",$conn);
            //创建result变量存取查询到的数据
            $result = mysql_query("select * from mytable");
            //定义一个表格样式
            $tr_th="<th style='border: solid 1px black;'>";
            echo "<table style='border:solid 1px black;'>";
            echo "
                <tr>
                    $tr_th Id</th>
                    $tr_th Name</th>
                    $tr_th Email</th>
                </tr>
                 ";
            //把查询到的数据存入到row数组中
            $tr_td = "<td style='border: solid 1px black;'>";
            while($row = mysql_fetch_array($result)){
                echo "<tr>";
                echo $tr_td.$row["id"]."</td>";
                echo $tr_td.$row["name"]."</td>";
                echo $tr_td.$row["email"]."</td>";
                echo "</tr>";
            }
            echo "</table>";
            //关闭连接
            mysql_close($conn);
?>

• 更改数据库数据

<?php
            $conn = mysql_connect("localhost","root","root");
            if(!$conn){
                die("Connection field ".mysql_error());
            }
            mysql_select_db("mydb",$conn);
            mysql_query("
                update mytable 
                    set email = 'zhongwenbin'
                    where id = 1004;
            ",$conn);
            $mark = mysql_affected_rows();
            echo $mark;    
            echo "<br>";
            if($mark > 0){
                echo $mark." 条数据被成功修改";
            }else{
                echo "没有成功修改到数据";
            }
            mysql_close($conn);
?>

• PHP删除数据面向对象过程

<?php
            $conn = mysql_connect("localhost","root","root");
            if(!$conn){
                die("Connection field ".mysql_error());
            }
            mysql_select_db("mydb",$conn);
    mysql_query(
                "delete from mytable 
                    where id=1012;
                "
            ,$conn);
            $mark = mysql_affected_rows();
            if($mark > 0){
                echo "<br>";
                echo "成功删除".$mark."条数据";
            }else{
                echo "<br>";
                echo "删除失败";
            }
            mysql_close($conn);
?>

更新时间:2016年8月19日             By:EngineerZhong