<?php
require_once 'class/classPeopleDatabase.php';
$Login = trim($_POST['Login']);
$Password = sha1(md5(trim($_POST['Password'])));
$select = "SELECT login, password FROM authorization WHERE login = '******'";
$objAuthorization = new PeopleDatabase();
$array = mysql_fetch_array($objAuthorization->MySQLquery($select));
if ($Login == $array[0] && $Password == $array[1]) {
header('Location: http://mysite/PeopleDatabase/insert/insert.php');
} else {
header('Location: http://mysite/PeopleDatabase/wrong_authorization/wrong_authorization.php');
}
<?php
require_once 'class/classPeopleDatabase.php';
$PersonalCode = $_POST['PersonalCode1'] . "-" . $_POST['PersonalCode2'];
$select1 = "SELECT id FROM people_personal_code WHERE personal_code = '{$PersonalCode}'";
$obj_select = new PeopleDatabase();
$select1_result = $obj_select->MySQLquery($select1);
$select1_array = mysql_fetch_array($select1_result);
$select2 = "SELECT name, surname, phone_number FROM people_list WHERE id = '{$select1_array['0']}'";
$select2_result = $obj_select->MySQLquery($select2);
$select2_array = mysql_fetch_array($select2_result);
echo "<h4>Vārds</h4>";
echo "<input type=\"text\" readonly class=\"GeneralBlockCentralContentBlockInputText\" value=\"";
echo $select2_array[0] . "\">";
echo "<br>";
echo "<h4>Uzvārds</h4>";
echo "<input type=\"text\" readonly class=\"GeneralBlockCentralContentBlockInputText\" value=\"";
echo $select2_array[1] . "\">";
echo "<br>";
echo "<h4>Personas kods</h4>";
echo "<input type=\"text\" readonly id=\"GeneralBlockCentralContentBlockInputPersonalCode1\">-<input type=\"text\" readonly id=\"GeneralBlockCentralContentBlockInputPersonalCode2\">";
echo "<br>";
echo "<h4>Telefona numurs</h4>";
echo "<input type=\"text\" readonly class=\"GeneralBlockCentralContentBlockInputText\" value=\"";
echo $select2_array[2] . "\">";
<?php
require_once 'class/classPeopleDatabase.php';
$Name = $_POST['Name'];
$Surname = $_POST['Surname'];
$PhoneNumber = $_POST['PhoneNumber'];
$PersonalCode = $_POST['PersonalCode1'] . "-" . $_POST['PersonalCode2'];
$query1 = "INSERT INTO people_list (name,surname,phone_number) VALUES ('{$Name}','{$Surname}','{$PhoneNumber}')";
$obj_from_insert = new PeopleDatabase();
$obj_from_insert->MySQLquery($query1);
$LastInsertID = mysql_insert_id();
$query2 = "INSERT INTO people_personal_code (id,personal_code) VALUES ('{$LastInsertID}','{$PersonalCode}')";
$obj_from_insert->MySQLquery($query2);
header('Location: http://mysite/PeopleDatabase/inserted/inserted.php');
