$query = SELECT * FROM `tablename` WHERE username = 'input username'
if(!empty($query)) { اگر نام کاربری بود} else { اگر نبود }
<?php$hostname = 'localhost';$dbuser = '';$dbpass = '';$dbname = '';$mgroup = mysql_connect ($hostname, $dbuser, $dbpass);mysql_select_db ($dbname, $mgroup);mysql_query("SET CHARACTER SET utf8");mysql_query("SET names utf8");?>
<?php @session_start();
//تابع بررسی صحت کاربرfunction user_login ($username, $password) { $username = mysql_real_escape_string($username); // چون پسورد در پایگاه داده به صورت کد شده قرار دارد ما نیز ابتدا پسورد دریافتی را کد کرده با پسورد موجود در پایگاه داده بررسی میکنیم $password = md5($password); $result = mysql_query("SELECT * FROM userer WHERE username = '".$username."' AND password = '".$password."' LIMIT 1"); while ( $row_usere = mysql_fetch_array($result) ) { $rows = mysql_num_rows($result); if ($rows<=0 ){ echo header("Location: index.php"); } else { // اگر کاربر تایید شد از طریق نشست ورود کاربر را مشخص میکنیم. $_SESSION['username'] = $row_usere['id']; echo header("Location: user.php"); } }}?>
<form method="post" action="go.php"> <input name="username" type="text" value="" required="required" placeholder="username"/><br /> <input name="password" type="password" value="" required="required" placeholder="pass"/><br /> <input type="submit" value="enter"/></form>
-- --------------------------------------------------------
--
--Table structure for table `user`
--
CREATE TABLE IF NOT EXISTS `user`(
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;
if(isset($_POST['submit'])) {if($_POST['password']==$_POST['password2']){ if(isset($username) && preg_match("/^[a-zA-Z0-9]+$/", $username) == 1){ $username = mysql_real_escape_string($_POST['username']); $email = mysql_real_escape_string($_POST['email']); $password = md5($_POST['password']); $sql = mysql_query("SELECT username FROM user WHERE username = '".$username."'"); if(mysql_num_rows($sql)>0){ die("Username taken."); } $add = mysql_query("INSERT INTO user(username, password, email) VALUES('$username', '$password', '$email')") or die (mysql_error());
$con=mysqli_connect("localhost","root","","my_db");
$check="SELECT * FROM persons WHERE Email = '$_POST[eMailTxt]'";
$rs = mysqli_query($con,$check);
$data = mysqli_fetch_array($rs, MYSQLI_NUM);
if($data[0] > 1) {
echo "User Already in Exists<br/>";
}
else
{
$newUser="INSERT INTO persons(Email,FirstName,LastName,PassWord) values('$_POST[eMailTxt]','$_POST[NameTxt]','$_POST[LnameTxt]','$_POST[passWordTxt]')";
if (mysqli_query($con,$newUser))
{
echo "You are now registered<br/>";
}
else
{
echo "Error adding user in database<br/>";
}
}