The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
mysql query from a cmps module
I already posted this on the vbadvanced forums but I know there are a lot of smart people on this forum so I thought I would post it here as well...
I have a cmps template module that calls a plugin that points to a php page.....and the php file contains a search form that returns the results from a mysql database... Here's the php file code: Code:
<p>If you would like to add information or have found incorrect information...please <a href="http://www.wheelsup.org/sendmessage.php">suggest an update for this database</a>... </p> <form action="?" method="GET"> <table border="0" id="table1" cellspacing="0" cellpadding="0" width="0"> <tr> <td colspan="2"> <strong>Search for Manufacturer Name or Aircraft</strong> (<em>search in development and may not work</em>) <br /> *Tip - searching for "vans" will not return "van's", but searching for "van" will... </td> </tr> <tr> <td> <input type="hidden" name="page" value="acmfg"> <input name="searchphrase" type="text" size="40" value="<?=$searchphrase?>"> <input type="submit" value="Search"> <a href="http://www.wheelsup.org/windex.php?page=acmfg">Reset and Show All</a></td> </tr> </table> </form> <hr size="1"> <hr size="1"> </br> <? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $searchphrase=$HTTP_GET_VARS['searchphrase'] ; $query="SELECT * FROM mfg where name like '%$searchphrase%' or aircraft like '%$searchphrase%' ORDER BY name ASC"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); ?> <? $i=0; while ($i < $num) { $name=mysql_result($result,$i,"name"); $url=mysql_result($result,$i,"url"); $phone=mysql_result($result,$i,"phone"); $aircraft=mysql_result($result,$i,"aircraft"); $forum=mysql_result($result,$i,"forum"); ?> <b><? echo "$name"; ?></b><br /> <? echo "URL: <a href=http://www.$url target=_blank> http://www.$url</a>"; ?><br /> <? echo "Phone: $phone"; ?><br /> <? echo "Aircraft: $aircraft"; ?><br /> <? echo "Forum: <a href=$forum> $forum</a>"; ?></a><br /> <hr size="1"> <? ++$i; } ?> http://www.wheelsup.org/modules/acmfg.php However, if you open the cmps page that includes the module that calls the file the search does not work: http://www.wheelsup.org/windex.php?page=acmfg When I perform the search the URL looks correct but it returns everything as if the query string is being stripped somehow... Any help would be greatly appreciated! -Bill |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|