Register.php
<?php
include ' functions.php ' ;
if (!$_SESSION[ ' is_logged ' ]==true)
{
if ($_POST[ ' hidden ' ]==1)
{
$login= trim($_POST[ ' login ' ]);
$pass= trim($_POST[ ' pass ' ]);
$pass2= trim($_POST[ ' pass2 ' ]);
$mail= trim($_POST[ ' mail ' ]);
$name= trim($_POST[ ' login ' ]);
if(strlen($login)<4)
{
$error_array[ ' login ' ]=true;
}
if(strlen($pass)<4)
{
$error_array[ ' pass ' ]=true;
}
if(!$pass==$pass2)
{
$error_array[ ' pass2 ' ]=true;
}
if(!eregi( " ^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\\.[a-z]{2,4}$ " , $mail)) {
$error_array[ ' mail ' ]=true;
}
if (!ereg( " ^[a-zA-Z]{3,16}$ " ,$name)) {
$error_array[ ' name ' ]=true;
}
if (!count($error_array)>0)
{
db_connect();
$sql= ' SELECT COUNT (*) as cnt FROM users WHERE login= " ' .addslashes($login). ' " OR email= " ' .addslashes($mail). ' " ' ;
$result= mysql_query($sql);
$row= mysql_fetch_assoc($result);
if($row[ ' cnt ' ]==0)
{
mysql_query( ' INSERT INTO users (login.pass.real_name.email.date_registerd)
VALUES ( " ' .addslashes($login). ' " , " ' .md5($pass). ' " , " ' .addslashes($name). ' " , " ' .addslashes($mail). ' " , ' .time(). ' ) ' );
if(mysql_error())
{
echo mysql_error(). '
' ;
echo ' <h1 style= " color:red " ;>Troubles with DB connecting</h1> ' ;
}
else
{
header ( ' Location: index.php ' );
exit;
}
}
else
{
$error_array[ ' sql ' ]= ' *User or Email ' ;
}
}
}
/* if($error_array[ ' login ' ]) { echo ' * ' ; }
if($error_array[ ' pass ' ]) { echo ' * ' ; }
if($error_array[ ' pass2 ' ]) { echo ' * ' ; }
if($error_array[ ' mail ' ]) { echo ' * ' ; }
if($error_array[ ' name ' ]) { echo ' * ' ; } */
head( ' Registration ' );
if($error_array[ ' sql ' ])
{
echo $error_array[ ' sql ' ];
}
?>
<form action= " register.php " method= " POST " >
User :<input type= " text " name= " login " > <?php if($error_array[ ' login ' ]) { echo ' * ' ; } ?>
Password :<input type= " text " name= " pass " > <?php if($error_array[ ' pass ' ]) { echo ' * ' ; } ?>
Password 2:<input type= " text " name= " pass2 " > <?php if($error_array[ ' pass2 ' ]) { echo ' * ' ; } ?>
Email :<input type= " text " name= " mail " > <?php if($error_array[ ' mail ' ]) { echo ' * ' ; } ?>
Name :<input type= " text " name= " name " > <?php if($error_array[ ' name ' ]) { echo ' * ' ; } ?>
<input type= " hidden " name= " hidden " value= " 1 " >
<input type= " submit " name= " submit " value= " Sing up " >
</form>
<?php
}
else {
header ( ' Location: index.php ' );
exit;
}
footer();
?>
Functions.php
<?php
session_start();
function head($title) {
?>
<html>
<head>
<meta http-equiv= " Content-Type " content= " text/html; charset-UTF-8 " >
<title> <?php echo $title; ?> </title>
</head>
<body>
<div id= " top_menu " >
<?php
if ($_SESSION[ ' is_logged ' ]===true)
{
}
else
{
echo ' <a href= " register.php " > Регистрирай се! </a> ' ;
}
?>
</div>
<?php
}
function footer() {
echo ' </body>
</html> ' ;
}
function db_connect() {
mysql_connect ( ' localhost ' , ' root ' , ' parola ' ) or die ( ' Грешка при свързване с ДБ! ' ) ;
mysql_select_db ( ' mcf ' );
}
?>
' Вмъкнах ' един юзър, после се опитах да се регна със същите имейл и п. име, но не ми изписа грешка (относно това), което ми говори, че проблема има оше от SQL заявките.
