php操作mysql

た入场券 2022-08-19 11:24 48阅读 0赞

使用xampp集成环境

（1）从xampp控制面板进入phpmyadmin

点击mysql-admin进入phpmyadmin

![20160112154821605][]

（2）test数据库中新建t\_student表，表共三个字段，编号id,姓名name,年龄age

![20160112155108743][]

选中t\_student表，自己录入几个数据

![20160112155532168][]

（3）新建php文件，访问t\_student数据表

<?php
    //连接数据库
    
    //定义常量  
    //define(DB_HOST, 'localhost');  
    //define(DB_USER, 'root');  
    //define(DB_PASS, '111111');  
    //define(DB_DATABASENAME, 'test');  
    //define(DB_TABLENAME, 't_student');  
      
    $DB_TABLENAME='t_student';
    $dbcolarray = array('id', 'name', 'age');  
      
    //mysql_connect  
    $conn = mysql_connect("localhost", "root", "") or die("connect failed" . mysql_error());//初始密码为空  
    mysql_select_db('test', $conn);  
      
    //读取表中纪录条数  
    $sql = sprintf("select count(*) from %s", 't_student');  
    $result = mysql_query($sql, $conn);  
    if ($result)  
    {  
        $count = mysql_fetch_row($result);  
    }  
    else  
    {  
        die("query failed");  
    }  
    echo "表中有$count[0] 条记录<br />";  
      
      
    $sql = sprintf("select %s from %s", implode(",",$dbcolarray), $DB_TABLENAME);  
    $result = mysql_query($sql, $conn);  
    //表格  
    echo '<table id="Table" border=1 cellpadding=10 cellspacing=2 bordercolor=#ffaaoo>';   
    //表头  
    $thstr = "<th>" . implode("</th><th>", $dbcolarray) . "</th>";  
    echo $thstr;  
    //表中的内容  
    while ($row=mysql_fetch_array($result, MYSQL_ASSOC))//与$row=mysql_fetch_assoc($result)等价  
    {  
        echo "<tr>";  
        $tdstr = "";  
        foreach ($dbcolarray as $td)  
            $tdstr .= "<td>$row[$td]</td>";  
        echo $tdstr;  
        echo "</tr>";  
    }  
    echo "</table>";  
    mysql_free_result($result);  
    mysql_close($conn);
    ?>

保存为mysql\_php.php，放到xampp\\htdocs文件夹里，浏览器输入http://localhost/mysql\_php.php，会打开页面如下，访问成功

![20160112155933709][]

pdo创建数据库

$dsn = "mysql:host=localhost;";  
$db = new PDO($dsn, 'root', '');  
$db->query('create database test');

pdo创建、插入数据表

$dbms='mysql';
    	$user='root';
    	$pwd='';
    	$host='localhost';
    	$dbName='database';
    	$dsn="$dbms:host=$host;dbname=$dbName";
    	if(isset($_POST['sub'])){
    		try {
    			$pdo = new PDO($dsn,$user,$pwd);
    			$pdo->query("SET NAMES utf8");
                $sql = "CREATE TABLE Persons 
                (
                FirstName varchar(15),
                LastName varchar(15),
                Age int
                )";
                $pdo->exec($sql);
    			$sql="insert into tb_fb(FirstName ,LastName ,Age) values('James','Cameron',15)";
    			$rs=$pdo->exec($sql);
    			if($rs=="1"){
    				echo "<b>插入成功</b>";
    			}
    		} catch (Exception $e) {
    			echo "ERROR".$e->getMessage()."<br>";
    		}
    	}

[20160112154821605]: /images/20220731/2fef755a9a3a4109bf66621432acbcf6.png
[20160112155108743]: /images/20220731/fe4f04c3aa6a41cb977c33f7be0c3d99.png
[20160112155532168]: /images/20220731/ea5f0fd9cbf94d25b1c438a5f499b656.png
[20160112155933709]: /images/20220731/5b19496dec014bdc8c27f57779f03770.png