Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $reff = createRandomreff();
- //Include database connection details
- require_once('db.php');
- //Array to store validation errors
- $errmsg_arr = array();
- //Validation error flag
- $errflag = false;
- //Connect to mysql server
- $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
- if(!$link) {
- die('Failed to connect to server: ' . mysql_error());
- }
- //Select database
- $db = mysql_select_db(DB_DATABASE);
- if(!$db) {
- die("Unable to select database");
- }
- //Function to sanitize values received from the form. Prevents SQL injection
- function clean($str) {
- $str = @trim($str);
- if(get_magic_quotes_gpc()) {
- $str = stripslashes($str);
- }
- return mysql_real_escape_string($str);
- }
- //Sanitize the POST values
- $fname = clean($_POST['fname']);
- $lname = clean($_POST['lname']);
- $username = clean($_POST['username']);
- $password = clean($_POST['password']);
- $cpassword = clean($_POST['cpassword']);
- //Input Validations
- if($fname == '') {
- $errmsg_arr[] = 'First name missing';
- $errflag = true;
- }
- if($lname == '') {
- $errmsg_arr[] = 'Last name missing';
- $errflag = true;
- }
- if($username == '') {
- $errmsg_arr[] = 'Username missing';
- $errflag = true;
- }
- if($password == '') {
- $errmsg_arr[] = 'Password missing';
- $errflag = true;
- }
- if($cpassword == '') {
- $errmsg_arr[] = 'Confirm password missing';
- $errflag = true;
- }
- if( strcmp($password, $cpassword) != 0 ) {
- $errmsg_arr[] = 'Passwords do not match';
- $errflag = true;
- }
- $earned = 0.10;
- //Check for duplicate login ID
- if($login != '') {
- $qry = "SELECT * FROM members WHERE username='$username'";
- $result = mysql_query($qry);
- if($result) {
- if(mysql_num_rows($result) > 0) {
- $errmsg_arr[] = 'Username already in use';
- $errflag = true;
- }
- @mysql_free_result($result);
- }
- else {
- die("Query failed");
- }
- }
- //If there are input validations, redirect back to the registration form
- if($errflag) {
- $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
- session_write_close();
- header("location: ../signup.php?m=$erorr_massage");
- exit();
- }
- $file_name = random(0000,9999);
- $ip = $_SERVER['REMOTE_ADDR'];
- //Create INSERT query
- $qry = "INSERT INTO members(ip, firstname, lastname, username, passwd, reff, file_name) VALUES('$ip','$fname','$lname','$username','".md5($_POST['password'])."','$reff','$file_name')";
- $result = @mysql_query($qry);
- //Check whether the query was successful or not
- if($result) {
- header("location: ../login.php?m=$reg_massage");
- exit();
- }else {
- die("Query failed");
- }
- $erorr_massage = 'there was some trouble registration you';
- $reg_massage = 'you have been register you may login now';
- function createRandomreff() {
- $chars = "abcdefghijkmnopqrstuvwxyz023456789";
- srand((double)microtime()*1000000);
- $i = 0;
- $pass = '' ;
- while ($i <= 7) {
- $num = rand() % 33;
- $tmp = substr($chars, $num, 1);
- $pass = $pass . $tmp;
- $i++;
- }
- return $pass;
- }
- // Usage
- $reff = createRandomreff();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement