Cavte... mam taky problem s updatovanim do mysql databazy... nechce to zmenit.
<h1>Editing file</h1>
<?php
$con = mysql_connect("localhost","sonic","php4fun");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("files", $con);
$result = mysql_query("SELECT * FROM upload WHERE path='".$_GET['file']."'");
while($row = mysql_fetch_array($result))
{
$_COOKIE['fpath']=$row['path'];
echo "<form class='blue' action='edit.php' method='get'>";
echo "<label for='name'>File name: </label><input value='".$row['name']."' type='text' name='name' id='name' /><br />";
echo "<label for='size'>File size: </label><input value='".$row['size']."B' disabled type='text' name='size' id='size' /><br />";
echo "<label for='date'>Date: </label><input value='".$row['date']."' disabled type='text' name='date' id='date' /><br />";
echo "<label for='path'>File path: </label><input value='".$_GET['file']."' disabled type='text' name='path' id='path' /><br />";
echo "<label for='cat'>Category: </label>";
}
mysql_close($con);
?>
<?php
$con = mysql_connect("localhost","sonic","php4fun");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("files", $con);
$result = mysql_query("SELECT * FROM cat ORDER BY name");
echo "<select name='cat'>";
while($row = mysql_fetch_array($result))
{
echo "<option value='".$row['name']."'>".$row['name']."</option>";
}
echo "</select>";
mysql_close($con);
?>
<label for="cat"><a href="/edit.php">Add category</a></label>
<input class='blueb' type='submit' name='submit' value='Save' /></form>
<?php
if ($_POST['name']!="") {
$con = mysql_connect("localhost","sonic","php4fun");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("files", $con);
mysql_query("UPDATE upload SET name='".$_GET['name']."', cat='".$_GET['cat']."' WHERE path='".$_COOKIE['fpath']."'");
mysql_close($con);
}
else {
}
?>
