I'm still fairly new to PHP, but I'm getting better.
I am working on a website which allows users to login and from their "member" page, they can submit a "mixed drink recipe" to the database for everyone else to see.
For the life of me, I CANNOT figure out what the issue is, and it is driving me nuts!
Here is the code for the form:
Code: Select all
<form name="myform" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<label class="register_label">Drink Name:</label>
<input class="register_field" name="drink_name" type="text" /><br /><br />
<label class="register_label">Author:</label>
<input class="register_field" name="drink_author" value="<?php echo $member_name ?>" type="text" /><br /><br />
<label class="register_label">Posted Date:</label>
<input class="drink_author" style="width: 100px; text-align: center;" value="<?php echo date("m/d/y"); ?>" name="date" type="text" /><br /><br />
<label class="register_label">Drink Type:</label>
<label class="drink_type_label">Mixed Drink:</label>
<input class="radio_drinks" name="drink_type" type="radio" value="mixed_drink" />
<label class="drink_type_label">Beer Recipe:</label>
<input class="radio_drinks" name="drink_type" type="radio" value="beer_drink" />
<label class="drink_type_label">Hot Drink:</label>
<input class="radio_drinks" name="drink_type" type="radio" value="hot_drink" />
<label class="drink_type_label">Punch Recipe:</label>
<input class="radio_drinks" name="drink_type" type="radio" value="punch_drink" />
<label class="drink_type_label">Other Drink:</label>
<input class="radio_drinks" name="drink_type" type="radio" value="other_drink" /><br /><br />
<label class="register_label">Submit Drink:</label>
<input name="upload_drink" value="Upload Drink" type="submit" />
</form>Code: Select all
<?php
// Check Data...
$error = "";
if(isset($_POST['upload_drink'])) {
if(!empty($_POST['drink_name']) && !empty($_POST['drink_type'])) {
$drink_name = stripslashes ($_POST['drink_name']);
$drink_creator = stripslashes ($_POST['drink_author']);
$drink_type = stripslashes ($_POST['drink_type']);
$drink_name = mysql_real_escape_string($drink_name);
$drink_creator = mysql_real_escape_string($drink_creator);
$drink_directions = mysql_real_escape_string($drink_directions);
$date = date("m/d/y");
// Submit Data...
$query = "INSERT INTO recipes (name, author, type, date_uploaded)
VALUES ('$drink_name', '$drink_creator', '$drink_type', '$date')";
mysql_query($query) or die ('Error, Insert Query Failed.');
$error = "<div id=\"register_complete\">Drink Successfully Added.</div><br />";
} else {
$error = "<div id=\"register_error\">Please Ensure All Fields Are Correctly Filled Out.</div><br />";
}
} else {
$error = "<div id=\"register_error\">Please Ensure All Fields Are Correctly Filled Out.</div><br />";
}
?>Anyone able to figure out what the issue is before I pull all my hair out? lol...
Thanks,
Phillips126