Jump to content


Photo

*SOLVED* Blank screen, What gives in my script?


  • Please log in to reply
2 replies to this topic

#1 Leovenous

Leovenous
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 11 July 2006 - 08:15 PM

This is probably one of thos "duh" moments, but I've worked my mind into a scramble so an outsider might point out my blindness.

This is a processing page for a form. It takes information A, and checks to see if there is a B, C, D, F, and G. That dictates what all it needs to insert into the database. As it is now, it inserts that basic (player info) fine. The first insert query works. Its at the end, the pitcher option where it hangs. Its in a secure phpBB enviornment so you can't go to it, but I think its a pretty straightforward script.

The second query needs to insert the ID that is generated by auto_increment in the initial query. This is not complete, right now, because I'm trying to keep it simple. But eventually it will have to do up to 6 queries after the initial one, using the ID to relate them. That may be the sticking place. I don't know.

<?php 
session_start(); 
header("Cache-control: private"); //IE 6 Fix 
define('IN_PHPBB', true);
include "includes/functions.php";

// Start phpBB Session
// phpbbsession();
	
	$phpbb_root_path = '../forum/';
	include($phpbb_root_path . 'extension.inc');
	include($phpbb_root_path . 'common.'.$phpEx);

	//
	// Start session management
	//
	$userdata = session_pagestart($user_ip, PAGE_MVPTIPS);
	init_userprefs($userdata);
	//
	// End session management
	//

// Make sure they belong here
//validate();
	// CHECK if user is logged in
	if (!$userdata['session_logged_in']) {  
    	header ("Location: http://www.fanfaregames.com/forum/login.php");
   	exit(); 
	} 
	// CHECK to see if they are in the FRC
		// Establish database connection
		require_once('../../scripts/mysql_connect.php');
		// Make a variable for comparison
		$userid = $userdata['user_id'];
		// Query the database on the ID of the user
		$query = "SELECT frc_id FROM frc_users WHERE frc_id = '$userid' "; 
		$result = mysql_query ($query) or die(mysql_error()); 	
	// Check if they are legit
	if(mysql_num_rows($result)<1) {
		header ("Location: http://www.fanfaregames.com/frc/denied.php");
		exit(); 
	}
$active_game = $_GET['emag'];
// ***END STANDARD STUFF***

	// Get POST's into variables
	$fname = $_POST['Fname'];
	$lname = $_POST['Lname'];
	$team = $_POST['Team'];
	$dob = $_POST['DOB'];
	$pos = $_POST['Pos'];
	$bathrow = $_POST['Bathrow'];
	$careerpotential = $_POST['careerpotential'];
	$dittytype = $_POST['batterdittytype'];
	$number = $_POST['Number'];
	
	// Check for pitcher data
	if ($_POST['Pos'] == "SP" || $_POST['Pos'] == "RP") {
		$windup = $_POST['Wstyle'];
		$stamina = $_POST['Stam'];
		$pickoff = $_POST['Pick'];
		
		// Theyre'll always be a first pitch
		$type1 = $_POST['Type1'];
		$movement1 = $_POST['Movmt1'];
		$control1 = $_POST['Cntrl1'];
		$velocity1 = $_POST['Velo1'];
	
		// Check for a second pitch
		if ($_POST['Type2']) {
			$type2 = $_POST['Type2'];
			$movement2 = $_POST['Movmt2'];
			$control2 = $_POST['Cntrl2'];
			$velocity2 = $_POST['Velo2'];
		}
		// Check for a third pitch
		if ($_POST['Type3']) {
			$type3 = $_POST['Type3'];
			$movement3 = $_POST['Movmt3'];
			$control3 = $_POST['Cntrl3'];
			$velocity3 = $_POST['Velo3'];
		}
		// Check for a fourth pitch
		if ($_POST['Type4']) {
			$type4 = $_POST['Type4'];
			$movement4 = $_POST['Movmt4'];
			$control4 = $_POST['Cntrl4'];
			$velocity4 = $_POST['Velo4'];
		}
		// Check for a fifth pitch
		if ($_POST['Type5']) {
			$type5 = $_POST['Type5'];
			$movement5 = $_POST['Movmt5'];
			$control5 = $_POST['Cntrl5'];
			$velocity5 = $_POST['Velo5'];
		}
	}
// Verify the data is present
if ($fname && $lname && $team && $dob && $pos && $bathrow && $careerpotential && $dittytype && $number) {

// Do the insert query
$query2 = "INSERT INTO mvp05_players (ID, Fname, Lname, Team, DOB, Pos, Batthrows, Carpotent, Ditty, Number, Creator_ID) VALUES (NULL, '$fname', '$lname', '$team', '$dob', '$pos', '$bathrow', '$careerpotential', '$dittytype', '$number', '$user_id')";
$result2 = mysql_query($query2) or die("Error: " . mysql_error());
	if (mysql_affected_rows() == 1) {
			// echo '<p><b>New Player Submitted</b></p>';
			// exit();
		
		
		// Check to see if we need to submit pitcher stuff
		if ($_POST['Pos'] == "SP" || $_POST['Pos'] == "RP") {
			$query3 = "INSERT INTO mvp05_pitchers (ID, delivery, stamina, pickoff) VALUES (LAST_INSERT_ID, $windup, $stamina, $pickoff)";
			$result3 = mysql_query($query3) or die("Error: " . mysql_error());
			if (mysql_affected_rows() == 1) {
				header ("Location: http://www.fanfaregames.com/frc/verifypitcher.php");
   				exit();
			}
		} else {
			header ("Location: http://www.fanfaregames.com/frc/verify.php");
   			exit();
		}
	} else {
		echo 'There has been an error submitting this player. Contact Leovenous.';
	}
}
?>


#2 akitchin

akitchin
  • Staff Alumni
  • Advanced Member
  • 2,516 posts
  • LocationCalgary, AB, Canada

Posted 11 July 2006 - 08:25 PM

my best guess would be that the query is going through, but that one of the pages you're forwarding to (verifypitcher.php, etc) results in the blank page, not the processing script.

for the last inserted id, another option is to use mysql_insert_id(), which returns the ID inserted in the last query performed.  one way of checking where it is stalling is to use:

exit('<pre>'.print_r(get_defined_vars(), TRUE));

this will cease the script wherever you put it and spit out any defined variables (with the local ones being at the bottom most often).  then you can take a look at exactly what variables have what values.  useful debugging line.

hope this helps.

#3 Leovenous

Leovenous
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 12 July 2006 - 04:30 PM

Thankyou, that worked like a champ!

I ended up dumping mysql_insert_id() into a normal variable, because I will be using it repeatedly. That code to view the variables is golden. Especially for seeing what I can access in the phpBB enviornment.

Cheers.

~Leo




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users