$target = GW_UPLOADPATH . $photo; move_uploaded_file($_FILES['photo']['tmp_name'], $target); $query = "SELECT * FROM allusers WHERE email = '{$email}'"; $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 0) { // The username is unique, so insert the data into the database $query = "INSERT INTO allusers (firstname, lastname, email, password, phone, photo, category) VALUES ('{$firstname}', '{$lastname}', '{$email}', SHA('{$password1}'), '{$phone}', '{$photo}', '{$category}')"; mysqli_query($dbc, $query); //echo "Query: ".$query; $query2 = "Select photo from allusers where email = '{$email}'"; $photoResult = mysqli_query($dbc, $query2); $photoRow = mysqli_fetch_array($photoResult); //Registration confirmation email $subject = "Registration confirmation-ClickArt"; $message = "Dear " . $firstname . ",<br/><br/>Welcome to the world of art.<br/><br/><u><b>Below are \n your registration information:</b></u><br/><br/>Email: " . $email . "<br/>Password: "******"<br/>Phone: " . $phone . "<br/>\n Category: " . $category . "<br/><br/><h4>Enjoy our services.</h4><br/><br/>\n <p>Copyright ©2015 IT354 Project."; $emailStatus = $ooClass->sendEmail($email, $subject, $message, $firstname); mysqli_close($dbc); //Confirm success with the user // $home_url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/registrationSuccess2.php'; // header('Location: ' . $home_url); // require_once('registrationSuccess.php'); $_SESSION['email'] = $email; ?> <script> window.location.assign("./registrationSuccess.php"); </script> <?php exit; } else { // An account already exists for this username, so display an error message echo '<p class="error">An account already exists for this username. Please use a different address.</p>';
// if (mysqli_num_rows($data) == 0) { // The username is unique, so insert the data into the database $query = "INSERT INTO paintings (paintingname, paintingtype, painter, publisher, category, price, availability, photo) VALUES ('{$paintingname}', '{$paintingtype}', '{$painter}', '{$publisher}', '{$category}', '{$price}', '{$availability}', '{$photo}')"; mysqli_query($dbc, $query); //echo "Query: ".$query; $tempEmail = $_SESSION['email']; $query2 = "Select * from allusers where email = '{$tempEmail}'"; $query2Result = mysqli_query($dbc, $query2); $row2 = mysqli_fetch_array($query2Result); //Registration confirmation email $subject = "Publication confirmation-ClickArt"; $message = "Dear " . $row2['firstname'] . ",<br/><br/>Welcome to the world of art.<br/><br/><u><b>Your painting has been published for sale on ClickArt.</b></u><br/>\n <br/>Thanks for your using our services.<br/>\n <p>Copyright ©2015 IT354 Project."; // echo '<script language="javascript">'; // echo 'alert("s1")'; // echo '</script>'; $emailStatus = $ooClass->sendEmail($tempEmail, $subject, $message, $row2['firstname']); mysqli_close($dbc); // Confirm success with the user $home_url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/artistSuccess.php'; header('Location: ' . $home_url); //echo "tempEmail ".$tempEmail; exit; // } //else { // An account already exists for this username, so display an error message echo '<p class="error">Some error found.</p>'; //$username = ""; //} } else { echo '<p class="error">You must enter all of the data</p>'; }