<?php
include("config.php");
//Get the name of the input type submit
if(ISSET($_POST['sign_up'])) {
    $username = trim($_POST['user']);
    $password = trim($_POST['pass']);
    $gender=$_POST['gen'];
    $firstname =($_POST['first']);
    $lastname = trim($_POST['last']);
    $y=$_POST['y'];
    $m=$_POST['m'];
    $d=$_POST['d'];
    $dob=$y."-".$m."-".$d;
    $imgpath=$_FILES['file']['name'];
    $imgFile = $_FILES['file']['name'];
    $tmp_dir = $_FILES['file']['tmp_name'];
    $imgExt = strtolower(pathinfo($imgFile,PATHINFO_EXTENSION));
   $valid_extensions = array('jpeg', 'jpg', 'png', 'gif');
   $userpic = rand(1000,1000000).".".$imgExt;
    if(!empty($username) && !empty($password)) {
    $sql = mysql_query("SELECT * FROM users WHERE user_name = '$username'") or die(mysql_error());
    if(mysql_num_rows($sql) > 0) {
    $msg_error = "Username already registered!";
} else {
    if(in_array($imgExt, $valid_extensions)){
    mysql_query("INSERT INTO users values('','$username','".MD5($password)."', '$gender', '$dob', '$imgpath', 'guest', '$firstname', '$lastname')") or die(mysql_error());
    $uuid=mysql_query("SELECT * FROM users");
     while ($puid=mysql_fetch_array($uuid)){
        $pid = $puid['user_id'];

$_SESSION['sname']=$_POST['user'];
    $msg_success = "You are now registered!";
    }
    else{
        $msg_error = "Invalid image!";
    }
}
}else{
    $msg_error = "All fields are required!";
}
}
?>