php操作mysql

来源：互联网发布：最新中国省市区数据库编辑：程序博客网时间：2024/06/05 05:17

使用xampp集成环境

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

点击mysql-admin进入phpmyadmin

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

选中t_student表，自己录入几个数据

（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，会打开页面如下，访问成功

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>";}}

0 0