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 ==. stackoverflow.com/questions/80646/… — Pyromonk
– Pyromonk, Commented Apr 18, 2017 at 5:04
Inside while add this print_r($data); die;. And provide the output. — Kinshuk Lahiri
– Kinshuk Lahiri, Commented Apr 18, 2017 at 5:06
@MayankPandeyz no error just the output for if($data) not properly function — Nexz
– Nexz, Commented Apr 18, 2017 at 5:59

Jeffrey Hitosis · Accepted Answer · 2017-04-18 06:35:11Z

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, 2017 at 6:35

Jeffrey Hitosis

3253 silver badges13 bronze badges

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

1 Comment

Nexz Over a year ago

that's correct. i should using the column number instead of column name.

pank sharma · Accepted Answer · 2017-04-18 06:20:02Z

0

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

answered Apr 18, 2017 at 6:20

pank sharma

377 bronze badges

1 Comment

pank sharma Over a year ago

you can use mysql_fetch_assoc() for using column name

halfer · Accepted Answer · 2017-04-18 15:43:04Z

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, 2017 at 15:43

community wiki

halfer

Collectives™ on Stack Overflow

php/sql : don't echo show data correctly

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related