Case being ignored...

mjshirley79

As a follow up to a previous post...

All my code works perfect on my local machine but after changing it to work with a postgre database and uploading it to the live server I found the Case(s) to be ignored to default...

The initial entry should be the default case but after selecting the add title link or edit this title it should reload the page in the relative case.

Case 1

<?php
switch ($input) {
	case 1 :
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Submit Case Studies &amp; Floor Plans</title>
</head>
<body>
<form action="<?php echo ($PHP_SELF) ?>" method="post">
<table summary="Form Table">
<tr>
<td colspan="2"><b>If you enter a 1 in both boxes this will publish out as both a Case Study and a Floor Plan.</b><br><hr></td>
</tr>
<tr>
<td align="right">Type 1 in the box if entering a Case Study:</td>
<td><INPUT TYPE="text" NAME="study"></td>
</tr>
<tr>
<td align="right">Type 1 in the box if entering a Floor Plan:</td>
<td><INPUT TYPE="text" NAME="plan"></td>
</tr>
<tr>
<td align="right">Model Name and/or Number: </td>
<td><INPUT TYPE="text" NAME="model"></td>
</tr>
<tr>
<td align="right">Modular Building Category:</td>
<td><INPUT TYPE="text" NAME="cat"></td>
</tr>
<tr>
<td align="right">Building Type: </td>
<td><INPUT TYPE="text" NAME="title"></td>
</tr>
<tr>
<td align="right">Square Footage: </td>
<td><INPUT TYPE="text" NAME="sqft"></td>
</tr>
<tr>
<td align="right">Company or Name:</td>
<td><INPUT TYPE="text" NAME="name"></td>
</tr>
<tr>
<td align="right">Location:</td>
<td><INPUT TYPE="text" NAME="location"></td>
</tr>
<tr>
<td align="right">Large Outside:</td>
<td><INPUT TYPE="text" NAME="lgpic"></td>
</tr>
<tr>
<td align="right">Small Outside :</td>
<td><INPUT TYPE="text" NAME="smpic"></td>
</tr>
<tr>
<td align="right">Interior 1:</td>
<td><INPUT TYPE="text" NAME="inside"></td>
</tr>
<tr>
<td align="right">Interior 2:</td>
<td><INPUT TYPE="text" NAME="inside1"></td>
</tr>
<tr>
<td align="right">Interior 3:</td>
<td><INPUT TYPE="text" NAME="inside2"></td>
</tr>
<tr>
<td align="right">Large 2d:</td>
<td><INPUT TYPE="text" NAME="lg2d"></td>
</tr>
<tr>
<td align="right">Small 2d:</td>
<td><INPUT TYPE="text" NAME="sm2d"></td>
</tr>
<tr>
<td align="right">Large 3d:</td>
<td><INPUT TYPE="text" NAME="lg3d"></td>
</tr>
<tr>
<td align="right">Small 3d:</td>
<td><INPUT TYPE="text" NAME="sm3d"></td>
</tr>
<tr>
<td align="right">PDF:</td>
<td><INPUT TYPE="text" NAME="pdf"></td>
</tr>
<tr>
<td align="right">About:</td>
<td><textarea name="about" rows="10" cols="40"></textarea></td>
</tr>
<tr>
<td align="right">Need:</td>
<td><textarea name="need" rows="10" cols="40"></textarea></td>
</tr>
<tr>
<td align="right">Solution:</td>
<td><textarea name="solution" rows="10" cols="40"></textarea></td>
</tr>
<tr>
<td><input type="submit" name="submittitle" value="SUBMIT"/></td></tr></table>
</form>
</body>
</html>
<?php

	break;
?>

mjshirley79

Case 2

<?php

case 2 :
	include ('db.inc');
	$query = pg_select("* FROM case_plans Where id = $id");
	$result = pg_query($query) or die('Error, query failed');
	while ($row = pg_fetch_array($result)) {
		$id 		= $row["id"];
		$plan 		= $row["plan"];
		$study 		= $row["study"];
		$model 		= $row["model"];
		$cat 		= $row["cat"];
		$sqft 		= $row["sqft"];
		$title 		= $row["title"];
		$name 		= $row["name"];
		$location 	= $row["location"];
		$about 		= $row["about"];
		$need 		= $row["need"];
		$solution 	= $row["solution"];
		$pdf 		= $row["pdf"];
		$lgpic 		= $row["lgpic"];
		$smpic 		= $row["smpic"];
		$lg2d 		= $row["lg2d"];
		$sm2d 		= $row["sm2d"];
		$lg3d 		= $row["lg3d"];
		$sm3d 		= $row["sm3d"];
		print "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">"."<html>"."<head>"."<title>Edit Case Studies &amp; Floor Plans</title>"."</head>"."<body>"."<form action=\"admin.php\" method=\"post\">"."<table summary=\"Form Table\">"."<tr>"."<td>Model Name and/or Number: </td>"."<td><INPUT TYPE=\"text\" NAME=\"model\" value=\"$model\"></td>"."</tr>"."<tr>"."<td>Modular Building Category:</td>"."<td><INPUT TYPE=\"text\" NAME=\"cat\" value=\"$cat\"></td>"."</tr>"."<tr>"."<td>Building Type: </td>"."<td><INPUT TYPE=\"text\" NAME=\"title\" value=\"$title\"></td>"."</tr>"."<tr>"."<td>Square Footage: </td>"."<td><INPUT TYPE=\"text\" NAME=\"sqft\" value=\"$sqft\"></td>"."</tr>"."<tr>"."<td>Company or Name:</td>"."<td><INPUT TYPE=\"text\" NAME=\"name\" value=\"$name\"></td>"."</tr>"."<tr>"."<td>Location:</td>"."<td><INPUT TYPE=\"text\" NAME=\"location\" value=\"$location\"></td>"."</tr>"."<tr>"."<td>Large Outside:</td>"."<td><INPUT TYPE=\"text\" NAME=\"lgpic\" value=\"$lgpic\"></td>"."</tr>"."<tr>"."<td>Small Outside :</td>"."<td><INPUT TYPE=\"text\" NAME=\"smpic\" value=\"$smpic\"></td>"."</tr>"."<tr>"."<td>Interior 1:</td>"."<td><INPUT TYPE=\"text\" NAME=\"inside\" value=\"$inside\"></td>"."</tr>"."<tr>"."<td>Interior 2:</td>"."<td><INPUT TYPE=\"text\" NAME=\"inside1\" value=\"$inside1\"></td>"."</tr>"."<tr>"."<td>Interior 3:</td>"."<td><INPUT TYPE=\"text\" NAME=\"inside2\" value=\"$inside2\"></td>"."</tr>"."<tr>"."<td>Large 2d:</td>"."<td><INPUT TYPE=\"text\" NAME=\"lg2d\" value=\"$lg2d\"></td>"."</tr>"."<tr>"."<td>Small 2d:</td>"."<td><INPUT TYPE=\"text\" NAME=\"sm2d\" value=\"$sm2d\"></td>"."</tr>"."<tr>"."<td>Large 3d:</td>"."<td><INPUT TYPE=\"text\" NAME=\"lg3d\" value=\"$lg3d\"></td>"."</tr>"."<tr>"."<td>Small 3d:</td>"."<td><INPUT TYPE=\"text\" NAME=\"sm3d\" value=\"$sm3d\"></td>"."</tr>"."<tr>"."<td>PDF:</td>"."<td><INPUT TYPE=\"text\" NAME=\"pdf\" value=\"$pdf\"></td>"."</tr>"."<tr>"."<td>About:</td>"."<td><textarea name=\"about\" rows=\"10\" cols=\"40\">$about</textarea></td>"."</tr>"."<tr>"."<td>Need:</td>"."<td><textarea name=\"need\" rows=\"10\" cols=\"40\">$need</textarea></td>"."</tr>"."<tr>"."<td>Solution:</td>"."<td><textarea name=\"solution\" rows=\"10\" cols=\"40\">$solution</textarea></td>"."</tr>"."<tr>"."<td><input type=\"submit\" name=\"edittitle\" value=\"SUBMIT\"/></td></tr></table>"."</form>"."</body>"."</html>";
	}
?>
<?php

	break;
?>

mjshirley79

Default

<?php

default;
	include ('db.inc');
	if ("SUBMIT" == $edittitle) {
		$sql = "UPDATE case_plans SET study='$study', plan='$plan', model='$model', cat='$cat', sqft='$sqft', title='$title', name='$name', location='$location', lgpic='$lgpic', smpic='$smpic', inside='$inside', inside1='$inside1', inside2='$inside2', lg2d='$lg2d', sm2d='$sm2d', lg3d='$lg3d', sm3d='$sm3d', pdf='$pdf', about='$about', need='$need', solution='$solution' WHERE id='$id'";
		if (pg_query($sql)) {
			echo ("<P>Your title has been updated.</P>");
		} else {
			echo ("<P>Error updating title: ".pg_last_error()."</P>");
		}
	}
	// If a title has been submitted,
	// add it to the database.
	if ("SUBMIT" == $submittitle) {
		$sql = "INSERT INTO case_plans SET study='$study', plan='$plan', model='$model', cat='$cat', sqft='$sqft', title='$title', name='$name', location='$location', lgpic='$lgpic', smpic='$smpic', inside='$inside', inside1='$inside1', inside2='$inside2', lg2d='$lg2d', sm2d='$sm2d', lg3d='$lg3d', sm3d='$sm3d', pdf='$pdf', about='$about', need='$need', solution='$solution'";
		if (pg_query($sql)) {
			echo ("<P>Your title has been added.</P>");
		} else {
			echo ("<P>Error adding submitted title: ".pg_last_error()."</P>");
		}
	}
	// If a title has been deleted,
	// remove it from the database.
	if (isset ($deletetitle)) {
		$sql = "DELETE FROM case_plans WHERE id=$deletetitle";
		if (pg_query($sql)) {
			echo ("<p>The title has been deleted.</p>");
		} else {
			echo ("<p>Error deleting title: ".pg_last_error()."</p>");
		}
	}
	echo ("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">"."<html>"."<head>"."<title>View Case Studies &amp; Floor Plans</title>"."<link rel=\"stylesheet\" type=\"text/css\" href=\"stylemaster.css\">"."</head>"."<body>"."<table class=\"page\" cellpadding=\"0\" cellspacing=\"0\" summary=\"layout\">"."<tr>"."<td>"."<table class=\"mainspecial\" cellpadding=\"0\" cellspacing=\"0\" summary=\"layout\">"."<tr>"."<td>"."<a href=\"/\">"."<img alt=\"Whitley Manufacturing\" src=\"/images/mast_2.jpg\" border=\"0\" width=\"750\" height=\"88\"></a>"."</td>"."</tr>"."</table>"."</td>"."</tr>"."<tr valign=\"top\">"."<td>"."<table class=\"content\" cellpadding=\"0\" cellspacing=\"0\" summary=\"layout\">"."<tr>"."<td valign=\"top\" width=\"150\">"."[+ inc('.mnu') +]"."</td>"."<td valign=\"top\" width=\"600\" align=\"center\">");
	echo ("<br><p align=\"center\"><a href='$PHP_SELF?input=1'>Add a title!</a></p><p align=\"center\">Here are all the titles in our database: </p><hr>");
	// Request the ID and text of all the titles
	$result = pg_query("SELECT * FROM case_plans");
	if (!$result) {
		echo ("<p>Error performing query: ".pg_last_error()."</p>");
		exit ();
	}
	// Display the text of each title in a paragraph
	// with a "Delete this title" link next to each.
	while ($row = pg_fetch_array($result)) {
		$id 		= $row["id"];
		$plan 		= $row["plan"];
		$study 		= $row["study"];
		$model 		= $row["model"];
		$cat 		= $row["cat"];
		$sqft 		= $row["sqft"];
		$title 		= $row["title"];
		$name 		= $row["name"];
		$location 	= $row["location"];
		$lgpic 		= $row["lgpic"];
		$smpic 		= $row["smpic"];
		$inside 	= $row["inside"];
		$inside1 	= $row["inside1"];
		$inside2 	= $row["inside2"];
		$lg2d 		= $row["lg2d"];
		$sm2d 		= $row["sm2d"];
		$lg3d 		= $row["lg3d"];
		$sm3d 		= $row["sm3d"];
		$pdf 		= $row["pdf"];
		$about 		= $row["about"];
		$need 		= $row["need"];
		$solution 	= $row["solution"];
		echo ("<BR><TABLE class=\"main\" summary=\"Modular Case Study - "."$name"." \">"."<TBODY>"."<TR>"."<TD valign=\"top\">"."<TABLE border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\" summary=\"layout\">"."<TBODY>"."<TR>"."<TD colspan=\"2\">"."<P class=\"bannerhead\">"."$title"." - "."$location"."</P>"."</TD>"."</TR>"."<TR bgcolor=\"#ffffff\">"."<TD align=\"center\" width=\"200\">"."<P>"."<A onclick=\"MM_openBrWindow('"."$lgpic"."','','scrollbars=yes,width=535,height=400')\" href=\"javascript:;\">"."<IMG src=\""."$smpic"."\" alt=\""."$name"." - "."$location"."\" style=\"border: 0px\"></A>"."</P>"."</TD>"."<TD valign=\"top\">"."<p class=\"about\">About "."$name"."</p>"."<p>"."$about"."</P>"."</TD>"."</TR>"."<TR valign=\"top\">"."<TD colspan=\"2\" rowspan=\"1\" class=\"footer\">");
		if ($study == '1') {
			echo (" <A href=\"case_study.html?"."$category"."&amp;"."$id"."\">Case Study</A> |");
		} else {
			echo ("");
		}
		if ($plan == '1') {
			echo (" <A href=\"floor_plans.html?"."$category"."&amp;"."$id"."\">Floor Plan</A> |");
		} else {
			echo ("");
		}
		echo (" <A href=\""."$pdf"."\">PDF Brochure</A>"."<BR>"."<a href=\"$PHP_SELF?deletetitle=$id\">"."Delete this title</a> "."| <a href=\"$PHP_SELF?input=2&amp;id=$id\">Edit this title</a>"."</TD>"."</TR>"."</TBODY>"."</TABLE>"."</TD>"."</TR>"."</TBODY>"."</TABLE>");
	}
	echo ("<br><table class=\"footer\" summary=\"layout\" cellpadding=\"0\" cellspacing=\"0\">"."<tbody><tr valign=\"top\">"."<td height=\"2\">Whitley Manufacturing Co., Inc. <br>"."PO Box 496 | 201 West First Street | South Whitley, IN 46787<br>"."260.723.5131 | 260.723.6949 fax </td>"."</tr>"."</tbody></table></tr></table><br>"."</td></tr></table></body>"."</html>");
	break;
}
?>