

{"id":135597,"date":"2024-07-05T10:45:58","date_gmt":"2024-07-05T05:15:58","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=135597"},"modified":"2024-07-05T10:45:58","modified_gmt":"2024-07-05T05:15:58","slug":"student-management-system-using-php","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/","title":{"rendered":"Student Management System using PHP"},"content":{"rendered":"<h3>Program 1<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;?php  include 'FrontPage.php'?&gt;\r\n&lt;html&gt;\r\n&lt;body&gt;\r\n    &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;\r\n    &lt;center&gt;\r\n    &lt;form method=post action=\"StudentUpdate.php\"&gt;\r\n      &lt;table border=1&gt;  \r\n        &lt;tr&gt;\r\n            &lt;th&gt;Student Id For Update&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtid&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n        &lt;td&gt;&lt;\/td&gt;\r\n        &lt;td&gt;&lt;input type=submit value=Search name=btnSubmit&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n&lt;\/table&gt; \r\n&lt;\/form&gt;\r\n&lt;pre&gt;\r\n&lt;?php\r\nif(isset($_POST['btnSubmit']))\r\n{\r\n \r\n     $stid=$_POST['txtid'];\r\n     $mycon=mysqli_connect(\"localhost\",\"root\",\"\",\"Library\") or die(\"Connection not success\");\r\n     $sql=\"select * from studentdata where sid=\".$stid;\r\n        $record=$mycon-&gt;query($sql);\r\n        if(mysqli_num_rows($record)&gt;0)\r\n        {\r\n            session_start();\r\n            $_SESSION['studid']=$stid;\r\n         ?&gt;         \r\n            &lt;table border=1&gt;\r\n                &lt;tr&gt;\r\n                    &lt;th&gt;Roll No&lt;\/th&gt;&lt;th&gt;Name&lt;\/th&gt;&lt;th&gt;Phy&lt;\/th&gt;&lt;th&gt;Chem&lt;\/th&gt;&lt;th&gt;Maths&lt;\/th&gt;\r\n               &lt;\/tr&gt;\r\n               &lt;tr&gt;\r\n          &lt;?php\r\n          echo \"&lt;form method=post action=UpdateData.php&gt;\";\r\n\r\n            while($row=mysqli_fetch_assoc($record))\r\n             {\r\n                   echo \"&lt;td&gt;\". $row['sid'].\"&lt;\/td&gt;\";\r\n                  echo \"&lt;td&gt;&lt;input type=text name=txtname value=\".$row['sname'].\"&gt;&lt;\/td&gt;\";\r\n                  echo \"&lt;td&gt;&lt;input type=text name=txtphy value=\".$row['phy'].\"&gt;&lt;\/td&gt;\"; \r\n                  echo \"&lt;td&gt;&lt;input type=text name=txtchem value=\".$row['chem'].\"&gt;&lt;\/td&gt;\";  \r\n                  echo \"&lt;td&gt;&lt;input type=text name=txtmath value=\".$row['math'].\"&gt;&lt;\/td&gt;\";   \r\n                   echo \"&lt;td&gt;&lt;input type=submit value=Update&gt;&lt;\/td&gt;\";\r\n            }\r\n            echo \"&lt;\/form&gt;\"; \r\n      }       \r\n        else\r\n        echo \"&lt;font color=red size=5&gt;Record not found&lt;\/font&gt;\";\r\n}   \r\n?&gt;\r\n&lt;\/tr&gt;\r\n&lt;\/pre&gt;\r\n&lt;\/center&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html<\/pre>\n<h3>Program 2<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;?php  include 'FrontPage.php'?&gt;\r\n&lt;html&gt;\r\n&lt;body&gt;\r\n    &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;\r\n    &lt;center&gt;\r\n        &lt;form method=post action=\"InsertStudent1.php\"&gt;\r\n      &lt;table border=1&gt;  \r\n        &lt;tr&gt;\r\n            &lt;th&gt;Student Id&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtid&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;th&gt;Name&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtname&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;th&gt;Physics&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtphy&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;th&gt;Chemistry&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtchem&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;th&gt;Maths&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtmath&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n        &lt;td&gt;&lt;\/td&gt;\r\n        &lt;td&gt;&lt;input type=submit value=Submit name=btnSubmit&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n&lt;\/table&gt; \r\n&lt;pre&gt;\r\n&lt;?php\r\n\r\n     if(isset($_POST['btnSubmit']))\r\n     {\r\n        $id=$_POST['txtid'];\r\n        $name=$_POST['txtname'];\r\n        $phy=$_POST['txtphy'];\r\n        $chem=$_POST['txtchem'];\r\n        $math=$_POST['txtmath'];\r\n        \r\n        $mycon=mysqli_connect(\"localhost\",\"root\",\"\",\"Library\") or die(\"Connection not success\");\r\n        echo \"Connection sucees&lt;br&gt;\"; \r\n        \/\/ $sql=\"insert into studentdata values(?,?,?,?,?)\";\r\n        \/\/ $ps=$mycon-&gt;prepare($sql);\r\n        \/\/ $ps-&gt;bind_param(\"isiii\", $id,$name,$phy,$chem,$math);\r\n        \/\/ $ps-&gt;execute();\r\n        \/\/ echo \" Record inserted....\";\r\n        $sql=\"select * from studentdata where sid=?\";\r\n        $ps=$mycon-&gt;prepare($sql);\r\n        $ps-&gt;bind_param(\"i\", $id);\r\n            echo $ps-&gt;execute_query();\r\n                \/\/ while($row=mysqli_fetch_assoc($record))\r\n                \/\/  {\r\n                \/\/          echo $row['sid'].\"  \".$row['sname'].\"  \".$row['course'].\"&lt;br&gt;\";\r\n\r\n                \/\/  }\r\n\r\n          $ps-&gt;close();\r\n          $mycon-&gt;close();        \r\n \r\n        \r\n\r\n    \/\/ i-integer , s-string , d-double,b-Blob\r\n\r\n     }\r\n\r\n?&gt;\r\n&lt;\/pre&gt;\r\n&lt;\/center&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h3>Program 3<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;?php  include 'FrontPage.php'?&gt;\r\n&lt;html&gt;\r\n&lt;body&gt;\r\n    &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt; \r\n       &lt;center&gt;\r\n    &lt;form method=post action=\"StudentDelete.php\"&gt;\r\n      &lt;table border=1&gt;  \r\n        &lt;tr&gt;\r\n            &lt;th&gt;Student Id For Delete&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtid&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n        &lt;td&gt;&lt;\/td&gt;\r\n        &lt;td&gt;&lt;input type=submit value=Search name=btnSubmit&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n&lt;\/table&gt; \r\n&lt;\/form&gt;\r\n&lt;pre&gt;\r\n&lt;?php\r\n\r\n     if(isset($_POST['btnSubmit']))\r\n     {\r\n           \r\n        $stid=$_POST['txtid'];\r\n        session_start();\r\n        $_SESSION['studid']=$stid;\r\n        $mycon=mysqli_connect(\"localhost\",\"root\",\"\",\"Library\") or die(\"Connection not success\");\r\n        \/\/echo \"Connection sucees&lt;br&gt;\"; \r\n        $sql=\"select * from studentdata where sid=\".$stid;\r\n        $record=$mycon-&gt;query($sql);\r\n        if(mysqli_num_rows($record)&gt;0)\r\n        {\r\n         ?&gt;         \r\n            &lt;table border=1&gt;\r\n                &lt;tr&gt;\r\n                    &lt;th&gt;Roll No&lt;\/th&gt;&lt;th&gt;Name&lt;\/th&gt;&lt;th&gt;Phy&lt;\/th&gt;&lt;th&gt;Chem&lt;\/th&gt;&lt;th&gt;Maths&lt;\/th&gt;\r\n               &lt;\/tr&gt;\r\n               &lt;tr&gt;\r\n          &lt;?php\r\n            while($row=mysqli_fetch_assoc($record))\r\n             {\r\n                   echo \"&lt;td&gt;\". $row['sid'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['sname'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['phy'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['chem'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['math'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;form method=post action=DeleteData.php&gt;\";\r\n                   echo \"&lt;td&gt;&lt;input type=submit value=Delete&gt;&lt;\/td&gt;\";\r\n                   echo \"&lt;\/form&gt;\";\r\n            }\r\n      }       \r\n        else\r\n        echo \"&lt;font color=red size=5&gt;Record not found&lt;\/font&gt;\";\r\n     \r\n}   \r\n?&gt;\r\n&lt;\/tr&gt;\r\n&lt;\/pre&gt;\r\n&lt;\/center&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h4>Program 4<\/h4>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\"&gt;\r\n&lt;html&gt;\r\n&lt;head&gt;\r\n&lt;title&gt;Untitled&lt;\/title&gt;\r\n&lt;meta http-equiv=\"content-type\" content=\"text\/html; charset=iso-8859-1\"&gt;\r\n&lt;meta name=\"generator\" content=\"Web Page Maker\"&gt;\r\n\r\n&lt;style type=\"text\/css\"&gt;\r\n\/*----------Text Styles----------*\/\r\n.ws6 {font-size: 8px;}\r\n.ws7 {font-size: 9.3px;}\r\n.ws8 {font-size: 11px;}\r\n.ws9 {font-size: 12px;}\r\n.ws10 {font-size: 13px;}\r\n.ws11 {font-size: 15px;}\r\n.ws12 {font-size: 16px;}\r\n.ws14 {font-size: 19px;}\r\n.ws16 {font-size: 21px;}\r\n.ws18 {font-size: 24px;}\r\n.ws20 {font-size: 27px;}\r\n.ws22 {font-size: 29px;}\r\n.ws24 {font-size: 32px;}\r\n.ws26 {font-size: 35px;}\r\n.ws28 {font-size: 37px;}\r\n.ws36 {font-size: 48px;}\r\n.ws48 {font-size: 64px;}\r\n.ws72 {font-size: 96px;}\r\n.wpmd {font-size: 13px;font-family: 'Arial';font-style: normal;font-weight: normal;}\r\n\/*----------Para Styles----------*\/\r\nDIV,UL,OL \/* Left *\/\r\n{\r\n margin-top: 0px;\r\n margin-bottom: 0px;\r\n}\r\n&lt;\/style&gt;\r\n\r\n\r\n&lt;script language=\"JavaScript1.4\" type=\"text\/javascript\"&gt;\r\n&lt;!--\r\nfunction jsPlay(soundobj) {\r\n var thissound= eval(\"document.\"+soundobj);\r\n try {\r\n     thissound.Play();\r\n }\r\n catch (e) {\r\n     thissound.DoPlay();\r\n }\r\n}\r\n\/\/--&gt;\r\n&lt;\/script&gt;\r\n\r\n&lt;script language=\"javascript\" type=\"text\/javascript\"&gt;\r\n&lt;!--\r\nfunction MM_swapImgRestore() {\r\n  var i,x,a=document.MM_sr; for(i=0;a&amp;&amp;i&lt;a.length&amp;&amp;(x=a[i])&amp;&amp;x.oSrc;i++) x.src=x.oSrc;\r\n}\r\n\r\nfunction MM_preloadImages() {\r\n  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();\r\n    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i&lt;a.length; i++)\r\n    if (a[i].indexOf(\"#\")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}\r\n}\r\n\r\nfunction MM_findObj(n, d) {\r\n  var p,i,x;  if(!d) d=document; if((p=n.indexOf(\"?\"))&gt;0&amp;&amp;parent.frames.length) {\r\n    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}\r\n  if(!(x=d[n])&amp;&amp;d.all) x=d.all[n]; for (i=0;!x&amp;&amp;i&lt;d.forms.length;i++) x=d.forms[i][n];\r\n  for(i=0;!x&amp;&amp;d.layers&amp;&amp;i&lt;d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);\r\n  if(!x &amp;&amp; d.getElementById) x=d.getElementById(n); return x;\r\n}\r\n\r\nfunction MM_swapImage() {\r\n  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i&lt;(a.length-2);i+=3)\r\n   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}\r\n}\r\n\r\n\/\/--&gt;\r\n&lt;\/script&gt;\r\n\r\n&lt;\/head&gt;\r\n\r\n&lt;body&gt;\r\n\r\n&lt;div id=\"image1\" style=\"position:absolute; overflow:hidden; left:35px; top:18px; width:149px; height:125px; z-index:0\"&gt;&lt;img src=\"images\/123.jpg\" alt=\"\" title=\"\" border=0 width=149 height=125&gt;&lt;\/div&gt;\r\n\r\n&lt;div id=\"image2\" style=\"position:absolute; overflow:hidden; left:1524px; top:17px; width:164px; height:138px; z-index:1\"&gt;&lt;img src=\"images\/123.jpg\" alt=\"\" title=\"\" border=0 width=164 height=138&gt;&lt;\/div&gt;\r\n\r\n&lt;div id=\"nav10d\" style=\"position:absolute; left:177px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav10','','images\/nav2729786710a.gif',1)\" href=\"FrontPage.php\"&gt;&lt;img name=\"nav10\" onLoad=\"MM_preloadImages('images\/nav2729786710a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786710i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav11d\" style=\"position:absolute; left:351px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav11','','images\/nav2729786711a.gif',1)\" href=\"InsertStudent1.php\"&gt;&lt;img name=\"nav11\" onLoad=\"MM_preloadImages('images\/nav2729786711a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786711i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav12d\" style=\"position:absolute; left:525px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav12','','images\/nav2729786712a.gif',1)\" href=\"SelectStudent.php\"&gt;&lt;img name=\"nav12\" onLoad=\"MM_preloadImages('images\/nav2729786712a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786712i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav13d\" style=\"position:absolute; left:699px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav13','','images\/nav2729786713a.gif',1)\" href=\"StudentDelete.php\"&gt;&lt;img name=\"nav13\" onLoad=\"MM_preloadImages('images\/nav2729786713a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786713i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav14d\" style=\"position:absolute; left:873px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav14','','images\/nav2729786714a.gif',1)\" href=\"StudentUpdate.php\"&gt;&lt;img name=\"nav14\" onLoad=\"MM_preloadImages('images\/nav2729786714a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786714i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav15d\" style=\"position:absolute; left:1047px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav15','','images\/nav2729786715a.gif',1)\" href=\"#\"&gt;&lt;img name=\"nav15\" onLoad=\"MM_preloadImages('images\/nav2729786715a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786715i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav16d\" style=\"position:absolute; left:1221px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav16','','images\/nav2729786716a.gif',1)\" href=\"#\"&gt;&lt;img name=\"nav16\" onLoad=\"MM_preloadImages('images\/nav2729786716a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786716i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n&lt;div id=\"nav17d\" style=\"position:absolute; left:1395px; top:117px; z-index:2\"&gt;&lt;a onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('nav17','','images\/nav2729786717a.gif',1)\" href=\"#\"&gt;&lt;img name=\"nav17\" onLoad=\"MM_preloadImages('images\/nav2729786717a.gif')\" alt=\"\" border=0 src=\"images\/nav2729786717i.gif\"&gt;&lt;\/a&gt;&lt;\/div&gt;\r\n\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h3>Program 5<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;?php  include 'FrontPage.php'?&gt;\r\n&lt;html&gt;\r\n&lt;body&gt;\r\n    &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;\r\n    &lt;center&gt;\r\n        &lt;form method=post action=\"SelectStudent.php\"&gt;\r\n      &lt;table border=1&gt;  \r\n        &lt;tr&gt;\r\n            &lt;th&gt;Student Id&lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtid&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n        &lt;td&gt;&lt;\/td&gt;\r\n        &lt;td&gt;&lt;input type=submit value=Search name=btnSubmit&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n&lt;\/table&gt; \r\n\r\n&lt;pre&gt;\r\n&lt;?php\r\n\r\n     if(isset($_POST['btnSubmit']))\r\n     {\r\n           \r\n        $stid=$_POST['txtid'];\r\n        $mycon=mysqli_connect(\"localhost\",\"root\",\"\",\"Library\") or die(\"Connection not success\");\r\n        \/\/echo \"Connection sucees&lt;br&gt;\"; \r\n        $sql=\"select * from studentdata where sid=\".$stid;\r\n        $record=$mycon-&gt;query($sql);\r\n        if(mysqli_num_rows($record)&gt;0)\r\n        {\r\n         ?&gt;         \r\n            &lt;table border=1&gt;\r\n                &lt;tr&gt;\r\n                    &lt;th&gt;Roll No&lt;\/th&gt;&lt;th&gt;Name&lt;\/th&gt;&lt;th&gt;Phy&lt;\/th&gt;&lt;th&gt;Chem&lt;\/th&gt;&lt;th&gt;Maths&lt;\/th&gt;\r\n               &lt;\/tr&gt;\r\n              \r\n          &lt;?php\r\n            while($row=mysqli_fetch_assoc($record))\r\n             {\r\n                   echo \"&lt;tr&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['sid'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['sname'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['phy'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['chem'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;td&gt;\". $row['math'].\"&lt;\/td&gt;\";\r\n                   echo \"&lt;\/tr&gt;\";\r\n             }\r\n        }\r\n        else\r\n        echo \"&lt;font color=red size=5&gt;Record not found&lt;\/font&gt;\";\r\n     }\r\n?&gt;\r\n\r\n&lt;\/pre&gt;\r\n&lt;\/center&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<h3>Program 6<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;html&gt;\r\n    &lt;head&gt;&lt;title&gt;User Login Application&lt;\/title&gt;\r\n    &lt;body&gt;\r\n&lt;center&gt;\r\n   &lt;form method=post action=\"&lt;?php echo $_SERVER['PHP_SELF']  ?&gt;\" &gt;\r\n    &lt;table border=1&gt;\r\n        &lt;tr&gt;\r\n            &lt;th&gt;User Name: &lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=text name=txtuser&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;th&gt;Password: &lt;\/th&gt;\r\n            &lt;td&gt;&lt;input type=password name=txtpass&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;td&gt;&lt;\/td&gt;\r\n            &lt;td&gt;&lt;input type=submit value=Submit name=submitbtn&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n     &lt;table&gt;   \r\n   &lt;\/form&gt;\r\n&lt;?php\r\n         if(isset($_POST['submitbtn']))\r\n        { \r\n               $user=$_POST['txtuser'];\r\n               $pass=$_POST['txtpass'];\r\n               $mycon=mysqli_connect(\"localhost\",\"root\",\"\",\"Library\") or die(\"Connection not success\");\r\n               $sql=\"select * from login where username='\".$user.\"' and password='\".$pass.\"'\" ;\r\n               $record=$mycon-&gt;query($sql);\r\n               if(mysqli_num_rows($record)&gt;0)\r\n               header(\"Location:FrontPage.php\");\r\n                else\r\n                   echo \"&lt;font color=red size=5&gt;Invalid userid or password&lt;\/font&gt;\";\r\n        }   \r\n       \r\n?&gt;\r\n&lt;\/center&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Program 1 &lt;?php include &#8216;FrontPage.php&#8217;?&gt; &lt;html&gt; &lt;body&gt; &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt; &lt;center&gt; &lt;form method=post action=&#8221;StudentUpdate.php&#8221;&gt; &lt;table border=1&gt; &lt;tr&gt; &lt;th&gt;Student Id For Update&lt;\/th&gt; &lt;td&gt;&lt;input type=text name=txtid&gt;&lt;\/td&gt; &lt;\/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;\/td&gt; &lt;td&gt;&lt;input type=submit value=Search name=btnSubmit&gt;&lt;\/td&gt; &lt;\/tr&gt; &lt;\/table&gt; &lt;\/form&gt; &lt;pre&gt; &lt;?php&#46;&#46;&#46;<\/p>\n","protected":false},"author":86671,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31445],"tags":[32559,21772,32332,32333,32558,32557],"class_list":["post-135597","post","type-post","status-publish","format-standard","hentry","category-php-tutorials","tag-how-to-create-student-management-system-in-php","tag-php","tag-php-practical","tag-php-program","tag-php-student-management-system","tag-student-management-system-using-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Student Management System using PHP - DataFlair<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Student Management System using PHP - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Program 1 &lt;?php include &#039;FrontPage.php&#039;?&gt; &lt;html&gt; &lt;body&gt; &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt; &lt;center&gt; &lt;form method=post action=&quot;StudentUpdate.php&quot;&gt; &lt;table border=1&gt; &lt;tr&gt; &lt;th&gt;Student Id For Update&lt;\/th&gt; &lt;td&gt;&lt;input type=text name=txtid&gt;&lt;\/td&gt; &lt;\/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;\/td&gt; &lt;td&gt;&lt;input type=submit value=Search name=btnSubmit&gt;&lt;\/td&gt; &lt;\/tr&gt; &lt;\/table&gt; &lt;\/form&gt; &lt;pre&gt; &lt;?php&#046;&#046;&#046;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-05T05:15:58+00:00\" \/>\n<meta name=\"author\" content=\"TechVidvan Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TechVidvan Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Student Management System using PHP - DataFlair","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/","og_locale":"en_US","og_type":"article","og_title":"Student Management System using PHP - DataFlair","og_description":"Program 1 &lt;?php include 'FrontPage.php'?&gt; &lt;html&gt; &lt;body&gt; &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt; &lt;center&gt; &lt;form method=post action=\"StudentUpdate.php\"&gt; &lt;table border=1&gt; &lt;tr&gt; &lt;th&gt;Student Id For Update&lt;\/th&gt; &lt;td&gt;&lt;input type=text name=txtid&gt;&lt;\/td&gt; &lt;\/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;\/td&gt; &lt;td&gt;&lt;input type=submit value=Search name=btnSubmit&gt;&lt;\/td&gt; &lt;\/tr&gt; &lt;\/table&gt; &lt;\/form&gt; &lt;pre&gt; &lt;?php&#46;&#46;&#46;","og_url":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2024-07-05T05:15:58+00:00","author":"TechVidvan Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"TechVidvan Team","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/"},"author":{"name":"TechVidvan Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/0e594f928e31fc96628ac40f6ae74f49"},"headline":"Student Management System using PHP","datePublished":"2024-07-05T05:15:58+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/"},"wordCount":12,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"keywords":["how to create student management system in php","PHP","php practical","php program","php student management system","student management system using php"],"articleSection":["PHP Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/","url":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/","name":"Student Management System using PHP - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"datePublished":"2024-07-05T05:15:58+00:00","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/student-management-system-using-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"PHP Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/php-tutorials\/"},{"@type":"ListItem","position":3,"name":"Student Management System using PHP"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/0e594f928e31fc96628ac40f6ae74f49","name":"TechVidvan Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","caption":"TechVidvan Team"},"description":"TechVidvan Team provides high-quality content &amp; courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.","url":"https:\/\/data-flair.training\/blogs\/author\/test001\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/86671"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=135597"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135597\/revisions"}],"predecessor-version":[{"id":142764,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135597\/revisions\/142764"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=135597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=135597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=135597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}