CODEWITHSUNDEEP
phpmysql
Adarsh Sojitra
Adarsh Sojitra

Reputation: 2219

Data not fetched from MySQL table in PHP

I want to print the name and last name of an ID entered in the text box. Here is the PHP and HTML code:

    <head>
        <title>
            Search your name by ID
        </title>
    </head>
<?php
if(isset($_POST["searchname"]))
{
    $id = $_POST["searchname"]; 
    $connect = new mysqli("localhost","adarsh","Yeah!","adarsh");
    $a = mysql_query("Select * from users where id='$id'",$connect);
    $row = mysql_fetch_assoc($a);
    echo "$row[0] , $row[1] , $row[2]";
}
else
{
    echo "error";
}
?>
    <body>
        <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
            <input type="text" maxlength="6" name="searchname">
            <input type="Submit" name="Submit">
        </form>
    </body>

Output when I enter ID:

 , ,

There are entries in the MySQL table but I am unable to fetch them. What is wrong with my code?

UPDATE: I have also tried mysql_fetch_array but it is not working.

Upvotes: 1

Views: 80

Answers (2)

Manisha Chaudhary
Manisha Chaudhary

Reputation: 84

Try this: 

<html>
    <head>
        <title>
            Search your name by ID
        </title>
    </head>
    <body>
        <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
            <input type="text" maxlength="6" name="searchname">
            <input type="Submit" name="Submit">
        </form>
    </body>
</html>

<?php
if(isset($_POST["searchname"])){

    $id = $_POST["searchname"]; 
    $connect = mysql_connect("localhost","adarsh","Yeah!","adarsh");
    $result = mysql_query("Select * from users where id='$id'",$connect);
    $row = mysql_fetch_assoc($result);
    print_R($row);
}else{

    echo "there is something wrong";
}

Upvotes: 0

u_mulder
u_mulder

Reputation: 54796

Main problem is that you're miximg mysqli and mysql. These are absolutely different APIs. Assuming you have

$id = $_POST["searchname"]; 
$connect = new mysqli("localhost","adarsh","Yeah!","adarsh");

Next you should:

$result = $connect->query("Select * from users where id='$id'");

Then get results:

while ($row = $result->fetch_assoc()) {
    var_dump($row);
}

And of course, instead of directly putting values into your query use prepared statements.

Update: about mistakes:

  • Your main mistake is mixing apis. When you use mysql (which is deprecated and you mustn't use it anymore) you can't use any of mysqli functions and vice versa.

  • Next - as you create mysqli object with new, you should work in object-oriented style, i.e. calling methods from your mysqli object.

Upvotes: 4

Related Questions