I am new to PHP and javascript and i am stuck while taking a tutorial on YouTube to start a project.
I uploaded my sign up page and when i tried to sign up it didn’t show me the sign up confirmation page i only got a signup_sucess under at the same page i was signing up.
please what can be wrong with this code? and how can i fix?
Java part!
function restrict(elem){
var tf = _(elem);
var rx = new RegExp;
if(elem == “email”){
rx = /[’ "]/gi;
} else if(elem == “username”){
rx = /[^a-z0-9]/gi;
}
tf.value = tf.value.replace(rx, “”);
}
function emptyElement(x){
_(x).innerHTML = “”;
}
function checkusername(){
var u = _(“username”).value;
if(u != “”){
_(“unamestatus”).innerHTML = ‘checking …’;
var ajax = ajaxObj(“POST”, “signup.php”);
ajax.onreadystatechange = function() {
if(ajaxReturn(ajax) == true) {
_(“unamestatus”).innerHTML = ajax.responseText;
}
}
ajax.send(“usernamecheck=”+u);
}
}
function signup(){
var u = _(“username”).value;
var e = _(“email”).value;
var p1 = _(“pass1”).value;
var p2 = _(“pass2”).value;
var c = _(“country”).value;
var g = _(“gender”).value;
var status = _(“status”);
if(u == “” || e == “” || p1 == “” || p2 == “” || c == “” || g == “”){
status.innerHTML = “Fill out all of the form data”;
} else if(p1 != p2){
status.innerHTML = “Your password fields do not match”;
} else if( _(“terms”).style.display == “none”){
status.innerHTML = “Please view the terms of use”;
} else {
_(“signupbtn”).style.display = “none”;
status.innerHTML = ‘please wait …’;
var ajax = ajaxObj(“POST”, “signup.php”);
ajax.onreadystatechange = function() {
if(ajaxReturn(ajax) == true){
if(ajax.responseText != “signup_success”) {
status.innerHTML = ajax.responseText;
_(“signupbtn”).style.display = “block”;
}
else {
window.scrollTo(0,0);
_(“signupform”).innerHTML = “OK “+u+”, check your email inbox and junk mail box at “+e+” in a moment to complete the sign up process by activating your account. You will not be able to do anything on the site until you successfully activate your account.”;
}
}
}
ajax.send(“u=”+u+"&e="+e+"&p="+p1+"&c="+c+"&g="+g);
}
}
HERE IS THE PHP part
<?php session_start(); // If user is logged in, header them away if(isset($_SESSION["username"])){ header("location: message.php?msg=NO to that weenis"); exit(); } ?> <?php // Ajax calls this NAME CHECK code to execute if(isset($_POST["usernamecheck"])){ include_once("php_includes/db_conx.php"); $username = preg_replace('#[^a-z0-9]#i', '', $_POST['usernamecheck']); $sql = "SELECT id FROM users WHERE username='$username' LIMIT 1"; $query = mysqli_query($db_conx, $sql); $uname_check = mysqli_num_rows($query); if (strlen($username) < 3 || strlen($username) > 16) { echo '3 - 16 characters please'; exit(); } if (is_numeric($username[0])) { echo 'Usernames must begin with a letter'; exit(); } if ($uname_check < 1) { echo '' . $username . ' is OK'; exit(); } else { echo '' . $username . ' is taken'; exit(); } } ?> <?php // Ajax calls this REGISTRATION code to execute if(isset($_POST["u"])){ // CONNECT TO THE DATABASE include_once("php_includes/db_conx.php"); // GATHER THE POSTED DATA INTO LOCAL VARIABLES $u = preg_replace('#[^a-z0-9]#i', '', $_POST['u']); $e = mysqli_real_escape_string($db_conx, $_POST['e']); $p = $_POST['p']; $g = preg_replace('#[^a-z]#', '', $_POST['g']); $c = preg_replace('#[^a-z ]#i', '', $_POST['c']); // GET USER IP ADDRESS $ip = preg_replace('#[^0-9.]#', '', getenv('REMOTE_ADDR')); // DUPLICATE DATA CHECKS FOR USERNAME AND EMAIL $sql = "SELECT id FROM users WHERE username='$u' LIMIT 1"; $query = mysqli_query($db_conx, $sql); $u_check = mysqli_num_rows($query); // ------------------------------------------- $sql = "SELECT id FROM users WHERE email='$e' LIMIT 1"; $query = mysqli_query($db_conx, $sql); $e_check = mysqli_num_rows($query); // FORM DATA ERROR HANDLING if($u == "" || $e == "" || $p == "" || $g == "" || $c == ""){ echo "The form submission is missing values."; exit(); } else if ($u_check > 0){ echo "The username you entered is alreay taken"; exit(); } else if ($e_check > 0){ echo "That email address is already in use in the system"; exit(); } else if (strlen($u) < 3 || strlen($u) > 16) { echo "Username must be between 3 and 16 characters"; exit(); } else if (is_numeric($u[0])) { echo 'Username cannot begin with a number'; exit(); } else { // END FORM DATA ERROR HANDLING // Begin Insertion of data into the database // Hash the password and apply your own mysterious unique salt $p_hash =md5($p); // Add user info into the database table for the main site table $sql = "INSERT INTO users (username, email, password, gender, country, ip, signup, lastlogin, notescheck) VALUES('$u','$e','$p_hash','$g','$c','$ip',now(),now(),now())"; $query = mysqli_query($db_conx, $sql); $uid = mysqli_insert_id($db_conx); // Establish their row in the useroptions table $sql = "INSERT INTO useroptions (id, username, background) VALUES ('$uid','$u','original')"; $query = mysqli_query($db_conx, $sql); // Create directory(folder) to hold each user's files(pics, MP3s, etc.) if (!file_exists("user/$u")) { mkdir("user/$u", 0755); } // Email the user their activation link $to = "$e"; $from = "your email"; $subject = ' Account Activation'; $message = 'yoursitename Message
website Account ActivationClick the link below to activate your account when ready:
Click here to activate your account now
Login after successful activation using your:
* E-mail Address: '.$e.'