[RESOLVED] PHP Form, Updating mysql database Page Blank

MysticItch

Hello, I've only tinkered around with PHP for a little bit, I'm trying to create a simple Update form where users can update the database themselves. The page displays correctly until I add the update function into the code, then the page just displays as a blank white page. Any help would be greatly appreciated. Code is below


<?php


function index(){

echo "<body bgcolor=\"#CCCCCC\"><h1>Update Guild Progression</h1><br>***NOT WORKING***<br><br><table><form action='?act=update' method='post'>"
    ."<tr><td>Login Name:</td><td><input type='text' name='Login' size='30'></td></tr>"
    ."<tr><td>Password:</td><td><input type='password' name='Password' size='30'></td></tr>"
    ."<tr><td colspan=\"2\"><b>Naxxramas</b></td></tr>"

."<tr><td>Anub'Rekhan:</td><td><select name='A'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Grand Widow Faerlina:</td><td><select name='F'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Maexxna:</td><td><select name='M'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Patchwerk:</td><td><select name='P'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Grobbulus:</td><td><select name='G'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Gluth:</td><td><select name='U'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Thaddius:</td><td><select name='T'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Noth the Plaguebringer:</td><td><select name='N'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Heigan the Unclean:</td><td><select name='H'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Loatheb:</td><td><select name='L'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Instructor Razuvious:</td><td><select name='I'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Gothik the Harvester:</td><td><select name='V'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>The Four Horsemen:</td><td><select name='4'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Sapphiron:</td><td><select name='S'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Kel'Thuzad:</td><td><select name='K'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td colspan=\"2\"><b>Eye of Eternity</b></td></tr>"

."<tr><td>Malygos:</td><td><select name='E'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td colspan=\"2\"><b>Vault of Archavon</b></td></tr>"

."<tr><td>Archavon the Storn Watcher:</td><td><select name='Y'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td colspan=\"2\"><b>Obsidian Sanctum</b></td></tr>"

."<tr><td>Satharion:</td> <td><select name='O'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Satharion +1Drake:</td><td><select name='O1'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Satharion +2Drakes:</td><td><select name='O2'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"

."<tr><td>Satharion +3Drakes:</td><td><select name='O3'>"
."<option value='N'>Alive</option>"
."<option value='Y'>Dead</option>"
."</select></td></tr>"




."<tr><td></td><td align=\"right\"><input type='submit' value='Update'></td></tr></table>"
."</form>"
."<i><font color=\"red\">***You need make sure all values are correct each time you update until I make the update page more convienient</font></i>"; 

}

function update(){


//Connecting to database
$connect = mysql_connect("host", "name", "pass");
if(!$connect){
die(mysql_error());
}

//Selecting database
$select_db = mysql_select_db("unrest", $connect);
if(!$select_db){
die(mysql_error());
}


//Collect your info from form
$Login = $_REQUEST['Login'];
$Password = $_REQUEST['Password'];
$A = $_REQUEST['A'];
$F = $_REQUEST['F'];
$M = $_REQUEST['M'];
$P = $_REQUEST['P'];
$G = $_REQUEST['G'];
$U = $_REQUEST['U'];
$T = $_REQUEST['T'];
$N = $_REQUEST['N'];
$H = $_REQUEST['H'];
$L = $_REQUEST['L'];
$I = $_REQUEST['I'];
$V = $_REQUEST['V'];
$4 = $_REQUEST['4'];
$S = $_REQUEST['S'];
$K = $_REQUEST['K'];
$O = $_REQUEST['O'];
$O1 = $_REQUEST['O1'];
$O2 = $_REQUEST['O2'];
$O3 = $_REQUEST['O3'];
$E = $_REQUEST['E'];
$Y = $_REQUEST['Y'];

//Check form
if(empty($Login)){
die("Please enter your Login Name!<br>");
}

if(empty($Password)){
die("Please enter your password!<br>");
}

$login_check = mysql_query("SELECT Login FROM Guild WHERE Login='$Login'");
$do_login_check = mysql_num_rows($login_check);

$pass_check = mysql_query("SELECT Password FROM Guild WHERE Login='$Login' AND Password='$Password'");
$do_pass_check = mysql_num_rows($pass_check);

//Check DB
if($do_login_check = 0){
die("Login Name not found!");
}

if($do_pass_check = 0){
die("Password is wrong!");
}

//Update Query
$update = mysql_query("UPDATE Guild SET A='$A', F='$F', M='$M', P='$P', G='$G', U='$U', T='$T', N='$N', H='$H', L='$L', I='$I', V='$V', 4='$4', S='$S', K='$K', O='$O', O1='$O1', O2='$O2', O3='$O3', E='$E', Y='$Y' WHERE Login='$Login' AND Password='$Password'");
if(!$update){
die(mysql_error());
}
echo "<body bgcolor=\"#CCCCCC\"><h1>Update Complete</h1>";

}


switch($act){

default;
index();
break;

case "update";
update();
break;



}
?>

Oni

I'm not sure if this is the cause of the problem, but default is usually put at the end.

As you know, you are defining small if statements using switch. After if some sort of bracket is opened. You should be using a colon : rather than a semicolon ; after cases and defaults. This is because you are defining rather than executing.

MysticItch

Edit, after further testing it seems the issue lies in defining the Select box form variables

Removing

$A = $REQUEST['A'];
$F = $REQUEST['F'];
$M = $REQUEST['M'];
$P = $REQUEST['P'];
$G = $REQUEST['G'];
$U = $REQUEST['U'];
$T = $REQUEST['T'];
$N = $REQUEST['N'];
$H = $REQUEST['H'];
$L = $REQUEST['L'];
$I = $REQUEST['I'];
$V = $REQUEST['V'];
$4 = $REQUEST['4'];
$S = $REQUEST['S'];
$K = $REQUEST['K'];
$O = $REQUEST['O'];
$O1 = $REQUEST['O1'];
$O2 = $REQUEST['O2'];
$O3 = $REQUEST['O3'];
$E = $REQUEST['E'];
$Y = $_REQUEST['Y'];

from the code allowed the page to be displayed correctly, and took me to the Update Complete echo, obviously however, nothing was updated since those variables aren't defined in the forum. I think I might have a solution if I change the select boxes to text.

Thank you for your response. I made the changes you suggested, but I'm still having the blank white screen. I've narrowed down the cause of the issue to be within this code, I just can't figure out what it is.

function update(){


//Connecting to database
$connect = mysql_connect("host", "name", "pass");
if(!$connect){
die(mysql_error());
}

//Selecting database
$select_db = mysql_select_db("unrest", $connect);
if(!$select_db){
die(mysql_error());
}


//Collect your info from form
$Login = $_REQUEST['Login'];
$Password = $_REQUEST['Password'];
$A = $_REQUEST['A'];
$F = $_REQUEST['F'];
$M = $_REQUEST['M'];
$P = $_REQUEST['P'];
$G = $_REQUEST['G'];
$U = $_REQUEST['U'];
$T = $_REQUEST['T'];
$N = $_REQUEST['N'];
$H = $_REQUEST['H'];
$L = $_REQUEST['L'];
$I = $_REQUEST['I'];
$V = $_REQUEST['V'];
$4 = $_REQUEST['4'];
$S = $_REQUEST['S'];
$K = $_REQUEST['K'];
$O = $_REQUEST['O'];
$O1 = $_REQUEST['O1'];
$O2 = $_REQUEST['O2'];
$O3 = $_REQUEST['O3'];
$E = $_REQUEST['E'];
$Y = $_REQUEST['Y'];

//Check form
if(empty($Login)){
die("Please enter your Login Name!<br>");
}

if(empty($Password)){
die("Please enter your password!<br>");
}

$login_check = mysql_query("SELECT Login FROM Guild WHERE Login='$Login'");
$do_login_check = mysql_num_rows($login_check);

$pass_check = mysql_query("SELECT Password FROM Guild WHERE Login='$Login' AND Password='$Password'");
$do_pass_check = mysql_num_rows($pass_check);

//Check DB
if($do_login_check = 0){
die("Login Name not found!");
}

if($do_pass_check = 0){
die("Password is wrong!");
}

//Update Query
$update = mysql_query("UPDATE Guild SET A='$A', F='$F', M='$M', P='$P', G='$G', U='$U', T='$T', N='$N', H='$H', L='$L', I='$I', V='$V', 4='$4', S='$S', K='$K', O='$O', O1='$O1', O2='$O2', O3='$O3', E='$E', Y='$Y' WHERE Login='$Login' AND Password='$Password'");
if(!$update){
die(mysql_error());
}
echo "<body bgcolor=\"#CCCCCC\"><h1>Update Complete</h1>";

}

MysticItch

resolved the issue by changing the select boxes to radio buttons.