Posiadam plik odbiorca.php w którym wyświetlam wszystkie rekordy z tabeli Odbiorca.
wygląda to mniej więcej tak:
<!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>Untitled Document</title>
</head>
<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<textarea name="query" cols="50" rows="1">Mysql Query Here</textarea><br />
<input type="submit" name="submit" value="Submit Your Query" />
</form>
<?php
$con = mysql_connect("localhost","test","test");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("testy", $con);
$result = mysql_query("SELECT * FROM Odbiorca where Nazwa like '%".$_POST["query"]."%'");
echo "<table border='0'>
<tr>
<th>Lp</th>
<th>Nazwa</th>
<th>Adres</th>
<th>Telefon</th>
<th>Email</th>
<th>NIP</th>
<th>info</th>
</tr>";
$i=0;
while($row = mysql_fetch_array($result))
{
$i++;
if($i%2 == 1)
{
echo "<tr>";
echo "<td>" . $i . "</td>";
echo "<td>" . $row['Nazwa'] . "</td>";
echo "<td>" . $row['Adres'] . "</td>";
echo "<td>" . $row['Telefon'] . "</td>";
echo "<td>" . $row['Email'] . "</td>";
echo "<td>" . $row['NIP'] . "</td>";
echo "<td>" . $row['info'] . "</td>";
echo "<td>" ."<a border='0' href='usun.php?id=" . $row['ID_Odbiorca'] . "'><img border='0' src='../img/del.jpg'/>". "</td>";
echo "<td>" ."<a border='0' href='edytuj.php?cmd=edit&id=$id" . $row['ID_Odbiorca'] . "'><img border='0' src='../img/edit.jpg'/>". "</td>";
echo "</tr>";
}
else
{
echo "<tr>";
echo "<td>" . $i . "</td>";
echo "<td bgcolor='#E6E6E6'>" . $row['Nazwa'] . "</td>";
echo "<td bgcolor='#E6E6E6'>" . $row['Adres'] . "</td>";
echo "<td bgcolor='#E6E6E6'>" . $row['Telefon'] . "</td>";
echo "<td bgcolor='#E6E6E6'>" . $row['Email'] . "</td>";
echo "<td bgcolor='#E6E6E6'>" . $row['NIP'] . "</td>";
echo "<td bgcolor='#E6E6E6'>" . $row['info'] . "</td>";
echo "<td bgcolor='#E6E6E6'>" ."<a href='usun.php?id=" . $row['ID_Odbiorca'] . "'><img border='0' src='../img/del.jpg'/>". "</td>";
echo "<td>" ."<a border='0' href='edytuj.php?cmd=edit&id=$id" . $row['ID_Odbiorca'] . "'><img border='0' src='../img/edit.jpg'/>". "</td>";
echo "</tr>";
}
}
echo "</table>";
mysql_close($con);
?>
<a href="dodaj.php"><img border="0" src="../img/new.jpg" alt="Dodaj nowy"></a>
</body>
</html>
W pliku edytuj.php powinienem moc wyświetlić dany rekord i go edytować.. wszystko jest ok plik edytuj mi go wczytuje ale nie zapisuje żadnych zmian po kliknięciu na submit ($id się chyba zeruje bo nie moglem jej wyświetlić). Co może być źle?
<?php
//connect to mysql
//change user and password to your mySQL name and password
$con = mysql_connect("localhost","test","test");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
else
{
echo 'yeee';
}
mysql_select_db("testy", $con);
if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
if (!isset($_POST["submit"]))
{
$id = $_GET["id"];
$sql = "SELECT * FROM Odbiorca WHERE ID_Odbiorca=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<form action="edytuj.php" method="post">
<input type=hidden name="id_odbiorca" value="<?php echo $myrow["ID_Odbiorca"] ?>">
<table>
<tr>
<td align="right">Nazwa:</td>
<td><input type="text" name="nazwa" value="<?php echo $myrow["Nazwa"] ?>"/></td>
</tr>
<tr>
<td align="right">Adres:</td>
<td><input type="text" name="adres" value="<?php echo $myrow["Adres"] ?>"/></td>
</tr>
<tr>
<td align="right">Telefon:</td>
<td><input type="text" name="telefon" value="<?php echo $myrow["Telefon"] ?>"/></td>
</tr>
<tr>
<td align="right">Email:</td>
<td><input type="text" name="email" value="<?php echo $myrow["Email"] ?>"/></td>
</tr>
<tr>
<td align="right">NIP:</td>
<td><input type="text" name="nip" value="<?php echo $myrow["NIP"] ?>"/></td>
</tr>
<tr>
<td align="right">info:</td>
<td><input type="text" name="info" value="<?php echo $myrow["info"] ?>"/></td>
</tr>
</table>
<input type="hidden" name="cmd" value="edit">
<input type="submit" name="submit" value="submit">
</form>
<?php
}
if ($_POST[submit])
{
$sql = "UPDATE Odbiorca SET Nazwa = '".$_POST["nazwa"]."', Adres = '".$_POST["adres"]."', Telefon = '".$_POST["telefon"]."', Email = '".$_POST["email"]."', NIP = '".$_POST["nip"]."', info = '".$_POST["info"]."' WHERE ID_Odbiorca=$id";
$result = mysql_query($sql);
echo "Thank you! Information updated. ";
}
}
mysql_close($con);
?>