МИНИСТЕРСТВО РОССИЙСКОЙ ФЕДЕРАЦИИ
ПО СВЯЗИ И ИНФОРМАТИЗАЦИИ
САНКТ-ПЕТЕРБУРГСКИЙ
ГОСУДАРСТВЕННЫЙ УНИВЕРСИТЕТ ТЕЛЕКОММУНИКАЦИЙ
им. проф. М.А.БОНЧ-БРУЕВИЧА
Лабораторная работа №5
по дисциплине: «Интернет технологии»
на тему: «Построение модели Интернет-магазина с использованием СУБД MySQL»
Выполнила студентка
группы ИСТ93-у:
Кузнецова В.В.
Преподаватель: Евстигнеев В. А.
Санкт-Петербург
2012
Задача
Код index.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MySQL</title>
</head>
<h1>ADD Tovar</h1>
<form action="Commodity.php" method="post">
<table width=400 rules="none" border="0">
<tr>
<td>Name tovara</td>
<td><input type="text" name="name_commodity" size="30"></td>
</tr>
<tr>
<td>Cost(rub.)</td>
<td><input type="text" name="cost" size="30"></td>
</tr>
<tr>
<td>Kolichestvo</td>
<td><input type="text" name="quantity" size="30"></td>
</tr>
</table>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>
<?
$db="kvv";
$link = mysql_connect( "localhost", "root", "" );
if (!$link)
die("Couldn't connect to MySQL" );
mysql_select_db($db);
$sql=mysql_query("select * from commodity");
echo "<table><tr><td>ID</td><td>Name tovara</td><td>Cost(rub.)</td><td>Kolichestvo</td></tr>";
while($one = mysql_fetch_array($sql))
{
echo "<tr><td>".$one['id_commodity']."</td>
<td>".$one['name_commodity']."</td>
<td>".$one['cost']."</td>
<td>".$one['quantity']."</td></tr>";
}
echo "</table>";
mysql_close($link);
?>
<h1>ADD kolichestvo tovara</h1>
<form action="kol.php" method="post">
<table width=400 rules="none" border="0">
<tr>
<td>ID tovara</td>
<td><input type="text" name="id" size="30"></td>
</tr>
<td>Add kolichestvo</td>
<td><input type="text" name="kol" size="30"></td>
</tr>
</table>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>
<h1>Change cost</h1>
<form action="cost.php" method="post">
<table width=400 rules="none" border="0">
<tr>
<td>ID tovara</td>
<td><input type="text" name="id_cost" size="30"></td>
</tr>
<td>New cost</td>
<td><input type="text" name="new_cost" size="30"></td>
</tr>
</table>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>
<h1>ADD Buyer</h1>
<form action="buyer.php" method="post">
<table width=400 rules="none" border="0">
<tr>
<td>Last name</td>
<td><input type="text" name="last_name" size="30"></td>
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="name" size="30"></td>
</tr>
<tr>
<td>Password</td>
<td><input type="text" name="password" size="30"></td>
</tr>
</table>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>
<?
$db="kvv";
$link = mysql_connect( "localhost", "root", "" );
if (!$link)
die("Couldn't connect to MySQL" );
mysql_select_db($db);
$sql=mysql_query("select * from buyer");
echo "<table><tr><td>ID</td><td>Last name</td><td>Name</td><td>Password</td></tr>";
while($b = mysql_fetch_array($sql))
{
echo "<tr><td>".$b['id_buyer']."</td>
<td>".$b['last_name']."</td>
<td>".$b['name']."</td>
<td>".$b['password']."</td></tr>";
}
echo "</table>";
mysql_close($link);
?>
<h1>Buy tovar</h1>
<form action="selling.php" method="post">
<table width=400 rules="none" border="0">
<tr>
<td width="50%">ID tovara</td>
<td><input type="text" name="id_commodity" size="30"></td>
</tr>
<tr>
<td>Cost(rub.)</td>
<td><input type="text" name="cost" size="30"></td>
</tr>
<tr>
<td>Kolichestvo tovara</td>
<td><input type="text" name="number_commodity" size="30"></td>
</tr>
<tr>
<td>ID buyer</td>
<td><input type="text" name="id_buyer" size="30"></td>
</tr>
<tr>
<td>Date</td>
<td><input type="text" name="date" size="11"></td>
</tr>
</table>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>
<?
$db="kvv";
$link = mysql_connect( "localhost", "root", "" );
if (!$link)
die("Couldn't connect to MySQL" );
mysql_select_db($db);
$sql=mysql_query("select * from selling");
echo "<table><tr><td>ID</td><td>ID tovara</td><td>Cost(rub.)</td><td>Kolichestvo</td><td>ID buyer</td><td>Date</td><td>Discount</td></tr>";
while($tri = mysql_fetch_array($sql))
{
echo "<tr><td>".$tri['id_selling']."</td>
<td>".$tri['id_commodity']."</td>
<td>".$tri['cost']."</td>
<td>".$tri['number_commodity']."</td>
<td>".$tri['id_buyer']."</td>
<td>".$tri['date']."</td>
<td>".$tri['discount']."</td>
</tr>";
}
echo "</table>";
mysql_close($link);
?>
<body>
</body>
</html>
Код commodity.Php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<?
if (isset($_POST['name_commodity'])) { $name_commodity=$_POST['name_commodity'];}
if (isset($_POST['cost'])) { $cost=$_POST['cost']; }
if (isset($_POST['quantity'])) { $quantity=$_POST['quantity'];}
if ( empty($name_commodity) or empty($cost) or empty($quantity))
{exit ("ADD TEXT!"); }
$db="kvv";
$link = mysql_connect( "localhost", "root", "" );
if (!$link)
die("Couldn't connect to MySQL" );
mysql_select_db($db);
$result = mysql_query ("INSERT INTO `kvv`.`commodity` (name_commodity,cost,quantity) VALUES('$name_commodity','$cost','$quantity')");
if ($result=='TRUE')
{ echo "Ok. <a href='index.php'>Back</a"; }
else {echo "False!"; }
?>
<body>
</body>
</html>
Код buyer.Php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<?
if (isset($_POST['last_name'])) { $last_name =$_POST['last_name'];}
if (isset($_POST['name'])) { $name=$_POST['name']; }
if (isset($_POST['password'])) { $password=$_POST['password'];}
if ( empty($last_name) or empty($name) or empty($password))
{
exit ("ADD TEXT!");
}
$db="kvv";
$link = mysql_connect( "localhost", "root", "" );
if (!$link)
die("Couldn't connect to MySQL" );
mysql_select_db($db);
$result = mysql_query ("INSERT INTO `kvv`.`buyer`(last_name,name,password) VALUES('$last_name','$name','$password')");
if ($result=='TRUE')
{
echo "Ok. <a href='index.php'>Back</a";
}
else {
echo "False!";
}
?>
<body>
</body>
</html>
Код selling.Php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>title>
</head>
<?
if (isset($_POST['id_commodity'])) { $id_commodity=$_POST['id_commodity'];}
if (isset($_POST['cost'])) { $cost=$_POST['cost']; }
if (isset($_POST['number_commodity'])) { $number_commodity=$_POST['number_commodity'];}
if (isset($_POST['id_buyer'])) { $id_buyer=$_POST['id_buyer']; }
if (isset($_POST['date'])) { $date=$_POST['date']; }
if (empty($id_commodity) or empty($cost) or empty($number_commodity)or empty($id_buyer)or empty($date))
{
exit ("ADD TEXT!");
}
$ifsale=$cost*$number_commodity;
if($ifsale>=1000 ){
$cost=$cost*0.97;
$discount=1;
}
else {
$discount=0;
}
$db="kvv";
$link = mysql_connect( "localhost", "root", "" );
if (!$link)
die("Couldn't connect to MySQL" );
mysql_select_db($db);
$result = mysql_query ("INSERT INTO `kvv`.`selling` (id_commodity,cost,number_commodity,id_buyer,date,discount) VALUES('$id_commodity','$cost','$number_commodity','$id_buyer','$date','$discount')");
if ($result=='TRUE')
{
echo "Ok. <a href='index.php'>Back</a>";
}
else {
echo "False!";
}
?>
<body>
</body>
</html>
Код kol.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<?
if (isset($_POST['id'])) { $id =$_POST['id'];}
if (isset($_POST['kol'])) { $kol=$_POST['kol']; }
if ( empty($id) or empty($kol))
{
exit ("ADD TEXT!");
}
$db="kvv";
$link = mysql_connect( "localhost", "root", "" );
if (!$link)
die("Couldn't connect to MySQL" );
mysql_select_db($db);
$result = mysql_query("UPDATE `commondity` SET `quantity`=`quantity`+'&kol' WHERE `id_commondity` = '$id'");
if ($result=='TRUE')
{
echo "Ok. <a href='index.php'>Back</a>";
}
else {
echo "False!";
}
?>
<body>
</body>
</html>