Hi,
I have a memberpersonalinfo php page showing the member personal info and I am using update_member_personal_information.php to post the data and save the member information but when the user clicks on the btnSave in the memberpersonalinfo.php it’s doing nothing with no error message.
here is my update_member_personal_information.php:
[php]<?php
include ‘includes/php_header.php’;
$member_title = $_POST['cboTitle'];
$first_name = $_POST['txtFirstName'];
$middle_name = $_POST['txtMiddleName'];
$last_name = $_POST['txtLastName'];
$date_of_birth = $_POST['dateBirthday'];
$gender = $_POST['cboGender'];
$marital_status = $_POST['cboMaritalStatus'];
$nationality = $_POST['cboNationality'];
$home_country = $_POST['cboHomeCountry'];
$current_country = $_POST['cboCurrentCountry'];
$home_phone = $_POST['txtHomePhone'];
$mobile_phone = $_POST['txtMobilePhone'];
try
{
include 'includes/connect2db.php';
$mysql_command = "CALL sp_update_member_personal_information(:param_member_guid, :param_member_title, :param_first_name, :param_middle_name, :param_last_name, :param_date_of_birth, :param_gender, :param_marital_status, :param_nationality, :param_home_country, :param_current_country, :param_home_phone, :param_mobile_phone)";
$mysql_query = $mysql_connection->prepare($mysql_command);
$mysql_query->bindParam(':param_member_guid', $_SESSION["member_guid"], PDO::PARAM_STR);
$mysql_query->bindParam(':param_member_title', $member_title, PDO::PARAM_INT);
$mysql_query->bindParam(':param_first_name', $first_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_middle_name', $middle_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_last_name', $last_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_date_of_birth', $date_of_birth, PDO::PARAM_STR);
$mysql_query->bindParam(':param_gender', $gender, PDO::PARAM_INT);
$mysql_query->bindParam(':param_marital_status', $marital_status, PDO::PARAM_INT);
$mysql_query->bindParam(':param_nationality', $nationality, PDO::PARAM_STR);
$mysql_query->bindParam(':param_home_country', $home_country, PDO::PARAM_STR);
$mysql_query->bindParam(':param_current_country', $current_country, PDO::PARAM_STR);
$mysql_query->bindParam(':param_home_phone', $home_phone, PDO::PARAM_STR);
$mysql_query->bindParam(':param_mobile_phone', $mobile_phone, PDO::PARAM_STR);
$mysql_query->execute();
exit(header("Location: memberhome.php"));
}
catch (PDOException $e)
{
echo 'PDO Exception Caught. ';
echo 'Error with the database: <br />';
echo 'SQL Query: ', $sql;
echo 'Error: ' . $e->getMessage();
return $e->getMessage();
}
include 'includes/php_footer.php';
?>
[/php]
and this my stored procedure DDL:
[code]CREATE DEFINER=root@localhost PROCEDURE sp_update_member_personal_information(IN param_member_guid varchar(255), IN param_member_title int, IN param_first_name varchar(255), IN param_middle_name varchar(255), IN param_last_name varchar(255), IN param_date_of_birth date, IN param_gender int, IN param_marital_status int, IN param_nationality varchar(255), IN param_home_country varchar(255), IN param_current_country varchar(255), IN param_home_phone varchar(255), IN param_mobile_phone varchar(255))
BEGIN
UPDATE members SET
member_title = param_member_title,
first_name = param_first_name,
middle_name = param_middle_name,
last_name = param_last_name,
date_of_birth = param_date_of_birth,
gender = param_gender,
marital_status1 = param_marital_status,
nationality = param_nationality,
home_country = param_home_country,
current_country = param_current_country,
home_phone = param_home_phone,
mobile_phone = param_mobile_phone
WHERE member_guid = param_member_guid;
END
[/code]
and here is my form post:
<form name="form1" method="post" action="update_member_personal_information.php">and button:
[code]Save
[/code]
please help…