PHP入门1.9

来源：互联网发布：joo yeon seo三级编辑：程序博客网时间：2024/06/05 02:21

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

0 0