PHP - Form Select With Binary Options

I'm doing a site for a used vehicles company.  I have a "searchbar" with the following select options:  the first one is to search per vehicle manufacturer (ex. BMW).
The second one is for a price range (ex. any - $1 000 000). the third is per mileage (ex. any - 150 000). and the last one is per model (ex. 320).

All of them are structured as drop-down selectors except for the last one "model" which is has a input type text.  Here is what I struggle with... When I choose a manufacturer and click search then I get the desired results.  But as-soon as I choose a value from the price or mileage or model I get all the values from the manufacturer, but it doesn't filter what I have chosen.

Can you please help me....  Thank you

Here is the code for the searchbar.php:
Code: [Select]
<?php
?>

<form name="searchForm" action="showroom.php" method="GET" class="search">
<table cellpadding="0" cellspacing="0">
<tr class="search_bar">
<td><b>Search</b></td>
<td><select name="make">
<?php
do {  
?><option value="<?php echo $row_make['Make']?>"<?php if (!(strcmp($row_make['Make'], $row_make['Make']))) {echo "selected=\"selected\"";} ?>>
                <?php echo $row_make['Make']?></option>
            <?php
} while ($row_make = mysql_fetch_assoc($make));
  $rows = mysql_num_rows($make);
   if($rows > 0) {
       mysql_data_seek($make, 0);
   $row_make = mysql_fetch_assoc($make);
   }
?>
  </select> </td>
<td><select style="height:20px;" name="price">
<option>Price</option>
<option value="">Any</option>
                <option value="5000">R5,000 </option>
                <option value="10000">R10,000 </option>
                <option value="15000">R15,000 </option>
                <option value="20000">R20,000 </option>
                <option value="25000">R25,000 </option>
                <option value="30000">R30,000 </option>
                <option value="35000">R35,000 </option>
                <option value="40000">R40,000 </option>
                <option value="45000">R45,000 </option>
                <option value="50000">R50,000 </option>
                <option value="55000">R55,000 </option>
                <option value="60000">R60,000 </option>
                <option value="65000">R65,000 </option>
                <option value="70000">R70,000 </option>
                <option value="75000">R75,000 </option>
                <option value="80000">R80,000 </option>
                <option value="85000">R85,000 </option>
                <option value="90000">R90,000 </option>
                <option value="95000">R95,000 </option>
                <option value="100000">R100,000 </option>
                <option value="125000">R125,000 </option>
                <option value="150000">R150,000 </option>
                <option value="175000">R175,000 </option>
                <option value="200000">R200,000 </option>
                <option value="225000">R225,000 </option>
                <option value="250000">R250,000 </option>
                <option value="275000">R275,000 </option>
                <option value="300000">R300,000 </option>
                <option value="325000">R325,000 </option>
                <option value="350000">R350,000 </option>
                <option value="375000">R375,000 </option>
                <option value="400000">R400,000 </option>
                <option value="425000">R425,000 </option>
                <option value="450000">R450,000 </option>
                <option value="475000">R475,000 </option>
                <option value="500000">R500,000 </option>
                <option value="600000">R600,000 </option>
                <option value="700000">R700,000 </option>
                <option value="800000">R800,000 </option>
                <option value="900000">R900,000 </option>
                <option value="1000000">R1,000,000 </option>
  </select> </td>
<td><select style="height:20px;" name="mileage">
<option>Mileage</option>
<option value="0_10000">0-10 000 km</option>
                <option value="10001_20000">10 001-20 000 km</option>
                <option value="20001_30000">20 001-30 000 km</option>
                <option value="30001_40000">30 001-40 000 km</option>
                <option value="40001_50000">40 001-50 000 km</option>
                <option value="50001_60000">50 001-60 000 km</option>
                <option value="60001_70000">60 001-70 000 km</option>
                <option value="70001_80000">70 001-80 000 km</option>
                <option value="80001_90000">80 001-90 000 km</option>
                <option value="90001_100000">90 001-100 000 km</option>
                <option value="100001_110000">100 001-110 000 km</option>
                <option value="110001_120000">110 001-120 000 km</option>
        <option value="120001">120 000km and above</option>
  </select></td>
<td align="right"><b>Model:</b></td>
<td><input type="text" name="model" /></td>
<td><input type="submit" value="Search" /></td>
</tr>
</table>
</form>

I'm trying to figure out why the options aren't appearing inside the select dropdown. Any ideas why?

Code: [Select]
echo "<label for=" . $row2['fullName'] . ">" . $row2['fullName'] . "</label>";
                       echo "<select name=" . $row2['fullName'] . " id=" . $row2['fullName'] . " class=dropdown title=" . $row2['fullName'] . " />";
                       if ($styleID == 1 || $styleID == 2 || $styleID == 6) {
                         $charactersQuery = "
                                SELECT
                                    characters.ID,
                                    characters.characterName
                                FROM
                                    characters
                                WHERE
                                    characters.styleID = 3
                                ORDER BY
                                    characters.characterName";
                         $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
                         while ( $row3 = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                            print "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
                         }   
                       } else {
                         $charactersQuery = "
                                SELECT
                                    characters.ID,
                                    characters.characterName
                                FROM
                                    characters
                                WHERE
                                    characters.styleID IN (1,2,6)
                                ORDER BY
                                    characters.characterName";
                         $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
                         while ( $row3 = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                            print "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
                         }
                       }
                       echo "</select>";
                   }

I have set up a form page with a select box of colleges to select. I want the "options" in the select box to be values taken from a field called "name" in a table called "colleges" and they should be ordered alphabetically. I also want the default selected option to be "none."

I have attached a picture to describe what i want. Please be detailed with the code. I am fairly new to php and mysql. Thank you.

Hi, Im not sure whether this is a PHP or MySQL question, but im trying to get a select menu to only display the number of options that are defined in the mysql database.   For example   The code I have that retrieves the $quantity from the database.   Lets say that   $quantity = 3   Now I would like the option menu to only display three options, like this:

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
</select>

but for example, if the $quantity was equal to 10 then I would like the menu to be displayed as such

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>

How is it possible to do this? I am completely at a loss here.   Many Thanks   aquaman

Hey Guys,

Here is my issue. I have a MySQL database with a table of products. I use this table to generate a mutliselect form element that is used int a larger form. The larger form contains other information relevant to an issue that we are having with that product (such as an outage). Anyway, the form works fine and the form validation works fine and I write it to the database fine. The issue I'm having is how to save the mutliselect options most efficiently.

This is my current process:

1. User creates a new entry from the form and clicks save
2. The form is validated
3. All entries are written to the database in a table called "incidents" (content inclues, timestamps, description of the problem, the impact, who to contact, etc)
4. Because the products list can vary from 1 product to all (~30) products I broke it out into a separate table called "impacted_products". I then loop through each of the selected products and write one row for each product using the id from the row in the "incidents" table to define the tables relationship.

Example of DB results:

"incidents"

+-----------------+------+----------+---------------------+---------+---------+
| notification_id | what | impact   | time_start          | summary | contact |
+-----------------+------+----------+---------------------+---------+---------+
| 235235          | Test | None.... | 2011-02-08 13:41:00 | Test    |       3 |
+-----------------+------+----------+---------------------+---------+---------+

"impacted_products"

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

5. Now the users wants to go back and make some updates.
6. They click the edit button from the menu on screen and the form is brought back up and all options/fields are filled out from that which is stored in the database.
7. They make their edits and save again.
8. Now this time it simple updates the "incidents" table but for the products table I do a:

"UPDATE impacted_products SET deleted=1 WHERE notification_id='$ID'"

and "delete" all the old impacted_products for this particular incident and then loop through all the products that the user still had selected and write them to the database again.
9. And repeat

So as you can see this could end up with a lot of "useless" entries in the database since my scripts only pay attention to those "impacted_products" whose deleted value is set to 0.

Example:

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 176 | 235235          |         37 | 2011-02-08 15:26:25 |       1 |
| 177 | 235235          |         43 | 2011-02-08 15:26:25 |       1 |
| 178 | 235235          |         37 | 2011-02-08 15:37:58 |       1 |
| 179 | 235235          |         43 | 2011-02-08 15:37:58 |       1 |
| 180 | 235235          |          1 | 2011-02-08 15:39:49 |       1 |
| 181 | 235235          |          7 | 2011-02-08 15:39:49 |       1 |
| 182 | 235235          |         37 | 2011-02-08 15:39:49 |       1 |
| 183 | 235235          |         43 | 2011-02-08 15:39:49 |       1 |
| 184 | 235235          |          1 | 2011-02-08 15:40:53 |       1 |
| 185 | 235235          |          7 | 2011-02-08 15:40:53 |       1 |
| 186 | 235235          |         37 | 2011-02-08 15:40:53 |       1 |
| 187 | 235235          |         43 | 2011-02-08 15:40:53 |       1 |
| 188 | 235235          |         37 | 2011-02-10 10:00:47 |       1 |
| 189 | 235235          |          1 | 2011-02-10 12:17:05 |       1 |
| 190 | 235235          |          7 | 2011-02-10 12:17:05 |       1 |
| 191 | 235235          |         13 | 2011-02-10 12:17:05 |       1 |
| 192 | 235235          |         37 | 2011-02-10 12:17:05 |       1 |
| 193 | 235235          |         23 | 2011-02-10 12:17:05 |       1 |
| 194 | 235235          |          1 | 2011-02-10 12:21:52 |       1 |
| 195 | 235235          |          7 | 2011-02-10 12:21:52 |       1 |
| 196 | 235235          |         13 | 2011-02-10 12:21:52 |       1 |
| 197 | 235235          |         37 | 2011-02-10 12:21:52 |       1 |
| 198 | 235235          |         23 | 2011-02-10 12:21:52 |       1 |
| 199 | 235235          |          7 | 2011-02-10 12:22:26 |       1 |
| 200 | 235235          |         37 | 2011-02-10 12:22:26 |       1 |
| 201 | 235235          |         23 | 2011-02-10 12:22:26 |       1 |
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

I did it this way beacuase it seems the easiest and fastest way. Otherwise I would have to lookup all the impacted_products from the table that match that notification_id and check

1) Was there a new product selected? If so, add it.
2) Was a product that was selected no longer selected? If so, delete it.
3) Was a product that was selected before still selected now? If so, leave it alone.

This seemed like a lot of extra looping and a lot of extra DB queries to essentially end up at the same place.

However, I feel that there has still got to be a more efficient way of doing this where I won't have all the extra entries in the impacted_products table. 

Any ideas?

Thanks in advance!

I understand that is might be something that is already answered and I apologize if it is, I could not find it. What I need to do is build a simple form that has two options, they will be dropdown options. Dropdown A and Dropdown B then a Submit button. This part I understand in HTML, although it may be easier in php or javascript. Then I need it to take the two options and create a "if/then" statement that loads a specific pdf that matches the two options selected. Example. If someone selects Option 1 from Dropdown A and Option 2 From Dropdown B then it loads 12.pdf
If someone selects Option 5 from Dropdown A and Option 3 From Dropdown B then it loads 53.pdf
If someone selects Option 2 from Dropdown A and Option 1 From Dropdown B then it loads 21.pdf and so on... It does not have to be the exact thing just some way to take both inputs and have it equal a specific pdf. Here is the form I built but I don't know what to put in the form_action.php file in order to make it work

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<center>
<h1> Get Directions</h1>
<form action="form_action.php" method="get" name="directions" target="_new">

<select name="startpoint" size="1">
<option value="north">North Tower Entrance</option>
  <option value="south">South Tower Entrance</option>
  <option value="moba">MOB A Entrance</option></select>
  
  ----->

<select name="endpoint" size="1">
<option value="onco">Oncology</option>
  <option value="radio">Radiology</option>
  <option value="pulm">Pulmanary</option></select>
<br /><br />
<input type="submit" value="Submit" />
</form>
</center>

</body>
</html>

Any help is appreciated, thanks.

Hi im new to php and I need help making webpage that queries a mysql database based on a 3 check boxes and displays results on the same page or on another page. The table being queried has 4 columns, name, gps, wifi, bluetooth. So for example a row in the table would be like, samsung galaxy s2, yes, yes, yes. The idea is for it to be a website that will display phones according to their features.

So the idea is depending on if the boxes were ticked the samsung galaxy would be displayed as a result. So i need some help understanding how to make this.

Some1 gave me the code below in attempt to help me (im not sure it works or not) but im not sure how fully use it, ie what pages i need to make and how i create the connection to the mysql database, and how to use the query that they wrote to display the results

thanks

code:
Code: [Select]
<form action="?do=filter" method="post">
<table cellspacing="0" cellpadding="3" border="1">
<tr>
<td>GPS<input type="checkbox" name="gps" value="checked"></td>
<td>Wifi<input type="checkbox" name="wifi" value="checked"></td>
<td>Bluetooth<input type="checkbox" name="bluetooth" value="checked"></td>
</tr>
<tr><td><input type='submit' name='filter' value='Filter'></td></tr>
</table>
</form>
</html>
<?php
function filterMe($filter){
if(isset($_POST[$filter])){
return "Yes";
}else{
return "No";
}
}

if(isset($_POST['filter'])){
echo "Gps - " . filterMe('gps');
echo "
Wifi - " . filterMe('wifi');
echo "
Bluetooth - " . filterMe('bluetooth');
}
?>


All you need to do is use a query something like
SELECT name,gps,wifi,bluetooth FROM `product` WHERE `gps`='".filterMe('gps')."' AND `wifi`='".filterMe('wifi')."' AND `bluetooth`='".filterMe('bluetooth')."'

Hello, first time poster..  I've looked the web over for a long time and can't figure this one out.

- Below is basic code that successfully checks MySQL for a match and displays result.  I was debugging and forced the "height" and "width" to be 24 and 36 to make sure that wasn't the problem.  That's good.. 
- I'd like to give the user ability to select width and height from a form.. and have it do an onchange this.form.submit so the form can be changing as fields are altered (thus the onchange interaction)
- In a normal coding environment I've done this numerous times with no "Page cannot be displayed" problems.  It would simply change one select-option value at a time til they get down the form and click submit...  but in WordPress I'm having trouble making even ONE single onchange work!
- I've implemented the plugins they offer which allows you to "copy+paste" your php code directly into their wysiwyg editor.  That works with basic tests like my first bullet point above.
- I've copied and pasted the wordpress url (including the little ?page_id=123) into the form "action" url... that didn't work...  tried forcing it into an <option value=""> tag.. didn't work.  I'm just not sure. 

I've obviously put xx's in place of private info..

Why does this form give me Page Cannot Be Displayed in WordPress every time?  It won't do anything no matter how simple.. using onchange..

Code..

$con = mysql_connect("xxxx.xxxxxxx.com","xxxxxx","xxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("xxxxxx", $con);
$myprodwidth=24;
$myprodheight=36;
$result = mysql_query("SELECT * FROM product_sizes WHERE prodwidth='$myprodwidth' and prodheight='$myprodheight'");
while($row = mysql_fetch_array($result))
  {
  echo $row['prodprice'];
  }
mysql_close($con);


<form method="post" action="">
<select name="myheight" onchange="this.form.submit();">
<option selected="selected" value="">select height</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">36</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">48</option>
</select>

I am just messing around, but I can't figure this out...

$hx = bin2hex('a');
echo base_convert($hx, 16, 2);
prints out 1100001
but I really want it to print: 01100001

why is the first 0 missing when my code runs?

Hi I need to convert hex or Decimal to Binary but can't find any function. Any one have one or ideas please.

 :confused:can any one please guide me through this.

i want  to calculate binary income like

FOR 1 ST PAIR 1:2 OR 2:1
1ST PAIR 1:2 OR 2:1
1:1 UNLIMITED DEPTH
WEEKLY CAPPING 30 PAIR

i have created a binary tree and i am also able to display it.
but don't know how to make pairs and implement that,and provide an income.

i really need this and it is urgent,
any help will be of great value for me,
this is for my college project,
actually i am a not so good at algorithms.

thanks.

[attachment deleted by admin]

So I have coded php for about 5-6 yrs and have never really needed to use binary conversions and the bitwise operator like >> or << .  I took a php class in college but that basically consisted of the students trying to learn php on their own...  So i have never had any exposure to that portion of php coding.  I have to take an exam on PHP with a bunch of questions that DO NOT show how good of a coder you are.  There are a bunch of questions on bitwise operators and binary conversions... Am I missing something???  Whats the point of converting a string to binary or knowing how to do this in your head?

Any help?

hi all.

I am working on a MLM project in which i have more than 30,000 members followed by the root member,i have to store member automatically in binary tree form like

1 is root
2 is child of 1
3 is child of 1

Then 4 is child of 2
5 is child of 2

and so on ......

i have to design database for that.

please help

Hi, guys.  I'm trying to wrap my head around trying to read a header in a binary file in php.  So, far, I have been able to get the data into a string using file_get_contents.  Now, I think I need to use unpack, but it's a bit confusing to me still.  For example, my file starts by having a 1 byte version number, 4 bytes to represent a number of walls, then "number of walls" * 40 bytes for the actual walls.  But, the problem is, the wall itself is a structure composed of various elements to make up that 40 bytes, from which I'll need to pick out a specific area of interest.  I can do this easily in C, but in php. I can't think how to grab the info.  Any ideas?  Maybe just how to read 1 byte, 4 bytes, then "number of walls" * 40 bytes will get me in the right direction.

This is my first try to display binary tree so please go easy on me.
I am trying to display binary tree using array. The values are stored in mysql.

Structure of mysql-
Code: [Select]
CREATE TABLE IF NOT EXISTS `tree` (
  `parent` int(7) NOT NULL,
  `rchild` int(7) NOT NULL,
  `lchild` int(7) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Display should look like
Code: [Select]
                    1
              ______|______
             |             |
             2             3
                     ______|______
                    |             |
                    4              5   


My Code till now-
Code: [Select]
<?php
 include 'connection.php';
 $rsearch = "SELECT rchild FROM tree WHERE parent='".$parent."'";
 $lsearch = "SELECT lchild FROM tree WHERE parent='".$parent."'";
    
  $rexec = mysql_query($rsearch);
  $lexec = mysql_query($lsearch);
  
  while($rrow = mysql_fetch_assoc($rexec)) // Putting right branch in an array first
{
    $rtree[$i][0] = $rrow['parent'] ; 
    $rtree[$i][1] = $rrow['lchild'] ;
    $rtree[$i][2] = $rrow['rchild'] ;
    $i++;
}
while($lrow = mysql_fetch_assoc($lexec)) // Putting left branch in an array 
{
    $ltree[$j][0] = $lrow['parent'] ; 
    $ltree[$j][1] = $lrow['lchild'] ;
    $ltree[$j][2] = $lrow['rchild'] ;
    $j++;
}

function displaytree($parent,$array)
{
   // Im stuck here. Can someone please help me with it
}
?>
I am stuck at displaying the tree function. Can someone please point me in the right direction ?