php form
Posted: Tue Aug 09, 2005 12:00 am
ok i know how much PHP guys hate Dreamweaver but for some reason the form is not querying the variables..... here is the code:ex of the form at http://www.nightspotz.com/testsearch.php DW is easier for me right now im in the process of learning PHP with MySQL more SORRY forgive me......
and here's how my table in the database is set up:
Code: Select all
<?php require_once('../Connections/connNightspotz.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_rsSRCH = 10;
$pageNum_rsSRCH = 0;
if (isset($_GET['pageNum_rsSRCH'])) {
$pageNum_rsSRCH = $_GET['pageNum_rsSRCH'];
}
$startRow_rsSRCH = $pageNum_rsSRCH * $maxRows_rsSRCH;
$AC_rsSRCH = "1";
if (isset($_POST['areacode'])) {
$AC_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['areacode'] : addslashes($_POST['areacode']);
}
$VN_rsSRCH = "2";
if (isset($_POST['venuename'])) {
$VN_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['venuename'] : addslashes($_POST['venuename']);
}
$VT_rsSRCH = "3";
if (isset($_POST['venuetype'])) {
$VT_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['venuetype'] : addslashes($_POST['venuetype']);
}
$AG_rsSRCH = "4";
if (isset($_POST['agegroup'])) {
$AG_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['agegroup'] : addslashes($_POST['agegroup']);
}
$MT_rsSRCH = "5";
if (isset($_POST['musictype'])) {
$MT_rsSRCH = (get_magic_quotes_gpc()) ? $_POST['musictype'] : addslashes($_POST['musictype']);
}
mysql_select_db($database_connNightspotz, $connNightspotz);
//-----this is the correction-----------
$query_rsSRCH = sprintf ("SELECT * FROM venues");
if (!empty($_POST['venuename']))
{
$sql .= " and VT = '" . $_POST['venuename']."' ";
}
if (!empty($_POST['areacode']))
{
$sql .= " and AC = '" . $_POST['areacode']."' ";
}
if (!empty($_POST['venuetype']))
{
$sql .= " and VT= '" . $_POST['venuetype']."' ";
}
if (!empty($_POST['agegroup']))
{
$sql .= " and AG = '" . $_POST['agegroup']."' ";
}
if (!empty($_POST['musictype']))
{
$sql .= " and MT = '" . $_POST['musictype']."' ";
}
//-------------------------------------------
$query_limit_rsSRCH = sprintf("%s LIMIT %d, %d", $query_rsSRCH, $startRow_rsSRCH, $maxRows_rsSRCH);
$rsSRCH = mysql_query($query_limit_rsSRCH, $connNightspotz) or die(mysql_error());
$row_rsSRCH = mysql_fetch_assoc($rsSRCH);
if (isset($_GET['totalRows_rsSRCH'])) {
$totalRows_rsSRCH = $_GET['totalRows_rsSRCH'];
} else {
$all_rsSRCH = mysql_query($query_rsSRCH);
$totalRows_rsSRCH = mysql_num_rows($all_rsSRCH);
}
$totalPages_rsSRCH = ceil($totalRows_rsSRCH/$maxRows_rsSRCH)-1;
$queryString_rsSRCH = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsSRCH") == false &&
stristr($param, "totalRows_rsSRCH") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsSRCH = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsSRCH = sprintf("&totalRows_rsSRCH=%d%s", $totalRows_rsSRCH, $queryString_rsSRCH);
$queryString_rsSrch = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsSrch") == false &&
stristr($param, "totalRows_rsSrch") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsSrch = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rsSrch = sprintf("&totalRows_rsSrch=%d%s", $totalRows_rsSrch, $queryString_rsSrch);
?>
<?php
$query_venues = "DELETE FROM venue";
mysql_query($query_venue,$srch);
?>and here's how my table in the database is set up:
Code: Select all
<table name="venues">
<fields>
<field name="v_nID" size="5" scale="0" type="int" auto_increment="auto_increment" key="PRI" default="" null="" />
<field name="venuename" size="50" scale="0" type="varchar" key="" default="" null="" />
<field name="address" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="city" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="state" size="50" scale="0" type="varchar" key="" default="" null="" />
<field name="zipcode" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="country" size="50" scale="0" type="varchar" key="" default="" null="" />
<field name="areacode" size="3" scale="0" type="char" key="" default="" null="" />
<field name="phonenumber" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="faxnumber" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="email" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="website" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="venuetype" size="200" scale="0" type="varchar" key="" default="" null="" />
<field name="agegroup" size="10" scale="0" type="varchar" key="" default="" null="" />
<field name="musictype" size="250" scale="0" type="varchar" key="" default="" null="" />
<field name="dresscode" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="payment" size="100" scale="0" type="varchar" key="" default="" null="" />
<field name="venuelogo" type="blob" key="" default="" null="" />
</fields>
</table>