How to check if data is inserted in MySQL using php

Question

Here is my code

I am searching from Mysql database and want to show message if record found status is FOUND else if record not found display FOUND??

<?php
    $status="";
    if ($_SERVER["REQUEST_METHOD"] == "POST")
    {   
        $degree=$_POST["degree"];
        $mysql_host = "*******";
        $mysql_database = "**********";
        $mysql_user = "*******";
        $mysql_password = "*********";

        $conn = mysql_connect($mysql_host, $mysql_user, $mysql_password);
        if(!$conn )
        {
            die('Could not connect: ' . mysql_error());
        }

        mysql_select_db($mysql_database)or die("cannot select DB");
        $sql = "SELECT *
            FROM studentRecord
            WHERE degree='$degree'";
        $result=mysql_query($sql,$conn);
        if(!$result )
        {
            $status="not found";
        }
        else
        {
            while($row = mysql_fetch_array($result))
            {    
                echo  $row['name'];echo "<br>";
                echo  $row['degree'];
                echo "<br>";
            }
            $status="";
        }
        echo "<h1>" . $status . "</h1>";    
    }
?>

here is my form

<h1>Search</h1>
<form action="search.php" method="post">
    <div class="form_settings">
        <p>
            <select name="degree">
                <option></option>
                <option>Civil Engineering</option>
                <option>Urban & Infrastructure Engineering</option>
                <option>Petroleum Engineering</option>
                <option>Mechanical Engineering</option>
                <option>Textile Engineering</option>
                <option>Industrial & Manufacturing Engineering</option>
                <option>Automotive & Marine Engineering</option>
                <option>Electrical Engineering</option>
                <option>Computer & Information Systems Engineering</option>
                <option>Electronic Engineering</option>
                <option>Chemical Engineering</option>
                <option>Materials Engineering</option>
                <option>Metallurgical Engineering</option>
                <option>Polymer & Petrochemical Engineering</option>
                <option>Software Engineering</option>
                <option>Construction Engineering</option>
                <option>Computer Science & Information Technology</option>
            </select>
            <span style="float:right;"class="error">
        </p>
        <br>
        <input class="submit" type="submit" name="searchSubmit" value="SEARCH" />  
    </div>    
</form>

I am searching from Mysql database and want to show message if record found status is FOUND else if record not found display FOUND??

...and what isn't working on your code?

Niels Keurentjes
– Niels Keurentjes

2014-01-19 17:31:59 +00:00
Commented Jan 19, 2014 at 17:31 — Niels Keurentjes
– Niels Keurentjes, Commented Jan 19, 2014 at 17:31
ps, might want to cover up your username and password...

James Stafford
– James Stafford

2014-01-19 17:35:28 +00:00
Commented Jan 19, 2014 at 17:35 — James Stafford
– James Stafford, Commented Jan 19, 2014 at 17:35
$status not showing when record not found

user3160438
– user3160438

2014-01-19 18:47:24 +00:00
Commented Jan 19, 2014 at 18:47 — user3160438
– user3160438, Commented Jan 19, 2014 at 18:47
solved @nigro.simone has solved it

user3160438
– user3160438

2014-01-19 18:59:09 +00:00
Commented Jan 19, 2014 at 18:59 — user3160438
– user3160438, Commented Jan 19, 2014 at 18:59

Simone Nigro · Accepted Answer · 2014-01-19 17:38:38Z

2

use mysql_num_rows()

$result = mysql_query($sql, $conn) or die( mysql_error() );

if( mysql_num_rows($result) <= 0 )
    echo 'not found';
else
    echo 'found';

PS. mysql_* is deprecated, use mysqli_* or pdo

edited Jan 19, 2014 at 17:38

answered Jan 19, 2014 at 17:32

Simone Nigro

4,9575 gold badges47 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to check if data is inserted in MySQL using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related