RE: Looking for help with forms/variables and an array!

"BSumrall" <Brads@xxxxxxxxx> · Tue, 12 Jun 2007 22:20:29 -0400

  _____  

From: BSumrall [mailto:Brads@xxxxxxxxx] 
Sent: Tuesday, June 12, 2007 8:46 PM
To: 'Jim Lucas'
Cc: 'php-general@xxxxxxxxxxxxx'
Subject: RE:  Looking for help with forms/variables and an array!

I had done that before,

But here it goes again because I have learned a little bit more

-> establish db connect

-> drop down box stores result as a variable

-> first initial query performed

-> query array established

-> drop down box 2 is saved as a variable

-> variable 2 filters query 1

-> display one record at a time

Here is what I have right now. It is error free, just doest work, all I have
done change some variables and not even bothering with record set 2 yet

Anything in bold is what I have played with since it would pull every
record, just not filter and now does not work.

Brad

<?php require_once('connections/ftn.php'); ?>

<?php

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Recordset1 = 1;

$pageNum_Recordset1 = 0;

if (isset($_GET['pageNum_Recordset1'])) {

  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];

}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_ftn, $ftn);

@extract($_POST);

$query_Recordset1 = "SELECT * FROM lstng_tbl WHERE price_range = '$state'";

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1,
$startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $ftn) or
die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {

  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];

} else {

  $all_Recordset1 = mysql_query($query_Recordset1);

  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);

}

$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";

if (!empty($_SERVER['QUERY_STRING'])) {

  $params = explode("&", $_SERVER['QUERY_STRING']);

  $newParams = array();

  foreach ($params as $param) {

    if (stristr($param, "pageNum_Recordset1") == false && 

        stristr($param, "totalRows_Recordset1") == false) {

      array_push($newParams, $param);

    }

  }

  if (count($newParams) != 0) {

    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));

  }

}

$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s",
$totalRows_Recordset1, $queryString_Recordset1);

?>

<body>

<form id="form1" name="form1" method="post" action="index_dev2.php">

        <label>market

           <select name="states">

                     <OPTION value="IN">Indiana</OPTION>

                     <OPTION value="WI">Wisconsin</OPTION>

                     <OPTION value="IL">Illinois</OPTION>

                     <OPTION value="MI">Michigan</OPTION>

                     <OPTION value="GA">Georgia</OPTION>

                     <OPTION value="FL">Florida</OPTION>

                     </select>

        </label>

   </form>

<?php 

  if ($states=="value" || !isset($states)) echo "selected"; 

?>

            <br>

<form id="form2" name="form2" method="post" action="index_dev2.php">

        <label>price_range

            <select name="price">

                     <OPTION value="1">Over $2 million</OPTION>

                     <OPTION value="2">$1 million - $2 million</OPTION>

                     <OPTION value="3">$750,000 - $1 million</OPTION>

                     <OPTION value="4">under $750,000</OPTION>

              </select>

         <input name="submit" type="submit" value="post"/>

         </label>

 </form>

<?php 

  if ($price=="value"|| !isset($price)) echo "selected"; 

?>

  <?php do { ?>

-----Original Message-----
From: Jim Lucas [mailto:lists@xxxxxxxxx] 
Sent: Tuesday, June 12, 2007 8:26 PM
To: BSumrall
Cc: php-general@xxxxxxxxxxxxx
Subject: Re:  Looking for help with forms/variables and an array!

Are you wanting to setup some sorta pagination, or just get the results from
the DB limited by the 

selected option in the form?

oh, where is your second form in this example?

In pseudo code, write out what you are attempting to do?

-- 

Jim Lucas

    "Some men are born to greatness, some achieve greatness,

        and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V

     by William Shakespeare