Undefined index: securityCode in C:\xampp\htdocs\aljabery\signup1.php on line 36
Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in C:\xampp\htdocs\aljabery\signup1.php:37 Stack trace: #0 C:\xampp\htdocs\aljabery\signup1.php(37): PDOStatement->execute() #1 {main} thrown in C:\xampp\htdocs\aljabery\signup1.php on line 37
signup.php
<?php
if(isset($_POST['signup'])){
require "connect.php";
$checkEmail = $database->prepare("SELECT * FROM users WHERE email = :email");
$checkEmail->bindParam(':email',$Email);
$email = $_POST['Email'];
$checkEmail->execute();
// if found email in database
if ($checkEmail->rowCount()>0){
echo "<script> alert('الحساب مستخدم من قبل يرجى تسجيل الدخول'); window.location.assign('signin.php');</script>";
}
// if not found email
else
{
$addData =$database->prepare("INSERT INTO users(f_name,l_name,email,pass,birthday,sex)
VALUES(:fnam,:lnam,:email,:pass,:birth,:gender)");
$addData->bindParam(':f_name',$fnam);
$addData->bindParam(':l_name',$lnam);
$checkEmail->bindParam(':email',$Email);
$addData->bindParam(':pass',$pass);
$addData->bindParam(':birthday',$birth);
$addData->bindParam(':sex',$gender);
$securityCode = md5(date("h:i:s"));
$addData->bindParam(':Security_Code',$securityCode);
$fnam = $_POST['fnam'];
$lnam = $_POST['lnam'];
$email = $_POST['Email'];
$pass = $_POST['pass'];
$birth = $_POST['birth'];
$gender = $_POST['gender'];
$Security_Code =$_POST['securityCode'];
if($addData->execute()){
echo "<center><h1>.. أهلاً وسهلاً بك في موقع معهد الجابري .. تم انشاء الحساب بنجاح .. قم بتسجيل الدخول </h1>.
<h2><a href='signin.php'>** تسجيل الدخول **</a></h2></center>";
require_once "mailer/mail.php";
$mail ->addAddress($email);
$mail ->Subject = "رمز التحقق من البريد الالكتروني";
$mail ->Body = '<h1>شكرا لتسجيلك في موقعنا </h1>'."<div>رابط التحقق من الحساب"."</div>".
"<a href ='http://localhost/aljabery/active.php?code=".$securitycode."'>"
."http://localhost/aljabery/active.php"."?code=".$securitycode."</a>";
$mail ->setFrom("albbassy881@gmail.com","Aljabery");
$mail-> send();
}else{
echo "حدث خطأ غير متوقع";
}
}
}
?>
