register.php
<?php
if(!$_POST['submit']) {
?>
<script src="chekname.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<hr color='black' width='300' align='center' />
<form action="?a=register" method="POST">
<table align="center">
<tr><td>Потребителско име:</td><td><input type="text" maxlength="12" style="background-color: #bbbbbb;" name="name" id="txt1" onblur="showHint(this.value)">
<span id="txtHint"></span> </td></tr>
<tr><td>Парола:</td><td><input type="password" style="background-color: #bbbbbb;" name="pass1"></td></tr>
<tr><td>Отново:</td><td><input type="password" style="background-color: #bbbbbb;" name="pass2"></td></tr>
<tr><td>Емайл:</td><td><input type="text" style="background-color: #bbbbbb;" name="mail"></td></tr>
<tr><td>Пол:</td><td><input type="radio" checked name="sex" value="male">Мъж <input type="radio" name="sex" value="female">Жена</td></tr>
<tr><td></td><td><input value="Регистрация" class="field-submit" type="submit" name="submit"></td></tr>
</table>
</form>
<? } ?>
<?php
if(isset($_POST['submit']) && $_SESSION['name'] == NULL)
{
if($_POST['name'] == NULL || $_POST['pass1'] == NULL || $_POST['pass2'] == NULL || $_POST['mail'] == NULL)
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Този емайл е зает.</span></td>
</table>';
}
elseif($_POST['pass1'] != $_POST['pass2'])
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Паролите не си съвпадат.</span></td>
</table>';
}
else
{
$name = htmlspecialchars($_POST['name']);
$pass = md5($_POST['pass1']);
$mail = htmlspecialchars($_POST['mail']);
$sex = htmlspecialchars($_POST['sex']);
$insert = "INSERT INTO `users` (`name` , `pass` , `mail` , `sex`) VALUES ('$name', '$pass', '$mail', '$sex')";
$select_users = mysql_query('SELECT * FROM users WHERE mail="'.$mail.'"');
if(mysql_num_rows($select_users)==0)
{
if(mysql_query($insert))
{
echo '
<table class="active1-reg" width="36%" align="center">
<td class="active-reg" rowspan="4" width="5%" align="center">
</td>
<td width="50%" align="center">Успешно се регистрирахте може да влезете със потребител и парола</span></td>
</table>';
}
else
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Регистрацията не е успешна.</span></td>
</table>';
}
}
else
{
echo '
<table class="error1-reg" width="46%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Има потребител с този имейл адрес.</span></td>
</table>';
}
}
}
?>
CREATE TABLE IF NOT EXISTS `msg` (
`id` int(11) NOT NULL auto_increment,
`to` varchar(11) collate cp1251_bulgarian_ci NOT NULL,
`name` varchar(11) character set latin1 NOT NULL,
`text` longtext character set latin1 NOT NULL,
`by` varchar(11) collate cp1251_bulgarian_ci NOT NULL,
`read` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=18 ;
<?php
if(!$_POST['submit']) {
?>
<script src="chekname.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<hr color='black' width='300' align='center' />
<form action="?a=register" method="POST">
<table align="center">
<tr><td>Потребителско име:</td><td><input type="text" maxlength="12" style="background-color: #bbbbbb;" name="name" id="txt1" onblur="showHint(this.value)">
<span id="txtHint"></span> </td></tr>
<tr><td>Парола:</td><td><input type="password" style="background-color: #bbbbbb;" name="pass1"></td></tr>
<tr><td>Отново:</td><td><input type="password" style="background-color: #bbbbbb;" name="pass2"></td></tr>
<tr><td>Емайл:</td><td><input type="text" style="background-color: #bbbbbb;" name="mail"></td></tr>
<tr><td>Пол:</td><td><input type="radio" checked name="sex" value="male">Мъж <input type="radio" name="sex" value="female">Жена</td></tr>
<tr><td></td><td><input value="Регистрация" class="field-submit" type="submit" name="submit"></td></tr>
</table>
</form>
<? } ?>
<?php
if(isset($_POST['submit']) && $_SESSION['name'] == NULL)
{
if($_POST['name'] == NULL || $_POST['pass1'] == NULL || $_POST['pass2'] == NULL || $_POST['mail'] == NULL)
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Този емайл е зает.</span></td>
</table>';
}
elseif($_POST['pass1'] != $_POST['pass2'])
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Паролите не си съвпадат.</span></td>
</table>';
}
else
{
$name = htmlspecialchars($_POST['name']);
$pass = md5($_POST['pass1']);
$mail = htmlspecialchars($_POST['mail']);
$sex = htmlspecialchars($_POST['sex']);
$insert = "INSERT INTO `users` (`name` , `pass` , `mail` , `sex`) VALUES ('$name', '$pass', '$mail', '$sex')";
$select_users = mysql_query('SELECT * FROM users WHERE mail="'.$mail.'"');
if(mysql_num_rows($select_users)==0)
{
if(mysql_query($insert))
{
echo '
<table class="active1-reg" width="36%" align="center">
<td class="active-reg" rowspan="4" width="5%" align="center">
</td>
<td width="50%" align="center">Успешно се регистрирахте може да влезете със потребител и парола</span></td>
</table>';
}
else
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Регистрацията не е успешна.</span></td>
</table>';
}
}
else
{
echo '
<table class="error1-reg" width="46%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Има потребител с този имейл адрес.</span></td>
</table>';
}
}
}
?>
CREATE TABLE IF NOT EXISTS `msg` (
`id` int(11) NOT NULL auto_increment,
`to` varchar(11) collate cp1251_bulgarian_ci NOT NULL,
`name` varchar(11) character set latin1 NOT NULL,
`text` longtext character set latin1 NOT NULL,
`by` varchar(11) collate cp1251_bulgarian_ci NOT NULL,
`read` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=18 ;