Click Link - Display Record - Need Help

tanaka99

I have a search box ... when I enter a dealer name (or partial), I get a list of dealers ... I've hyperlinked the dealer name because when someone clicks on the link I want the appropriate dealer record displayed.

I've got it up to the display with hyperlink, but cannot figure how to get the record to display when the link is clicked ... Here is my existing code:

<?php

if ($DlrAccess == 888) {
	 $searchedit = $HTTP_POST_VARS['searchedit'];
	 if (strlen($searchedit) < 1) $searchedit = $HTTP_POST_VARS['searchedit'];

session_register("searchedit");
$searchedit = $HTTP_POST_VARS['searchedit'];

?>

<body onLoad="document.edit1.edituser.focus()">

<table width="760" border="0" cellspacing="0" cellpadding="5" background="images/common/logoback.jpg">
<tr><td colspan="2" valign="top">
<font face="Verdana,Geneva,Arial,Helvetica,sans-serif" size="-2"><b><a href="index.php">Home</a> > Select User To Edit<br></b></font><p align=center>
<font face="verdana,Arial" color=#000000 size=4>Tanaka's Partner Area - EDIT USER INFORMATION</font><br>
<form action="http://www.tkandaa.com/index.php?d=5&t=1&b=edit1" name=edit1 method="post">

<table width=480 border=5 cellpadding=5 align=center background="images/common/logoback.jpg">
<tr><td bgcolor=#EE7218 align=center>
<font face="verdana,Arial" color=#000000 size=2><b>Enter UserID to Edit<b></font></td></tr>

<tr><td align=center>
<font face="verdana,Arial" color=#000000 size=2>UserID:</font>
&nbsp;<input type="text" name="searchedit" size="10" maxsize="15">

&nbsp;&nbsp;&nbsp;<input type="submit" value="See User">&nbsp;&nbsp;<input type="reset" value="Clear">
</td></tr>
</table>
<br><br>


<br>

<?php

include("dbinfo.inc.php");

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

  $query = "SELECT * FROM Dealers WHERE DlrName LIKE '$searchedit%'";

  $result=mysql_query($query);
  $num=mysql_numrows($result);

$i=0;

echo "<table border=\"2\" align=\"center\"><tr valign=\"middle\" align=\"center\"><td bgcolor=\"#c0c0c0\"><font size=2><b>User Name</b></td><td bgcolor=\"#c0c0c0\"><font size=2><b>User City</b></td><td bgcolor=\"#c0c0c0\"><font size=2><b>User ID</b></td><td bgcolor=\"#c0c0c0\"><font size=2><b>Dlr Number</b></td></tr>";


while ($i < $num) {

$EditName=mysql_result($result,$i,"DlrName");
$EditCity=mysql_result($result,$i,"DlrCity");
$EditID=mysql_result($result,$i,"UserID");
$EditNumber=mysql_result($result,$i,"DlrNumber");

echo "<tr align=\"left\" valign=\"top\"><td><font size=2><a href=\"\">$EditName</a></td><td><font size=2>$EditCity</td><td align=\"right\"><font size=2>$EditID</td><td align=\"center\"><font size=2>$EditNumber</td></tr>";

++$i;
}

echo "</table><br><font size=\"2\" face=|\"verdana,arial\"><br><br><br>";

}

?>

</body>
</html>

Mordecai

[php] and [/php] are your friend.

tanaka99

Is the above post helping me in any way?

Mordecai

It's helping you help yourself (cheesy but true).

Please put all code inside those tags if you want it to be color-coded and in a fixed-width font. It will make it much easier for others, and yourself, to read.

Mordecai

echo "<tr align=\"left\" valign=\"top\"><td><font size=2><a href=\"\">$EditName</a></td><td><font size=2>$EditCity</td><td align=\"right\"><font size=2>$EditID</td><td align=\"center\"><font size=2>$EditNumber</td></tr>";
This is the line which prints the link, correct? It doesn't go anywhere. The href argument is entirely blank. Are you having problems with finding out what to put inside of this?

azrath

You need to create an 'edit' page, which populates a form with the appropriate record data and lets the user save any changes.

Your record row will look like:

echo "<tr align=\"left\" valign=\"top\"><td><font size=2><a href=\"edit_record.php?id=<?=$EditID?>\">$EditName</a></td><td><font size=2>$EditCity</td><td align=\"right\"><font size=2>$EditID</td><td align=\"center\"><font size=2>$EditNumber</td></tr>";

edit_record.php will select the record referred to by id and display it in the form. Also, you have combined GET and POST methods in your form. Instead of

<form action="http://www.tkandaa.com/index.php?d=5&t=1&b=edit1" name=edit1 method="post">

you will probably want:

<form action="http://www.tkandaa.com/index.php" name=edit1 method="post">
<input type="hidden" name="t" value="5">
<!-- ... etc, same for other fields -->

tanaka99

Perfect. Thanks a million.

tanaka99

Here's the error I get:

Warning: Failed opening 'dealers/editselect?id=paul.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site89/fst/var/www/html/index.php on line 113

Here's my code:

<?php

if ($DlrAccess == 888) {
	 $searchedit = $HTTP_POST_VARS['searchedit'];
	 if (strlen($searchedit) < 1) $searchedit = $HTTP_POST_VARS['searchedit'];

session_register("searchedit");
$searchedit = $HTTP_POST_VARS['searchedit'];

?>

<body onLoad="document.edit1.edituser.focus()">

<table width="760" border="0" cellspacing="0" cellpadding="5" background="images/common/logoback.jpg">
<tr><td colspan="2" valign="top">
<font face="Verdana,Geneva,Arial,Helvetica,sans-serif" size="-2"><b><a href="index.php">Home</a> > Select User To Edit<br></b></font><p align=center>
<font face="verdana,Arial" color=#000000 size=4>Tanaka's Partner Area - EDIT USER INFORMATION</font><br>
<form action="http://www.tanaka-usa.com/index.php?d=5&t=1&b=edit1" name=edit1 method="post">

<table width=480 border=5 cellpadding=5 align=center background="images/common/logoback.jpg">
<tr><td bgcolor=#EE7218 align=center>
<font face="verdana,Arial" color=#000000 size=2><b>Enter UserID to Edit<b></font></td></tr>

<tr><td align=center>
<font face="verdana,Arial" color=#000000 size=2>UserID:</font>
&nbsp;<input type="text" name="searchedit" size="10" maxsize="15">

&nbsp;&nbsp;&nbsp;<input type="submit" value="See User">&nbsp;&nbsp;<input type="reset" value="Clear">
</td></tr>
</table>
<br><br>


<?php
}
?>

</body>
</html>

-------------------------------

and editselect.php

<?php 
include("dbinfo.inc.php");

$EditID = $HTTP_POST_VARS['searchedit'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$sql1 = "SELECT * FROM Dealers WHERE UserID='$EditID'";


$result = mysql_query($sql1)
	or die ("Unable to get results.");

$num = mysql_numrows($result)
	or die ("Bad UserID, try again.");

$i=0;
while ($i < $num) {


$EditID=mysql_result($result,$i,"UserID");

$EditName=mysql_result($result,$i,"DlrName");

$EditAddress=mysql_result($result,$i,"DlrAddress");

$EditCity=mysql_result($result,$i,"DlrCity");

$EditState=mysql_result($result,$i,"DlrState");

$EditZip=mysql_result($result,$i,"DlrZip");

$EditPhone=mysql_result($result,$i,"DlrPhone");

$EditType=mysql_result($result,$i,"DlrType");

$EditEmail=mysql_result($result,$i,"DlrEmail");

$EditWeb=mysql_result($result,$i,"DlrWeb");

$EditPass=mysql_result($result,$i,"DlrPass");

$EditAccess=mysql_result($result,$i,"DlrAccess");

$EditNumber=mysql_result($result,$i,"DlrNumber");

$EditDist=mysql_result($result,$i,"DlrDist");



++$i;
}

$temp = $DlrAccess;
?>


<HTML> 
<HEAD><TITLE>Edit User Information</TITLE></HEAD>

<body onLoad="document.Deletedealer.DeleteName.focus()">

<table border=0 width=760 cellpadding=2 background="images/common/logoback.jpg">
<tr><td colspan="2" valign="top">
<font face="Verdana,Geneva,Arial,Helvetica,sans-serif" size="-2"><b><a href="index.php">Home</a> > <a href="index.php?d=5&d=5&t=1&b=login2"><?=$DlrName?></a> > Edit Partner Area User
</td></tr></table>

<table border="0" cellpadding="0" width="760" background="images/common/logoback.jpg">
<tr>

<td nowrap align="left" valign="top" width=130><br>

<?php
if ($DlrAccess == "888") { 
  			include ("888.inc");
    } elseif ($DlrAccess == "601") { 
            include ("601.inc");
	} elseif ($DlrAccess == "701") { 
            include ("701.inc");
    } elseif ($DlrAccess == "801") { 
            include ("801.inc");
    } elseif ($DlrAccess == "901") { 
			include ("901.inc");
} 
?>
</td>

<td align=center><br>
<form action="index.php?d=5&t=1&b=editdealer" method="post" name="editdealer">

<table border=0>
<tr><td align=center colspan=3>
<font color=#ee7218 face=verdana,arial><h3>EDIT PARTNER AREA USER</h3></font><br>
</td></tr>
<tr><td align=right valign=middle><input type="hidden" size="10" name="DeleteID" value="<?=$EditID?>"><font size=2 face=verdana,arial></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Name:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="20" name="EditName" value="<?=$EditName?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Address:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="25" name="EditAddress" value="<?=$EditAddress?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>City:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="20" name="EditCity" value="<?=$EditCity?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>State:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="3" name="EditState" value="<?=$EditState?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Zip:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="10" name="EditZip" value="<?=$EditZip?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Phone:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="15" name="EditPhone" value="<?=$EditPhone?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Type:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="3" name="EditType" value="<?=$EditType?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>E-mail:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="25" name="EditEmail" value="<?=$EditEmail?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Web:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="30" name="EditWeb" value="<?=$EditWeb?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Dist:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="6" name="EditDist" value="<?=$EditDist?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Access:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="4" name="EditAccess" value="<?=$EditAccess?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>ID:&nbsp;&nbsp;</td>
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="12" name="EditID" value="<?=$EditID?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Password:&nbsp;&nbsp;<br><br></td> 
<td align=left valign=middle><font size=2 face=verdana,arial color="green"><input type="text" size="12" name="EditPass" value="<?=$EditPass?>"><br><br></td><td align=left>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="Delete User"><br><br></td></tr>
</table>
</FORM> 
</BODY> 
</HTML> 

</td></tr></table>

<?php
?>

kevinsequeira

well it should be

dealers/editselect.php?id=paul

not

dealers/editselect?id=paul.php

reg
kevin

tanaka99

and editdealer:

<?php 
include("dbinfo.inc.php");


mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$sql1 = "SELECT * FROM Dealers WHERE UserID='$edituser'";


$result = mysql_query($sql1)
	or die ("Unable to get results.");

$num = mysql_numrows($result)
	or die ("Bad UserID, try again.");

$i=0;
while ($i < $num) {

session_register("UserID");
$EditID=mysql_result($result,$i,"UserID");
session_register("DlrName");
$EditName=mysql_result($result,$i,"DlrName");
session_register("DlrAddress");
$EditAddress=mysql_result($result,$i,"DlrAddress");
session_register("DlrCity");
$EditCity=mysql_result($result,$i,"DlrCity");
session_register("DlrState");
$EditState=mysql_result($result,$i,"DlrState");
session_register("DlrZip");
$EditZip=mysql_result($result,$i,"DlrZip");
session_register("DlrPhone");
$EditPhone=mysql_result($result,$i,"DlrPhone");
session_register("DlrType");
$EditType=mysql_result($result,$i,"DlrType");
session_register("DlrEmail");
$EditEmail=mysql_result($result,$i,"DlrEmail");
session_register("DlrWeb");
$EditWeb=mysql_result($result,$i,"DlrWeb");
session_register("DlrPass");
$EditPass=mysql_result($result,$i,"DlrPass");
session_register("DlrAccess");
$EditAccess=mysql_result($result,$i,"DlrAccess");
session_register("DlrNumber");
$EditNumber=mysql_result($result,$i,"DlrNumber");
session_register("DlrDist");
$EditDist=mysql_result($result,$i,"DlrDist");



++$i;
}

$temp = $DlrAccess;
?>
<HTML> 
<HEAD><TITLE>Edit User Information</TITLE></HEAD><BODY> 

<body onLoad="document.editdealer.EditName.focus()">

<table border=0 width=760 cellpadding=2 background="images/common/logoback.jpg">
<tr><td colspan="2" valign="top">
<font face="Verdana,Geneva,Arial,Helvetica,sans-serif" size="-2"><b><a href="index.php">Home</a> > <a href="index.php?d=5&t=1"><?=$DlrName?></a> > Edit Partner Area User
</td></tr></table>

<table border="0" cellpadding="0" width="760" background="images/common/logoback.jpg">
<tr>

<td nowrap align="left" valign="top" width=130>

<font face="Verdana,Geneva,Arial,Helvetica,sans-serif">
<br>
<font size=1><a href="http://www.tanaka-usa.com/index.php?d=5&t=1&b=login">Main Page</a><br>
<font size=1><a href="index.php?d=5&t=1&b=parts_pricesNEW">Parts Prices</a><br>
<font size=1><a href="index.php?d=5&t=1&b=registrationNEW">Register Products</a><br>
<font size=1><a href="index.php?d=5&t=1&b=claimNEW">Warranty Claims</a><br>
<font size=1><a href="index.php?d=5&t=1&b=literatureNEW">Service Literature</a><br>
<font size=1><a href="index.php?d=5&t=1&b=dlrchangeNEW">Dealer Profile</a><br>
<font size=1><a href="index.php?d=5&t=1&b=marketingNEW">Sales & Marketing</a><br>
<font size=1><a href="http://www.tanaka-usa.com/DevBB/">Discussion Forum</a><br>
<font size=1><a href="index.php?d=5&t=1&b=shopfirstNEW">Order Parts</a><br>
<font size=1><a href="index.php?d=5&t=1&b=upstrackNEWfirst">UPS Tracking</a><br>
<font size=1><a href="index.php?d=5&t=1&b=suggestNEW">Suggestion Box</a><br>
<font size=1><a href="index.php?d=5&t=1&b=testimonyNEW">Testimonials</a><br>
<font size=1><a href="mailto:custsvc@tanaka-ism.com">Website Feedback</a><br>
<font size=1><a href="index.php?d=5&t=1&b=logoffNEW">Logoff</a><br>
</font>
</td>

<td align=center><br>
<form action="updated.php" method="post">
<table border=0>
<tr><td align=center colspan=3>
<font color=#ee7218 face=verdana,arial><h3>EDIT A USER OF THE PARTNER AREA</h3></font><br>
</td></tr>
<tr><td align=right valign=middle><input type="hidden" size="10" name="EditID" value="<?=$EditID?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Name:</td>
<td align=left valign=middle><input type="text" size="25" name="EditName" value="<?=$EditName?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Address:</td>
<td align=left valign=middle><input type="text" size="40" name="EditAddress" value="<?=$EditAddress?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>City:</td>
<td align=left valign=middle><input type="text" size="20" name="EditCity" value="<?=$EditCity?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>State:</td>
<td align=left valign=middle><input type="text"  size="2" name="EditState" value="<?=$EditState?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Zip:</td>
<td align=left valign=middle><input type="text" size="10" name="EditZip" value="<?=$EditZip?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Phone:</td>
<td align=left valign=middle><input type="text" size="15" name="EditPhone" value="<?=$EditPhone?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Type:</td>
<td align=left valign=middle><input type="text" size="2" name="EditType" value="<?=$EditType?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>E-mail:</td>
<td align=left valign=middle><input type="text" size="25" name="EditEmail" value="<?=$EditEmail?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Web:</td>
<td align=left valign=middle><input type="text" size="25" name="EditWeb" value="<?=$EditWeb?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Dist:</td>
<td align=left valign=middle><input type="text" size="6" name="EditDist" value="<?=$EditDist?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Access:</td>
<td align=left valign=middle><input type="text" size="3" name="EditAccess" value="<?=$EditAccess?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>ID:</td>
<td align=left valign=middle><input type="text" max="8" size="10" name="EditID" value="<?=$EditID?>"></td></tr>
<tr><td align=right valign=middle><font size=2 face=verdana,arial>Password:<br><br></td> 
<td align=left valign=middle><input type="text" size="12" max="10" name="EditPass" value="<?=$EditPass?>"><br><br></td><td align=left><input type="submit" value="Edit User"><br><br></td></tr>
</table>
</FORM> 
</BODY> 
</HTML> 
</td></tr></table>
<?php
?>

tanaka99

Looks like the problem is in the passing of the 'ID' variable in the link to editdealer.

tanaka99

If I add .php to editselect ... it jumps to my home page which is the default action for all dead links on my site. The site is encased in an index.php script ...

in the address below, the d=5 indicates the folder and the t=1 indicates a php file extension. The editselect (without the .php) indicates filename. If I add the .php extension like below, it cannot recognize the address.

http://www.tanaka-usa.com/index.php?d=5&t=1&b=editselect.php?id=paul