База данных автомагазина

    "avto" => array("ID Автомобиля", "ID Корпуса", "ID Двигателя", "Цена", "Дата производства", "Цвет", "Комплект"),

    "dolzhnosti" => array("Должность", "ФИО", "Адрес", "Номер телефона"),

    "prodazha" => array("ID Продажи", "ID Автомобиля", "Имя  покупателя", "Номер паспорта", "Адрес", "Номер телефона"),

    "proizvoditel" => array("ID Автомобиля", "Марка", "ID корпуса", "ID Двигателя", "Цвет", "Дата производства", "Дата прихода", "Комплект", "Цена"),

    "sotrudniki" => array("ID Сотрудника", "ФИО", "Должность", "Адрес", "Номер телефона")

  );

  $myss = array(

    "avto" => array("id_auto", "id_korpus", "id_motor", "cena", "data_proizvodstva", "cvet", "komplekt"),

    "dolzhnosti" => array("post", "name", "adress", "phone"),

    "prodazha" => array("id_prodazh", "id_auto", "name_pokupatel", "num_pasport", "adress", "phone"),

    "proizvoditel" => array("id_auto", "marka", "id_korpus", "id_motor", "cvet", "data_proizvodstva", "data_prihoda", "komplekt", "cena"),

    "sotrudniki" => array("id_sotrud", "name", "post", "adress", "phone")

  );

/*

create database automag;

use automag;

set names cp1251;

 

create table avto(id_auto int not null, id_korpus int not null, id_motor int not null, cena int not null, data_proizvodstva date not null, cvet varchar(20) not null, komplekt varchar(50) not null, primary key(id_auto));

create table dolzhnosti(post varchar(50) not null, name varchar(50) not null, adress varchar(50) not null, phone varchar(10) not null, primary key(post));

create table prodazha(id_prodazh int not null, id_auto int not null, name_pokupatel varchar(50) not null, num_pasport int not null, adress varchar(50) not null, phone varchar(10) not null, primary key(id_prodazh));

create table proizvoditel(id_auto int not null, marka varchar(50) not null, id_korpus int not null, id_motor int not null, cvet varchar(20) not null, data_proizvodstva date not null, data_prihoda date not null, komplekt varchar(50) not null, cena int not null, primary key(id_auto));

create table sotrudniki(id_sotrud int not null, name varchar(50) not null, post varchar(50) not null, adress varchar(50) not null, phone varchar(10) not null, primary key(id_sotrud));

 

delimiter |

create trigger t

after insert on prodazha for each row

begin

delete from avto where id_auto = new.id_auto;

end;|

delimiter ;

 

delimiter |

create procedure ch(id int)

begin

select p.id_auto, name_pokupatel, cena from prodazha p, proizvoditel where p.id_auto = id;

end|

delimiter ;

 

*/

?>

 

Файл обработчик кликов

 

function mouseOver(val)

{

  document.getElementById("table").value = val;

}

 

function mouseClick(val)

{

  document.location = ".?table=" + val;

}

 

function deleteClick(tb, id)

{

  document.location = "action.php?action=delete&table=" + tb + "&id=" + id;

}

 

function addClick(tb, co)

{

  val = document.getElementById("val0").value;

  for (var i = 1; i < co; i++)

    val += "~" + document.getElementById("val" + i).value;

  document.location = "action.php?action=add&table=" + tb + "&val=" + val;

}

 

function filClick(tb, co)

{

  fil = document.getElementById("fil0").value;

  for (var i = 1; i < co; i++)

    fil += "~" + document.getElementById("fil" + i).value;

  document.location = "table.php?table=" + tb + "&filter=" + fil;

}

 

function chClick(id_auto, name_pokupatel, cena)

{

  parent.document.location = "ch.php?id_auto=" + id_auto + "&name_pokupatel=" + name_pokupatel + "&cena=" + cena;

}

 

Файл таблици стилей

 

input.selection

{

  font: 20px arial, sans-serif;

  width: 100%;

  height: 140px;

  background-color: transparent;

  color: #0033dd;

  border: solid 1px gray;

  padding: 20px;

  margin: 10px;

  cursor: pointer;

}

 

input.selection:hover

{

  border-color: orange;

}

 

table td

{

  font: 12px arial, sans-serif;

  height: 40px;

  text-align: center;

}

 

table td input

{

  height: 30px;

  text-align: center;

  padding: 4px;

}

 

table td img

{

  width: 30px;

  padding-left: 10px;

}

 

table.header

{

  margin-left: 8px;

}

 

table.header td

{

  background-color: #0033dd;

  color: white;

}

 

iframe

{

  height: 600px;

  width: 100%;

}

 

Файл отображения страниц

<?php

  require_once("include.php");

  echo "

    <html>

      <head>

        <script type = 'text/javascript' src = 'script.js'></script>

        <link rel = 'stylesheet' type = 'text/css' href = 'style.css' />

        <meta http-equiv = 'content-type' content = 'text/html; charset = ibm866'>

      </head>

      <body>

  ";

  if (isset($_GET["filter"]))

  {

    $c = mysql_connect("127.0.0.1", "root", "1234");

    mysql_query("set names cp1251");

    mysql_query("use automag");

    $q = "select * from " . $_GET["table"] . " where ";

    $exp = explode("~", $_GET["filter"]);

    for ($i = 0; $i < count($exp); $i++)

    {

      $q .= $myss[$_GET["table"]][$i] . " like '" . $exp[$i] . "'";

      if ($i < count($exp) - 1)

        $q .= " and ";

    }

    $q = mysql_query($q);

    echo "<center><table cellpadding = '0' style = 'margin-left: " . ($_GET["table"] == "prodazha" ? "0" : "44") . "px;'>";

    $length = count($cols[$_GET["table"]]);

    $width = 1020 / $length;

    while ($f = mysql_fetch_array($q))

    {

      echo "<tr>";

      if ($_GET["table"] == "prodazha")

      {

        $fun = mysql_query("select p.id_auto, name_pokupatel, cena from prodazha p, proizvoditel where p.id_auto = " . $f[1]); // "call ch($f[1])"

        $funf = mysql_fetch_array($fun);

        echo "<td style = 'cursor: pointer;' onClick = 'chClick(" . $funf[0] . ", \"" . $funf[1] . "\", \"" . $funf[2] . "\")'><img src = 'ch.jpg' /></td>";

      }

      for ($i = 0; $i < $length ; $i++)

        echo "<td style = 'border: solid 1px transparent; width: " . $width . ";'>" . $f[$i] . "</td>";

      echo "

          <td style = 'cursor: pointer;' onClick = 'deleteClick(\"" . $_GET["table"] . "\", " . $f[0] . ")'><img src = 'del.jpg' /></td>

        </tr>";

    }

    echo "<tr>";

    if ($_GET["table"] == "prodazha")

      echo "<td style = 'width: 30px;'></td>";

    for ($i = 0; $i < $length ; $i++)

      echo "<td style = 'width: " . $width . "'><input id = 'val" . $i . "' type = 'text' style = 'width: " . $width . "' /></td>";

    echo "

          <td style = 'cursor: pointer;' onClick = 'addClick(\"" . $_GET["table"] . "\", " . $length  . ")'><img src = 'add.jpg' /></td>

        </tr>";

    if ($_GET["table"] == "prodazha")

      echo "<td style = 'width: 30px;'></td>";

    for ($i = 0; $i < $length ; $i++)

      echo "<td style = 'width: " . $width . "'><input id = 'fil" . $i . "' type = 'text' style = 'width: " . $width . "' value = '%' /></td>";

    echo "

          <td style = 'cursor: pointer;' onClick = 'filClick(\"" . $_GET["table"] . "\", " . $length  . ")'><img src = 'fil.jpg' /></td>

        </tr>

      </table></center>

    ";

    mysql_close($c);

  }

  echo "

      </body>

    </html>

  ";

?>