أكواد PHP مهمة ...1

"From "appointment and blood bank website

For login

<?php

require("admin/config/config.php");

$email_err = $pass_err = "";

if (isset($_POST['login'])) {

    $email = $pass = "";

    if (empty($_POST['email'])) {

        $email_err = "Please enter email";

    } else {

        $email = trim(mysqli_real_escape_string($conn, $_POST['email']));

    }

    if (empty($_POST['password'])) {

        $pass_err = "Please enter Password";

    } else {

        $pass = md5(trim(mysqli_real_escape_string($conn, $_POST['password'])));

    }

    if (!empty($email) && !empty($pass)) {

        $selectQuery = "SELECT donor_email AND donor_password FROM donor where donor_email = '{$email}' AND donor_password='{$pass}'";

        $result =  mysqli_query($conn, $selectQuery) or die("Querry Unsuccessfull" . mysqli_error($conn));

        if (mysqli_num_rows($result) > 0) {

            $_SESSION['donor_email'] = $email;

            header("Location: {$path}/donorAccount.php");

        } else {

?><script>

                alert("Your account dose not exists! Please register yourself");

            </script><?php

                    }

                } else {

                }

            }

      ?>

---------------------------------

For register new account:

<?php

include("admin/config/config.php");

$donor_name_err = $donor_contact_err = $donor_email_err = $donor_age_err = $donor_gender_err = $donor_blood_err = $donor_city_err = $donor_pic_err = $donor_pass_err = $donor_cpass_err = $email_Exists =  $match_pass_err = "";

if (isset($_POST['register'])) {

  $donor_name = $donor_contact = $donor_email = $donor_age = $donor_gender = $donor_blood = $donor_city = $donor_pic = $donor_pass = $donor_cpass = "";

  if (empty($_POST['name'])) {

    $donor_name_err = "* Name is required";

  } else {

    $donor_name = mysqli_real_escape_string($conn, $_POST['name']);

  }

  if (empty($_POST['contact'])) {

    $donor_contact_err = "* Contact is required";

  } else {

    $donor_contact = mysqli_real_escape_string($conn, $_POST['contact']);

  }

  if (empty($_POST['age'])) {

    $donor_age_err = "* age is required";

  } else {

    $donor_age = mysqli_real_escape_string($conn, $_POST['age']);

  }

  if (empty($_POST['email'])) {

    $donor_email_err = "* email is required";

  } else {

    $donor_email = mysqli_real_escape_string($conn, $_POST['email']);

    if (!filter_var($donor_email, FILTER_VALIDATE_EMAIL)) {

      $donor_email_err = "Email is not valid";

    }

  }

  if (empty($_POST['gender'])) {

  } else {

    $donor_gender = $_POST['gender'];

  }

  if (empty($_POST['blood'])) {

    $donor_blood_err = "* blood type is required";

  } else {

    $donor_blood = $_POST['blood'];

  }

  if (empty($_POST['city'])) {

    $donor_city_err = "* city is required";

  } else {

    $donor_city = mysqli_real_escape_string($conn, $_POST['city']);

  }

  if (empty($_POST['password'])) {

    $donor_pass_err = "* password is required";

  } else {

    $donor_pass = md5(trim(mysqli_real_escape_string($conn, $_POST['password'])));

  }

  if (empty($_POST['cpassword'])) {

    $donor_cpass_err = "* password confirmation is required";

  } else {

    $donor_cpass = md5(trim(mysqli_real_escape_string($conn, $_POST['cpassword'])));

  }

  if ($donor_pass == $donor_cpass && !empty($donor_name) && !empty($donor_contact) && !empty($donor_email) && !empty($donor_age) && !empty($donor_city) && !empty($donor_blood) && !empty($donor_pass) && !empty($donor_cpass)) {

    $checkEmailExists = "SELECT donor_email from donor WHERE donor_email = '{$donor_email}'";

    $resultExists = mysqli_query($conn, $checkEmailExists) or die("Query un-successfull" . mysqli_error($conn));

    if (mysqli_num_rows($resultExists) > 0) {

?><script>

        alert("Donor already exists with this username or email");

      </script><?php

              } else {

                if (isset($_FILES['file'])) {

                  $donor_pic = $_FILES['file']['name'];

                  $file_type = $_FILES['file']['type'];

                  $file_size = $_FILES['file']['size'];

                  $file_tem_loc = $_FILES['file']['tmp_name'];

                  $file_store = "assets/images/" . $donor_pic;

                  if (move_uploaded_file($file_tem_loc, $file_store)) {

                    $insertQuery = "INSERT INTO `donor`(`donor_name`, `donor_contact`, `donor_email`, `donor_age`, `donor_gender`, `donor_blood`, `donor_city`, `donor_pic`, `donor_password`, `donor_status`) 

VALUES ('{$donor_name}','{$donor_contact}','{$donor_email}',{$donor_age},'{$donor_gender}','{$donor_blood}','{$donor_city}','{$donor_pic}','{$donor_pass}',1)";

                    if (mysqli_query($conn, $insertQuery) or die("Querry Unsuccessfull") . mysqli_error($conn)) {

                      $_SESSION['success'] = '<div style="font-size:18px" class="alert alert-success alert-dismissible fade show"><a style="text-decuration:none !important;" type="button" class="close" data-dismiss="alert">&times;</a>

                     <strong>Success!</strong> Account Created successfully."</div>';

                      header("Location: {$path}/login.php");

                    } else {

                      echo "Query unsuccessfull";

                    }

                  }

                } else {

                  $donor_pic_err = "Please upload your profile picture";

                }

              }

            } else {

              if ($donor_pass != $donor_cpass) {

                $match_pass_err = "* password did not match";

              }

            }

          }

                ?>

------------------

create connection: config

<?php

$conn =mysqli_connect("localhost","root","","bloodr");

$path = "http://localhost/bloodr";

session_start();

?>