getting error when we get data from mysql database how correct

Question

i make this submit.php for submitting the student data into database

here is code

<html>
    <head>
        <title>Submit Student DATA </title>
        <link rel="stylesheet" type="text/css" href="style.css">
    </head>
    <body>

        <div id="main">
            <h1>Submit Student Data for Verify </h1>
            <div id="login">
                <h2>Student's Form</h2>
                <hr/>
                <form action="" method="post">
                    <label>Student Name  :</label>
                    <input type="text" name="stu_name" id="name" required="required" placeholder="Please Enter Name"/><br /><br />
                    <label>Father Name  :</label>
                    <input type="text" name="stu_fathername" id="name" required="required" placeholder="Please Father Name"/><br /><br />
                    <label>Phone Number  :</label>
                    <input type="text" name="stu_phonenumber" id="name" required="required" placeholder="+92000000"/><br /><br />
                    <label>Address  :</label>
                    <input type="text" name="stu_address" id="name" required="required" placeholder="Pakistan, Punjab 0000"/><br /><br />
                    <label>Course Name  :</label>
                    <input type="text" name="stu_course" id="name" required="required" placeholder="Nebosh saftey"/><br /><br />
                    <label>Certificate Number  :</label>
                    <input type="text" name="stu_certificatenumber" id="name" required="required" placeholder="Enter Number"/><br /><br />
                    <label>Registration Number  :</label>
                    <input type="text" name="stu_registrationnumber" id="name" required="required" placeholder="Enter Number"/><br /><br />
                    <label>Student Email  :</label>
                    <input type="email" name="stu_email" id="email" required="required"  placeholder="john123@gmail.com"/><br/><br />
                    <label>Student City  :</label>
                    <input type="text" name="stu_city" id="city" required="required"  placeholder="Lahore"/><br/><br />
                    <input type="submit" value=" Submit " name="submit"/><br />
                </form>
            </div>


        </div>
        <?php
        if (isset($_POST["submit"])) {
            $servername = "localhost";
            $username = "root";
            $password = "root";
            $dbname = "college";

// Create connection
            $conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            }

            $sql = "INSERT INTO students (student_name, father_name, phone_number, student_address, student_course, student_certificatenumber, student_reg, student_email, student_city)
VALUES ('" . $_POST["stu_name"] . "','" . $_POST["stu_fathername"] . "','" . $_POST["stu_phonenumber"] . "','" . $_POST["stu_address"] . "','" . $_POST["stu_course"] . "','" . $_POST["stu_certificatenumber"] . "','" . $_POST["stu_registrationnumber"] . "','" . $_POST["stu_email"] . "','" . $_POST["stu_city"] . "')";

            if ($conn->query($sql) === TRUE) {
                echo "<script type= 'text/javascript'>alert('New Record Inserted Successfully');</script>";
            } else {
                echo "<script type= 'text/javascript'>alert('Error: " . $sql . "<br>" . $conn->error . "');</script>";
            }

            $conn->close();
        }
        ?>
    </body>
</html>

i want to make search box where 1 text box call student Registration number. when i put student registration number and click on search then i get student data from mysql

here is search code maybe correct or wroing i dont no

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
$hostname_php_result_conn = "localhost";
$database_php_result_conn = "college";
$username_php_result_conn = "root";
$password_php_result_conn = "root";   
$php_result_conn = mysql_connect($hostname_php_result_conn, $username_php_result_conn, $password_php_result_conn);
mysql_select_db($database_php_result_conn,$php_result_conn);

if(isset($_POST['submit'])) {
   $student_reg = $_POST['stu_registrationnumber'];

   $sql1 = mysql_query("SELECT students FROM student_reg WHERE = $stu_registrationnumber");
   $row1 = mysql_num_rows($sql1);

   if($row1 == 0) {
      echo 'Error, ID does not exist';
   } else {
      header('Location: show_result.php?student_reg='.$stu_registrationnumber);
   }   
}
?>

<html>
<head>
<title>Search</title>
</head>
<body>

<form action="search.php" method="post">
<input name="student_reg" type="text" id="stu_registrationnumber" />
<input type="submit" name="submit" value="search" />
</form>
</body>
</html>

and here is show_result.php page

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
$hostname_php_result_conn = "localhost";
$database_php_result_conn = "college";
$username_php_result_conn = "root";
$password_php_result_conn = "root";   
$php_result_conn = mysql_connect($hostname_php_result_conn, $username_php_result_conn, $password_php_result_conn);
mysql_select_db($database_php_result_conn,$php_result_conn);

$stu_reg = $_GET['stu_registrationnumber'];

$sql1 = mysql_query("SELECT * FROM students WHERE stu_registrationnumber = $stu_registrationnumber");
$row1 = mysql_fetch_array($sql1);
$student_name = $row1['student_name'];
$phone_number = $row1['phone_number'];
$student_address = $row1['student_address'];
$student_course = $row1['student_course'];
$student_certificatenumber = $row1['student_certificatenumber'];
$stu_registrationnumber = $row1['stu_registrationnumber'];
$student_email = $row1['student_email'];
$student_city = $row1['student_city'];
?>

<html>
<head>
<title>Show Results</title>
</head>
<body>

<?php
echo 'Student Name = '.$student_name.'<br />
Father Name = '.$father_name;
Phone Number = '.$phone_number;
Address = '.$student_address;
Course = '.$student_course;
Certificate Number = '.$student_certificatenumber;
Registration Number = '.$stu_registrationnumber;
E-Mail = '.$student_email;
City = '.$student_city;
?>

</body>
</html>

but i getting Error, ID does not exist but in database we have registration number already but getting error still error

`$student_reg = $_POST['student_reg'];` vs `` - you have the wrong value for $_POST, it should be `$_POST['stu_registrationnumber']` — Carl Casbolt, Oct 03 '16 at 14:55
`$_POST['student_reg'];` -> `$_POST['stu_registrationnumber'];` **BUT** don't use mysql_*, sanitize user input, use prepared statements. — Jeff, Oct 03 '16 at 14:56
Plus, why are you using the mysqli_ API in one, then mysql_ in another? — Funk Forty Niner, Oct 03 '16 at 14:57

score 0 · Answer 1 · answered Oct 03 '16 at 14:56

0

You have a wrong post value.

change:

<input type="text" name="stu_registrationnumber" />

to

<input type="text" name="student_reg" />

answered Oct 03 '16 at 14:56

ahaha beat me by a few seconds. Funny how our posts are almost identical in format. – Matthew Goulart Oct 03 '16 at 14:57
@MatthewGoulart haha i noticed that. which ever is easier for him to proceed with his project – Oct 03 '16 at 15:01
i did this but still getting blank page – Umer khan Oct 03 '16 at 15:14

score 0 · Answer 2 · answered Oct 03 '16 at 14:56

0

The name if your student registration input is "stu_registrationnumber" but you are looking for "student_reg" in display.php.

Change

$student_reg = $_POST['student_reg'];

to

$student_reg = $_POST['stu_registrationnumber']

answered Oct 03 '16 at 14:56

Matthew Goulart

2,873
4
28
63

i did this but still getting blank page in display.php – Umer khan Oct 03 '16 at 15:15
More information is required in that case. Are you getting an error? Is error reporting turned on? What is the result of `echo $_POST['stu_registrationnumber']`? If you run your query in a tool like workbench, do you get a mysql error? I suggest you do some troubleshooting yourself. The simplest way is to put `var_dump` in key places to make sure you aren't using unexpected `NULL`s. – Matthew Goulart Oct 03 '16 at 15:17
yes i do this also but getting still blank page of display.php – Umer khan Oct 03 '16 at 15:25

getting error when we get data from mysql database how correct

2 Answers2