Grabbing data from DB

[Godz06]

I’m trying to grab information for a user and displaying it on their profile, but this isn’t working. what am I doing wrong? and how i can correct it?

after I clicking on the user link:

<a href="profiles.php?=<?php echo $rows['id']?>"> <?php echo $rows['firstname'], ' ', $rows['lastname']?> <br /><br /> </a>

I can’t fetch the data

<?php
session_start();
include 'core/connect.php';
	
	$id = $_GET['id'];

	$query = dbConnect()->prepare("SELECT `id`, `firstname`, `lastname`, `notes` FROM `loaders` WHERE id = :id");

	foreach($query->fetchAll(PDO::FETCH_ASSOC) AS $rows){
		echo $rows['notes'];
	}
	?>

[Mittineague]

Substituting some unlikely values, the link looks like

<a href="profiles.php?=1234"> god z06 <br /><br /> </a>

I see a Get value but no name (id), and the break tags inside the link don’t look right.

[blue_sky2]

It seems you forget to bind the id’s value,like

$query->bindValue(':id', $id);

[Godz06]

I’m getting errors:

Notice: Undefined Index: Id In C:\Wamp\Www\Loaders.Php On Line 10
Notice: Undefined Index: Firstname In C:\Wamp\Www\Loaders.Php On Line 14
Notice: Undefined Index: Firstname In C:\Wamp\Www\Loaders.Php On Line 15
Notice: Undefined Index: Notes In C:\Wamp\Www\Loaders.Php On Line 16

<?php
session_start();
include 'core/connect.php';

    $id = $_GET['id'];

    $query = dbConnect()->prepare("SELECT `id`, `firstname`, `lastname`, `notes` FROM `loaders` WHERE id = :id");
    $query->bindValue(':id', $id);
    $query->bindValue(':firstname', $_POST['firstname']);
    $query->bindValue(':lastname', $_POST['lastname']);
    $query->bindValue(':notes', $_POST['notes']);
    $query->execute();

    foreach($query->fetchAll(PDO::FETCH_ASSOC) AS $rows){
        echo $rows['notes'];
    }
    ?>

	<a href="profiles.php?=<?php echo $rows['id']?>"> <?php echo $rows['firstname'], ' ', $rows['lastname']?> <br /><br /> </a>

[Mittineague]

Are you using $_GET or $_POST, should be one or the other, not both.

[ahundiak]

You almost had it. Forgot the execute call.

    $id = $_GET['id']; 

    $query = dbConnect()->prepare("SELECT `id`, `firstname`, `lastname`, `notes` FROM `loaders` WHERE id = :id"); 
    $query->execute(array('id' => $id);
    $rows = $query->fetchAll(PDO::FETCH_ASSOC);

    foreach($rows AS $row){ 
        echo $row['notes']; 
    } 

http://www.php.net/manual/en/class.pdostatement.php

[Godz06]

( ! ) Parse error: syntax error, unexpected ‘;’ in C:\wamp\www\loaders.php on line 13

with that code

@ahundiak

You almost had it. Forgot the execute call.

    $id = $_GET['id']; 

    $query = dbConnect()->prepare("SELECT `id`, `firstname`, `lastname`, `notes` FROM `loaders` WHERE id = :id"); 
    $query->execute(array('id' => $id);
    $rows = $query->fetchAll(PDO::FETCH_ASSOC);

    foreach($rows AS $row){ 
        echo $row['notes']; 
    } 

http://www.php.net/manual/en/class.pdostatement.php

[Mittineague]

Missing a parens, they have to be in pairs.

$query->execute(array('id' => $id));