php/sql : don't echo show data correctly

Question

i have a problem with my php and sql code. I trying to make code that when i enter some data that related with the database, the output should show 'zero' if the row user_designid equal to 0 and if vice versa it will show 'one'. but the problem is both of output only show the first anwser ('zero').

Php file (co.php is my config)

 <?php
 require "co.php";
 $link = mysqli_connect($h,$u,$p,$db);

 if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
 }
echo "Connected successfully";

$q = "select * from tab_ss_user where User_name ='".$_POST['name']."'";
$result = mysqli_query($link,$q);


if($result){
echo "<table border='1' >
<tr>
<td align=center> <b>user Id No</b></td>
<td align=center><b>Name</b></td>
<td align=center><b>Password</b></td>
<td align=center><b>responsibility</b></td></td>";

while($data = mysqli_fetch_row($result))
{   
echo "<tr>";
echo "<td align=center><option>$data[0]</option></td>";
echo "<td align=center>$data[1]</td>";
echo "<td align=center>$data[2]</td>";

    //this is the problem
if($data['User_DesignID'] == 0 ){
      echo "<td align=center> zero </td>";
 }
else{
      echo "<td align=center> one </td>";
 }


   echo "</tr>";
 }
   echo "</table>";
 }

  else{
   echo ' Failed';
 }
 ?>

that all thank you.

Try using `===` instead of `==`. http://stackoverflow.com/questions/80646/how-do-the-php-equality-double-equals-and-identity-triple-equals-comp — Pyromonk, Apr 18 '17 at 05:04
Inside `while` add this `print_r($data); die;`. And provide the output. — Kinshuk Lahiri, Apr 18 '17 at 05:06
@MayankPandeyz no error just the output for if($data) not properly function — Nexz, Apr 18 '17 at 05:59
@SardonicSaviour still same. but the answer change from only taking 'zero' to only using 'one' — Nexz, Apr 18 '17 at 06:00
@KinshukLahiri i dont understant, you mean in while(____) or after { — Nexz, Apr 18 '17 at 06:01
@A.ANoman ooh, typo over there sorry. but still work even though it not the same. (still not fixing the problem) — Nexz, Apr 18 '17 at 06:03
@KinshukLahiri do you mean like this? while(____)( print_r($data);die; echo "-------";} — Nexz, Apr 18 '17 at 06:15

score 1 · Accepted Answer · answered Apr 18 '17 at 06:35

1

You are not referencing the field correctly See enter link description here

When using mysqli_fetch_row, the result is an associative array so $data['User_DesignID'] will not be referenced correctly.

answered Apr 18 '17 at 06:35

Jeffrey Hitosis

325
3
13

that's correct. i should using the column number instead of column name. – Nexz Apr 18 '17 at 06:58

score 0 · Answer 2 · answered Apr 18 '17 at 06:20

0

please make sure your column name is "User_DesignID"
if($data['User_DesignID'] == 0 ){

answered Apr 18 '17 at 06:20

pank sharma

37
7

you can use mysql_fetch_assoc() for using column name – pank sharma Apr 18 '17 at 07:23

score 0 · Answer 3 · answered Apr 18 '17 at 15:43

0

(Posted on behalf of the OP).

Thanks to Jeffrey idea, I have found an answer (please refer to Jeffrey's answer on this page).

And also if you want to use column name instead please use mysqli_fetch_assoc instead of row.

answered Apr 18 '17 at 15:43

halfer

19,824
17
99
186

php/sql : don't echo show data correctly

3 Answers3