I am trying to get this script to:
- Display a form
- Preview the data in the form
- If data is correct add to the database
- If not go back to form to edit
I tried to set this up with a switch statement but it is not working. When I submit the form the form just reloads, nothing happens. Can anyone see why this would happen?
<?php
session_start();
require_once("dbConnect.php");
if (isset($_REQUEST['video']))
{
switch($_REQUEST['video'])
{
case "add":
$embedHTML = $_SESSION['embedHTML'];
$description = $_SESSION['description'];
$query = "INSERT INTO videos (embed_html, description) VALUES ('$embedHTML','$description')";
$result = mysql_query($query);
if ($result) echo "video added succesfully!";
else echo "video not added to the DB";
break;
case "preview":
$embedHTML = $_POST['embedHTML'];
$videoDesc = $_POST['description'];
echo "<html>";
echo "<blockquote>";
echo stripslashes($embedHTML);
echo "</blockquote>";
echo "<br />";
echo "<blockquote>";
echo stripslashes($videoDesc);
echo "</blockquote>";
echo "</html>";
$_SESSION['embedHTML'] = $embedHTML;
$_SESSION['description'] = $description;
echo "<a href=\"".$_SERVER['PHP_SELF']."?video=add\">Add to DB</a>";
echo "<a href=\"" . $_SERVER['PHP_SELF'] ."?video=edit\">Edit input</a>";
break;
case "edit":
?>
<html>
<table>
<tr>
<td><form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">Embed HTML:</td>
<td><textarea rows="5" cols="50" wrap="virtual" name="embedHTML"><?php echo $_SESSION['embedHTML']; ?></textarea></td>
</tr>
<tr>
<td>Description: </td>
<td><textarea rows="5" cols="50" wrap="physical" name="description"><?php echo $_SESSION['description']; ?></textarea></td>
</tr>
<tr>
<td><input type="submit" value="Add Video!"></form></td>
</tr>
</table>
</html>
<?php break;
}
} else { ?>
<html>
<table>
<tr>
<td><form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">Embed HTML:</td>
<td><textarea rows="5" cols="50" wrap="virtual" name="embedHTML">Enter Embed HTML</textarea></td>
</tr>
<tr>
<td>Description: </td>
<td><textarea rows="5" cols="50" wrap="physical" name="description"> Describe The Video Here</textarea></td>
</tr>
<tr>
<td><input type="submit" value="preview"></form></td>
</tr>
</table>
</html>
<?php } ?>
