frijole Posted March 12, 2008 Share Posted March 12, 2008 I am trying to get this script to: 1. Display a form 2. Preview the data in the form 3. If data is correct add to the database 4. 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 } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.