Trouble passing URL Variable

crseader

Greetings,
I am having some trouble passing a URL variable after an insert on a form action.

Here is my script below it seems i have everything right, but im not sure why the variable does not show up in the URL when i hit submit and it moves to the next page.

Can anyone see where im making my mistake?

<?php
//Environment Variables
//putenv("LD_LIBRARY_PATH=/home/db2admin/sqllib/lib");
//putenv("DB2INSTANCE=db2admin");

//Connection statement
require_once('../Connections/orsdb2.php');

//Aditional Functions
require_once('../includes/functions.inc.php');

// build the form action
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'] . (isset($HTTP_SERVER_VARS['QUERY_STRING']) ? "?REQ_ID_RMS=" . $HTTP_SERVER_VARS['QUERY_STRING'] : "");

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO OCM.SPEC_HANDLING_REQ (requester_rms, phone_rms, request_rms, otherreq_rms, req_time_rms, req_date_rms) VALUES (%s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['requester_rms'], "text"),
GetSQLValueString($HTTP_POST_VARS['phone_rms'], "text"),
GetSQLValueString($HTTP_POST_VARS['request_rms'], "text"),
GetSQLValueString($HTTP_POST_VARS['otherreq_rms'], "text"),
GetSQLValueString($HTTP_POST_VARS['req_time_rms'], "text"),
GetSQLValueString($HTTP_POST_VARS['req_date_rms'], "text"));

$Result1 = $orsdb2->Execute($insertSQL) or die($orsdb2->ErrorMsg());

$insertGoTo = "../reqhandling/currentrpt.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
KT_redir($insertGoTo);
}

// begin Recordset
$colnameRecordset1 = '-1';
if (isset($HTTP_POST_VARS['req_id_rms'])) {
$colnameRecordset1 = $HTTP_POST_VARS['req_id_rms'];
}
$query_Recordset1 = sprintf("SELECT * FROM OCM.SPEC_HANDLING_REQ WHERE REQ_ID_RMS = %s", $colname__Recordset1);
$Recordset1 = $orsdb2->SelectLimit($query_Recordset1) or die($orsdb2->ErrorMsg());
$totalRows_Recordset1 = $Recordset1->RecordCount();
// end Recordset

//PHP ADODB document - made with PHAkt 2.5.0
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>Special Handling Request</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">


<link href="/css/linkcolor.css" rel="stylesheet" type="text/css">
</head>

<body leftmargin="0" topmargin="0">
<div align="left">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="52" align="left" valign="top" nowrap bgcolor="#008A72">
<div align="left">
<table width="500" height="54" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="149" height="52" nowrap bgcolor="#FFFFFF"><img src="../graphics/IPCO02c.jpg" width="210" height="52"></td>
<td width="729" height="52" valign="middle" nowrap bgcolor="#008A72">
<blockquote>
<p><em><font color="#FFFFFF" size="6" face="Times New Roman, Times, serif">
<strong> Operations Request System</strong></font></em></p>
</blockquote>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr bgcolor="#333333">
<td height="22" valign="middle" nowrap bgcolor="#000000">
<table width="730" height="22" border="0" align="left" cellpadding="1" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#000000">
<tr>
<td nowrap>
<div align="center"><strong><font color="#FFFFFF">:: </font></strong><a class="one" href="../index.php"><font color="#FFFFFF">Home</font></a><font color="#FFFFFF"><strong>
::</strong></font></div>
</td>
<td nowrap>
<div align="center"><strong><font color="#FFFFFF">:: </font></strong><a class="one" href="shrform.php"><font color="#FFFFFF">S.H.R.</font></a><font color="#FFFFFF"><strong>
::</strong></font></div>
</td>
<td nowrap>
<div align="center"><strong><font color="#FFFFFF">::</font></strong>
<a class="one" href="srform.php"><font color="#FFFFFF">Scheduling
Request</font></a><font color="#FFFFFF"> <strong>::</strong></font></div>
</td>
<td nowrap>
<div align="center"></div>
</td>
<td nowrap>
<div align="center"></div>
</td>
<td nowrap>
<div align="center"><strong><font color="#FFFFFF">:: Help </font></strong><font color="#FFFFFF"><strong>::</strong></font></div>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="86" align="left" valign="top" bgcolor="#E8E8E8">
<div align="left">
<h1 align="center"><strong><font size="5"><br>
Special Handling Request </font></strong></h1>
<form action="<?php echo $editFormAction; ?>" method="POST" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Requester:</td>
<td><input type="text" name="requester_rms" value="" size="32">
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Time:</td>
<td><input type="text" name="req_time_rms" value="<?php print(date('G:i')); ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Date:</td>
<td><input type="text" name="req_date_rms" value="<?php print(date('m/d/Y')); ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Phone #:</td>
<td><input type="text" name="phone_rms" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top">Request:</td>
<td> <textarea name="request_rms" cols="50" rows="5"></textarea>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top">Other:</td>
<td> <textarea name="otherreq_rms" cols="50" rows="5"></textarea>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input name="" type="submit" value="Submit">
</td>
</tr>
</table>
<div align="left"></div>
<div align="left"></div>
<div align="left">
<input type="hidden" name="req_id_rms" value="<?php echo $HTTP_POST_VARS['req_id_rms'];?>">
</div>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
<strong> </strong>
<p> </p>
</div>
</td>
</tr>
</table>
<p> </p>
</div>
</body>
</html>
<?php
$Recordset1->Close();
?>

paulnaj

Hi crseader,

$HTTP_POST_VARS has been deprecated (see the section on predefined variables in the manual for reasons why).

Use $_POST instead.

That might be it 🙂

Paul

crseader

I have updated all the HTTP*VARS and still i am not getting the variable passed through the URL.
any other ideas???

paulnaj

Hi again,

Two poss ...

First one, did you do the $HTTP_ stuff on the 'target' page (just checking :queasy: ).

Second, I notice that early on you have the line ...

if (isset($_POST['req_id_rms'])) { 
	$colname__Recordset1 = $_POST['req_id_rms']; 
}

But what happens if isset() returns false? I ask because later on you use $POST['req_id_rms'] in the form ...

<input type="hidden" name="req_id_rms" value="<?php echo $_POST['req_id_rms'];?>">

Should that be $colname__Recordset1 instead?

Paul.

crseader

I've looked at that and i can't seem to figure it out. Is there a better way i can do this? The variable REQ_ID_RMS is an automatically generated ID from the database. I'm trying to pull that out into a URL variable to be passed to another page for Query information and viewing.

So my Question again Is there a better way this can be done?
-Cameron

paulnaj

From your code, $colname__Recordset1 doesn't change, once set, so surely you could replace $_POST['req_id_rms'] with it in value of the hidden field called 'req_id_rms'.

This assumes that -1 is a valid id ... since that's a possible value for $colname__Recordset1!

If it's not a valid value, then you're going to have to break out of this code altogether to 'obtain' a valid id.

Paul.

crseader

Yeah im going to have to break out of this code altogether because the -1 value is not a real value in the database. Infact I'm not sure what value it gets when the data is inserted. So how would you pull that kind of data out of the database if it is not set on that form anyhow? I'm guessing its not possible.
-Cameron

paulnaj

Hi again, crseader ... wasn't able to respond before now ...

Ok, the thing is, I'm sorta surprised you're having trouble with the logic since the code you're using seems pretty sophisticated (classes, modular code, etc.).

Having said that, the point is to establish clearly in your mind what you want to happen. Then, explain it step-by-step (as if to an alien).

For example ...

How would a user make it to this page at all? Is it as a result of a search? List ALL the possibilities.

What variables should be sent to the page? Knowing that means you can test for them.

What do you want to happen if things go wrong ... display a message, kill the program or what.

See how you get on.

Paul.