Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialROBERT RUBY II
10,586 PointsOkie dokie, What am I missing here in my find() function. Getting array of NULLS
Getting an array of NULLS and not sure why
<?php
class sqlRepository extends PDO implements RepositoryInterface
{
public function all ($table)
{
// Query
$pdoS = $this->query('SELECT * FROM ' . $table);
return $pdoS->fetchAll(PDO::FETCH_OBJ);
}
public function find( $table, $value, $col = 'id' ) {
// Prepare Query
$sql = "SELECT * FROM $table WHERE $col = ?";
$pdoS = $this->prepare( $sql, [ $value ] );
// Execute Query
$pdoS->execute();
// Return fetched objects
return $pdoS->fetchAll( PDO::FETCH_OBJ);
}
}
1 Answer
ROBERT RUBY II
10,586 PointsI was trying to pass values into the prepare instead of the execute funtion.
public function find( $table, $value, $col = 'id' ) { // Prepare Query $sql = "SELECT * FROM $table WHERE $col = ?"; $pdoS = $this->prepare( $sql ); // Execute Query $pdoS->execute( [ $value ] );
// Return feteched table
return $pdoS->fetchAll( PDO::FETCH_OBJ);
}
ROBERT RUBY II
10,586 PointsROBERT RUBY II
10,586 PointsI had to refresh myself but i figured out the issue..... posting answer.