PHP implements student management system-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP implements student management system

不言

Jun 12, 2018 pm 05:32 PM

This article mainly introduces the specific implementation code of the PHP student management system in detail. Interested friends can refer to it.

The example in this article shares the source code of the PHP student management system for everyone. For reference, the specific content is as follows

Function:
1.Add/Delete/Modify
2.Data storage.
Interface distribution:
index.php --->Main interface
add.php --->stu add
action ---> add/del/update in sql (processing html form-->mysql Data storage && page jump)
edit.php --->stu modify
menu.php -->Homepage

1. index.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>学生信息管理</title>
 <script>
  function doDel(id) {
   if(confirm(&#39;确认删除?&#39;)) {
    window.location=&#39;action.php?action=del&id=&#39;+id;
   }
  }
 </script>
</head>
<body>
<center>
 <?php
 include ("menu.php");
 ?>
 <h3 id="浏览学生信息">浏览学生信息</h3>
 <table width="500" border="1">
  <tr>
   <th>ID</th>
   <th>姓名</th>
   <th>性别</th>
   <th>年龄</th>
   <th>班级</th>
   <th>操作</th>
  </tr>
  <?php
//  1. 链接数据库
  try{
   $pdo = new PDO("uri:mysqlPdo.ini","root","1");
  }catch (PDOException $e) {
   die(&#39;connection failed&#39;.$e->getMessage());
  }
  //2.执行sql
  $sql_select = "select * from stu";
  //3.data 解析
  foreach ( $pdo->query($sql_select) as $row) {
   echo "<tr>";
   echo "<th>{$row[&#39;id&#39;]} </th>";
   echo "<th>{$row[&#39;name&#39;]}</th>";
   echo "<th>{$row[&#39;sex&#39;]} </th>";
   echo "<th>{$row[&#39;age&#39;]} </th>";
   echo "<th>{$row[&#39;classid&#39;]}</th>";
   echo "<td>
     <a href=&#39;edit.php?id={$row[&#39;id&#39;]}&#39;>修改</a>
     <a href=&#39;javascript:void(0);&#39; onclick=&#39;doDel({$row[&#39;id&#39;]})&#39;>删除</a>
    </td>";
   echo "</tr>";
  }
  ?>
 </table>
</center>
</body>
</html>

2. add.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>学生管理系统</title>
</head>
<body>
<center>
 
 <?php include (&#39;menu.php&#39;); ?>
 <h3 id="增加学生信息">增加学生信息</h3>
 <form action="action.php?action=add" method="post">
  <table>
   <tr>
    <td>姓名</td>
    <td><input type="text" name="name"></td>
   </tr>
   <tr>
    <td>年龄</td>
    <td><input type="text" name="age"></td>
   </tr>
   <tr>
    <td>性别</td>
    <td><input type="radio" name="sex" value="男">男</td>
    <td><input type="radio" name="sex" value="女">女</td>
   </tr>
   <tr>
    <td>班级</td>
    <td><input type="text" name="classid"></td>
   </tr>
   <tr>
<!--    <td> </td>-->
    <td><a href="index.php">返回</td>
    <td><input type="submit" value="添加"></td>
    <td><input type="reset" value="重置"></td>
   </tr>
  </table> 
 </form>
  
</center>
</body>
</html>

3. action.php

<?php
/**
 * Created by PhpStorm.
 * User: hyh
 * Date: 16-7-7
 * Time: 下午9:37
 */
//1. 链接数据库
try{
 $pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
//   echo &#39;Connection failed: &#39; . $e->getMessage();
 die(&#39;connection failed&#39;.$e->getMessage());
}
 
//2.action 的值做对操作
 
switch ($_GET[&#39;action&#39;]){
  
 case &#39;add&#39;://add 
  $name = $_POST[&#39;name&#39;];
  $sex = $_POST[&#39;sex&#39;];
  $age = $_POST[&#39;age&#39;];
  $classid = $_POST[&#39;classid&#39;];
   
  $sql = "insert into stu (name, sex, age, classid) values (&#39;{$name}&#39;, &#39;{$sex}&#39;,&#39;{$age}&#39;,&#39;{$classid}&#39;)";
  $rw = $pdo->exec($sql); 
  if ($rw > 0){
   echo "<script>alter(&#39;添加成功&#39;);</script>";
  }else{
   echo "<script>alter(&#39;添加失败&#39;);</script>";
  }
  header(&#39;Location: index.php&#39;);
  break; 
  
 case &#39;del&#39;://get
  $id = $_GET[&#39;id&#39;];
  $sql = "delete from stu where id={$id}";
  $rw = $pdo->exec($sql);
  if ($rw > 0){
   echo "<script>alter(&#39;删除成功&#39;);</script>";
  }else{
   echo "<script>alter(&#39;删除失败&#39;);</script>";
  }
  header(&#39;Location: index.php&#39;);
  break;
 
 case &#39;edit&#39;://post
  $id = $_POST[&#39;id&#39;];
  $name = $_POST[&#39;name&#39;]; 
  $age = $_POST[&#39;age&#39;];
  $classid = $_POST[&#39;classid&#39;];
  $sex = $_POST[&#39;sex&#39;];
   
//  echo $id, $age, $age, $name;
  $sql = "update stu set name=&#39;{$name}&#39;, age={$age},sex=&#39;{$sex}&#39;,classid={$classid} where id={$id};";
//  $sql = "update myapp.stu set name=&#39;jike&#39;,sex=&#39;女&#39;, age=24,classid=44 where id=17";
  print $sql;
  $rw = $pdo->exec($sql);
  if ($rw > 0){
   echo "<script>alter(&#39;更新成功&#39;);</script>";
  }else{
   echo "<script>alter(&#39;更新失败&#39;);</script>";
  }
  header(&#39;Location: index.php&#39;);
  break; 
  
 default:
  header(&#39;Location: index.php&#39;);
  break;
}

4.edit.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>学生管理系统</title>
</head>
<body>
<center>
 <?php include (&#39;menu.php&#39;);
 //1. 链接数据库
 try{
  $pdo = new PDO("uri:mysqlPdo.ini","root","1");
 }catch (PDOException $e) {
  die(&#39;connection failed&#39;.$e->getMessage());
 }
 //2.执行sql
 $sql_select = "select * from stu where id={$_GET[&#39;id&#39;]}";
 $stmt = $pdo->query($sql_select);
 if ($stmt->rowCount() >0) {
  $stu = $stmt->fetch(PDO::FETCH_ASSOC); // 解析数据
 }else{
  die("no have this id:{$_GET[&#39;id&#39;]}");
 }
 ?>
  
 <h3 id="修改学生信息">修改学生信息</h3>
 
 <form action="action.php?action=edit" method="post">
  <input type="hidden" name="id" value="<?php echo $stu[&#39;id&#39;];?>">
  <table>
   <tr>
    <td>姓名</td>
    <td><input type="text" name="name" value="<?php echo $stu[&#39;name&#39;];?>"></td>
   </tr>
   <tr>
    <td>年龄</td>
    <td><input type="text" name="age" value="<?php echo $stu[&#39;age&#39;];?>"></td>
   </tr>
   <tr>
    <td>性别</td>
    <td>
     <input type="radio" name="sex" value="男" <?php echo ($stu[&#39;sex&#39;] == "男")? "checked":"";?> >男
    </td>
    <td>
     <input type="radio" name="sex" value="女" <?php echo ($stu[&#39;sex&#39;] == "女")? "checked":"";?> >女
    </td>
   </tr>
   <tr>
    <td>班级</td>
    <td><input type="text" name="classid" value="<?php echo $stu[&#39;classid&#39;]?>"></td>
   </tr>
   <tr>
    <td> </td>
    <td><input type="submit" value="更新"></td>
    <td><input type="reset" value="重置"></td>
   </tr>
  </table>
 </form>
  
  
</center>
 
<?php
?>
</body>
</html>

5. menu.php

<!DOCTYPE html>
<html lang="en">
<body>
 <h2 id="学生管理系统">学生管理系统</h2>
 <a href="index.php"> 浏览学生</a>
 <a href="add.php"> 添加学生</a>
 <hr>
</body>
</html>

The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

Analysis of the pessimistic locking mechanism implemented by PHP and redis

The above is the detailed content of PHP implements student management system. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

Simple Guide: Sending Email with PHP ScriptMay 12, 2025 am 12:02 AM

PHPisusedforsendingemailsduetoitsbuilt-inmail()functionandsupportivelibrarieslikePHPMailerandSwiftMailer.1)Usethemail()functionforbasicemails,butithaslimitations.2)EmployPHPMailerforadvancedfeatureslikeHTMLemailsandattachments.3)Improvedeliverability

PHP Performance: Identifying and Fixing BottlenecksMay 11, 2025 am 12:13 AM

PHP performance bottlenecks can be solved through the following steps: 1) Use Xdebug or Blackfire for performance analysis to find out the problem; 2) Optimize database queries and use caches, such as APCu; 3) Use efficient functions such as array_filter to optimize array operations; 4) Configure OPcache for bytecode cache; 5) Optimize the front-end, such as reducing HTTP requests and optimizing pictures; 6) Continuously monitor and optimize performance. Through these methods, the performance of PHP applications can be significantly improved.

Dependency Injection for PHP: a quick summaryMay 11, 2025 am 12:09 AM

DependencyInjection(DI)inPHPisadesignpatternthatmanagesandreducesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itallowspassingdependencieslikedatabaseconnectionstoclassesasparameters,facilitatingeasiertestingandscalability.

Increase PHP Performance: Caching Strategies & TechniquesMay 11, 2025 am 12:08 AM

CachingimprovesPHPperformancebystoringresultsofcomputationsorqueriesforquickretrieval,reducingserverloadandenhancingresponsetimes.Effectivestrategiesinclude:1)Opcodecaching,whichstorescompiledPHPscriptsinmemorytoskipcompilation;2)DatacachingusingMemc

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks agoByDDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks agoByDDD

Nordhold: Fusion System, Explained

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SublimeText3 Linux new version

SublimeText3 Linux latest version

Hot Topics

1666

1425

1327

1273

1252