Can't get data from database using mysqli

Question

I have got this code

$dafirstname = "SELECT fullname FROM websiteusers WHERE userName='$usernamer'";
$differentvariables = mysqli_query($link, $dafirstname);
$row = mysqli_fetch_array($differentvariables, MYSQLI_ASSOC);
printf("%s (%s)\n", $row["pass"], $row["userID"]);

if(!mysqli_query($link,$dafirstname)){
  echo mysqli_error($link);     
}

But it does not print any thing or it is not giving any errors

have you enabled php errors? http://stackoverflow.com/questions/845021/how-to-get-useful-error-messages-in-php — devlin carnate, Sep 08 '15 at 15:39
also, as a side note (not to fix your problem), consider prepared statements to avoid sql injection: http://stackoverflow.com/questions/1290975/how-to-create-a-secure-mysql-prepared-statement-in-php — devlin carnate, Sep 08 '15 at 15:43

score 0 · Accepted Answer · answered Sep 08 '15 at 15:34

0

Change your query. You were asking fullname only. change it to see the result.

$dafirstname="SELECT * FROM websiteusers WHERE userName='$usernamer'";
$differentvariables=mysqli_query($link,$dafirstname);
$row=mysqli_fetch_array($differentvariables,MYSQLI_ASSOC);
printf ("%s (%s)\n", $row["pass"], $row["userID"]);
if(!mysqli_query($link,$dafirstname)){
  echo mysqli_error($link);     
}

answered Sep 08 '15 at 15:34

Nana Partykar

10,556
10
48
77

He should use `SELECT pass, userID` -- no need to select `*` if he doesn't use anything else. – Barmar Sep 08 '15 at 15:35
Oh no its working thanks.I will accept you answer in 50 seconds – Murad Murader Sep 08 '15 at 15:38
I Am Glad. :) @MuradMurader – Nana Partykar Sep 08 '15 at 15:42

Can't get data from database using mysqli

1 Answers1