method not returning anything

Question

I created a method for returning a certain row and there is no error or anything just the method not returning any data from the database.

Here is where I invoke the method:

<a class="navbar-brand" href="http://localhost/old marketplace website/">
    <?php echo $controller->getTableData($table, $column, $columnValue, $rowTitle); ?>
</a>

And here is what the method getTableData() looks like:

public function getTableData($table, $column, $columnValue, $rowTitle)
{
    $query = $this->db->prepare("SELECT * FROM $table WHERE $column = ? ");

    $query->bindValue(1,$columnValue);    
    $query->execute();

    $f = $query->fetch(PDO::FETCH_ASSOC);

    $result = $f['$rowTitle'];

    return $result;
}

How do I need to adjust my method to have it return the desired data?

In the actual class file it is in a php tag... i just didn't include the tag in the post. — Jmorin2017, Aug 30 '17 at 03:59
`var_dump($f)` to make sure you are getting a result from your query. If not, that's what you need to address. — Luke, Aug 30 '17 at 04:10

score 5 · Answer 1 · edited Sep 02 '17 at 13:24

5

Try removing quotes from the following line:

$result = $f['$rowTitle'];

You're looking for a column with the name equal to the value of $rowTitle, rather than a column with the name '$rowTitle'. Remove the single quotes to use the value of the variable $rowTitle:

$result = $f[$rowTitle];

For reference, see:

edited Sep 02 '17 at 13:24

localheinz

9,179
2
33
44

answered Aug 30 '17 at 01:06

Jamie M

422
3
8

1

Not only that, if anyone writes `'`, PHP will try to **literally** parse it, it is not the same as `"` – matiaslauriti Aug 30 '17 at 01:58
Still didn't return anything – Jmorin2017 Aug 30 '17 at 03:58
I think with the info you've given this is the best answer you'll get. Try echoing what is retrieved from the db? – HumbleWebDev Aug 30 '17 at 04:09

method not returning anything

1 Answers1