<td align="center">email</td>

</tr>

<?php

$db->query("SELECT id, first_name,last_name,surname,addr FROM dev");

while($arr=$db->fetch_array()){

echo "<tr>";

foreach($arr as $key=>$val){

if($key=='id') $val = "<input type=checkbox name=delarr[] value=$val>";

if ($key=='addr') $val = "<a href=\"mailto:$val\">$val</a>";

echo "<td bgcolor=\"#dcdcdc\" align=\"center\">".$val."</td>";

}

echo "</tr>";

}

?>

<tr><td colspan="5" align="center"><input type="submit" name="del" value="Видалити автора"></td></tr>

</table>

</form>

</div>

<?php include("../footer.inc.html"); ?>

forms/distr.html

<form action="../scripts/distr.php">

<table class=text>

<tr>

<td colspan=2 align="center" class=h1>Add/Del distr<br><br></td>

</tr>

<tr>

<td>Ім'я</td>

<td><input type="text" name="name" size="15" maxlength="30"></td>

</tr>

<tr>

<td>Версія:</td>

<td><input type="text" name="version" size="15" maxlength="30"></td>

</tr>

<tr>

<td>Адрес:</td>

<td><input type="text" name="address" size="15" maxlength="30"></td>

</tr>

<tr>

<td><input type="submit" name="add" value="Додати distr"></td>

<td><input type="submit" name="del" value="Видалити distr"></td>

</tr>

</table>

</form>

scripts/distr.php

<?php include("../header.inc.html"); echo myheader("Дістр") ?>

<div align=center>

<?php

include "../forms/distr.html";

require ("../db.php");

$db = new db();

if(isset($_GET['add'])) {

$n = $_GET['name'];

$v = $_GET['version'];

$a = $_GET['address'];

$db->query("INSERT INTO distr(name, version, addr)

VALUES ('$n','$v','$a') ");

} elseif(isset($_GET['del'])) {

foreach($_GET['delarr'] as $arr){

$db->query("DELETE FROM distr

WHERE id = $arr ");

}

}

?>

<div class=h2>Наявні дистрибутиви</div>

<form action=<?php print $PHP_SELF; ?> >

<table style="border: 1px solid black; " cellpadding=3 cellspacing=1 class=text>

<tr bgcolor="#c0c0c0">

<td align="center">&nbsp;</td>

<td align="center">Назва</td>

<td align="center">Версія</td>

<td align="center">ftp-адреса</td>

</tr>

<?php

$db->query("SELECT id,name,version,addr FROM distr");

while($arr=$db->fetch_array()){

echo "<tr>";

foreach($arr as $key=>$val) {

if ($key=='id') $val = "<input type=checkbox name=delarr[] value=$val>";

if ($key=='addr') $val = "<a href=\"ftp://$val\">$val</a>";

echo "<td bgcolor=\"#dcdcdc\" align=\"center\">".$val."</td>\n";

}

echo "</tr>";

}

?>

<tr><td align="center" colspan=4><input type="submit" name="del" value="Видалити відмічені"></td></tr>

</table>

</form>

</div>

<?php include("../footer.inc.html"); ?>

forms/pz.html

<<form action="../scripts/pz.php">

<table class=text>

<tr>

<td colspan=2 align="center" class=h1>Додати/Видалити ПЗ<br><br></td>

</tr>

<tr>

<td>Назва</td>

<td><input type="text" name="name" size="15" maxlength="30"></td>

</tr>

<tr>

<td>Версія:</td>

<td><input type="text" name="version" size="15" maxlength="30"></td>

</tr>

<tr>

<td>Дата:</td>

<td><input type="text" name="date" size="15" maxlength="30"></td>

</tr>

<tr>

<td>Дистрибутив:</td>

<td>

<select name=distr>

<?php

$db->query("SELECT id,name,version FROM distr");

while ( $arr = $db->fetch_array() ) {

$tmp = $arr['id'];

$tmpname = $arr['name']." - ".$arr['version'];

echo "<option value=$tmp>$tmpname";

}

?>

</select>

</td>

</tr>

<tr>

<td>Автор:</td>

<td>

<select name=author>

<?php

$db->query("SELECT id,first_name,surname FROM dev");

while($arr=$db->fetch_array()) {

$tmp = $arr['id'];

$tmpname = $arr['first_name']." ".$arr['surname'];

echo "<option value=$tmp>$tmpname";

}

?>

</select>

</td>

</tr>

<tr>

<td>Ліцензія:</td>

<td><input type="text" name="licence" size="15" maxlength="30"></td>

</tr>

<tr>

<td>ftp-адреса:</td>

<td><input type="text" name="address" size="15" maxlength="30"></td>

</tr>

<tr>

<td colspan=2 align="center"><input type="submit" name="add" value="Додати ПЗ"></td>

</tr>

</table>

</form>

scripts/pz.php

<?php include("../header.inc.html"); echo myheader("ПЗ") ?>

<?php

require ("../db.php");

$db = new db();

?>

<div align="center">

<?php

include "../forms/pz.html";

if(isset($_GET['add'])) {

$n = $_GET['name'];

$v = $_GET['version'];

$d = $_GET['date'];

$l = $_GET['licence'];

$n_d=$_GET['distr'];

$n_a=$_GET['author'];

$a = $_GET['address'];

$db->query("INSERT INTO pz(name, version, dev_id, distr_id, date, licence, addr)

VALUES ('$n','$v', '$n_a', '$n_d', DATE '$d', '$l', '$a') ");

} elseif(isset($_GET['del'])) {

foreach($_GET['delarr'] as $arr){

$tmp = explode (":",$arr);

$db->query("DELETE FROM pz

WHERE name = '$tmp[0]'

AND version = '$tmp[1]' ");

}

}

?>

<div class=h2>Наявне ПЗ</div>

<form action=<?php print $PHP_SELF; ?> >

<table style="border: 1px solid black" cellpadding=3 cellspacing=1 class=text>

<tr bgcolor="#c0c0c0" class=>

<td>&nbsp;</td>

<td align="center">Назва</td>

<td align="center">Версія</td>

<td align="center">Датa</td>

<td align="center">Ліцензія</td>

<td align="center">ftp-адреса</td>

<td align="center" colspan=2>Розробник</td>

<td align="center">Дистрибутив</td>

<td align="center">ftp-aдреса дистрибутива</td>

</tr>

<?php

$db->query("SELECT pz.name, pz.version,pz.date,pz.licence,pz.addr, dev.first_name,

dev.surname,distr.name AS name1, distr.addr AS address

FROM pz,dev, distr

WHERE (pz.dev_id=dev.id AND pz.distr_id=distr.id )");

while($arr=$db->fetch_array()){

echo "<tr>";

$tmp=$arr['name'].":".$arr['version'];

$val = "<input type=checkbox name=delarr[] value=\"$tmp\">";

echo "<td bgcolor=\"#dcdcdc\" align=\"center\">".$val."</td>\n";

foreach($arr as $key=>$val)

echo "</tr>";

}

?>

<tr><td colspan=10 align=center><input type="submit" name="del" value="Видалити ПЗ"></td></tr>

</table>

</form>

</div>

<?php include("../footer.inc.html"); ?>

if(isset($_GET['add'])) {

$n = $_GET['name'];

$v = $_GET['version'];

$d = $_GET['date'];

$l = $_GET['licence'];

$n_d=$_GET['distr'];

$n_a=$_GET['author'];

$a = $_GET['address'];

$db->query("INSERT INTO pz(name, version, dev_id, distr_id, date, licence, addr)

VALUES ('$n','$v', '$n_a', '$n_d', DATE '$d', '$l', '$a') ");

} elseif(isset($_GET['del'])) {

$db->query("DELETE FROM distr

WHERE name = '$n'

AND version = '$v' ");

}

?>

</div>

<?php include("../footer.inc.html"); ?>

forms/sAName.html

<form action="../scripts/sAName.php">

<table class=text>

<tr>

<td colspan=2 align="center" class=h1>Пошук авторa<br><br></td>

</tr>

<tr>

<td>Прізвище автора:</td>

<td><input type="text" name="surname" maxlength="60"></td>

</tr>

<tr>

<td colspan=2 align=center>

<input type="submit" name="search" value="Пошук!">

</td>

</tr>

</table>

</form>

scritps/sAName.php

<?php include("../header.inc.html"); echo myheader("Пошук по автору") ?>

<div align="center">

<?php

include "../forms/sAName.html";

$name = $_GET['surname'];

require ("../db.php");

$db =new db();

##########

$db->query("SELECT dev.first_name, dev.last_name, dev.surname,dev.addr

FROM dev

Страницы: 1, 2, 3, 4, 5