Problem med add og edit i php!
Jeg sidder lige og prøver at lave et edit og et add function til min mysql, men har problem med at få det til at virke, min kode ser sådan ud:add.php:
<?php
$conn = mysql_connect("xxxxx", "xxxxx", "xxxxx")
or die(mysql_error());
$db = mysql_select_db("xxxxx")
or die(mysql_error());
if($submit)
$products_name = $_POST['products_name'];
if(!$title){
echo "Error: ";
exit();
end of if
$result = mysql_query("INSERT INTO products (products_name)
VALUES ('$products_name',NOW())");
//print success message.
echo "<meta http-equiv=Refresh content=4;url=index.php>";
}//end of if($submit).
// If the form has not been submitted, display it!
else
{//begin of else
?>
<br>
<h3>::Add</h3>
<form method="post" action="<?php echo $PHP_SELF ?>">
Title: <input name="title" size="40" maxlength="255">
<br>
Text1: <textarea name="text1" rows="7" cols="30"></textarea>
<br>
Text2: <textarea name="text2" rows="7" cols="30"></textarea>
<br>
<input type="submit" name="submit" value="Add News">
</form>
<?
}//end of else
?>
edit.php:
<?php
$conn = mysql_connect("xxxxx", "xxxxx", "xxxxx")
or die(mysql_error());
$db = mysql_select_db("xxxxx")
or die(mysql_error());
if($submit)
{
$products_navn = $_POST['products_navn'];
$result = mysql_query("UPDATE products SET products_navn='$products_navn' WHERE products_prodnum='$products_prodnum'");
header("location: produkter.php");
}
elseif($products_prodnum)
{
$result = mysql_query("SELECT * FROM products WHERE products_prodnum='$products_prodnum' ");
while($myrow = mysql_fetch_assoc($result))
{
$products_navn = $row["products_navn"];
?>
<br>
<h3>::Edit </h3>
<form method="post" action="<?php echo $PHP_SELF ?>">
<input type="hidden" name="products_prodnum" value="<?php echo $row['products_prodnum']?>">
Title:
<input name="products_navn" size="40" maxlength="255" value="<?php echo $row["products_navn"] ?>">
<input type="submit" name="submit" value="UPDATE products">
</form>
<?
}//end of while loop
}//end else
?>
Hvad gør jeg forkert?
