PHP: How to fetch data from database?

Question

<?php
session_start();
$_SESSION['id']="id";
?>

<!DOCTYPE html>
<html>
<head>
    <title>Update</title>
</head>
<body>

<table border="2">
    <tr>
        <th>Username</th>
        <th>Email</th>
        <th>Edit</th>
    </tr>
<?php
     $conn=mysqli_connect("localhost","root","","telephasic");
     $q2="select * from register where id = '".$_SESSION['id']."'";
     $run=mysqli_query($conn, $q2);
     while($row=mysqli_fetch_array($run))
     {
         $name=$row[1];
         $email=$row[2];
     ?>

    <tr>
        <td><?php echo $name; ?></td>
        <td><?php echo $email; ?></td>
        <td><a href="edit.php"> Edit </a></td>
    </tr>
 <?php } ?>
 </table> 
 </body>

here i want to fetch an individual row information stored in database i can't able to fetch the data so what i have to do here for fetch code with help of session id

So you get no data in return or data just doesn't show up? Have you checked that $row[1] is valid and contains data? — user8034901
– user8034901, Commented Jul 23, 2018 at 8:33
why $row[1]... ? I guess u need something like $row['name']... — B001ᛦ
– B001ᛦ, Commented Jul 23, 2018 at 8:33

Nikhil Tiwari · Accepted Answer · 2018-07-23 12:40:13Z

1

<?php
session_start();
$id = $_SESSION['id'];
?>
<!DOCTYPE html>
<html>
<head>
    <title>Update</title>
</head>
<body>

<table border="2">
    <tr>
        <th>Username</th>
        <th>Email</th>
        <th>Edit</th>
    </tr>
<?php
     $conn = mysqli_connect("localhost","root","","telephasic");
     $q2 = "select * from register where id = $id ";
     $run = mysqli_query($conn, $q2);
     $row = mysqli_fetch_array($run);
?>
    <tr>
        <td><?= $row['name']; ?></td>
        <td><?= $row['email']; ?></td>
        <td><a href="edit.php"> Edit </a></td>
    </tr>
 </table> 
 </body>

skip the while part, cuz you are fetching single record.

edited Jul 23, 2018 at 12:40

answered Jul 23, 2018 at 8:50

Nikhil Tiwari

1193 bronze badges

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

2 Comments

Arun Sharma Over a year ago

but it can only fetch data of 1st id only i have to fetch data of the person login

Nikhil Tiwari Over a year ago

simply assign the user id in $_SESSION['id'] variable . i recommend to create session id when user login, and use that session variable. i already edited the code.

Mohammad Al-Ani · Accepted Answer · 2018-07-23 08:46:40Z

0

you have problem at the third row in code

$_SESSION['id']="id";

you set the $_SESSION['id'] to the string "id", so you will get nothing from your database cause you have no row that have id = "id" . remove this line and everything will work fine

answered Jul 23, 2018 at 8:46

Mohammad Al-Ani

62611 silver badges14 bronze badges

3 Comments

Arun Sharma Over a year ago

but i cannot fetch the row info

Mohammad Al-Ani Over a year ago

use mysqli_fetch_row not mysqli_fetch_array at line 23

Mohammad Al-Ani Over a year ago

and put the second <tr> section inside the while loop

Collectives™ on Stack Overflow

PHP: How to fetch data from database?

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related