<?php
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Edycja</title>
<link rel="stylesheet" href="style.css" type="text/css" />
</head>
<body>
<?php
if($_SESSION["zalogowany"]==0
){echo "nie masz dostêpu do tej czê¶ci witryny. <a href='index.php'>Zaloguj siê</a></body></html>;"; exit();} ?>
<div>
<div>
<img src="img/logos.GIF" width="300"/> <br />
</div>
<div id="nav">
<a href="index.php"><img src="img/but1.gif" /></a>
<a href="wyswietlenie.php"><img src="img/but2.gif" /></a>
<a href="edit.php"><img src="img/but3.gif" /></a>
<a href="klienci.php"><img src="img/but4.gif" /></a>
<a href='index.php?wyloguj=tak'><img src="img/but5.gif" /></a><br /> <br />
</div>
</div>
<table width='35%' id="tabela">
<tr class="naglowek">
<td width='5%' align='center'>ID</td>
<td width='20%'>Nazwa firmy</td>
<td width='10%'>Akcja</td></tr>
<?
// ³±czymy siê z baz± danych
require "connection.php";
// wywo³ujemy funkcjê connection()
connection();
{
//wyswietla tabele
$result = mysql_query("select * from potencjalni order by id");
/* echo "<table width='100%'>
<tr class='naglowek'>
<td width='10%' align='center'>ID</td>
<td width='20%'>Nazwa firmy</td>
<td width='30%'>Akcja</td><tr>"; */
{
$title=$r["nazwa_f"];//wyciaga nazwe
$id=$r["id"];//wyciaga ID
//robi link
echo "<tr><td width='10%' align='center'>$id</td> <td width='20%'>$title</td>
<td width='10%' class='center'><b><a href='edit.php?cmd=edit&id=$id'>Edytuj</a></b></td>
";
}
echo "</tr></table><br />"; }
?>
<?
if($_REQUEST["cmd"] == "edit")
{
if (!isset($_POST["submit"])) {
$id = $_GET["id"];
$sql = "SELECT * FROM potencjalni WHERE id=$id";
?>
<div>Edycja dodanych firm</div>
<form action="edit.php" method="post">
<input type="hidden" name="id" value="
<?php echo $myrow["id"] ?>" />
<table width="100%" border="0" >
<tr>
<td colspan="4">
<b>Nazwa firmy</b> <font color="red">*</font><br />
<input name="nazwa_f" type="text" size="30" value="
<?php echo $myrow["nazwa_f"] ?>" />
</td>
</tr>
<tr>
<td colspan="4">
<b>Miejscowo¶æ:</b> <font color="red">*</font><br />
<input name="place" type="text" size="30" value="
<?php echo $myrow["place"] ?>" />
</td>
</tr>
<tr>
<td colspan="4">
<b>Strona www:</b> <font color="red">*</font><br />
<input name="www" type="text" size="30" value="
<?php echo $myrow["www"] ?>" />
</td>
</tr>
<tr>
<td width="25%">
<b>Osoba kontaktowa:</b> <font color="red">*</font><br />
<input name="os_kontakt" type="text" size="30" value="
<?php echo $myrow["os_kontakt"] ?>" />
</td>
<td width="25%">
<b>E-mail:</b> <font color="red">*</font><br />
<input name="email" type="text" size="30" value="
<?php echo $myrow["email"] ?>" />
</td>
<td width="25%">
<b>Doda³/³a:</b> <font color="red">*</font><br />
<input name="added" type="text" size="30" value="
<?php echo $myrow["added"] ?>" />
</td>
<td width="25%">
<b>Zainteresowany:</b> <font color="red">*</font><br />
<input type="checkbox" name="interest" size="1"
<?php if($row['interest'] == 1
) echo 'checked="checked"'; ?> />
</td>
</tr>
<tr>
<td width="25%">
<b>Status:</b><br />
<select name="status" value="
<?php echo $myrow["status"] ?>">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
</select>
</td>
<td width="25%">
<b>Osoba obs³uguj±ca:</b><br />
<input name="obsluga" type="text" size="30" value="
<?php echo $myrow["obsluga"] ?>"/>
</td>
<td>
<b>Opis:</b><br />
<textarea name="opis" rows="8" cols="50" style="color: gray; font-style: italic;" >
<?php echo $myrow["opis"] ?></textarea>
</td>
</tr>
<tr>
<td colspan="4" align="center">
<br />
<input type="hidden" name="cmd" value="edit" />
<input name="submit" id="submit" type="submit" value="Edytuj" class="submit" />
<input type="reset" name="reset" value="Reset" class="submit" />
</td>
</tr>
</table>
</form>
<? } ?>
<?
if ($_POST["submit"])
{
$nazwa_f = $_POST["nazwa_f"];
$place = $_POST["place"];
$www = $_POST["www"];
$os_kontakt = $_POST["os_kontakt"];
$email = $_POST["email"];
$added = $_POST["added"];
$interest = $_POST["interest"];
$id= $_POST["id"];
$opis = $_POST["opis"];
$obsluga = $_POST["obsluga"];
$status = $_POST["status"];
$sql = "UPDATE potencjalni SET nazwa_f='$nazwa_f',place='$place',www='$www',os_kontakt='$os_kontakt',email='$email',added='$added', status='$status', obsluga='$obsluga', interest=".(isset($status)?
1:0).", opis='$opis' WHERE id='$id'";
echo "Twój wpis zosta³ zaktualizowany"; }
}
?>
</body>
</html>