Web Development

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 7 for routine bizcards.sp_subscribe is not a variable or NEW pseudo-variable in BEFORE trigger' in /home/meskholdings/aromaexpress/web/send_subscription.php:27 Stack trace: #0 /home/meskholdings/aromaexpress/web/send_subscription.php(27): PDOStatement->execute() #1 {main} thrown in /home/meskholdings/aromaexpress/web/send_subscription.php on line 27

$mysql_query = $mysql_connection->prepare('CALL sp_subscribe(:param_first_name, :param_last_name, :param_birthday, :param_mobile, :param_email, :param_created_ip, :param_promotion_code)');

$mysql_query->bindParam(':param_first_name', $first_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_last_name', $last_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_birthday', $borthday, PDO::PARAM_STR);
$mysql_query->bindParam(':param_mobile', $mobile_number, PDO::PARAM_STR);
$mysql_query->bindParam(':param_email', $email_address, PDO::PARAM_STR);
$mysql_query->bindParam(':param_created_ip', $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR);
$mysql_query->bindParam(':param_promotion_code', $promotion_code, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT);

$mysql_query->execute();

$data = $promotion_code;