Автор: Пользователь скрыл имя, 12 Декабря 2010 в 15:38, курсовая работа
Цель работы:
Разработать сайт о компьютерных играх. Он должен предоставлять возможность регистрации, просмотра новостей сайта, статей и пользователей, возможность добавления новой информации и комментариев.
vacansii2.php
<?php session_start();?>
<? include("top.php");?>
<table class="main">
<tr><td class="left"><table class="left1" >
<tr class="avt">
<td><? include("aut.php");?></td>
</tr>
<tr class="add"><td><?
include("add.php");?></td></
<tr><td></td><
<td class="right"><table class="left1">
<tr><td
class="vac" valign="top"><font size=5><center></font></td></
<tr><td
valign="top">
<? include ('db_connect.php');
$id=$_GET['id_vac'];
$sql
= 'SELECT `vacansii`.`id_vac`, `vacansii`.`D`, `vacansii`.`ZP`, `vacansii`.`obr`,`vacansii`.`
$result=mysql_query($sql);
echo "<center><table border=2 width=100% >";
while
($myrow=mysql_fetch_array($
{echo "<tr ><td bgcolor=ffffaa height=10>Наименование</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['D']."</td>
echo "<tr ><td bgcolor=ffffaa height=10>Версия</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['ZP']."</
echo "<tr ><td bgcolor=ffffaa height=10>Годвыпуска</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['obr']."</
echo "<tr ><td bgcolor=ffffaa
height=10>Фирмаразработчик</
echo "<td bgcolor=ffffff width=550>".$myrow['opit']."</
echo "<tr ><td bgcolor=ffffaa
height=10>Дополнительная
echo "<td bgcolor=ffffff width=550>".$myrow['DI']."</
}
echo "</table></center>";
echo
"<tr><td><a href='redactvac.php?id=$id'>
echo "</body>";
?>
</td></table>
</td></tr>
</table>
<? include("niz.php");?>
vacansii3.php
<?php session_start();?>
<? include("top.php");?>
<table class="main">
<tr><td class="left"><table class="left1" >
<tr class="avt">
<td><? include("aut.php");?></td>
</tr>
<tr class="add"><td><?
include("add.php");?></td></
<tr><td></td><
<td class="right"><table class="left1">
<tr><td
class="vac" valign="top"><font size=5><center></font></td></
<tr><td
valign="top">
<? include ('db_connect.php');
$id=$_GET['id_vac'];
$sql
= 'SELECT `vacansii`.`id_vac`, `vacansii`.`D`, `vacansii`.`ZP`, `vacansii`.`obr`,`vacansii`.`
$result=mysql_query($sql);
echo "<center><table border=2 width=100% >";
while
($myrow=mysql_fetch_array($
{echo "<tr ><td bgcolor=ffffaa height=10>Фамилия</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['D']."</td>
echo "<tr ><td bgcolor=ffffaa height=10>Имя</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['ZP']."</
echo "<tr ><td bgcolor=ffffaa height=10>Отчество</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['obr']."</
echo "<tr ><td bgcolor=ffffaa height=10>Стаж работы</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['opit']."</
echo "<tr><td bgcolor=ffffaa height=10>Возраст</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['Age']."</
echo "<tr ><td bgcolor=ffffaa
height=10>Контактная
echo "<td bgcolor=ffffff
width=550>".$myrow['KI']."</
echo "<tr ><td bgcolor=ffffaa
height=10>Дополнительная
echo "<td bgcolor=ffffff width=550>".$myrow['DI']."</
}
echo "</table></center>";
echo "<tr><td>";
echo "</body>";
?>
</td></table>
</td></tr>
</table>
<? include("niz.php");?>
delvac.php
<?php
include ('db_connect.php');
$id=$_GET['id'];
$query = 'DELETE FROM vacansii WHERE (id_vac='.$id.')';
echo $query;
if(mysql_query($query))
{ print "<HTML><HEAD>\n";
print "<META HTTP-EQUIV='Refresh' CONTENT='0; URL=vacansii.php'>\n";
print "</HEAD></HTML>\n";
}
?>
rez.php
<?php session_start();?>
<? include("top.php");?>
<table class="main">
<tr><td class="left"><table class="left1" >
<tr class="avt">
<td><? include("aut.php");?></td>
</tr>
<tr class="add"><td><?
include("add.php");?></td></
<tr><td></td><
<td
class="right"><? include("rezum1.php");?></td><
</table>
<? include("niz.php");?>
rezum1.php
<?php?>
<table
class="left1" ><tr><td height="10%"
valign="top" ><font size=6><center>Резюме</font></
<tr><td valign="top">
<? include ('db_connect.php');
$sql = 'SELECT `rez`.`id_rez`, `rez`.`F`, `rez`.`I`, `rez`.`O`, `rez`.`obr`, `rez`.`cpec`, `rez`.`opit`, `rez`.`Age`, `rez`.`KI`, `rez`.`DI`, `rez`.`Log`'. ' FROM `rez` LIMIT 0, 30';
$result=mysql_query($sql);
echo "<center><table border=1 width=100% >";
echo
"<tr bgcolor=ffffaa><td width=50% height=10>Специальность</td><
while
($myrow=mysql_fetch_array($
{
echo "<tr bgcolor=eeeeee>";
if ($myrow['Log']!==$_SESSION['
else {if ($myrow['Log']==$_SESSION['
echo "<td width=550><a href='".$put."=".$myrow['id_
echo "<td>".$myrow['F']." ".$myrow['I']." ".$myrow['O']."
</td>";
echo "</tr>";
}
echo "</table></center>";
echo "</body>";
?>
</td></tr></table>
rezum2.php
<?php session_start();?>
<? include("top.php");?>
<table class="main">
<tr><td class="left"><table class="left1" >
<tr class="avt">
<td><? include("aut.php");?></td>
</tr>
<tr class="add"><td><?
include("add.php");?></td></
<tr><td></td><
<td class="right"><table class="left1">
<tr><td
class="vac" valign="top"><font size=5><center>Резюме</font></
<tr><td valign="top">
<? include ('db_connect.php');
$id=$_GET['id_rez'];
$sql = 'SELECT `rez`.`id_rez`, `rez`.`F`, `rez`.`I`, `rez`.`O`, `rez`.`obr`, `rez`.`cpec`, `rez`.`opit`, `rez`.`Age`, `rez`.`KI`, `rez`.`DI`'. ' FROM `rez` WHERE (`rez`.`id_rez` ='.$id.')';
$result=mysql_query($sql);
echo "<center><table border=1 width=100% >";
while
($myrow=mysql_fetch_array($
{echo "<tr ><td bgcolor=ffffaa height=10>Фамилия</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['F']."</td>
echo "<tr ><td bgcolor=ffffaa height=10>Имя</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['I']."</td>
echo "<tr ><td bgcolor=ffffaa height=10>Отчество</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['O']."</td>
echo "<tr ><td bgcolor=ffffaa height=10>Образование</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['obr']."</
echo "<tr><td bgcolor=ffffaa height=10>Специальность</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['cpec']."</
echo "<tr ><td bgcolor=ffffaa height=10>Стаж работы</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['opit']."</
echo "<tr ><td bgcolor=ffffaa height=10>Возраст</td>";
echo "<td bgcolor=ffffff width=550>".$myrow['Age']."</
echo "<tr ><td bgcolor=ffffaa
height=10>Контактная