DaniWeb Forum Index > Web Development > PHP

Problem with $_GET variables...

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Sep 2007

Posts: 45

Reputation: verbob is an unknown quantity at this point

Solved Threads: 1

verbob

Offline

Light Poster

Problem with $_GET variables...

30 Days Ago

I am writing a script to add and edit listings in a realestate site.

For some reason I can't get the variables from the url to recognize properly.

heres the "problem" part of the script:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php 
require_once "../dbconnect.php"; // include the database information 
// if the 'mode' is set in the url (i.e. is the originating call is from new (mode is not set from this file) or edit )
if (isset($mode)) { 
	// get the id of the row to be editted from the url
	$editid = $_GET['id'];
	//retrieve the old pictures field and place into temp
	$old =  mysql_query("SELECT * FROM commercial WHERE id = ".$editid);
	$rowold = mysql_fetch_assoc($old);
	$pictures = $rowold['pictures'];
	mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '$pictures' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
	$result =  mysql_query("SELECT * FROM temp");
	$row = mysql_fetch_assoc($result);
	// get the temp id
	$id = $row['id'];
	$url = "imgup.php?id=".$id."&editid=".$editid;
} else {
		// if temp is not already in use, i.e., pictures not already added, then create temp
		mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
		$result =  mysql_query("SELECT * FROM temp");
		$row = mysql_fetch_assoc($result);
		$id = $row['id'];
		$url = "imgup.php?id=".$id;
	}
// redirect to upload images script
echo("<script>
<!--
	location.replace(\"".$url."\");
-->
</script>");?>
<?php 
require_once "../dbconnect.php"; // include the database information 
// if the 'mode' is set in the url (i.e. is the originating call is from new (mode is not set from this file) or edit )
if (isset($mode)) { 
	// get the id of the row to be editted from the url
	$editid = $_GET['id'];
	//retrieve the old pictures field and place into temp
	$old =  mysql_query("SELECT * FROM commercial WHERE id = ".$editid);
	$rowold = mysql_fetch_assoc($old);
	$pictures = $rowold['pictures'];
	mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '$pictures' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
	$result =  mysql_query("SELECT * FROM temp");
	$row = mysql_fetch_assoc($result);
	// get the temp id
	$id = $row['id'];
	$url = "imgup.php?id=".$id."&editid=".$editid;
} else {
		// if temp is not already in use, i.e., pictures not already added, then create temp
		mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
		$result =  mysql_query("SELECT * FROM temp");
		$row = mysql_fetch_assoc($result);
		$id = $row['id'];
		$url = "imgup.php?id=".$id;
	}
// redirect to upload images script
echo("<script>
<!--
	location.replace(\"".$url."\");
-->
</script>");?>

the url that calls this is:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

images.php?id=27&mode=edit

heres is the first part of "imgup.php"

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
$id = $_GET['id'];
if  (isset($_GET['editid'])){ 
	$editid = $_GET['editid']; 
	$headerurl = "?id=".$id."&editid=".$editid;
	} 
		else {
			$headerurl = "?id=".$id;
			$editid = "0";
		}
 echo $headerurl;
.
.
.
<?php
$id = $_GET['id'];
if  (isset($_GET['editid'])){ 
	$editid = $_GET['editid']; 
	$headerurl = "?id=".$id."&editid=".$editid;
	} 
		else {
			$headerurl = "?id=".$id;
			$editid = "0";
		}
 echo $headerurl;
.
.
.

(If you wonder why I set editid equal to zero, its so that if I need to check later on in this page if editid is set, I just check if its set to 0 instead of using isset...I know its really no big deal, Its just an attempt to keep it easy to read when i look back at it some time later)

headerurl echos as: "id=#" (obvious # represents an actual number, in this case, the number of the "temp id", which I verified to be accurate)

Seems to work fine when I "add a new listing", but when I edit one, thats when the problem appears.

all i can say is -- what the..? What am I missing??

•

Join Date: Oct 2009

Posts: 15

Reputation: alagirinetaxis is an unknown quantity at this point

Solved Threads: 3

alagirinetaxis alagirinetaxis is offline

Offline

Newbie Poster

30 Days Ago

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php 
require_once "../dbconnect.php"; // include the database information 
// if the 'mode' is set in the url (i.e. is the originating call is from new (mode is not set from this file) or edit )
if (isset($mode)) { 
	// get the id of the row to be editted from the url
	$editid = $_REQUEST['id'];
	//retrieve the old pictures field and place into temp
	$old =  mysql_query("SELECT * FROM commercial WHERE id = ".$editid);
	$rowold = mysql_fetch_assoc($old);
	$pictures = $rowold['pictures'];
	mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '$pictures' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
	$result =  mysql_query("SELECT * FROM temp");
	$row = mysql_fetch_assoc($result);
	// get the temp id
	$id = $row['id'];
	$url = "imgup.php?id=".$id."&editid=".$editid;
} else {
		// if temp is not already in use, i.e., pictures not already added, then create temp
 
		mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
		$result =  mysql_query("SELECT * FROM temp");
		$row = mysql_fetch_assoc($result);
		$id = $row['id'];
 
		$url = "imgup.php?id=".$id;
	}
// redirect to upload images script
echo("<script>
<!--
	location.replace(\"".$url."\");
-->
</script>");?>
<?php 
require_once "../dbconnect.php"; // include the database information 
// if the 'mode' is set in the url (i.e. is the originating call is from new (mode is not set from this file) or edit )
if (isset($mode)) { 
	// get the id of the row to be editted from the url
	$editid = $_REQUEST['id'];
	//retrieve the old pictures field and place into temp
	$old =  mysql_query("SELECT * FROM commercial WHERE id = ".$editid);
	$rowold = mysql_fetch_assoc($old);
	$pictures = $rowold['pictures'];
	mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '$pictures' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
	$result =  mysql_query("SELECT * FROM temp");
	$row = mysql_fetch_assoc($result);
	// get the temp id
	$id = $row['id'];
	$url = "imgup.php?id=".$id."&editid=".$editid;
} else {
		// if temp is not already in use, i.e., pictures not already added, then create temp
		
		mysql_query("INSERT INTO temp (id, pictures) VALUES (NULL, '' )") or die("somthing went wrong during the registration. MySQL said: ".mysql_error()); 
		$result =  mysql_query("SELECT * FROM temp");
		$row = mysql_fetch_assoc($result);
		$id = $row['id'];
		
		$url = "imgup.php?id=".$id;
	}
// redirect to upload images script
echo("<script>
<!--
	location.replace(\"".$url."\");
-->
</script>");?>

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
$id = $_REQUEST['id'];
if  (isset($_REQUEST['editid'])){ 
	$editid = $_REQUEST['editid']; 
	$headerurl = "?id=".$id."&editid=".$editid;
	} 
		else {
			$headerurl = "?id=".$id;
			$editid = "0";
		}
 echo $headerurl;
.
.
.
<?php
$id = $_REQUEST['id'];
if  (isset($_REQUEST['editid'])){ 
	$editid = $_REQUEST['editid']; 
	$headerurl = "?id=".$id."&editid=".$editid;
	} 
		else {
			$headerurl = "?id=".$id;
			$editid = "0";
		}
 echo $headerurl;
.
.
.