Select and display from MySQL table with php

Question

I want to select all the rows that have $name but it only shows the first row. My table is like this

id 
name
password
email

Code :

$result = mysql_fetch_assoc(mysql_query("SELECT * FROM  data WHERE username ='$name'"));

print_r($result);

This is not working, it only shows the first row.

did u checked that there are more than one entry for that username you have entered — Sundar Bons
– Sundar Bons, Commented Apr 27, 2015 at 9:49
yes sir,it fixed now $query= mysql_query("SELECT * FROM data WHERE username ='$name'"); $finalRes = array(); while($result = mysql_fetch_assoc($query)) { $finalRes[] = $result; } print_r($finalRes); — Zouaoui Djaballah
– Zouaoui Djaballah, Commented Apr 27, 2015 at 9:59

Sunil Pachlangia · Accepted Answer · 2015-04-27 09:43:16Z

1

Better to use in this way

$query= mysql_query("SELECT * FROM data WHERE username ='$name'");
$finalRes = array();
while($result = mysql_fetch_assoc($query))
{
   $finalRes[] = $result;
}
print_r($finalRes);

answered Apr 27, 2015 at 9:43

Sunil Pachlangia

2,0613 gold badges17 silver badges26 bronze badges

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

Comments

cn0047 · Accepted Answer · 2015-04-27 10:31:01Z

0

You should look errors:

<?php

$result = mysql_query("SELECT * FROM  data WHERE username = '$name'");
if (!$result) {
    var_export(mysql_error());
}
$data = [];
while ($row = mysql_fetch_assoc($result)) {
    $data[] = $row;
}
var_export($data);

and don't forget about sql-injections...

PDO:

<?php

try {
    $dbh = new PDO('mysql:dbname=test;host=127.0.0.1', 'root');
} catch (PDOException $e) {
    echo 'Connection failed: '.$e->getMessage();
}
$name = 'yourName';
$sth = $dbh->prepare('SELECT * FROM  data WHERE username = :name');
$sth->bindParam(':name', $name, PDO::PARAM_STR);
if (!$sth->execute()) {
    throw new Exception($sth->errorInfo());
}
$result = $sth->fetchAll(PDO::FETCH_ASSOC);
var_export($result);

edited Apr 27, 2015 at 10:31

answered Apr 27, 2015 at 9:54

cn0047

17.2k7 gold badges61 silver badges75 bronze badges

5 Comments

cn0047 Over a year ago

1) "SELECT * FROM data WHERE username = '$name'" - it's a hole. Write this - it's bad practice... but problem not in this... 2) I suppose: if error occurs it should be processed... var_export(mysql_error());

Zouaoui Djaballah Over a year ago

ok,i will look more into how to prevent sql injection,for now will just put var_export(mysql_error()); after each query.

cn0047 Over a year ago

I recommend to you use PDO!) And be sure that your user really exists at database)

Zouaoui Djaballah Over a year ago

alright PDO it is then,is it more secure or something?

cn0047 Over a year ago

yes! secure, performance, and much other... I added pdo example, looks almost the same, but more powerful...

Neelesh · Accepted Answer · 2015-04-27 09:54:43Z

0

Try like this

    $sql = "select * from data where username='$username'";
    $res = mysql_query($sql);
    while ($row = mysql_fetch_array($res))
   {
   print_r($row);
   }

i have changed the code try this loop so that all the data will print,if not let us know

edited Apr 27, 2015 at 9:54

answered Apr 27, 2015 at 9:44

Neelesh

1931 silver badge12 bronze badges

1 Comment

Zouaoui Djaballah Over a year ago

it still show me only first row // Array ( [0] => 9 [id] => 9 [1] => anis [username] => anis [2] => test [email] => test [3] => test [password] => test )

Collectives™ on Stack Overflow

Select and display from MySQL table with php

3 Answers 3

Comments

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related