Re: SEARCHING for an answer...
| From: | Jason Pruim | Date: | Tue, 11 Sep 2007 19:20:13 +0000 |
| Subject: | Re: SEARCHING for an answer... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-261969@lists.php.net to get a copy of this message | ||
On Sep 11, 2007, at 2:57 PM, Jay Blanchard wrote:
There is no redirection to edit.php? You're calling PHP_SELF so it should not go anywhere else. Is there any mention of edit.php in the code?Correct. PHP_SELF refers to index.php which is the page that the search is happening on. a few lines above that there is a reference to edit.php and here is the code for it: Sorry for the long cut/paste, but I thought it was important to try and provide it in context, and the line where it says : <td><a href='edit.php?Record={$row['Record']}'>Edit</a></td> is the ONLY reference to edit.php in the entire code of that page. //Display the info using heredoc syntax echo <<<HTML <tr> <td>{$row['FName']}</td> <td>{$row['LName']}</td> <td>{$row['Add1']}</td> <td>{$row['Add2']}</td> <td>{$row['City']}</td> <td>{$row['State']}</td> <td>{$row['Zip']}</td> <td>{$row['XCode']}</td> <td>{$row['Record']}</td> <td><a href='edit.php?Record={$row['Record']}'>Edit</a></td> <td><a href='delete.php?Record={$row['Record']}'>Delete</a></td> </tr> HTML; } echo "<div class=\"nav\"><A Href=\"excelexport.php\">Export to Excel</A><BR><A href=\"logout.php\">Logout</A><BR><a href=\"add.shtml\">Add Record</A>"; echo "<P class=\"total\">Total Records: $num_rows</P></div>"; echo "</div></div>"; } $search = $_GET['search']; $self = $_SERVER['PHP_SELF']; $qstring = "SELECT * FROM current WHERE FName like '%$search%' or LName like '%$search%' or Add1 like '%$search%' or Add2 like '%$search%' or City like '%$search%' or State like '%$search%' or Zip like '%$search%' or XCode like '%$search%'"; echo $qstring; if ($search != NULL){ echo "The search string is: <strong>$search</strong>.<BR>"; echo $search; $qresult= mysql_query($link, $qstring); echo "Query completed"; } else { echo (' <form action="'.$self.'" method="get"> <label>Search: <input type="text" name="search" id="search" /> </label> <input type="submit" value="Go!" /> </form> '); }
-- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com japruim@raoset.com