Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
conn.php:CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
reg.php:<?php
$user = "";
$pass = "";
$db = "";
$host = "localhost";
$connection = mysql_connect($host, $user, $pass) or die("Error");
$db = mysql_select_db($db,$connection)or die("Грешка!");
$chars="set character set cp1251";
mysql_query($chars);
?>
login.php:<form action="" method="POST">
<table align="center">
<tr><td><font size="1">Потребител:*</font></td>
<td><input type="text" maxlength="25" name="username"></td></tr>
<tr><td><font size="1">Парола:*</font></td>
<td><input type="text" maxlength="25" name="password"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="button" value="Регистрация"></td></tr>
</table>
</form>
<?
include"conn.php";
if($_POST['button']){
$username = htmlspecialchars($_POST['username']);
$password= htmlspecialchars($_POST['password']);
if (empty($username) or empty($password))
{ echo "Попълнете и двете полета!";
}
else {
$send = mysql_query("INSERT INTO `users`(`id`,`username`,`password`) VALUES ('NULL','$username','$password');") or die (mysql_error());
echo "Регистрирахте се успешно!";
}
}
?>
<form action="" method="POST">
<table align="center">
<tr><td><font size="1">Потребител:</font></td>
<td><input type="text" maxlength="25" name="username"></td></tr>
<tr><td><font size="1">Парола:</font></td>
<td><input type="text" maxlength="25" name="password"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="button" value="Вход"></td></tr>
</table>
</form>
<?
include "conn.php";
$userche=$_POST['username'];
$sql=mysql_query("SELECT username,password from users where username='$userche'") or die(mysql_error());
while($row=mysql_fetch_array($sql)){
$password=$row['password'];
if($password==$_POST[password]){
echo "tuk ne6ta za lognat"; }
else { echo "gre6en pass"; }
}
?>
DeathGuard_ каза:Драснах ти една възможно най-проста
SQL:
conn.php:CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
reg.php:<?php
$user = "";
$pass = "";
$db = "";
$host = "localhost";
$connection = mysql_connect($host, $user, $pass) or die("Error");
$db = mysql_select_db($db,$connection)or die("Грешка!");
$chars="set character set cp1251";
mysql_query($chars);
?>
login.php:<form action="" method="POST">
<table align="center">
<tr><td><font size="1">Потребител:*</font></td>
<td><input type="text" maxlength="25" name="username"></td></tr>
<tr><td><font size="1">Парола:*</font></td>
<td><input type="text" maxlength="25" name="password"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="button" value="Регистрация"></td></tr>
</table>
</form>
<?
include"conn.php";
if($_POST['button']){
$username = htmlspecialchars($_POST['username']);
$password= htmlspecialchars($_POST['password']);
if (empty($username) or empty($password))
{ echo "Попълнете и двете полета!";
}
else {
$send = mysql_query("INSERT INTO `users`(`id`,`username`,`password`) VALUES ('NULL','$username','$password');") or die (mysql_error());
echo "Регистрирахте се успешно!";
}
}
?><form action="" method="POST">
<table align="center">
<tr><td><font size="1">Потребител:</font></td>
<td><input type="text" maxlength="25" name="username"></td></tr>
<tr><td><font size="1">Парола:</font></td>
<td><input type="text" maxlength="25" name="password"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="button" value="Вход"></td></tr>
</table>
</form>
<?
include "conn.php";
$userche=$_POST['username'];
$sql=mysql_query("SELECT username,password from users where username='$userche'") or die(mysql_error());
while($row=mysql_fetch_array($sql)){
$password=$row['password'];
if($password==$_POST[password]){
echo "tuk ne6ta za lognat"; }
else { echo "gre6en pass"; }
}
?>