Dropdown Menu Item to GET All in a database?

Hi all!
I am a newbie and unfamiliar with PHP and MySQL... I am trying to create a dropdown menu that defaults to all items in my database while still allowing one to also filter to certain products. Right now, I have a database named Products and am trying to base my dropdown off of the three different Product_Type items (Chips, Dips & Marinades, Rubs). Below is my code that I have so far which gets the individual Product_Type items, but I cannot get the dropdown to get ALL items in my db. Can someone help me out?

Expand|Select|Wrap|Line Numbers

 <code>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}
 
$currentPage = $_SERVER["PHP_SELF"];
 
$maxRows_Test = 10;

$pageNum_Test = 0;

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

  $pageNum_Test = $_GET['pageNum_Test'];

}

$startRow_Test = $pageNum_Test * $maxRows_Test;
 
mysql_select_db($database_WPhoto, $WPhoto);

$query_Test = "SELECT * FROM Products WHERE Product_Type='$Product_Type' ORDER BY Product_Title ASC";

$query_limit_Test = sprintf("%s LIMIT %d, %d", $query_Test, $startRow_Test, $maxRows_Test);

$Test = mysql_query($query_limit_Test, $WPhoto) or die(mysql_error());

$row_Test = mysql_fetch_assoc($Test);
 
if (isset($_GET['totalRows_Test'])) {

  $totalRows_Test = $_GET['totalRows_Test'];

} else {

  $all_Test = mysql_query($query_Test);

  $totalRows_Test = mysql_num_rows($all_Test);

}

$totalPages_Test = ceil($totalRows_Test/$maxRows_Test)-1;
 
$queryString_Test = "";

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

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

  $newParams = array();

  foreach ($params as $param) {

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

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

      array_push($newParams, $param);

    }

  }

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

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

  }

}

$queryString_Test = sprintf("&totalRows_Test=%d%s", $totalRows_Test, $queryString_Test);

?>
 
<!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>Callaloo Foods - Products</title>
 
<link rel="stylesheet" href="animated-menu/animated-menu.css"/>  
 
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script> 

    <script src="animated-menu/js/jquery.easing.1.3.js" type="text/javascript"></script>

    <script src="animated-menu/animated-menu.js" type="text/javascript"></script>

<!-- JavaScripts-->
 
<script type="text/javascript" src="s3Slider.js"></script>

<script type="text/javascript">

    $(document).ready(function() {

        $('#slider1').s3Slider({

            timeOut: 10000

        });

    });

</script>

</head>
 
<body>

<div id="container">

   <div id="header">

   <img src="http://bytes.com/images/header_logo_top.jpg" width="898" height="95" border="0" usemap="#Map" />

      <map name="Map" id="Map">

      <area shape="rect" coords="224,1,673,89" href="index.php" alt="home" />

      </map>
 
      <ul class="nav">

      <img src="http://bytes.com/images/header_logol_bottom.jpg" align="left"/> 

         <li class="green-home">  

            <p><a href="index.php">Home</a></p>  

            <p class="subtext"></p>  

         </li>  

         <li class="green-background">  

            <p><a href="background.php">Background</a></p>  

            <p class="subtext"></p>  

         </li>  

         <li class="green-products">  

            <p><a href="products.php">Products</a></p>  

            <p class="subtext"></p>  

         </li>  

         <li class="green-contact">  

            <p><a href="contact.php">Contact</a></p>  

            <p class="subtext"></p>  

         </li>   

         <li class="green-locations">  

            <p><a href="locations.php">Locations</a></p>  

            <p class="subtext"></p>  

         </li>  

      <img src="http://bytes.com/images/header_logor_bottom.jpg" align="right"/> 

      </ul>

   </div>
 
   <div id="thankyou">

      <div id="gallery">

         <div id="content">

            <h1>Products</h1>
 
            <form id="form1" name="form1" method="get" action="products.php">

  <p>

    <label>Narrow Your Search:

      <select name="Product_Type" method="post">

      <option value="Product_Type" selected="selected">All</option>

        <option value="Chips">Chips</option>

        <option value="Dips, Marinades">Dips, Marinades</option>

        <option value="Rubs">Rubs</option>

      </select>

    </label>

    <label>

      <input type="submit" name="button" id="button" value="Submit" />

    </label>

  </p>

</form>
 
         </div>

         <div id="contentbody">

            <?php do { ?>

            <p><img src = "http://bytes.com/images/<?php echo $row_Test['Product_Image_Small']; ?>" align="left"/><br />

               <a href="productdetails.php?recordID=<?php echo $row_Test['Product_ID']; ?>" >

               <?php echo $row_Test['Product_Title']; ?></a><br />

               <?php echo $row_Test['Product_Type']; ?><br />

               <?php echo $row_Test['Product_Description']; ?><br />

               <?php } while ($row_Test = mysql_fetch_assoc($Test)); ?>

            </p>

         </div>

            <p>&nbsp;</p>

            <h2><br />

               <table border="0">

                  <tr>

                     <td><?php if ($pageNum_Test > 0) { // Show if not first page ?>

                            <p><a href="<?php printf("%s?pageNum_Test=%d%s", $currentPage, 0, $queryString_Test); ?>">First</a>

                            </p>

                         <?php } // Show if not first page ?></td>

                     <td><?php if ($pageNum_Test > 0) { // Show if not first page ?>

                            <p><a href="<?php printf("%s?pageNum_Test=%d%s", $currentPage, max(0, $pageNum_Test - 1), $queryString_Test); ?>">Previous</a>

                            </p>

                         <?php } // Show if not first page ?></td>

                     <td><?php if ($pageNum_Test < $totalPages_Test) { // Show if not last page ?>

                            <p><a href="<?php printf("%s?pageNum_Test=%d%s", $currentPage, min($totalPages_Test, $pageNum_Test + 1), $queryString_Test); ?>">Next</a>

                            </p>

                         <?php } // Show if not last page ?></td>

                     <td><?php if ($pageNum_Test < $totalPages_Test) { // Show if not last page ?>

                            <p><a href="<?php printf("%s?pageNum_Test=%d%s", $currentPage, $totalPages_Test, $queryString_Test); ?>">Last</a>

                            </p>

                         <?php } // Show if not last page ?></td>

                  </tr>

               </table>

            </h2>

      </div>

      <p>    Records <?php echo ($startRow_Test + 1) ?> to <?php echo min($startRow_Test + $maxRows_Test, $totalRows_Test) ?> of <?php echo $totalRows_Test ?> <br />

      </p>

      <p>&nbsp;</p>

   </div>

</div>
 
   <div id="footer">

       <ul>

             <li><a href="index.php">home</a></li>

          <li><a href="background.php">background</a></li>

          <li><a href="products.php">products</a></li>

          <li><a href="contact.php">contact</a></li>

          <li><a href="locations.php">locations</a></li>

      </ul>

   </div>

</div>

</body>

</html>

<?php

mysql_free_result($Test);

?>

</code>

Dec 3 '12 #1

Subscribe Post Reply

2526

zmbd

5,501

Expert Mod 4TB

reigns7703
As I've said in other posts... I'm a tad out my depth in PHP. I normally work w/vba and dabble in little C++.

By way of general trouble shooting...
Using the formatted code block in your post :)
- Is line 44 where you set the record source for your list box?
- Have you obtained what the actual value of the SQL that is feeding your list box at runtime? In VBA I'd set a debug.print variableofinterest I'm sure that there is something similar, or you could simply send it to stdout.
- How many records were you expecting on an unfiltered (return everything) query?
-- In relation to the afore, how many records did you return?

I'm sure those with more PHP experience than mine will have other questions... :)

Dec 9 '12 #2

Rabbit

12,516

Expert Mod 8TB

Use an if statement to decide whether or not to put in the WHERE clause.

Dec 9 '12 #3

lolyzor

Im a bit confused with your script, but what I would have done is when i create select html element, I will add onchange='jsFunction()' and that will call my javascript function when user selects something from a dropdown list, from javascript I will use ajax request to my php script pass in the get or post values and get data back, use jquery to populate the select dropdown, Here is silimar script that i use

Expand|Select|Wrap|Line Numbers

  <select onchange="loadAssignments()" class="" id="language">

                            <option>Select a language</option>

                            <option>C++</option>

                            <option>Java</option>

                        </select>

Now from my javascript i do this

Expand|Select|Wrap|Line Numbers

 function loadAssignments(){

        var req = new XMLHttpRequest();

        var lang = $('#language>option:selected').text();

        if (lang == "C++"){

            lang = "Cplusplus";

        }

        if(lang == 'Cplusplus' || lang == 'Java'){

            var url = 'checkCode.php'+'?action=getAssignments'+'&language='+lang;

            var out = '';

            req.open('GET',url,true);

            req.send(null);

            req.onreadystatechange = function () {

                if (req.readyState == 4) {

                    out = req.responseText;

                }

                data = JSON.parse(out);                

                var html = '';

                for (var i=0;i<data.length;i++){

                    html += '<option>'+data[i]['name']+'</option>';

                }

                $('#assignments').html(html);

            }

        }

Not the php script is something like this

Expand|Select|Wrap|Line Numbers

 if ($_GET['action'] == 'getAssignments'){

    $language = $_GET['language'];

    $recieved = $Login->getAssignments($language);

    echo(json_encode($recieved));

I have another class which does the interaction with database but you can connect to database here and request what ever you want. Remember that on you select html element to put first option as <option>Select something below<option> and below you put

Expand|Select|Wrap|Line Numbers

 <option>All elements<option>

<option>THis element</option>

Sorry for this long a.s.s answer :D

Dec 11 '12 #4

Similar topics

dropdown list and database connection

by: djharrison | last post by:

I'm new to ASP and database programming but I am trying to connect to a database using a concatenation of a strings and a menu item from a form. Ok here's what I have... an asp form that has a...

ASP / Active Server Pages

Dropdown Menu

by: Dennis M. Marks | last post by:

Is there a javascript alternative to the dropdown menu in a form (SELECT OPTION). I would like the ability to pass a selected item to a function but I would like more control in the design of the...

Javascript

how to fix it:SelectBox always on top of dropdown menu item.

by: Matthew | last post by:

in a page, I have a dropdown menu, and below the menu there is a dropDownList control. when the menuItem is pulled down, the DropDownList control always on top of the menu div, what cause this? I...

ASP.NET

dropdown menu problem

by: Ian Davies | last post by:

Hello Ive been informed that I need to do the following in javascript. I have two drop down menus in my php script. The items displayed in the second is dependent on which item is choosen from the...

Javascript

Dynamic dropdown menu to database

by: Bertman105 | last post by:

Hey all, Heres the situation: I have a form page that needs to have multiple drop down menus that is pulling their options from a database. Right now I have one working out of 3. So that is one...

PHP

Xara Menumaker(Javascript) Navbar Dropdown Menus positioning

by: torquehero | last post by:

Hi all :) I have created a horizontal navbar using Xara Menumaker. The Menu items have several dropdown menus. Its a javascript. When the mouse cursor is moved over any menu item, a dropdown...

Javascript

Issues with a dropdown menu

by: plunder | last post by:

Hi all what I'm trying to do is a flash menu which in some points has a dropdown sub-menu which comes out on mouseover and contains elements which if clicked link to other pages. Point is that these...

Flash / Actionscript

problem on creating dropdown menu?

by: dittu | last post by:

I want to design dropdown menu.This menu contains two item(save,saveContent).When mouse over on Menu then display below like that ____________ Menu | -------------| Save | SaveContent |...

Javascript

hey,i m newbie to php.i wan ask how to passing value from dropdown menu to database ?

by: micropos | last post by:

hey,i m newbie to php.i wan ask that how to pass value from drop down menu into database .after click ''go'' button ,it will out.thanks...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice