当前位置：Gxlcms > 数据库问题 > 数据库访问

数据库访问

时间：2021-07-01 10:21:17 帮助过：3人阅读

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 2 <html xmlns="http://www.w3.org/1999/xhtml"> 3 <head> 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 5 <title>无标题文档</title> 6 </head> 7 8 <body> 9 10 <h1>主页面</h1> 11 <div style="width:100%"> 12 13 <?php 14 15 //1.造连接对象 16 $db = new mysqli("localhost","root","123","mydb"); 17 18 //2.判断是否连接成功 19 if(mysqli_connect_error()) 20 { 21 echo "连接失败"; 22 23 //退出整个程序 24 exit; 25 } 26 else 27 { 28 29 //3.写SQL语句 30 $sql = "select * from Info"; 31 32 //4.执行SQL语句 33 $result = $db->query($sql); 34 35 //5.处理数据（提取数据） 36 37 echo "<table width=‘100%‘ cellpadding=‘0‘ cellspacing=‘0‘ border=‘1‘>"; 38 39 echo "<tr bgcolor=‘#66FF99‘><td>代号</td><td>姓名</td><td>性别</td><td>民族</td><td>生日</td><td>操作</td></tr>"; 40 41 //遍历每一条数据 42 while($row = $result->fetch_row()) 43 { 44 //处理性别 45 $sex = (bool)$row[2]?"男":"女"; 46 47 //处理民族 48 $nation = NationName($db,$row[3]); 49 50 //处理生日 51 $birthday = date("Y年m月d日",strtotime($row[4])); 52 53 echo "<tr><td>{$row[0]}</td><td>{$row[1]}</td><td>{$sex}</td><td>{$nation}</td><td>{$birthday}</td><td><a href=‘Delete.php?code=".$row[0]."‘>删除</a>&nbsp;<a href=‘XiuGai.php?code=".$row[0]."‘>修改</a></td></tr>"; 54 } 55 56 echo "</table>"; 57 58 } 59 60 61 62 63 //根据民族代号查询名族名称 64 function NationName($db,$code) 65 { 66 //写SQL语句 67 $sql = "select * from Nation where Code = ‘{$code}‘"; 68 69 //执行SQL语句 70 $result = $db->query($sql); 71 72 //处理数据 73 if($row = $result->fetch_row()) 74 { 75 return $row[1]; 76 } 77 else 78 { 79 return ""; 80 } 81 82 83 } 84 85 ?> 86 </div> 87 <div><a href="Add.php">添加数据</a></div> 88 89 </body> 90 </html>

添加页面

 1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 2 <html xmlns="http://www.w3.org/1999/xhtml">
 3 <head>
 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 5 <title>无标题文档</title>
 6 </head>
 7 
 8 <body>
 9 
10 <h1>添加页面</h1>
11 
12 <form action="Insert.php" method="post">
13 
14 <div><span style="width:80px;">代号：</span><input type="text" name="code" /></div>
15 
16 <div><span style="width:80px;">姓名：</span><input type="text" name="name" /></div>
17 
18 <div><span style="width:80px;">性别：</span><input type="radio" name="sex" value="true" checked="checked" />男&nbsp;&nbsp;<input type="radio" name="sex" value="false"/>女</div>
19 
20 <div><span style="width:80px;">民族：</span>
21 <select name="nation">
22     <?php
23         //1.造连接对象
24     $db = new mysqli("localhost","root","123","mydb");
25     
26     //2.判断是否连接成功
27     if(mysqli_connect_error())
28     {    
29         echo "连接失败";
30         
31         //退出整个程序
32         exit;
33     }
34     else
35     {
36         //3.写SQL语句
37         $sql = "select * from Nation";
38         
39         //4.执行SQL语句
40         $result = $db->query($sql);
41         
42         //5.处理数据
43         //遍历每一条数据
44         while($row = $result->fetch_row())
45         {            
46             echo "<option value=‘{$row[0]}‘>{$row[1]}</option>";
47         }
48     }
49     ?>
50 </select>
51 </div>
52 
53 <div><span style="width:80px;">生日：</span><input type="text" name="birthday" /></div>
54 
55 <div><input type="submit" value="添加"/> &nbsp;&nbsp;<a href="Test.php">返回</a></div>
56 
57 
58 </form>
59 
60 </body>
61 </html>

添加处理

 1 <?php
 2     
 3     $code = $_POST["code"];
 4     $name = $_POST["name"];
 5     $sex = $_POST["sex"];
 6     $nation = $_POST["nation"];
 7     $birthday = $_POST["birthday"];
 8     
 9     //1.造连接对象
10     $db = new mysqli("localhost","root","123","mydb");
11     
12     //2.判断是否连接成功
13     if(mysqli_connect_error())
14     {    
15         echo "连接失败";
16         
17         //退出整个程序
18         exit;
19     }
20     else
21     {
22         //3.写SQL语句
23         $sql = "insert into Info values(‘{$code}‘,‘{$name}‘,{$sex},‘{$nation}‘,‘{$birthday}‘)";
24         
25         
26         //4.执行SQL语句
27         $result = $db->query($sql);
28         
29         //判断是否添加成功
30         
31         if($result)
32         {
33             header("Location:Add.php");
34         }
35         else
36         {
37             echo "添加失败";
38         }
39     }
40     
41 ?>

修改页面

  1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2 <html xmlns="http://www.w3.org/1999/xhtml">
  3 <head>
  4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  5 <title>无标题文档</title>
  6 </head>
  7 
  8 <body>
  9 
 10 <h1>修改页面</h1>
 11 
 12 <?php
 13 
 14     $code = $_GET["code"];
 15     
 16     //1.造连接对象
 17     $db = new mysqli("localhost","root","123","mydb");
 18     
 19     //2.判断是否连接成功
 20     if(mysqli_connect_error())
 21     {    
 22         echo "连接失败";
 23         
 24         //退出整个程序
 25         exit;
 26     }
 27     else
 28     {
 29         //3.写SQL语句
 30         $sql = "select * from Info where Code=‘".$code."‘";
 31         
 32         //4.执行SQL语句
 33         $result = $db->query($sql);
 34         
 35         //5.处理数据
 36         $row = $result->fetch_row();
 37 
 38     }
 39     
 40 ?>
 41 
 42 <form action="Update.php" method="post">
 43 
 44 <div><span style="width:80px;">代号：</span><input type="text" name="code" value="<?php echo $row[0] ?>" readonly="readonly" /></div>
 45 
 46 <div><span style="width:80px;">姓名：</span><input type="text" name="name" value="<?php echo $row[1] ?>" /></div>
 47 
 48 <div>
 49 <span style="width:80px;">性别：</span>
 50 <input type="radio" name="sex" value="true" <?php echo (bool)$row[2]?"checked=‘checked‘":"" ?> />男&nbsp;&nbsp;
 51 <input type="radio" name="sex" value="false" <?php echo !(bool)$row[2]?"checked=‘checked‘":"" ?>/>女
 52 </div>
 53 
 54 <div><span style="width:80px;">民族：</span>
 55 <select name="nation">
 56     <?php
 57         //1.造连接对象
 58     $db = new mysqli("localhost","root","123","mydb");
 59     
 60     //2.判断是否连接成功
 61     if(mysqli_connect_error())
 62     {    
 63         echo "连接失败";
 64         
 65         //退出整个程序
 66         exit;
 67     }
 68     else
 69     {
 70         //3.写SQL语句
 71         $sql = "select * from Nation";
 72         
 73         //4.执行SQL语句
 74         $result = $db->query($sql);
 75         
 76         //5.处理数据
 77         //遍历每一条数据
 78         while($rownation = $result->fetch_row())
 79         {        
 80             if($rownation[0] == $row[3])
 81             {
 82                 echo "<option selected=‘selected‘ value=‘{$rownation[0]}‘>{$rownation[1]}</option>";
 83             }
 84             else
 85             {
 86                 echo "<option value=‘{$rownation[0]}‘>{$rownation[1]}</option>";
 87             }
 88             
 89         }
 90     }
 91     ?>
 92 </select>
 93 </div>
 94 
 95 <div><span style="width:80px;">生日：</span><input type="text" name="birthday" value="<?php echo $row[4] ?>" /></div>
 96 
 97 <div><input type="submit" value="修改"/> &nbsp;&nbsp;<a href="Test.php">返回</a></div>
 98 
 99 
100 </form>
101 
102 </body>
103 </html>

修改处理

 1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 2 <html xmlns="http://www.w3.org/1999/xhtml">
 3 <head>
 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 5 <title>无标题文档</title>
 6 </head>
 7 
 8 <body>
 9 <?php
10 
11     $code = $_POST["code"];
12     $name = $_POST["name"];
13     $sex = $_POST["sex"];
14     $nation = $_POST["nation"];
15     $birthday = $_POST["birthday"];
16     
17     //1.造连接对象
18     $db = new mysqli("localhost","root","123","mydb");
19     
20     //2.判断是否连接成功
21     if(mysqli_connect_error())
22     {    
23         echo "连接失败";
24         
25         //退出整个程序
26         exit;
27     }
28     else
29     {
30         //3.写SQL语句
31         $sql = "update Info set Name=‘".$name."‘,Sex={$sex}, Nation=‘".$nation."‘,Birthday=‘".$birthday."‘ where Code = ‘".$code."‘";
32     
33         //4.执行SQL语句
34         $result = $db->query($sql);
35         
36         //判断是否修改成功
37         
38         if($result)
39         {
40             header("Location:Test.php");
41         }
42         else
43         {
44             echo "修改失败";
45         }
46     }
47 
48 ?>
49 </body>
50 </html>

删除页面

 1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 2 <html xmlns="http://www.w3.org/1999/xhtml">
 3 <head>
 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 5 <title>无标题文档</title>
 6 </head>
 7 
 8 <body>
 9 <?php
10     
11     $code = $_GET["code"];
12     
13     //1.造连接对象
14     $db = new mysqli("localhost","root","123","mydb");
15     
16     //2.判断是否连接成功
17     if(mysqli_connect_error())
18     {    
19         echo "连接失败";
20         
21         //退出整个程序
22         exit;
23     }
24     else
25     {
26         //3.写SQL语句
27         $sql = "delete from Info where Code = ‘".$code."‘";
28         
29         //4.执行SQL语句
30         $result = $db->query($sql);
31         
32         //判断是否删除成功
33         if($result)
34         {
35             header("Location:Test.php");
36         }
37         else
38         {
39             echo "删除失败！";
40         }
41     }
42     
43 ?>
44 </body>
45 </html>

 

数据库访问

标签：

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！