Click here to Skip to main content
15,886,873 members
Home / Discussions / Web Development
   

Web Development

 
QuestionBest alternative for web automation in Internet Explorer Pin
IT - Researcher24-May-16 23:42
IT - Researcher24-May-16 23:42 
QuestionAngularJS controller is not firing, in ASP.NET MVC and AngularJS application Pin
indian14323-May-16 22:17
indian14323-May-16 22:17 
AnswerRe: AngularJS controller is not firing, in ASP.NET MVC and AngularJS application Pin
Nathan Minier24-May-16 1:28
professionalNathan Minier24-May-16 1:28 
GeneralRe: AngularJS controller is not firing, in ASP.NET MVC and AngularJS application Pin
indian14324-May-16 7:05
indian14324-May-16 7:05 
GeneralRe: AngularJS controller is not firing, in ASP.NET MVC and AngularJS application Pin
Nathan Minier25-May-16 2:39
professionalNathan Minier25-May-16 2:39 
QuestionAdvise needed to start an open sourced web project Pin
Member 1253861822-May-16 1:12
Member 1253861822-May-16 1:12 
AnswerRe: Advise needed to start an open sourced web project Pin
Nathan Minier23-May-16 1:40
professionalNathan Minier23-May-16 1:40 
QuestionHelp with SQLSTATE[HY000] Please Pin
Jassim Rahma18-May-16 2:42
Jassim Rahma18-May-16 2:42 
Hi,

Why I am getting:
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:
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:
SQL
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,
Jassim[^]

Technology News @ www.JassimRahma.com

AnswerRe: Help with SQLSTATE[HY000] Please Pin
Richard Deeming18-May-16 5:12
mveRichard Deeming18-May-16 5:12 
GeneralRe: Help with SQLSTATE[HY000] Please Pin
Jassim Rahma18-May-16 7:35
Jassim Rahma18-May-16 7:35 
QuestionProblem installing curl for Apache and PHP (Required to use moodle) Pin
adkPrasanna16-May-16 22:41
adkPrasanna16-May-16 22:41 
SuggestionRe: Problem installing curl for Apache and PHP (Required to use moodle) Pin
Richard Deeming17-May-16 1:24
mveRichard Deeming17-May-16 1:24 
AnswerRe: Problem installing curl for Apache and PHP (Required to use moodle) Pin
Richard MacCutchan17-May-16 2:56
mveRichard MacCutchan17-May-16 2:56 
GeneralRe: Problem installing curl for Apache and PHP (Required to use moodle) Pin
adkPrasanna17-May-16 6:08
adkPrasanna17-May-16 6:08 
QuestionTab Control Pin
Ali Al Omairi(Abu AlHassan)16-May-16 21:36
professionalAli Al Omairi(Abu AlHassan)16-May-16 21:36 
AnswerRe: Tab Control Pin
Richard Deeming17-May-16 1:23
mveRichard Deeming17-May-16 1:23 
GeneralRe: Tab Control Pin
Ali Al Omairi(Abu AlHassan)17-May-16 5:23
professionalAli Al Omairi(Abu AlHassan)17-May-16 5:23 
GeneralRe: Tab Control Pin
Richard Deeming17-May-16 5:39
mveRichard Deeming17-May-16 5:39 
GeneralRe: Tab Control Pin
Ali Al Omairi(Abu AlHassan)17-May-16 6:17
professionalAli Al Omairi(Abu AlHassan)17-May-16 6:17 
GeneralRe: Tab Control Pin
Richard Deeming17-May-16 6:52
mveRichard Deeming17-May-16 6:52 
Questionfacebook sharing Pin
Priyanka Kolambe16-May-16 21:01
Priyanka Kolambe16-May-16 21:01 
Questionglassfish alternatedocroot error 404 Pin
V.12-May-16 23:28
professionalV.12-May-16 23:28 
QuestionHow To Get Markup Of Page Using Chrome DevTools Pin
MadDashCoder12-May-16 0:05
MadDashCoder12-May-16 0:05 
AnswerRe: How To Get Markup Of Page Using Chrome DevTools Pin
Ali Al Omairi(Abu AlHassan)16-May-16 21:56
professionalAli Al Omairi(Abu AlHassan)16-May-16 21:56 
QuestionBest method to automate website filling in Google Chrome Pin
srikrishnathanthri9-May-16 2:07
srikrishnathanthri9-May-16 2:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.