tomi

unknown
php
a year ago
2.5 kB
Indexable
Never
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<?php
// include 'db.php';
include_once 'db.php';
// require 'db.php';
// require_once 'db.php';

if(isset($_POST['submit']))
{
	$error = 0;
	$username = $_POST['username'];
	$password = $_POST['password'];
	$password2 = $_POST['password2'];
	$first_name = $_POST['first_name'];
	$last_name = $_POST['last_name'];
	$email = $_POST['email'];
	$f_number = $_POST['f_number'];
	$address = $_POST['address'];
	$phone = $_POST['phone'];
	if(strlen($password) > 8 && strlen($password) < 20)
	{
		$password = md5($password);
	}
	else
	{
		$error = 1;
		echo "Паролата не отговаря на условията!";
	}
	if(strlen($f_number) != 6)
	{
		$error = 1;
		echo "не е правилен факултетния номер!";
	}
	
	if($password != $password2)
	{
		$error = 1;
		echo "Паролите не съвпадат!";
	}
	
	
	$query = "INSERT INTO `users`
	(`f_number`, `first_name`, `last_name`, 
	`email`, `phone`, `address`, `username`, 
	`password`) 
	VALUES ('$f_number','$first_name',
	'$last_name','$email',
	'$phone','$address','$username','$password')";
	if($error == 0)
	{
		$inserted = mysqli_query($con,$query);
	}
	if(@$inserted == 1)
	{
		echo "Успешно въведени данни!";
	}
	else
	{
		echo "Имате грешка звъннете на администратора!";
	}
	
}



$query = "SELECT `first_name`, `email`, `address`  FROM `users`";
$result = mysqli_query($con,$query);
$num = mysqli_num_rows($result);

//$row = mysqli_fetch_row($result);
//$row = mysqli_fetch_assoc($result);
//$row = mysqli_fetch_array($result);
if($num > 0)
{
	while($row = mysqli_fetch_assoc($result))
	{
		echo "<br />Здравейте, ". $row['first_name'];
		echo " от ". $row['address'];
	}
}
else
{
	echo 'Няма записи :/';
}
?>


<form action="" method="POST" >
username: <input type="text" name="username" /><br />
password: <input type="password" name="password" /><br />
email: <input type="email" name="email" /><br />
f_number: <input type="text" name="f_number" /><br />
first_name: <input type="text" name="first_name" /><br />
last_name: <input type="text" name="last_name" /><br />
address: <input type="text" name="address" /><br />
phone: <input type="text" name="phone" /><br />
<input type="submit" name="submit" value="send" />

</form>




</body>
</html>