$db = new mysqli('localhost', 'root', null, 'san');
if ($mysqli->connect_error)
{
die('Ошибка подключения (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}
$result = $db->query('SELECT id from table1 WHERE iin = ' . $_REQUEST['iin']);
if($result->num_rows > 0)
{
exit('Данные не добавлены! IIN уже существует!');
}
$query = 'INSERT INTO table1 (
iin, category, periud, fio,
today, email, tel) VALUES (
"' . $_REQUEST['iin'] . '",
"' . $_REQUEST['category'] . '",
"' . $_REQUEST['periud'] . '",
"' . $_REQUEST['fio'] . '",
"' . date("Y-m-d H:i:s") . '",
"' . $_REQUEST['email'] . '",
"' . $_REQUEST['tel'] . '"
);';
if(!$result = $db->query($query))
{
exit($db->errno . ' : ' . $db->error);
}
exit('Данные успешно добавлены');
while ($row = $result->fetch_assoc()) {
array_push($results, array(
'id' => cleanStr($row['id']),
'title' => cleanStr($row['title']),
'content' => cleanStr($row['content']),
'image_url' => cleanStr($row['image_url']),
'post_url' => cleanStr($row['post_url']),
'created_at' => cleanStr($row['created_at']),
'summary' => cleanStr($row['summary'])
));
}
if(!isset($_SESSION['logged_user'])) {
header('Location: /'); exit;
}
if($_SESSION['logged_user'] != 'admin') {
header('Location: /'); exit;
}