Advertisement
Guest User

Untitled

a guest
Oct 11th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.17 KB | None | 0 0
  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>Untitled Document</title>
  6. </head>
  7.  
  8. <?php
  9.  
  10.    
  11.     echo $_POST['id']."<BR>";
  12.     echo $_POST['pre']."<BR>";
  13.     echo $_POST['name']."<BR>";
  14.     echo $_POST['sname']."<BR>";
  15.     echo $_POST['group']."<BR>";
  16.     echo $_POST['gpa']."<BR>";
  17.    
  18.    
  19.     $id =  $_POST['id'];
  20.     $pre = $_POST['pre'];
  21.     $name = $_POST['name'];
  22.     $sname =  $_POST['sname'];
  23.     $group =  $_POST['group'];
  24.     $gpa = $_POST['gpa'];
  25.    
  26.    
  27.     $servername = "localhost";
  28.     $username = "root";
  29.     $password = "1234";
  30.     $dbname = "regis";
  31.  
  32.  
  33.     $conn = mysql_connect($servername, $username, $password);
  34.     mysql_select_db($dbname) or die("Can't connect to database...");
  35.     mysql_db_query($dbname,"SET NAMES UTF8");
  36.     $sql = "INSERT INTO student VALUES('$id','$pre','$name','$sname','$group','$gpa')";
  37.     $result = mysql_query($sql);
  38.     if($result){
  39.         mysql_affected_rows();
  40.         echo "Insert Successful."."<br>";
  41.     }else{
  42.         echo "Insert Failed."."<br>";
  43.     }
  44.    
  45.  
  46. ?>
  47.  
  48.  
  49. <body>
  50. </body>
  51. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement