PHP - Php Multi Selection Lists

Hi guys,

I would like to display data from MySQL in the format of 5 lists (of one column each) one next to each other on a webpage

I am quite good with SQL, but I  lack knowledge about php and displaying data.

SQL version: 5.1

Does anyone have any good website that would show how to do such a thing?






 

Hi

I am having problems trying to view some data and wondered if anyone could help.

I have a table called 'parties' which contains fields - partyid, docid and party. There is another table called 'documents' which has fields - docid and doctitle.

I have a number of documents and for each document there are a number of parties - ie people linked to that document.

What I would like to do is get a view on screen (and also printed out) that has the title of the document followed by a list of the parties associated with that document.

For example, if in the documents table there was:

|docid   |doctitle           |
|1           |first document   |
|2           |second document|

and in the parties table there was:
|partyid   |docid   |party   |
|1      |1        |Fred    |
|2      |1           |Jim     |
|3      |1           |Jane   |
|4      |2        |Peter   |
|5      |2        |Fred           |

I could get a view that looked like:

First document:
Fred
Jim
Jane

Second document:
Peter
Fred

I suspect it may involve arrays but I have never used them so any guidance would be very welcome.

Thanks

Hi,
for uni i've got to make a shopping cart application in php/mysql. I'm almost done with it, managed to teach myself some nifty jquery and have been able to learn loads more PHP, I'm really enjoying it. I've come to a bit of a stand still though, I showed my application as it is to my lecturer and he had one little point.
My application, you have lists, each list has its own categories (users can add, edit, delete their own) and in each category, there are items (which like categorys can be added, edited or deleted).

So basically, you have a browse_list.php, which browses all the lists, each list has it's own unique hyperlink to browse_list_category.php?list_id= using the get method, it selects all the categories associated with that list, which, like browse_list.php have their own hyperlinks, but this time they link to browse_category_item.php?category_id= and they list what ever items are associated with that category. Sounds a mouth full, but it's really quite simple.

I showed my lecturer that and he wasn't happy with the whole category/item layout. He said it would be better if the category list had a nested item list underneath it. He was happy with the whole list to category part with the hyperlink, though.
Kinda like:

Quote

-list
-------category
-------item
-list1
------category1
------item1
------category2
------item2
------category3
------item3


My database layout is
tbllist -main list table, list_id, list_name
tblcategory - main category table, category_id, category_name
tblcategory_list - link table for list and category (many-many) list_id, category_id
tblitem - main item table, item_id, item_name
tbl_category_item - link table for category and item (many-many) category_id, item_id

So, now you've kinda got the gist of what I'm doing.. I just need help with displaying each item in a category, under the category.. like a nested list
<ul>
<li>category 1</li>
<ul>
<li> item 1</li>
<li> item 2</li>
<li> item 3</li>
</ul>
</ul>

I did try and have a go earlier, kinda rushed and managed to come up with this:
<ul id="sortme" class="shoppinglist">
<?php
// Split records in $result by table rows and put them in $row.
while($row = mysql_fetch_array($result)) {
echo '<li class="list" id="' . $row['category_id'] . '"><div class="text"><a href="browse_item_category.php?category_id=' .  $row['category_id'] . '">' . $row['category_name'] . "</a></div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"categoryupdater.php?category_id=" . $row['category_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}
?><ul id="sortme" class="shoppinglist">
<?php
while($row = mysql_fetch_array($resultitem)) {
echo '<li class="list" id="' . $row['item_id'] . '"><div class="text">' . $row['item_name'] . "</div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"itemupdater.php?item_id=" . $row['item_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}

?>
</ul>
</ul>

but this i get this

not the whole list nested'ness


it's a bit long winded I know but could anyone possible give me a hand? i've done pretty well so far not asking for help, but I think this is going to be the end of me!

Hi everyone,

I've read through the FAQs for Dynamic Dropdown Menus on this site, as well as others, and I can't figure out why my code won't work. I have two dropdown boxes that need to be populated with data from a mysql table; one menu for route types, and one for route numbers. When I choose the route from the 'Route' menu, the 'Number' menu automatically populates with all of the possible numbers, rather than only those that correspond with the route type. I can tell that the problem has something to do with the value of 'Route' not being recognized, but I don't know why. I'm a beginner when it comes to PHP, so any suggestions or help would be much appreciated!  Thanks!

The code is as follows:

Code: [Select]

<html>
<body>
<basefont face='calibri' color='#7E2217'>
<?php 
// set variables 
$mileTable = $_GET['mileTable']; 
$routeType = isset($_POST['Roadtype'])? $_POST['Roadtype']: 0; 
include 'opendbMile.php'; 
include 'error.php'; 
    // Connect to the MySQL DBMS 
   if (!($connection = @ mysql_connect($hostName, 
                                                                           $username, 
                                                                           $password))) 
          die("Could not connect"); 
   if (!mysql_select_db($databaseName, $connection)) 
         showerror(  ); 
 
    // Start a query... 
    $query = "SELECT ID, 
                                         Roadtype 
                          FROM Alabama 
                          GROUP BY Roadtype"; 
    // execute the SQL statement 
    $result = mysql_query($query, $connection) or die(mysql_error()); 
echo '<form name="mileform" method="post" action="MileQuery.php">'; 
echo '<p>Route: 
<select name="routeType" id="routeType" onchange="this.form.submit();"> 
<option value="0"'.($routeType == 0? ' SELECTED': '').'>Route</option>'; 
while($row = mysql_fetch_array($result)){ 
    echo ' 
            <option value="'.$row[0].'"'.(($routeType == $row[0])? ' SELECTED': '').'>'.$row[1].'</option>'; 
} 
    echo ' 
    </select> 
</p>'; 
// create the SQL statement 
$query2 = "SELECT ID, 
          Roadnumber 
                   FROM Alabama 
                   GROUP BY Roadnumber"; 
         if($mnucategory != 0){    // Filter road numbers 
    $query2 .= " WHERE Roadtype='".$routeType."'"; 
    } 
// execute the SQL statement 
$result2 = mysql_query($query2, $connection) or die(mysql_error()); 
echo '<p>Number: 
    <select name="routeNumber" id="routeNumber" onchange="this.form.submit();"> 
            <option value="0"'.($routeNumber == 0? ' SELECTED': '').'>Number</option>'; 
while($row2 = mysql_fetch_array($result2)){ 
    echo ' 
            <option value="', $row2[0].'"'.(($routeNumber == $row2[0])? ' SELECTED': '').'>'. $row2[1], '</option>'; 
} 
    echo ' 
    </select> 
</p>'; 
 // Close the DBMS connection 
   mysql_close($connection); 
?>
</form>
</body>
</html>

Thanks in advance for any help that you may be able to provide. I'm a graphic designer with VERY limited knowledge of php, javascript, etc. I'm trying to create a form on my company's website that will allow customers to view specifications for particular products. I'm trying to use selection boxes to narrow the customer's search, with the selection from the second box dependent on the first, and the resulting information displayed dependent on the choice from the second list.

So far, I've only been able to adapt some code I found in a tutorial to display the data in the first selection box. No matter what I've tried, I can't seem to get any information to display in the second box, let alone information that is dependent on the first selection. I am brand new to php and javascript, and I didn't even know AJAX, JSON, or JQuery even existed until only a few days ago. Below is the three php files I'm using to try and make this work. If someone could point out what is wrong with it, I would be eternally grateful.

Here is the code from db.php, the file I'm using to connect to my database:

Code: [Select]
<?php
/*changing "db_username" to "root", changing "db_password" to "xxXXXX", changing "database" to "trailers" */
mysql_connect("localhost", "root", "xxXXXX") or die(mysql_error());
mysql_select_db("trailers") or die(mysql_error());
?>
Here is the code from func.php, the file with all the functions and database queries:

Code: [Select]
<?php
//**************************************
//     Page load dropdown results - changing tier_one to tnttrailer_brand, changing two_drops to trailerquote, changing 'tier_one' to 'tnttrailer_brand'     //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT tnttrailer_brand FROM trailerquote") 
or die(mysql_error());

  while($tier = mysql_fetch_array( $result )) 
  
{
   echo '<option value="'.$tier['tnttrailer_brand'].'">'.$tier['tnttrailer_brand'].'</option>';
}

}

//**************************************
//     First selection results - changing two_drops to trailerquote, changing tier_one to tnttrailer_brand, changing 'tier_two' to 'trailer_description',     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}

function drop_1($drop_var)
{  
    include_once('db.php');
$result = mysql_query("SELECT trailer_description FROM trailerquote WHERE tnttrailer_brand='$drop_var'") 
or die(mysql_error());

echo '<select name="tier_two" id="tier_two">
      <option value=" " disabled="disabled" selected="selected">Choose one</option>';

   while($drop_2 = mysql_fetch_array( $result )) 
{
  echo '<option value="'.$drop_2['trailer_description'].'">'.$drop_2['trailer_description'].'</option>';
}

echo '</select> ';
    echo '<input type="submit" name="submit" value="Submit" />';
}
?>
Finally, this is the code from index.php, the file with the form, javascript and the AJAX:

Code: [Select]
<?php 
  include('db.php');
  include('func.php');
?><!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>Chained Select Boxes using PHP, MySQL and jQuery</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {
$('#wait_1').hide();
$('#drop_1').change(function(){
  $('#wait_1').show();
  $('#result_1').hide();
      $.get("func.php", {
func: "drop_1",
drop_var: $('#drop_1').val()
      }, function(response){
        $('#result_1').fadeOut();
        setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
      });
    return false;
});
});

function finishAjax(id, response) {
  $('#wait_1').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
</script>
</head>

<body>
<p>
<form action="" method="post">
 
    <select name="drop_1" id="drop_1">
   
      <option value="" selected="selected" disabled="disabled">Select a Category</option>
     
      <?php getTierOne(); ?>
   
    </select>
   
    <span id="wait_1" style="display: none;">
    <img alt="Please Wait" src="ajax-loader.gif"/>
    </span>
    <span id="result_1" style="display: none;"></span>
 
</form>
</p>
<p>
<?php if(isset($_POST['submit'])){
$drop = $_POST['drop_1'];
$tier_two = $_POST['trailer_description'];
echo "You selected ";
echo $drop." & ".$tier_two;
}
/* changed 'tier_two' to 'trailer_description' */
?>
</body>
</html>
Here's the page on my website. I'm using Joomla for my website, and the above php is loaded into a module at the bottom of the page:

http://www.tnttrailer.com/index.php/dimensions.html

I want to produce a pdf document using mysql and TCPDF.

I can do this OK in some circumstances but I now have a problem. I have two tables - documents and parties - they are linked by a common field docid.

I have for table documents, the fields:
docid, doctitle, idcode

and for the parties table:
partyid, docid, party (the field party is the name of the party)

For any document there could be any number of parties and for a single idcode there could be any number of documents.

For example, for idcode = 12345 there might be 2 documents called doctitle 1 and doctitle 2. For doctitle 1 there are 3 parties to it party1, party 2 and party 3. For doctitle 2 there are two parties - party4 and party 5.

For any idcode (which is passed through by the url) I want the pdf to give a list such as:

Doctitle 1:
party name 1
party name 2
party name 3

Doctitle 2:
party name 4
party name 5

Part of my code is:

mysql_select_db($database_process, $process);
$result2 = mysql_query("SELECT parties.docid, GROUP_CONCAT(party SEPARATOR '<br>') AS partylist, documents.doctitle
FROM parties INNER JOIN documents ON parties.docid=documents.docid
                    WHERE parties.idcode = '$appidpassed'
               GROUP BY parties.docid
                    LIMIT 1
                    ") or die(mysql_error());   

while($row = mysql_fetch_array($result2))
  {
    $doctitle = $row['doctitle'];
   $parties = $row['partylist'];
   
   
}   

and then further down the page:

$doctitle<br>
$parties

This only gives one document and the parties associated with it. I know the solution is probably easy but I can't see it.

Does anyone have any ideas?

Hi,

A quick question please  , I am trying to assign a selected index to a drop down list based on data retrieved from the database.

I tried using JavaScript :
document.getElementById('Country').selectedIndex ='".$array['Country']."';

but it does work. Any suggestion?

Hello Friends!.... here is the big idea. I am trying to make a form in which there will be 2 drop down lists which will be populating directly from MySQL DB ....
Actually i am developing a student management system as my first PHP project... here i want to have 2 drop down lists first is roll number and second is student name. i want that when some one select the roll number in the first drop down the student name against it is automatically populated in the next drop down.


please help me friends i am new to php and dont know soo much.! any help PLZZZZZZZZZZ

i have a list of check boxes
im ordering it according to Amenity name ASC
im floating 2 divs (columns)side by side

how can i get the list to echo it according to ABC :
like this::?

A D
B E
C F
Code: [Select]
<?php 
              echo '<div style="height:800px;" />';
              foreach($amens as $amen) {
              echo '<div style="float:left;padding-left: 2px;width:200px;"><input onclick="changedata(this)" type="checkbox" id="mm'.$amen['Amen_ID'].'" value="'.$amen['Amenity'].'" '.checkAmenity($id, $amen['Amenity']).' /><label style="padding-left:3px;" for="mm'.$amen['Amen_ID'].'">'.$amen['Amenity'].'</label></div>';

              } 
echo '</div>';
              ?>

Ok, so i got this website project dropped in my lap, and I'm stuck not really having done much php coding ever.  I have a database which is linked already, and it was working when pulling data from a specific table.  The problem arose when I was asked to make it work with other tables.  I have a table with the table names in it, and the drop down field to select the table populates.  The next field is a multiple select field that is supposed to populate report dates from the previously selected table, and then finally the last multiple select field is supposed to populate with names that match the dates selected from the previous field.  The last one I can live without, as the existing code takes into account if the name selected doesn't exist in the table with the selected date, but at the moment the date field just comes up blank.  Any help would be greatly appreciated.

Hello.

Im having trouble using a Tempory Operator in a list. maybe someone might know a way around it.

so the list below has 3 Tempory Operators.

the first 1 looks for pages with links that are internal links
the first 2 looks for pages with links that are external links
the first 3 looks for pages with links that have no links

if the link is a "nonTitle" it will be a normal list item
if the link is a "title" it will be a header for a sub list (class="subexpandable")

the problem is that every time it gets to the '; at the end of each Tempory Operators it breaks



THIS IS NOT WORKING
Code: [Select]
<ul>
//FIND INTERNAL LINKS
echo $type == "internal" && $list == "nonTitle" ? '<li><a href="index.php">'.$title.'</a></li>' : '<li><a href="index.php" class="subexpandable">'.$title.'</a>';


//FIND EXTERNAL LINKS
echo $type == "external" && $list == "nonTitle" ? '<li><a href="http://www.url.com">'.$title.'</a></li>' : '<li><a href="http://www.url.com" class="subexpandable">'.$title.'</a>';


//FIND NON LINKS
echo $type == "non" && $list == "nonTitle" ? '<li><a>'.$title.'</a></li>' : '<li><a class="subexpandable">'.$title.'</a>';


                //GET SUB LINKS
echo'
<ul class="subcategoryitems" style="margin-left: 15px">
                <li><a href="">sub link</a></li>
</ul>
        </li>
</ul>';





If i put the sub level inside of each type it works but then i keep having to use the same code over.



THIS IS WORKING

Code: [Select]
<ul>
//FIND INTERNAL LINKS
echo $type == "internal" && $list == "nonTitle" ? '<li><a href="index.php">'.$title.'</a></li>' : '<li><a href="index.php" class="subexpandable">'.$title.'</a>
                <ul class="subcategoryitems" style="margin-left: 15px">
                <li><a href="">sub link</a></li>
</ul>
        </li>';


//FIND EXTERNAL LINKS
echo $type == "external" && $list == "nonTitle" ? '<li><a href="http://www.url.com">'.$title.'</a></li>' : '<li><a href="http://www.url.com" class="subexpandable">'.$title.'</a>
<ul class="subcategoryitems" style="margin-left: 15px">
                <li><a href="">sub link</a></li>
</ul>
        </li>';


//FIND NON LINKS
echo $type == "non" && $list == "nonTitle" ? '<li><a>'.$title.'</a></li>' : '<li><a class="subexpandable">'.$title.'</a>
<ul class="subcategoryitems" style="margin-left: 15px">
                <li><a href="">sub link</a></li>
</ul>
        </li>';

</ul>';




so is there a way to do the first example without having to do the second example



thanks
ricky

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=329775.0

Is there a simple way to keep a yes or no selection in a drop down menu after the page is submitted?
Code: [Select]
<form name="survey" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
Satisfied<select name="satisfied">
<option value="yes"> yes </option>
<option value="no"> no </option>
</select>
<input name="submit" type="submit" value="Submit">
</form>

how do i make it so that all the items appear on eventname

Code: [Select]
<?php

require "scripts/connect.php";

$query = mysql_query("SELECT eventname FROM events");
while ($row = mysql_fetch_array($query)){

$eventname = $row['eventname'];

$form = "<form action='addcat.php' method='post'>
<table>
<tr>
<td>SELECT EVENT</td>
<td>
<select value='$eventname'>
<option value='$eventname'>$eventname</option>
</select>
</td>
</tr>
<tr>
<td>SELECT VENUE</td>
<td>
<select>
<option></option>
</select>
</td>
</tr>
<tr>
<td>SELECT CATEGORY</td>
<td>
<select>
<option>FOOTBALL</option>
<option>BASKETBALL</option>
<option>HOCKEY</option>
<option>DRAMA</option>
<option>MUSIC</option>
<option>DANCE</option>
<option>VISUAL ARTS</option>
</select>
</td>
</tr>
</table>
</form>";
echo "$form";
}
?>

Hi, I'm basically trying to write something like the below:

$uri = "1";
$uri = "2";
         
if ($uri == "1") {
   echo 'test 1';
}
         
if ($uri == "2") {
   echo 'test 2';
}

if ($uri == "3") {
   echo 'test 3';
}

I will define $uri on every page and I want the php to process what to display on the page, ie test 1, test 2 and/or test 3