MySql PDO - Referring two colowns and displaying the id as result

Question

I have been checking for more than an hour but i cant get the result, my question is, by checking two columns it must display the other columns value as result using PDO.

$sql ="SELECT column3 FROM tablename WHERE column1 = :request AND column2= :recived";
$conn = $conn->prepare($sql);
$fetch = $conn->execute(array(':request'=> $value1,':recived'=>$value2));
$fetch = $fetch->fetchColumn();

please help me with this. Thanks in advance

Don't reuse variables like that? After you prepare the statement, you can no longer use that database connection any more because you overwrote the `$conn` variable. — Barmar, Jun 07 '17 at 08:35
Make sure you have `error_reporting(E_ALL)` enabled. The last statement should have reported an error. — Barmar, Jun 07 '17 at 08:46
http://stackoverflow.com/questions/845021/how-to-get-useful-error-messages-in-php — Barmar, Jun 07 '17 at 16:19

score 1 · Answer 1 · answered Jun 07 '17 at 08:39

1

This is what you looking for :

<?php

$sql ="SELECT column3 FROM tablename WHERE column1 = :request AND column2= :recived";
$stmt = $conn->prepare($sql);
$stmt->execute(array(':request'=> $value1,':recived'=>$value2));
$fetch = $stmt->fetchColumn();
?>

answered Jun 07 '17 at 08:39

Masivuye Cokile

4,754
3
19
34

score 0 · Answer 2 · answered Jun 07 '17 at 08:27

Change it as such:

$sql ="SELECT column3 FROM tablename WHERE column1 = :request AND column2= :recived";
$conn = $conn->prepare($sql);
$conn->execute(array(':request'=> $value1,':recived'=>$value2));
$fetch = $conn ->fetchColumn();

You should call fetchColumn() on the statement. Because execute() only returns a boolean as result.

score 0 · Accepted Answer · answered Jun 07 '17 at 08:28

0

execute() returns a boolean and you're trying to call fetchColumn() on it. Call fetchColumn() on the statement instead:

$fetch = $conn->fetchColumn();

For future debugging, check your error log because there will be a message indicating the problem here.

answered Jun 07 '17 at 08:28

MrCode

63,975
10
90
112

but when i echo no result – Aravind Venkat Jun 07 '17 at 08:41

MySql PDO - Referring two colowns and displaying the id as result

3 Answers3