Menu
Community /Pin to ProfileBookmark
@NogDogMay 18.2016 — #My first guess would be that the execute if returning false, so I'd start by checking there:
That's just quick-and-dirty debug code. You'd want something "nicer" that did not display application data to the user in the final code -- maybe put it in a try/catch block with the catch logging the exception and displaying a generic "sorry" message.@NogDogMay 19.2016 — #I assumed that's the syntax for calling the stored procedure -- but I'll admit I've never used it and did not check it in the manual. (I've only used stored functions in PostgreSQL, and only as triggered functions, not called from an application.) @NogDogMay 19.2016 — #
My first thought in that case would be that the parameters the code is passing to the function differ in some way than those you use when you test it manually, so you might want to take a closer look at those variables (var_export() is a good way to see exactly what an variable's value is, including type).
Help with SQLSTATE[HY000] Please
Hi,
Why I am getting:
[code=php]Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: General error’ in /home/meskholdings/mybluefile.com/change_password.php:22 Stack trace: #0 /home/meskholdings/mybluefile.com/change_password.php(22): PDOStatement->fetch(2) #1 {main} thrown in /home/meskholdings/mybluefile.com/change_password.php on line 22
For below code:
[code=php]$mysql_query = $mysql_connection->prepare(‘CALL sp_web_get_employee_by_password_guid(:param_guid, :param_code)’);
$mysql_query->bindParam(‘:param_guid’, $password_guid, PDO::PARAM_STR);
$mysql_query->bindParam(‘:param_code’, $activation_code, PDO::PARAM_STR);
$mysql_query->execute();
while($mysql_row = $mysql_query->fetch())
{
$full_name = $mysql_row[“official_name”];
$first_name = $mysql_row[“first_name”];
$email_address = $mysql_row[“email_address”];
}
This is my SELECT SQL:
[CODE]CREATE DEFINER=`root`@`%` PROCEDURE `sp_web_get_employee_by_password_guid`(IN param_guid varchar(255), IN param_code varchar(255))
BEGIN
DECLARE param_employee_id INT;
IF EXISTS (SELECT employees.employee_id FROM employees JOIN employee_contacts ON employee_contacts.employee_id = employees.employee_id JOIN contact_category ON contact_category.contact_category_id = employee_contacts.contact_category WHERE new_password_guid = param_guid AND new_password_code = param_code AND contact_category.contact_category_type = “EMAIL” AND employee_contacts.use_for_communication = TRUE) THEN
BEGIN
SET param_employee_id = (SELECT employees.employee_id FROM employees JOIN employee_contacts ON employee_contacts.employee_id = employees.employee_id JOIN contact_category ON contact_category.contact_category_id = employee_contacts.contact_category WHERE new_password_guid = param_guid AND new_password_code = param_code AND contact_category.contact_category_type = “EMAIL” AND employee_contacts.use_for_communication = TRUE);
SELECT employees.employee_number, employees.first_name, employees.official_name, employee_contacts.contact_details AS email_address
FROM employees
JOIN employee_contacts ON employee_contacts.employee_id = employees.employee_id
JOIN contact_category ON contact_category.contact_category_id = employee_contacts.contact_category
WHERE employees.employee_id = param_employee_id AND contact_category.contact_category_type = “EMAIL” AND employee_contacts.use_for_communication = TRUE;
END;
END IF;
END
Thanks,
[URL=”http://www.cakeboutiquebh.com”]Jassim
Sign in
to post a comment9 Comments(s) ↴
0
@NogDogMay 18.2016 — #My first guess would be that the execute if returning false, so I'd start by checking there:[code=php]
if($mysql_query->execute() == false) {
die('<pre>execute failed:'.PHP_EOL.print_r($mysql_query->errorInfo(),1).'</pre>');
}
[/code]That's just quick-and-dirty debug code. You'd want something "nicer" that did not display application data to the user in the final code -- maybe put it in a try/catch block with the catch logging the exception and displaying a generic "sorry" message.
0
@NogDogMay 19.2016 — #0
@NogDogMay 19.2016 — #Also when I run:
I get zero but when I run my stored procedure on the server I get one row.[/QUOTE]
My first thought in that case would be that the parameters the code is passing to the function differ in some way than those you use when you test it manually, so you might want to take a closer look at those variables (var_export() is a good way to see exactly what an variable's value is, including type).