Code: Select all
tags when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
i am using the following code to insert new user into my db file:Code: Select all
function sanitize($variable){
$variable = str_replace("",";",$variable);
if(!get_magic_quotes_gpc()){
$variable = addslashes($variable);
}
return $variable;
}
function checkPassword($password1,$password2,$minPasswordLength){
$result =0;
if(strlen($password1) >= $minPasswordLength){
if($password1 == $password2){
$result = $password1;
}
}
return $result;
}
mysql_select_db($database_slovakvideo, $slovakvideo);
$query_rsChannels = "SELECT tblchannels.videoSourceID, tblchannels.stationName FROM tblchannels WHERE tblchannels.stationActive = '1' ORDER BY tblchannels.stationName DESC";
$rsChannels = mysql_query($query_rsChannels, $slovakvideo) or die(mysql_error());
$row_rsChannels = mysql_fetch_assoc($rsChannels);
$totalRows_rsChannels = mysql_num_rows($rsChannels);
// PHPLS10 - Check for Unique Username and Insert - Part 2
if($HTTP_POST_VARS['action'] == "check"){
$minPasswordLength = 6;
$pPassword1 = sanitize($HTTP_POST_VARS['password']);
$pPassword2 = sanitize($HTTP_POST_VARS['passConfirm']);
$pUsername = sanitize($HTTP_POST_VARS['userid']);
$pPassword = checkPassword($pPassword1, $pPassword2, $minPasswordLength);
if((strlen($pUsername)>0) && ($pPassword !== 0)){
$rsCheckSQL = "SELECT userid FROM users WHERE userid='" . $pUsername . "'";
mysql_select_db($database_slovakvideo, $slovakvideo);
$rsCheck = mysql_query($rsCheckSQL, $slovakvideo) or die(mysql_error());
$totalRows_rsCheck = mysql_num_rows($rsCheck);
if($totalRows_rsCheck < 1){
$rsCheckSQL = "INSERT INTO users (userid, PASSWORD) VALUES ('" . $pUsername . "',MD5('" . $pPassword . "'))";
$rsCheck = mysql_query($rsCheckSQL, $slovakvideo) or die(mysql_error());
session_start();
session_register("userid");
$HTTP_SESSION_VARS['userid'] = $pUsername;
header("Location: newUserDetails.php");
} else {
mysql_free_result($rsCheck);
$phplsMessage = "User name already exists.";
}
}else{
$phplsMessage = "Password has to be at least 6 characters.";
}
}Bech100 | Please use
Code: Select all
tags when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]