||||||| Loose Data on "Top of Page" Click

Gary_Kambic

Hello,

I'm sending information through a variable $listing (using submit and Post) to another *.php page. The information displays fine when the page first appears. Since the page is long, I have a Top of Page button at the bottom. When I click this button the information displayed in $listing variable disappears.

Is their anyway to resend the the same information $listing to the same page when I click the Top of Page button?

Thanks much,

Gary

YappyDog

Well, you could make your Top of Page button a submit button on a form, and put your $listing data in a hidden field within that form. That way the data will be POSTed to the page again.

Gary_Kambic

Hey, thanks for the help.

I have a similar situation but different. The page with the Top of Page button, when completed by the viewer "Submit" calls another PHP page. If a field is left blank I have a link to return to the calling page. But, like the Top of Page situation it resets the $listing information. Now I understand that I can just put a submit post function like I did for this page.

However, I really don't want to convert all the HTML code inside my PHP script. Is their an easier way to call the submit function?

Right now I have this:

echo "YOUR E-MAIL ADDRESS MUST BE UNIQUE" . "<BR><BR>\n" . "Please Re-Enter Your E-Mail Address . . ." . "<br><br>\n" ;
echo "    " . ">  Use BACK Button to return to SCHEDULE Page  (Field Entry Information will be RETAINED)" . "<br><br>\n" ;
echo "    >  " . "<a href=\"" . $subredirectlink . "\">Click here to return to SCHEDULE Page  (Field Entry Information will be RESET)</a>";

Can I make a sub routine that is called?

This is what I need to include:

</form>

src=" would be replaced with:
<a href=\"" . $subredirectlink . "\"> I assume

Thanks much,

Gary

YappyDog

I'm not too clear on what you are asking this time.

Your form looks like it will work fine. I would add in quotes around the $listing value to be safe (in case it has any spaces). You could also use $PHP_SELF for your action to make it more generic.

Gary_Kambic

Sorry about the confusion. Here is the code for the page:

The first time I call this page the search variable ($name) is correct, meaning the name is "gary kambic", I echo the name each time the script is called. The second time when I try to update the information, (passing the $name variable to the same script to update the record information) the $name or name is "gary". For some reason it is truncating the name ($name) when I return to update the information:

Why would it be truncating the name at the space?

Thanks very much, Gary

<html>
<title>Tnevni | MySQL Display/Update Clients Table</title>
<link href="style001.css" rel="stylesheet" type="text/css">
<body>
<form method="POST" action="MySQL_client_search.php">
<input type="hidden" name="name" value=<?php print($name);?>>
<input type="hidden" name="redirectlink" value="http://www.tnevni.com/firms/MySQL_db_manipulation.htm">

echo "name: " . "$name <br>";

$user="tnevni";
$password="terraka";
$database="tnevni";
mysql_connect(mysqldb,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);

$query = "SELECT * FROM clients WHERE agent_name = '$name'";
$result=mysql_query($query);
$id = mysql_result($result,$i,"id");

if ($update_agent_name != "") {
$query="UPDATE clients WHERE id='$id' SET agent_name='$update_agent_name'";
mysql_query($query);
$name = $update_agent_name;
$update_agent_name = ""; }

if ($update_agency_name != "") {
$query="UPDATE clients WHERE id='$id' SET agency_name='$update_agency_name'";
mysql_query($query);
$update_agency_name = ""; }

additional field updates

if ($name == "") {
echo "Please Enter Valid AGENT NAME . . . ";
echo "<a href=\"" . $redirectlink . "\">RETURN to MySQL Data Base</a><br>";
echo "<br><br><HR width=\"100%\" color=blue>";
mysql_close();
return;
}

$name = strtolower($name);
$query="SELECT * FROM clients";
$result=mysql_query($query);
$num=mysql_numrows($result);
$status = "no";

$i=0;

while ($i < $num) {
$name_table = mysql_result($result,$i,"agent_name");
$name_table = strtolower($name_table);

if ($name_table == $name) {
$status = "yes";
$id = mysql_result($result,$i, "id");
$i = $num; }
else
++$i;
}

if ($status == "no") {
echo "Agent Name: NOT FOUND . . . ";
echo "<a href=\"" . $redirectlink . "\">RETURN to MySQL Data Base</a><br>";
echo "<br><br><HR width=\"100%\" color=blue>";
mysql_close();
return; }

$query = "SELECT * FROM clients WHERE id ='$id'";
$result=mysql_query($query);

$agency_name=mysql_result($result,$i2,"agency_name");

additional updates

mysql_close();

/ insert comment here /

?>
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="24" colspan="5" align="center" valign="middle"><font size="3" face="Verdana, Arial, Helvetica, sans-serif">DATA BASE CLIENTS
| SEARCH/UPDATE</font></td>

</tr>

output values

YappyDog

I'm pretty sure it is truncating the name because you don't have quotes around your value. It should look like this:

Gary_Kambic

Thanks, that worked fine. Always good to have an outside perspective when it comes to code.

The only problem I seem to be having is that my data base is not being updated. After I find the record with the $name field, I enter a new city (for example) and click submit. This should update the agency_city in the data base with the new city and then display all my fields once again. Well, I checked my data base and the city field is not being updated. Am I missing something where I UPDATE the fields?

Thanks again, Gary

echo "name: " . "$name <br>";

/-- Data Base Commands --/
$user="tnevni";
$password="terraka";
$database="tnevni";
mysql_connect(mysqldb,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);

/-- Begin Data Base Search for Agent Name --/
$name = strtolower($name);
$query="SELECT * FROM clients";
$result=mysql_query($query);
$num=mysql_numrows($result);
$status = "no";

$i=0;

while ($i < $num) {
$name_table = mysql_result($result,$i,"agent_name");
$name_table = strtolower($name_table);

if ($name_table == $name) {
$status = "yes";
$id = mysql_result($result,$i,"id");
$agency_name=mysql_result($result,$i,"agency_name");
$agency_telephone=mysql_result($result,$i,"agency_telephone");
$agency_telephone_800=mysql_result($result,$i,"agency_telephone_800");
$agency_fax=mysql_result($result,$i,"agency_fax");
$agency_address_1=mysql_result($result,$i,"agency_address_1");
$agency_address_2=mysql_result($result,$i,"agency_address_2");
$agency_city=mysql_result($result,$i,"agency_city");
$agency_state=mysql_result($result,$i,"agency_state");
$agency_postal_code=mysql_result($result,$i,"agency_postal_code");
$agency_website_url=mysql_result($result,$i,"agency_website_url");
$agent_name=mysql_result($result,$i,"agent_name");
$agent_direct_line=mysql_result($result,$i,"agent_direct_line");
$agent_mobile_line=mysql_result($result,$i,"agent_mobile_line");
$agent_other_line=mysql_result($result,$i,"agent_other_line");
$agent_email_current=mysql_result($result,$i,"agent_email_current");
$agent_email_new=mysql_result($result,$i,"agent_email_new");
$web_host_name=mysql_result($result,$i,"web_host_name");
$web_host_userid=mysql_result($result,$i,"web_host_userid");
$web_host_password=mysql_result($result,$i,"web_host_password");
$i2 = $i;
$i = $num; }
else
++$i;
}

echo "status:" . "$status <br>";
echo "name:" . "$name <br>";
echo "name_table:" . "$name_table <br>";
echo "i2:" . "$i2 <br>";
echo "id:" . "$id <br>";

/-- If Status Not Found - Send Error Message --/
if ($status == "no") {
echo "Agent Name: NOT FOUND . . . ";
echo "<a href=\"" . $redirectlink . "\">RETURN to MySQL Data Base</a><br>";
echo "<br><br><HR width=\"100%\" color=blue>";
mysql_close();
return; }

/-- If Status Found - Query/Update Agent Information --/
/$query = "SELECT FROM clients WHERE agent_name = '$name'";
$result=mysql_query($query);
$id = mysql_result($result,$i2,"id"); */

if ($update_agent_name != "") {
$query="UPDATE clients WHERE id='$id' SET agent_name='$update_agent_name'";
mysql_query($query);
$name = $update_agent_name;
$update_agent_name = ""; }

if ($update_agency_name != "") {
$query="UPDATE clients WHERE id='$id' SET agency_name='$update_agency_name'";
mysql_query($query);
$update_agency_name = ""; }

if ($update_agency_telephone != "") {
$query="UPDATE clients WHERE id='$id' SET agency_telephone='$update_agency_telephone'";
mysql_query($query);
$update_agency_telephone = ""; }

if ($update_agency_telephone_800 != "") {
$query="UPDATE clients WHERE id='$id' SET agency_telephone_800='$update_agency_telephone_800'";
mysql_query($query);
$update_agency_telephone_800 = ""; }

if ($update_agency_fax != "") {
$query="UPDATE clients WHERE id='$id' SET agency_fax='$update_agency_fax'";
mysql_query($query);
$update_agency_fax = ""; }

if ($update_agency_address_1 != "") {
$query="UPDATE clients WHERE id='$id' SET agency_address_1='$update_agency_address_1'";
mysql_query($query);
$update_agency_address_1 = ""; }

if ($update_agency_address_2 != "") {
$query="UPDATE clients WHERE id='$id' SET agency_address_2='$update_agency_address_2'";
mysql_query($query);
$update_agency_address_2 = ""; }

/ ----------------------- Checking City Field Below -----------------/

if ($update_agency_city != "") {
echo "city:" . "$update_agency_city <br>";
$query="UPDATE clients WHERE id='$id' SET agency_city='$update_agency_city'";
mysql_query($query);
$update_agency_city = ""; }

/ ------------------------------- End City Section -------------------- /

if ($update_agency_state != "") {
$query="UPDATE clients WHERE id='$id' SET agency_state='$update_agency_state'";
mysql_query($query);
$update_agency_state = ""; }

if ($update_agency_postal_code != "") {
$query="UPDATE clients WHERE id='$id' SET agency_postal_code='$update_agency_postal_code'";
mysql_query($query);
$update_agency_postal_code = ""; }

if ($update_agency_website_url != "") {
$query="UPDATE clients WHERE id='$id' SET agency_website_url='$update_agency_website_url'";
mysql_query($query);
$update_agency_website_url = ""; }

if ($update_agent_direct_line != "") {
$query="UPDATE clients WHERE id='$id' SET agent_direct_line='$update_agent_direct_line'";
mysql_query($query);
$update_agent_direct_line = ""; }

if ($update_agent_mobile_line != "") {
$query="UPDATE clients WHERE id='$id' SET agent_mobile_line='$update_agent_mobile_line'";
mysql_query($query);
$update_agent_mobile_line = ""; }

if ($update_agent_other_line != "") {
$query="UPDATE clients WHERE id='$id' SET agent_other_line='$update_agent_other_line'";
mysql_query($query);
$update_agent_other_line = ""; }

if ($update_agent_email_current != "") {
$query="UPDATE clients WHERE id='$id' SET agent_email_current='$update_agent_email_current'";
mysql_query($query);
$update_agent_email_current = ""; }

if ($update_agent_email_new != "") {
$query="UPDATE clients WHERE id='$id' SET agent_email_new='$update_agent_email_new'";
mysql_query($query);
$update_agent_email_new = ""; }

if ($update_agent_web_host_name != "") {
$query="UPDATE clients WHERE id='$id' SET agent_web_host_name='$update_agent_web_host_name'";
mysql_query($query);
$update_agent_web_host_name = ""; }

if ($update_agent_web_host_userid != "") {
$query="UPDATE clients WHERE id='$id' SET agent_web_host_userid='$update_agent_web_host_userid'";
mysql_query($query);
$update_agent_web_host_userid = ""; }

if ($update_agent_web_host_password != "") {
$query="UPDATE clients WHERE id='$id' SET agent_web_host_password='$update_agent_web_host_password'";
mysql_query($query);
$update_agent_web_host_password = ""; }

mysql_close();

<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="24" colspan="5" align="center" valign="middle"><font size="3" face="Verdana, Arial, Helvetica, sans-serif">DATA BASE CLIENTS
| SEARCH/UPDATE</font></td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="middle"> </td>
</tr>
<tr>
<td height="19" align="center" valign="middle" class="borderall"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">DESCRIPTION</font></td>
<td width="11" align="center" valign="middle"> </td>
<td align="center" valign="middle" class="borderall"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">CURRENT</font></td>
<td width="11" align="center" valign="middle" class="bordertop1"></td>
<td align="center" valign="middle" class="borderall"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">UPDATE</font></td>
</tr>
</table>

YappyDog

Looks like the format of your update statement is a bit out of order. It should be

Update myTable Set myColumn = 'something' Where ID = $id

The Where clause is after the Set part

So this:
$query="UPDATE clients WHERE id='$id' SET agent_name='$update_agent_name'";

Would become this:
$query="UPDATE clients SET agent_name='$update_agent_name' WHERE id='$id' ";

Gary_Kambic

Hey, it works great! Thanks for all your help. Take care, Gary