Mixing
PHP PDO returning false when executing prepared statement with parameters
-1
I have been banging my head against this issue for the past three days. Seemingly no matter what I do, if I try and execute a prepared PDO statement while passing in parameters it will always return false.
function login($email,$password)
$outcome;
$conn;
$servername = ...
$username = ...
$password = ...
$database = ...
try {
$conn = new PDO(...);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->setAttribute( PDO::ATTR_EMULATE_PREPARES, FALSE );
} catch(PDOException $e) {
$outcome = "Connection failed: " . $e->getMessage();
return $outcome;
die();
}
$sql = "SELECT * FROM `users` WHERE user_email = ?";
$stmt = $conn->prepare($sql);
$stmt->execute(array($email));
$user = $stmt->fetch(PDO::FETCH_ASSOC);
echo (json_encode($user));
...
I've tried using bindValue() and bindParam() to explicitly bind the $email variable to the placeholder, either way the $user variable will always evaluate to false. It should return the first row of the query results as an associative array.
php sql function pdo prepared-statement
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
add a comment |
-1
I have been banging my head against this issue for the past three days. Seemingly no matter what I do, if I try and execute a prepared PDO statement while passing in parameters it will always return false.
function login($email,$password)
$outcome;
$conn;
$servername = ...
$username = ...
$password = ...
$database = ...
try {
$conn = new PDO(...);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->setAttribute( PDO::ATTR_EMULATE_PREPARES, FALSE );
} catch(PDOException $e) {
$outcome = "Connection failed: " . $e->getMessage();
return $outcome;
die();
}
$sql = "SELECT * FROM `users` WHERE user_email = ?";
$stmt = $conn->prepare($sql);
$stmt->execute(array($email));
$user = $stmt->fetch(PDO::FETCH_ASSOC);
echo (json_encode($user));
...
I've tried using bindValue() and bindParam() to explicitly bind the $email variable to the placeholder, either way the $user variable will always evaluate to false. It should return the first row of the query results as an associative array.
php sql function pdo prepared-statement
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
If either the prepare or execute returns false, you should find out what the specific error was. Refer to documentation about error handling in PDO. For example, it could be that your MySQL user doesn't have privileges to query theuserstable, or it could be theuserstable doesn't exist in the database you have selected as your default database. It's fruitless to guess at the error, when the error message is easy to get.
– Bill Karwin
Nov 20 '18 at 2:53
Enable error reporting php.net/manual/en/function.error-reporting.php then tell us what you get back.
– Funk Forty Niner
Nov 20 '18 at 3:03
@FunkFortyNiner I followed your example and no error is output, just the value from the $user variable that I am echoing which equals 'false'
– Dalton Jones
Nov 20 '18 at 3:13
add a comment |
-1
-1
-1
I have been banging my head against this issue for the past three days. Seemingly no matter what I do, if I try and execute a prepared PDO statement while passing in parameters it will always return false.
function login($email,$password)
$outcome;
$conn;
$servername = ...
$username = ...
$password = ...
$database = ...
try {
$conn = new PDO(...);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->setAttribute( PDO::ATTR_EMULATE_PREPARES, FALSE );
} catch(PDOException $e) {
$outcome = "Connection failed: " . $e->getMessage();
return $outcome;
die();
}
$sql = "SELECT * FROM `users` WHERE user_email = ?";
$stmt = $conn->prepare($sql);
$stmt->execute(array($email));
$user = $stmt->fetch(PDO::FETCH_ASSOC);
echo (json_encode($user));
...
I've tried using bindValue() and bindParam() to explicitly bind the $email variable to the placeholder, either way the $user variable will always evaluate to false. It should return the first row of the query results as an associative array.
php sql function pdo prepared-statement
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
I have been banging my head against this issue for the past three days. Seemingly no matter what I do, if I try and execute a prepared PDO statement while passing in parameters it will always return false.
function login($email,$password)
$outcome;
$conn;
$servername = ...
$username = ...
$password = ...
$database = ...
try {
$conn = new PDO(...);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->setAttribute( PDO::ATTR_EMULATE_PREPARES, FALSE );
} catch(PDOException $e) {
$outcome = "Connection failed: " . $e->getMessage();
return $outcome;
die();
}
$sql = "SELECT * FROM `users` WHERE user_email = ?";
$stmt = $conn->prepare($sql);
$stmt->execute(array($email));
$user = $stmt->fetch(PDO::FETCH_ASSOC);
echo (json_encode($user));
...
I've tried using bindValue() and bindParam() to explicitly bind the $email variable to the placeholder, either way the $user variable will always evaluate to false. It should return the first row of the query results as an associative array.
php sql function pdo prepared-statement
php sql function pdo prepared-statement
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
edited Nov 20 '18 at 3:14
Dalton Jones
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
asked Nov 20 '18 at 2:44
Dalton JonesDalton Jones
12
12
If either the prepare or execute returns false, you should find out what the specific error was. Refer to documentation about error handling in PDO. For example, it could be that your MySQL user doesn't have privileges to query theuserstable, or it could be theuserstable doesn't exist in the database you have selected as your default database. It's fruitless to guess at the error, when the error message is easy to get.
– Bill Karwin
Nov 20 '18 at 2:53
Enable error reporting php.net/manual/en/function.error-reporting.php then tell us what you get back.
– Funk Forty Niner
Nov 20 '18 at 3:03
@FunkFortyNiner I followed your example and no error is output, just the value from the $user variable that I am echoing which equals 'false'
– Dalton Jones
Nov 20 '18 at 3:13
add a comment |
If either the prepare or execute returns false, you should find out what the specific error was. Refer to documentation about error handling in PDO. For example, it could be that your MySQL user doesn't have privileges to query theuserstable, or it could be theuserstable doesn't exist in the database you have selected as your default database. It's fruitless to guess at the error, when the error message is easy to get.
– Bill Karwin
Nov 20 '18 at 2:53
Enable error reporting php.net/manual/en/function.error-reporting.php then tell us what you get back.
– Funk Forty Niner
Nov 20 '18 at 3:03
@FunkFortyNiner I followed your example and no error is output, just the value from the $user variable that I am echoing which equals 'false'
– Dalton Jones
Nov 20 '18 at 3:13
If either the prepare or execute returns false, you should find out what the specific error was. Refer to documentation about error handling in PDO. For example, it could be that your MySQL user doesn't have privileges to query the
users table, or it could be the users table doesn't exist in the database you have selected as your default database. It's fruitless to guess at the error, when the error message is easy to get.– Bill Karwin
Nov 20 '18 at 2:53
If either the prepare or execute returns false, you should find out what the specific error was. Refer to documentation about error handling in PDO. For example, it could be that your MySQL user doesn't have privileges to query the
users table, or it could be the users table doesn't exist in the database you have selected as your default database. It's fruitless to guess at the error, when the error message is easy to get.– Bill Karwin
Nov 20 '18 at 2:53
Enable error reporting php.net/manual/en/function.error-reporting.php then tell us what you get back.
– Funk Forty Niner
Nov 20 '18 at 3:03
Enable error reporting php.net/manual/en/function.error-reporting.php then tell us what you get back.
– Funk Forty Niner
Nov 20 '18 at 3:03
@FunkFortyNiner I followed your example and no error is output, just the value from the $user variable that I am echoing which equals 'false'
– Dalton Jones
Nov 20 '18 at 3:13
@FunkFortyNiner I followed your example and no error is output, just the value from the $user variable that I am echoing which equals 'false'
– Dalton Jones
Nov 20 '18 at 3:13
add a comment |
2 Answers
2
active
oldest
votes
0
$sql = "SELECT * FROM `users` WHERE user_email = :user_email";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':user_email', $email);
$stmt->execute();
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
No, this gives me the same result as well
– Dalton Jones
Nov 20 '18 at 3:18
add a comment |
0
Try this and see what it gives you. Once you see where the error is, you can go from there
<?php
function login($email,$password)
{
$servername = 'localhost';
$username = 'DB_USERNAME';
$password = 'DB_PASSWORD';
$database = 'DB_NAME';
$charset = 'utf8mb4';
$dsn = "mysql:host=$servername;dbname=$database;charset=$charset";
try
{
$opt = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ];
$conn = new PDO($dsn, $username, $password, $opt);
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
$stmt = $conn->prepare('SELECT * FROM users WHERE user_email = :user_email');
$stmt->bindParam(':user_email', $email);
if ($stmt->execute())
{
if ($user = $stmt->fetch())
{
echo (json_encode($user));
} else {
echo "Error, failed fetching data";
}
} else {
echo "Error, failed executing query";
}
}
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53385475%2fphp-pdo-returning-false-when-executing-prepared-statement-with-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
$sql = "SELECT * FROM `users` WHERE user_email = :user_email";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':user_email', $email);
$stmt->execute();
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
No, this gives me the same result as well
– Dalton Jones
Nov 20 '18 at 3:18
add a comment |
0
$sql = "SELECT * FROM `users` WHERE user_email = :user_email";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':user_email', $email);
$stmt->execute();
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
No, this gives me the same result as well
– Dalton Jones
Nov 20 '18 at 3:18
add a comment |
0
0
0
$sql = "SELECT * FROM `users` WHERE user_email = :user_email";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':user_email', $email);
$stmt->execute();
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
$sql = "SELECT * FROM `users` WHERE user_email = :user_email";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':user_email', $email);
$stmt->execute();
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
answered Nov 20 '18 at 3:15
MackProgramsAlotMackProgramsAlot
450315
450315
No, this gives me the same result as well
– Dalton Jones
Nov 20 '18 at 3:18
add a comment |
No, this gives me the same result as well
– Dalton Jones
Nov 20 '18 at 3:18
No, this gives me the same result as well
– Dalton Jones
Nov 20 '18 at 3:18
No, this gives me the same result as well
– Dalton Jones
Nov 20 '18 at 3:18
add a comment |
0
Try this and see what it gives you. Once you see where the error is, you can go from there
<?php
function login($email,$password)
{
$servername = 'localhost';
$username = 'DB_USERNAME';
$password = 'DB_PASSWORD';
$database = 'DB_NAME';
$charset = 'utf8mb4';
$dsn = "mysql:host=$servername;dbname=$database;charset=$charset";
try
{
$opt = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ];
$conn = new PDO($dsn, $username, $password, $opt);
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
$stmt = $conn->prepare('SELECT * FROM users WHERE user_email = :user_email');
$stmt->bindParam(':user_email', $email);
if ($stmt->execute())
{
if ($user = $stmt->fetch())
{
echo (json_encode($user));
} else {
echo "Error, failed fetching data";
}
} else {
echo "Error, failed executing query";
}
}
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
add a comment |
0
Try this and see what it gives you. Once you see where the error is, you can go from there
<?php
function login($email,$password)
{
$servername = 'localhost';
$username = 'DB_USERNAME';
$password = 'DB_PASSWORD';
$database = 'DB_NAME';
$charset = 'utf8mb4';
$dsn = "mysql:host=$servername;dbname=$database;charset=$charset";
try
{
$opt = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ];
$conn = new PDO($dsn, $username, $password, $opt);
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
$stmt = $conn->prepare('SELECT * FROM users WHERE user_email = :user_email');
$stmt->bindParam(':user_email', $email);
if ($stmt->execute())
{
if ($user = $stmt->fetch())
{
echo (json_encode($user));
} else {
echo "Error, failed fetching data";
}
} else {
echo "Error, failed executing query";
}
}
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
add a comment |
0
0
0
Try this and see what it gives you. Once you see where the error is, you can go from there
<?php
function login($email,$password)
{
$servername = 'localhost';
$username = 'DB_USERNAME';
$password = 'DB_PASSWORD';
$database = 'DB_NAME';
$charset = 'utf8mb4';
$dsn = "mysql:host=$servername;dbname=$database;charset=$charset";
try
{
$opt = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ];
$conn = new PDO($dsn, $username, $password, $opt);
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
$stmt = $conn->prepare('SELECT * FROM users WHERE user_email = :user_email');
$stmt->bindParam(':user_email', $email);
if ($stmt->execute())
{
if ($user = $stmt->fetch())
{
echo (json_encode($user));
} else {
echo "Error, failed fetching data";
}
} else {
echo "Error, failed executing query";
}
}
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
Try this and see what it gives you. Once you see where the error is, you can go from there
<?php
function login($email,$password)
{
$servername = 'localhost';
$username = 'DB_USERNAME';
$password = 'DB_PASSWORD';
$database = 'DB_NAME';
$charset = 'utf8mb4';
$dsn = "mysql:host=$servername;dbname=$database;charset=$charset";
try
{
$opt = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ];
$conn = new PDO($dsn, $username, $password, $opt);
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
$stmt = $conn->prepare('SELECT * FROM users WHERE user_email = :user_email');
$stmt->bindParam(':user_email', $email);
if ($stmt->execute())
{
if ($user = $stmt->fetch())
{
echo (json_encode($user));
} else {
echo "Error, failed fetching data";
}
} else {
echo "Error, failed executing query";
}
}
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
answered Nov 24 '18 at 18:33
JeanPaul98JeanPaul98
510415
510415
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53385475%2fphp-pdo-returning-false-when-executing-prepared-statement-with-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If either the prepare or execute returns false, you should find out what the specific error was. Refer to documentation about error handling in PDO. For example, it could be that your MySQL user doesn't have privileges to query the
userstable, or it could be theuserstable doesn't exist in the database you have selected as your default database. It's fruitless to guess at the error, when the error message is easy to get.– Bill Karwin
Nov 20 '18 at 2:53
Enable error reporting php.net/manual/en/function.error-reporting.php then tell us what you get back.
– Funk Forty Niner
Nov 20 '18 at 3:03
@FunkFortyNiner I followed your example and no error is output, just the value from the $user variable that I am echoing which equals 'false'
– Dalton Jones
Nov 20 '18 at 3:13