Løber helt igennem koden
Hej eksperter,jeg kunne godt bruge noget hjælp til nedenstående kode.
Problemet er at computeren løber helt igennem koden, så selvom der er fejl, gemmer den på serveren.
---
Outputtet/fejlen ser sådan her ud:
We encountered an error:
Please enter the yearWe encountered an error:
Please enter the price of the wine, or your best estimateWe encountered an error:
Please rate the wine
kjaslkdjaljda has been added!
----
Koden er strikket sammen af lidt af hvert, men har fungeret tidligere i dag (?), og er som følger:
<?php
/* Check all form inputs using check_input function */
$winetype = check_input($_POST['winetype'], "Please select type of wine");
$winename = check_input($_POST['winename'], "Please enter a name of the wine");
$wineyear = check_input($_POST['wineyear'], "Please enter the year");
$wineprice = check_input($_POST['wineprice'], "Please enter the price of the wine, or your best estimate");
$winestars = check_input($_POST['winestars'], "Please rate the wine");
function check_input($data, $problem='')
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
if ($problem && strlen($data) == 0)
{
show_error($problem);
}
return $data;
}
function show_error($myError)
{
echo "<html>";
echo "<body>";
echo "<b>We encountered an error:</b><br />";
echo $myError;
echo "</body>";
echo "</html>";
}
$con = mysql_connect("DATABASE","USER","PASSWORD");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$a = uniqid(pro);
mysql_query("SET NAMES utf8");
mysql_select_db("MAINDATABASE", $con);
$sql="INSERT INTO Stellenbosch (winetype, winename, wineyear, wineprice, winestars, reviewer, description, id)
VALUES
('$_POST[winetype]','$_POST[winename]','$_POST[wineyear]','$_POST[wineprice]','$_POST[winestars]','$_POST[reviewer]','$_POST[description]','$a')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "<html>";
echo "<head>";
echo "<title>" . $_POST[winename] . "</title>";
echo "</head>";
echo "<body>";
echo "<p class='boks'>" . $_POST[winename] . " has been added!</p></div></a>";
echo "</body>";
echo "</html>";
mysql_close($con)
?>
På forhånd tak for hjælpen!
