$page_id=1; // public page?>
include ("security.php") ?>
if ($login==1)
{
header('Location:profile.php');
}
function getVer($cc)
{
while ($key = key($_POST)) {
if ($key==$cc)
{return 1;}
next($_POST);
}
return 0;
}
function getDBConnection ()
{
include("_db.php"); //contains the given DB setup $db, $server, $user, $pass
$conn = mysql_connect($server, $user, $pass);
if (!$conn) {
//echo "Connection to DB was not possible!";
end;
}
if (!mysql_select_db($db, $conn)) {
//echo "No DB with that name seems to exist at the server!";
end;
}
return $conn;
}
$user_nm_err="";
$action_id=0;
$user_nm="";
$u_email="";
$u_site="http://";
if (getVer('hd_action')==1)
{
$action_id=$_POST['hd_action'];
$user_nm=$_POST['tx_uname'];
$u_pwd=$_POST['tx_pswd'];
$u_email=$_POST['tx_email'];
$u_site=$_POST['tx_site'];
$invalid_err="* Invalid";
}
if ($action_id==10)
{
//check user_name
$valid=1;
if ($user_nm=="")
{$valid=0;
$user_nm_err=$invalid_err;
}
//-- user name validation
$conn = getDBConnection();
$sql = "select count(*) from btb_user where user_name = '$user_nm'";
$results = mysql_query($sql, $conn);
$row_c = mysql_fetch_array($results);
if ($row_c[0]>0)
{$valid=0;
$user_nm_err=" *
User Name is already used!";
}
mysql_free_result($results);
mysql_close($conn);
// echo ($valid);
if ($valid==1)
{
$sql="insert btb_user values(null,'".$user_nm."','".$u_pwd."',null,null,'".$u_email."',0,'".$u_site;
$sql=$sql."',1,now())" ;
$conn = getDBConnection();
$results = mysql_query($sql, $conn);
//setcookie("bband_id", $user_id);
setcookie("bannerband_login", 1);
setcookie("bband_user", $user_nm);
mysql_close($conn);
// echo($sql);
// header('Location:banner.php');
// exit();
?>
include ("./include/left_nav.php") ?> |