Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php // кодировка обязательно UTF-8 без BOM
- $host="localhost";
- $user="mysql";
- $pass="mysql"; //установленный вами пароль
- $db_name="test";
- $link=mysql_connect($host,$user,$pass);
- mysql_select_db($db_name,$link) or die("Нет соединения с БД".mysql_error());
- $mail = ($_POST["email"]) ? htmlspecialchars($_POST["email"]) : "";
- $pass = ($_POST["pass"]) ? htmlspecialchars($_POST["pass"]) : "";
- $query = mysql_query("SELECT * FROM `Таблица` WHERE `email` = '$mail'");
- if(mysql_num_rows($query)!=0) {
- exit("E-Mail <b>$mail</b> doouble.");
- }
- if (!empty($mail)) {
- mysql_query("INSERT INTO `Таблица` (`email`, `pass`) VALUES ('$mail','$pass')");
- echo "<p>good.</p>";
- }
- $query = mysql_query("SELECT * FROM `Таблица`");
- $rows = mysql_num_rows($query);
- ?>
- <!doctype html>
- <html lang="ru">
- <head>
- <title>admin</title>
- </head>
- <body>
- <table>
- <form action="1.php" method="post">
- </form>
- </table>
- <p>In base:</p>
- <? echo $rows; ?>
- <span> lines</span>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement