I want to select data from database what is the error in my code ,

<center>
<table align="center">
<tr>
<th><a href="phpfirstpjroject.php">Add data here</a></th>
<th> Name</th>
<th>City_Name</th>
<th colspan="2">Operation</th>
</tr>
<?php
include_once'dbconfiguration.php';
$sql_query="SELECT * FROM usertable";
$result_set=$con->query($sql_query);
while($row=$result_set->fetch_assoc())
?>
<tr>
<td><?php echo $row[1]; ?></td>
<td><?php echo $row[2]; ?></td>
<td><?php echo $row[3]; ?></td>
<td align="center"><a href="javascript:edt_id('<?php echo $row[0]; ?>')">
<img src="b_edit.png" align="EDIT" /></a></td>
<td align="center"><a href="javascript:delete_id('<?php echo $row[0]; ?
>')"><img src="b_drop.png" align="DELETE" /></a></td>
</tr>
<?php

?>
}
?>
</table>
</center>


HERE IS THE OUT PUT
Add data here Name City_Name Operation

Notice: Undefined offset: 1 in C:xampphtdocsprojectphpread.php on line 24

Notice: Undefined offset: 2 in C:xampphtdocsprojectphpread.php on line 25

Notice: Undefined offset: 3 in C:xampphtdocsprojectphpread.php on line 26

Notice: Undefined offset: 1 in C:xampphtdocsprojectphpread.php on line 24

Notice: Undefined offset: 2 in C:xampphtdocsprojectphpread.php on line 25

Notice: Undefined offset: 3 in C:xampphtdocsprojectphpread.php on line 26

Notice: Undefined offset: 1 in C:xampphtdocsprojectphpread.php on line 24

Notice: Undefined offset: 2 in C:xampphtdocsprojectphpread.php on line 25

Notice: Undefined offset: 3 in C:xampphtdocsprojectphpread.php on line 26

Notice: Undefined offset: 1 in C:xampphtdocsprojectphpread.php on line 24

Notice: Undefined offset: 2 in C:xampphtdocsprojectphpread.php on line 25

Notice: Undefined offset: 3 in C:xampphtdocsprojectphpread.php on line 26

Notice: Undefined offset: 1 in C:xampphtdocsprojectphpread.php on line 24

Notice: Undefined offset: 2 in C:xampphtdocsprojectphpread.php on line 25

Notice: Undefined offset: 3 in C:xampphtdocsprojectphpread.php on line 26

Notice: Undefined offset: 1 in C:xampphtdocsprojectphpread.php on line 24

Notice: Undefined offset: 2 in C:xampphtdocsprojectphpread.php on line 25

Notice: Undefined offset: 3 in C:xampphtdocsprojectphpread.php on line 26

var_dump( $result_set );

$con

mysql client

1 Answer
1

If you use fetch_assoc you should access tho the values using the related column name

while($row=$result_set->fetch_array()) {
?>
<tr>
<td><?php echo $row['my_col1']; ?></td>
<td><?php echo $row['my_col2']; ?></td>
<td><?php echo $row['my_col3']; ?></td>
...................


if you want access by position you should use fetch_array()

$result_set=$con->query($sql_query);
while($row=$result_set->fetch_array()) {
?>
<tr>
<td><?php echo $row[1]; ?></td>
<td><?php echo $row[2]; ?></td>
<td><?php echo $row[3]; ?></td>
.......


rememamber tha the index start form 0 in the way you are using you are accessing to the column in position 1,2,3 (skipping the first at position zero

Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy