Php not fetching the data from mysql

Question

I have created a login form and a connectivity page which deals with sql connection. Every time its printing "Query not retrieved ". I want to run the query with the login details given in the text box . If its true , The first name has to be stored in the session.

This is the structure of the database i use to link it with php

Database z1760359

Table member

        member ID  firstName  lastName  userName  password

index.php

<html>
<head>
<style>
#login
{

    position:absolute;
    top: 30%;
    bottom: 30%;
    left:30%;
    right:30%;
    margin: 0px auto;
 }

</style>
</head>
<body>
<?php
session_start();

echo"<center>";
echo"<div id=\"login\">";

 echo"<form method=\"POST\" action=\"connectivity.php\">";
 echo"<b>Username</b>  <input type =\"text\" name=\"username\">";
 echo"<br/><br/>";
 echo"<b>Password</b>&nbsp;<input type =\"password\" name=\"password\">";
 echo"<br/><br/>";
 echo"<input type=\"submit\" value=\"submit\">";

 echo"</div>";
 echo"</center>";
 ?>

 </body>
 </html>

connectivity.php

<?php
 $username = $_POST['username'];
$password = $_POST['password'];
$host="localhost";
$uname="root";
$pword="";
$db="z1760359";
$conn=mysqli_connect($host,$uname,$pword,$db) or die("Oops something went   wrong");
session_start();
$query="Select firstName  from member where userName=$username, password=$password";
if(!empty($_POST['username']))
  {
     $query_first=mysqli_query($conn,$query) or die(" Query not retrieved");
     $query_second=mysqli_fetch_assoc($query_first);
     if(!empty($row['username']) AND !empty($row['password']) )
        {
           $_SESSION['user_name']=extract($query_second);
        }
        else
   {
        echo"wrong password";
    }

   }
   else
    {
      echo"please enter the password or username";
    }
  echo"$password";
  echo"<br>";
  echo"$username";
  ?>

please change your or die statement to actually produce the SQL error using (i think...) or die(mysqli_error($conn)) — MuppetGrinder
– MuppetGrinder, Commented Apr 21, 2015 at 8:19

Jens · Accepted Answer · 2015-04-21 08:19:42Z

3

If you do not use prepared statements, you have to make single quotes arround the values in mysql:

$query="Select firstName  from member where userName='$username' AND password='$password'";

Also you have to use logical operators between the conditions.

edited Apr 21, 2015 at 8:19

answered Apr 21, 2015 at 8:17

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

Comments

Nisha · Accepted Answer · 2015-04-21 08:22:19Z

3

In your code "mysqli_query" returns false, hence you should use mysqli_error() for printing more details about the error and move forward accordingly.

answered Apr 21, 2015 at 8:22

Nisha

6851 gold badge4 silver badges16 bronze badges

3 Comments

Lalit Kumar B Over a year ago

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.

Alex Shesterov Over a year ago

@LalitKumarB, though it's not a perfect answer, but a useful hint. It's not a link-only answer.

Lalit Kumar B Over a year ago

At least some important parts should have been included. Else, it is more of a comment rather than an answer. Here at Stack Overflow, it is expected to post an answer if it is a complete answer, else we have comments for giving hints. Isn't it?

Vivek Singh · Accepted Answer · 2015-04-21 08:19:55Z

0

use single quote when using a variable in my mysql query

$query="Select `firstName`  from `member` where `userName`='".$username."' and `password`='".$password."'";

answered Apr 21, 2015 at 8:19

Vivek Singh

2,4451 gold badge16 silver badges29 bronze badges

Comments

Iswanto San · Accepted Answer · 2015-04-21 08:20:23Z

0

Error in your query. You are missing single quotes when comparing the value and you are missing AND operator.

$query="Select firstName  from member where userName='$username' and password='$password'";

answered Apr 21, 2015 at 8:20

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

Comments

Vincenzo Petrucci · Accepted Answer · 2015-04-21 08:53:57Z

0

There's an error in your query. Conditions should be separated by AND, not by comma and you should add single quotes around string values. So your query should be:

Select firstName  from member where userName='$username' AND password='$password'

instead of:

Select firstName  from member where userName=$username, password=$password

answered Apr 21, 2015 at 8:53

Vincenzo Petrucci

8651 gold badge8 silver badges16 bronze badges

Collectives™ on Stack Overflow

Php not fetching the data from mysql

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related