首页 / PHP / PHP——0126最初

PHP——0126最初

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了PHP——0126最初，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含8133字，纯文字阅读大概需要12分钟。

内容图文

数据库mydb

表格info，nation

技术分享

实现效果

技术分享

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<h1>主页面</h1>
<div style="width:100%">
<?php

//1.生成连接 造连接对象

//$db=new mysqli($dbhost（服务器）,$username,$userpass,$dbdatabase);$db = new mysqli("localhost","root","123","mydb");

//2.判断是否连接成功 成功为空，失败返回string（字符串）错误信息if(mysqli_connect_error())


{
    echo "连接失败";
    //exit  退出整个程序    }
else 
{
    //3.写sql语句$sql = "select * from Info";
    //4.执行sql语句$result=$db->query($sql);
    //5.处理数据（提取数据）echo "<table width=90% cellpadding=‘0‘ cellspacing=‘0‘ border=‘1‘>";
    echo "<tr><td>代号</td> <td>姓名</td> <td>性别</td> <td>民族</td> <td>生日</td> <td>操作</td></tr>";
    //遍历每一条数据while($row=$result->fetch_row())
    {
        //处理性别$sex=(bool)$row[2]?"男":"女";
        //处理民族$nation=NationName($db,$row[3]);
        //处理生日$birthday=date("Y年m月d日",strtotime($row[4]));
          
        echo "<tr bgcolor=‘#00CC33‘><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;&nbsp;<a href=‘xiugai.php?code=".$row[0]."‘>修改</a></td></tr>";
        
        }    
    
        echo "</table>";
    
}
//根据民族代号查询民族名称function NationName($db,$code)
{
    //3.写sql语句$sql = "select * from Nation where code=‘{$code}‘";
    //4.执行sql语句$result=$db->query($sql);
    //处理数据if($row=$result->fetch_row())
    {
        return$row[1];
        }
    else
    {
        return "";
        }
    }

?>
</div>
<div><a href="ADD.php">添加数据</a>
</div>
<div>
<form>
<input type="submit" value="提交" onclick="return confirm(‘确定吗‘)" />
</form>
</div>
</body>
</html>

0126.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<h1>添加页面</h1>

<form action="Insert.php" method="post">
<div><span>代号:</span><input type="text" name="code" /></div>
<div><span>姓名:</span><input type="text" name="name"/></div>
<div><span>性别:</span><input type="radio" name="sex" value="true" checked="checked"/>男 &nbsp;&nbsp;<input type="radio" name="sex" value="false"/>女</div>
<div><span>民族:</span>
<select name="nation">
<?php
//1.连接数据库$db= new mysqli("localhost","root","123","mydb");
//2.判断是否连接成功if(mysqli_connect_error())
{
    echo "连接失败";
    }
else
{
    //3.写sql语句$sql="select * from nation";
    //4.执行sql语句$result=$db->query($sql);
    //5.处理数据，遍历while($row=$result->fetch_row())
    {
        echo "<option value=‘{$row[0]}‘>{$row[1]}</option>";
    }
}    

?>
</select>
</div>
<div><span>生日:</span><input type="text" name="birthday"/></div>
<div><input type="submit" value="添加"/>&nbsp;&nbsp;<a href="0126.php">返回</a></div>
</form>


</body>
</html>

ADD.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>


<?php

      $code = $_POST["code"];
      $name = $_POST["name"];
      $sex = $_POST["sex"];
      $nation = $_POST["nation"];
      $birthday = $_POST["birthday"];
//1.造连接对象$db= new mysqli("localhost","root","123","mydb");
//2.判断是否连接if(mysqli_connect_error())
{
    echo "连接错误";
    } 
else
{
    //3.写添加语句$sql="insert into Info values(‘{$code}‘,‘{$name}‘,{$sex},‘{$nation}‘,‘{$birthday}‘)";
    //4.执行语句$result=$db->query($sql);
    //5.判断是否添加成功if($result)
    {
        header("Location:ADD.php");//跳回页面        }
    else
    {
        echo "添加失败";
        }
    }    

?>

</body>
</html>

Insert.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<?php
     $code = $_GET["code"];
     //1.造连接对象$db=new mysqli("localhost","root","123","mydb");
      //2.判断连接是否成功if(mysqli_connect_error())
      {
          echo "连接错误";
          }
      else
       {
       //3.写sql语句$sql="delete from Info where code=‘".$code."‘";
        //4.执行sql语句$result=$db->query($sql);
       //判断是否删除成功if($result)
       {
           header("Location:0126.php");
        }
        else
        {
            echo "删除失败!";
            }
       
         }

?>
</body>
</html>

Delete.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<h1>修改页面</h1>
<?php
$code = $_GET["code"];
//1.造连接对象$db = new mysqli("localhost","root","123","mydb");
//2.判断是否连接成功if(mysqli_connect_error())
{
    echo "连接失败";
    }
else
{
    //3.写sql语句$sql="select * from Info where code=‘".$code."‘";
    //4.执行sql语句$result=$db->query($sql);
    //5.处理数据$row=$result->fetch_row();
}

?>
<form action="update.php" method="post">
<div><span>代号：</span><input type="text" name="code" value="<?php echo $row[0]?>" readonly="readonly" /></div>
<div><span>姓名：</span><input type="text" name="name" value="<?php echo $row[1]?>"</div>
<div>
<span>性别：</span>
<input type="radio" name="sex" value="true"
<?php echo (bool)$row[2]?"checked=‘checked‘":""?>
 />男&nbsp;&nbsp;
<input type="radio" name="sex" value="false"
<?php echo !(bool)$row[2]?"checked=‘checked‘":""?>
 />女
</div>
<div>
<span>民族：</span>
<select name="nation">
    <?php
     //1.造连接对象$db=new mysqli("localhost","root","123","mydb");
     //2.判断连接是否成功if(mysqli_connect_error())
     {
         echo "连接失败";
         }
         else
         {
        //3.写sql语句$sql="select * from nation";
        //4.执行sql语句$result=$db->query($sql);
        //5.处理数据
        //遍历数据while($rownation=$result->fetch_row())
        {
            if($rownation[0]==$row[3])
            {
                echo "<option selected=‘selected‘ value=‘{$rownation[0]}‘>{$rownation[1]}</option>";
                }
            else
            {
                echo "<option value=‘{$rownation[0]}‘>{$rownation[1]}</option>";
                }
            } 
             
      }
    ?>
</select>
</div>
<div><span>生日：</span><input type="text" name="birthday" value="<?php echo $row[4] ?>"</div>
<div><input type="submit" value="修改" />&nbsp;&nbsp;
<a href="0126.php">返回</a></div>
</form>
</body>
</html>

xiugai.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<?php
$code=$_POST["code"];
$name=$_POST["name"];
$sex=$_POST["sex"];
$nation=$_POST["nation"];
$birthday=$_POST["birthday"];
//1.造连接对象$db=new mysqli("localhost","root","123","mydb");
//2.判断是否连接成功if(mysqli_connect_error())
{
    echo "连接失败";
    }
    else
    {
        //3.写语句$sql="update info set name=‘".$name."‘,sex=‘".$sex."‘,nation=‘".$nation."‘,birthday=‘".$birthday."‘where code=‘".$code."‘";
        //4.执行sql语句$result = $db->query($sql);
        //判断是否修改成功if($result)
        {
            header("Location:0126.php");
            }
            else
            {
                echo "修改失败！";
                }
        
        }

?>
</body>
</html>

update.php

原文：http://www.cnblogs.com/Chenshuai7/p/5196907.html

内容总结

以上是互联网集市为您收集整理的PHP——0126最初全部内容，希望文章能够帮你解决PHP——0126最初所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/1259107.html

来源：【匿名】

首页 / PHP / PHP——0126最初

PHP——0126最初

内容导读

内容图文

内容总结

内容备注

内容手机端

PHP - 技术教程分类

PHP - 最新教程

PHP - 最热教程