trouble with switch statement

frijole · 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 } ?>

Sign In

trouble with switch statement

Recommended Posts

frijole

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information