Untitled

<!DOCTYPE html>
<html lang="ru">
<head>
<link rel="stylesheet" type="text/css" href="knop.css">
<link rel="stylesheet" type="text/css" href="men.css">
<link rel="stylesheet" type="text/css" href="mig.css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>PRESTIGE</title>
 <style type="text/css">
   A {
    text-decoration: none;
   }
  </style>
</head>
<body bgcolor="ffffff">
<table border="5" bordercolor="ffffff" width="1000" align="center">
<tr>
<td bgcolor="000000">

<!--*************************************************************-->
<table border="5" bordercolor="ffffff" width="990" height="200"
 cellpadding="10">
<tr>
<th background="https://avatanplus.com/files/resources/original/580f4a86bae6e157fbbb1e6e.jpg">
<h1 style = 'cursor: default;' ><c href='men'><font color="ffffff" face="Zing Sans Rust Demo Base" style = "font-size: 43px;">
Prestige</font> </c>
<h3 align="center" style = 'cursor: default;'>
<font color="000000"><font face="Zing Sans Rust Demo Base" size=+2 >агенство недвижимости
</font></font>
</h3>
</h1>
</th>
</tr>
</table>


<!--*************************опции поиска************************************-->
<table border="5" bordercolor="ffffff" width="990" cellpadding="10">
<tr>
<td rowspan="4" width="600" bgcolor="000000">
<h3 style = 'cursor: default;'><font face="Zing Sans Rust Demo Base"><font color="ffffff"><span style = "font-size: 25px;">Клиентская база</span></font></font></h3>

<!--******добавление******-->
<table border="5" bordercolor="ffffff" width="600" cellpadding="10">
<tr>
<td rowspan="4" width="600" bgcolor="000000">
<form action="reg.php" method="post" >
<p><font face="Zing Sans Rust Demo Base" color="ffffff">Добавить нового клиента:</font><br>

<input  font size = 10  name="tel"  type="text"   value="" >
<input  font size = 10  name="name"  type="text"  value="" >
<input  font size = 10  name="tname"  type="text" value="" >
<input  font size = 10  name="pass"  type="text"  value="" >
<input type=submit value="Добавить">
</form></td></tr></table>

<!--******после нажатия добавления******-->
<?php
$host = "localhost";
$user = "nika";
$password = "";
$db = "ag";

mysql_query("SET NAMES 'cp1251'");
mysql_query("SET CHARACTER SET 'cp1251'");
mysql_query("SET SESSION collation_connection = 'cp1251_general_ci'");
if (!$conn = mysql_connect($host, $user, $password))
{
echo "<h2>MySQL Error!</h2>";
exit;
}
$tel = $_POST['tel'];
$name = $_POST['name'];
$tname = $_POST['tname'];
$pass = $_POST['pass'];
mysql_select_db($db);


$result = mysql_query("INSERT INTO user (tel, name, tname, pass)  VALUE ('$tel', '$name', '$tname', '$pass')");
echo mysql_error();

?>


<!--******поиск******-->
<table border="5" bordercolor="ffffff" width="600" cellpadding="10">
<tr>
<td rowspan="4" width="600" bgcolor="000000">
<form action="reg.php" method="post">
 <font face="Zing Sans Rust Demo Base" color="ffffff">Искать клиента по:</font><br>
 <select name="search">

  <option value="name">Имени</option>
  <option value="tname">Фамилии</option>
  <option value="tel">Телефону</option>
  </select>
 <br /> <p><font face="Zing Sans Rust Demo Base" color="ffffff">Введите информацию для поиска:</font><br>
 <input name="term" type="text">
 </p><br />
 <input type="submit" name="submit" value="Найти">
</form></td></tr></table>


<!--******после нажатия поиска******-->

<?php
  $search=$_POST['search'];
  $term=$_POST['term'];
  $Host="localhost";  $User="nika"; $DBName="ag";
  $Password="";

if ($search || $term):
  @ $db = mysql_pconnect($Host, $User, $Password);
 mysql_query("SET NAMES 'cp1251'");
mysql_query("SET CHARACTER SET 'cp1251'");
mysql_query("SET SESSION collation_connection = 'cp1251_general_ci'");

 if (!$db)
{
 echo 'Ошибка: Не удалось установить соединение с базой
 данных.<br>Пожалуйста, повторите попытку позже.';
exit;
}

mysql_select_db("ag");
$query = "select * from user where ".$search."
like '%".$term."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows ($result);
  echo '<p><font color=white>Найдено клиентов: '.$num_results.'</font></p>';

echo"<table border=1 width = '600px' align=centr>";
echo "<tr>
<td><b><font size=3 color=white> Телефон</font></b></td>
<td><b><font size=3 color=white >Имя</font></b></td>
<td><b><font size=3 color=white> Фамилия</font></b></td>
<td><b><font size=3 color=white> Пасспорт</font></b></td>";

while ($num_results = mysql_fetch_array($result))
{
        echo "<tr>\n";
    echo "<td><font color=white>".$num_results['tel']."</font></td>\n";
    echo "<td><font color=white>".$num_results['name']."</font></td>\n";
    echo "<td><font color=white>".$num_results['tname']."</font></td>\n";
    echo "<td><font color=white>".$num_results['pass']."</font></td>\n";

    echo "</tr>\n";
}
endif;

?>

<!--*****************************все клиенты********************************-->
<?php

$db = mysql_connect ("localhost","nika","");
mysql_select_db("ag",$db);
mysql_query("SET NAMES 'cp1251'");
mysql_query("SET CHARACTER SET 'cp1251'");
mysql_query("SET SESSION collation_connection = 'cp1251_general_ci'");
$result=mysql_query("SELECT tel, name, tname, pass FROM user ORDER BY name");


$row=mysql_num_rows($result);
echo"<table border=1 width = '600px' align=centr>";
echo "<tr>
<td><b><font size=3 color=white>----ВСЕ Клиенты----</font></b></td>";

echo"<table border=1 width = '600px' align=centr>";
echo "<tr>
<td><b><font size=3 color=white> Телефон</font></b></td>
<td><b><font size=3 color=white >Имя</font></b></td>
<td><b><font size=3 color=white> Фамилия</font></b></td>
<td><b><font size=3 color=white> Пасспорт</font></b></td>
<td><b><font size=3 color=white> Удалить</font></b></td>";

while ($row = mysql_fetch_array($result))
{
        echo "<tr>\n";
    echo "<td><font color=white>".$row['tel']."</font></td>\n";
    echo "<td><font color=white>".$row['name']."</font></td>\n";
    echo "<td><font color=white>".$row['tname']."</font></td>\n";
    echo "<td><font color=white>".$row['pass']."</font></td>\n";
    echo '<td><a tel=\"del\" href="reg.php?del='.$row['tel'].'" onClick="if(!confirm(\'Удалить?\'))return false;">Удалить</a></td>';
    echo "</tr>\n";
}
echo "</table>";
?>

<?php
$host = "localhost";
$user = "nika";
$password = "";
$db = "ag";
mysql_connect($host, $user, $password);
mysql_select_db($db);
if(isset($_GET['del']))
{
    $del = $_GET['del'];
    $query = "DELETE FROM user WHERE tel = $del";
    /* Выполняем запрос. Если произойдет ошибка - вывести ее. */
    mysql_query($query) or die($query . '<br />' . mysql_error());
header("Location: reg.php");

}

?>

<!--*************************************************************-->
<td bgcolor="000000" align="left">
<h3 style = 'cursor: default;'><font face="Zing Sans Rust Demo Base" color="ffffff">Меню</font></h3>

<c href='men'><p style = 'cursor: pointer;'><img src="pic.png"><a href="main.php">
<font face="Zing Sans Rust Demo Base" color="ffffff">Главная</font></a></p></c>

<c href='men'><p style = 'cursor: pointer;'><img src="pic.png"><a href="flat.php">
<font face="Zing Sans Rust Demo Base" color="ffffff">Поиск квартир</font></a></p></c>

<c href='men'><p style = 'cursor: pointer;'><img src="pic.png"><a href="sel.php">
<font face="Zing Sans Rust Demo Base" color="ffffff">Заявки на покупку</font></a></p></c>

<c href='men'><p style = 'cursor: pointer;'><img src="pic.png"><a href="reg.php">
<font face="Zing Sans Rust Demo Base" color="ffffff">Клиенты</font></a></p>
</c>
<c href='men'><p style = 'cursor: pointer;'><img src="pic.png"><a href="dog.php">
<font face="Zing Sans Rust Demo Base" color="ffffff">Договоры</font></a></p></c></td>
</tr>


<tr>
<td bgcolor="000000" align="center">
<h3 style = 'cursor: default;'><font face="Zing Sans Rust Demo Base" color="ffffff">Личный кабинет</font></h3>
 <p align="left" style = 'cursor: default;'><font face="Zing Sans Rust Demo Base" color="ffffff">Логин:</font>
   <input style = 'cursor: pointer;' type="text" size="22">
  </p>
 <p align="left" style = 'cursor: default;'><font face="Zing Sans Rust Demo Base" color="ffffff">Пароль:</font>
   <input style = 'cursor: pointer;' type="text" size="20">
  </p>
<z class="buttons" href='#' >Bxoд</z> <z class="buttons" href='#' >Очистить</z>
</td>
</td>
 </tr>
 </tr>
 </table>
</table>
 </body>
 </html>