PHP - Multi List Selection Php

could anyone please help me with the code which is i have already displayed data as a multi select list but now i need to select one or more from them and insert into another database table. would be appreciate your help. thanx

Hi, I'm new to PHP/MySQL and need some help getting my query to work for my selection list:

The selection list is built with:
<form action='processformmissing.php' method='POST'>
<fieldset>
<legend>Choose Department</legend>
<select name='depart'>
<option value=''></option>

<?php
while ($row = mysqli_fetch_array($result))
{
extract($row);
echo "<option value='$department'>$department</option>\n";
}
?>
</select>
<p><input type='submit' value='Select Department' /></p>
</fieldset>

</form>

The data is then sent to:

$depart = $_POST['depart'];
$deptlike = "%".$depart."%";

echo "<p>$depart</p>";
echo "<p>$deptlike</p>";

$query = "SELECT * FROM lifecerts INNER JOIN employees ON lifecerts.cid = employees.cid WHERE department LIKE '$deptlike' ORDER BY employees.name";



Hitting the submit button from my selection list form seems to be working fine because when I echo my data ($depart and $deptlike) it is giving me the correct value, but the query doesn't give me any results. However, if my post data comes from a text box instead of a selection list, my query works fine. Any thoughts on what I'm doing wrong???

Many thanks!

I need some help with the query for a form that selects values across multiple columns, and allow users to select multiple values in several columns.

     http://brinsterinc.com/tpa/tpasearch.php

I assume you build the where clause for the sql by determining if there is an option value has been selected in the single-value select boxes.

But how do I handle the multi-select list boxes?

I'm desperate for help!  Need to get somewhere with this over the weekend!

TIA!

Hi,
In my mysql database i have a text input option, in the registration form and edit my details form i have a multiple select dropdown list, which user selects options to populate the text input box, which ultimately populates the text field in the mysql database.
All works perfectly.

The dropdownlist consists of 3 parts <optgroups> first is current selection (what is the usesr current selection)works fine, The second <optgroup> is existing words, what words we(the site) have given as options, and the third <optgroup> is the words that others have used. This is where im having a small problem.
Because its a text field when i call the data from the database, it calls the entire text box as a single option in my select list..

I want to break the words in the text field (at the comma) and have them listed each one as an option in the select list.


Example what i need:

Words in text box:(my input allows the "comma")
word1, word2, word3, word4, word5, word6,

How i want them called/displayed:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

here's my code:
$query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $original_functionsexperience =doSelectSql($query,1);
         $query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $functionsexperiencelist=doSelectSql($query);
          $funcexpList ="<select multiple=\"multiple\" onchange=\"setFunctionsexperience(this.options)\">";   
         foreach ($functionsexperiencelist as $functionsexperienceal)
            {
            $selected="";
            if ($functionsexperienceals->allwords == $original_functionsexperience)
               $selected=' selected="selected"';
            $allwords=$functionsexperienceal->allwords;
            $funcexpList .= "<optgroup label=\"Current selection\">
            <option value=\"".$allwords."\" ".$selected." >".$allwords."</option>
            </optgroup>      
              <optgroup label=\"Existing Words\">
              <option value=\"existing1,\">existing1</option>
              <option value=\"existing2,\">existing2</option>
              <option value=\"existing3,\">existing3</option>
              <option value=\"existing4,\">existing4</option>
              <option value=\"existing5,\">existing5</option>
              <option value=\"existing6,\">existing6</option>
         </optgroup>
         <optgroup label=\"Others added\">    //heres problem
         <option value=\"".$allwordsgeneral."\">".$allwordsgeneral."</option>
         </optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         
      
         
   The result im getting for optgroup others added:
   word1, word2, word3, word4, word5,

how can i get it like this:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

Hi , I have one question .. Can I split showing of content of dynamic list in 2 parts , when I echo list in code ..

Code: [Select]
<?php 
// Run a select query to get my letest 8 items
// Connect to the MySQL database  
include "../connect_to_mysql.php"; 
$dynamicList = "";
$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 8");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0) {
while($row = mysql_fetch_array($sql)){ 
             $id = $row["id"];
 $product_name = $row["product_name"];
 $price = $row["price"];
 $date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
 $dynamicList .= '<table width="100%" border="2" cellspacing="2" cellpadding="2">
        <tr>
          <td width="17%" valign="top"><a href="product.php?id=' . $id . '"><img style="border:#666 1px solid;" src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="2" /></a></td>
          <td width="83%" valign="top">' . $product_name . '<br />
            $' . $price . '<br />
            <a href="product.php?id=' . $id . '">View Product Details</a></td>
        </tr>
      </table>';
    }
} else {
$dynamicList = "We have no products listed in our store yet";
}
mysql_close();
?>


Code: [Select]
<p><?php echo $dynamicList; ?><br />
</p>
It works ok, and putting my files, everything works, but when I put 8 pictures with price and other details, it just show one image with details and another image below with details, and the third image below and so on ..
Can I split dynamic list to show 4 images with details on the left side and 4 on the right side?

Thank you in advance for help , if is possible

Hi, I use the following code to create a select menu from an array of options stored in LISTS.php:


include 'LISTS.php';

print('<select id="from" name="from">');
foreach ($langList as $lang) {printf('<option %s>%s</option>', 
     ($from1 == $lang ? 'selected="selected"' : ''), $lang);
     }
echo '</select>';


where LISTS.php includes the following:
$langList = array(' ','English', 'French', 'German', 'Dutch', 'Spanish');

This works great, but now I want to do something similar with a checkbox list, where each checkbox has an associated 'onchange' javascript function and I'm getting pretty stuck.

My checkbox list is of the following form:

Code: [Select]
<html>
<ul style="height: 95px; overflow: auto; width: 200px; border: 1px solid #480091; list-style-type: none; margin: 0; padding: 0;">
    <li id="li1b"><label for="chk1b"><input name="chk1b" id="chk1b" type="checkbox" onchange="function1('chk1b','li1b')">Option1</label></li>
    <li id="li2b"><label for="chk2b"><input name="chk2b" id="chk2b" type="checkbox" onchange="function1('chk2b','li2b')">Option2</label></li>
//etc.
 </ul>
</html>
What I want to do is have 'Option1', 'Option2', etc. stored in an array in LISTS.php and have a PHP script that populates the checkbox list accordingly, in a similar manner to my select menu above. I can't work out how to get the ID of the next <li> and the next <input> in the list to go up by one each time, e.g. 'li1b' then 'li2b', 'li3b', etc.

Could someone pls help me out? Thanks!

Is there a way to take data that is listed like a,b,c,d,e and turn that into an unordered list?

Basically, I'm going to have a list of schools that will be listed with comma separators.  I'll print that data out in two places, one will be printed as it's in the database.  The other I would like to echo as an unordered list.

How hard would something like this be? I have a database with all my users.

I need an empty list and when a user clicks a button "Add me to the list" they are added to the first position in the list

Slots
1. Tom
2.
3.
4.
5.

Later, Jerry wants to be added to the list. So this happens

Slots
1. Jerry
2. Tom
3.
4.
5.

More people join the list

1. Bob
2. John
3. Jerry
4. Tom
5.

Tom gets upset clicks the same button to join the list again, and he's bumped back up to first place. 

Slots
1. Tom
2. Bob
3. John
4. Jerry
5.

Is this possible? And is so, how would I go about getting started on such a thing? I've been using PHP for about a year and a half.

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";
}
?>

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>

Hello there,

this is a really noob question, but I've no idea on how to make it work without making everything messy and crappy.

I have one SQL table called categories, and another called subcategories.
Inside the subcategories table there's a field named 'parent' that will link it to the correspondent category, so it should look something like this in html:

Code: [Select]
<ul>
<li>Category
<ul>
<li>Subcategory</li>
</ul>
</li>
</ul>

Would you please give this poor guy a hand? =)

Is it possible to get bittorrent peer list (IP list) via php, udp protocol ?

txh!

My website, http://www.LawnBagSigns.com, has a lot of price tables, which I think, are getting bulky and hard to read. Like

this price page here, I think the table might be scaring people away.

So here is what I want to try - have a series of dropdown boxes where the user can choose the details a product one by one

(for example, first the size, then the quantity). I want to do this in PHP and XML, and I want to avoid JavaScript since,

believe it or not, not all of my website's visitors have JavaScript enabled.

My problem at the moment is that the XML document is full of white scape that is screwing over my system, but I don't want

to sacrifice readability by blobbing the whole xml file into one line with no spaces (because if I want to change or add

something... you get the idea).

So my question is, how do I get rid of the white scape?

Here is the prototype I've been working on:
http://www.lawnbagsigns.com/flyers-test.php
The XML:
Code: [Select]
<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="whitespace_ripper.xsl"?>

<price_table>
<side>1
<qty>25
<size>3.5 x 8.5
<price>
37
</price>
</size>
<size>8.5 x 5.5
<price>
37
</price>
</size>
<size>4.25 x 11
<price>
37
</price>
</size>
<size>8.5 x 7
<price>
38
</price>
</size>
</qty>
</side>
<side>2
<qty>25
<size>3.5 x 8.5
<price>
37
</price>
</size>
<size>8.5 x 5.5
<price>
37
</price>
</size>
<size>4.25 x 11
<price>
37
</price>
</size>
<size>8.5 x 7
<price>
38
</price>
</size>
</qty>
</side>

</price_table>and the PHP code:
Code: [Select]
<?php

//P  Session

function priceSelect ($path)
{

if (!empty($_REQUEST['Previous']))
{

$_SESSION['xmlCursor'] = $_SESSION['xmlCursor']->parentNode;
echo 'test1<br />';
}
elseif (!empty($_REQUEST['Next']))
{

$exitLoop = false;
$childCursor = $_SESSION['xmlCursor']->firstChild;

while ($exitLoop == false)
{
if ($childCursor == $_SESSION['choice'])
{
$_SESSION['xmlCursor'] = $childCursor;
$exitLoop = true;
}
else
{
$childCursor = $childCursor->nextSibling;
}
}
echo 'test2<br />';
}
else
{

$_SESSION['userMadeChoices'] = array(array());
$_SESSION['xmlCursor'] = loadXML($path);
echo $_SESSION['xmlCursor']->firstChild->nodeValue;
echo $_SESSION['xmlCursor']->parentNode->nodeValue;
echo 'test3<br />';

}

$reload = $_SERVER['PHP_SELF'];

echo 
'<form action="'.$reload.'" method="post">';

displayChoices($_SESSION['userMadeChoices']);
echo 'test4<br />';
displayMenu($_SESSION['xmlCursor'], $_SESSION['userMadeChoices'] );
echo 'test5<br />';
displayButtons($_SESSION['xmlCursor']);
echo 'test6<br />';

echo '</form>';
}

function loadXML($path)
{
$xmlDoc = new DOMDocument();
$xmlDoc->load($path);
$xmlDoc = $xmlDoc->documentElement;
return $xmlDoc;
}

function displayChoices($data)
{
for ($i = 0; $i < count($data); $i ++)
{
echo $data[$i][0];
echo '</br>';
}
}

function displayMenu($xml, $data)
{
echo '<select name="choice">';
//$xml = $xml->documentElement;
//$data[$xml] = 

foreach($xml->childNodes AS $child)
{
echo '<option value="' . $child->firstChild->nodeValue . '">' . $child->firstChild->nodeValue . 

'</option>';
}

    echo '</select>';
}

function displayButtons($xml)
{
if ($xml->childNodes != null)
{
echo '<input type="submit" name="Previous" value="Previous Step" />';
}

if ($xml->parentNode != null)
{
echo '<input type="submit" name="Next" value="Next Step" />';
}
}

function stripWhitespace ($string)
{

return $string;
}
?>

When I try to select more than one value for my report, only one value shows.  I tried a few things, but I'm not having any luck.

Here is the form code:
Code: [Select]
<td style="text-align: right">Job Type:</td>
<td>
<select name="job_type" multiple="multiple" size="3">
<option value="0" selected>ALL</option>
{section name=jt loop=$job_type_list}
<option value="{$job_type_list[jt][0]}">{$job_type_list[jt][1]}</option>
{/section}
</select>
</td>
Here is the other code:
//All IIS Object Code is to be encapsulated in the execute_object function
function execute_object($tab){
if ((isset($_POST['job']) and
 isset($_POST['job_type']) and
 isset($_POST['child_type']) and
 isset($_POST['job_status']) and
 isset($_POST['child_status']) and
 isset($_POST['ou']) and
 isset($_POST['child_ou']) and
 isset($_POST['pm']) and
 isset($_POST['child_pm']) and
 isset($_POST['dm']) and
 isset($_POST['child_dm']) and
 isset($_POST['customer']) and
 isset($_POST['end_date'])) or
(isset($_SESSION['report_job']) and
 isset($_SESSION['report_job_type']) and
 isset($_SESSION['report_child_type']) and
 isset($_SESSION['report_job_status']) and
 isset($_SESSION['report_child_status']) and
 isset($_SESSION['report_ou']) and
 isset($_SESSION['report_child_ou']) and
 isset($_SESSION['report_pm']) and
 isset($_SESSION['report_child_pm']) and
 isset($_SESSION['report_dm']) and
 isset($_SESSION['report_child_dm']) and
 isset($_SESSION['report_customer']) and
 isset($_SESSION['report_end_date'])))
 {
 //Include functions
include $GLOBALS['include_path']."penta.job.functions.php";
include $GLOBALS['include_path']."display.functions.php";
include $GLOBALS['include_path']."report.functions.php";

//Get report parameters
if (isset($_POST['job'])){
$job_id = $_POST['job'];
} else {
$job_id = $_SESSION['report_job'];
}
if (isset($_POST['job_type'])){
$job_type = $_POST['job_type'];
} else {
$job_type= $_SESSION['report_job_type'];
}
if (isset($_POST['child_type'])){
$child_type = $_POST['child_type'];
} else {
$child_type= $_SESSION['report_child_type'];
}
if (isset($_POST['exclude_type'])){
$exclude_type = 1;
} else {
if(isset($_SESSION['report_exclude_type'])){
$exclude_type = $_SESSION['report_exclude_type'];
} else {
$exclude_type = 0;
}
}
if (isset($_POST['job_status'])){
$job_status = $_POST['job_status'];
} else {
$job_status= $_SESSION['report_job_status'];
}
if (isset($_POST['child_status'])){
$child_status = $_POST['child_status'];
} else {
$child_status= $_SESSION['report_child_status'];
}
if (isset($_POST['ou'])){
$ou_id = $_POST['ou'];
} else {
$ou_id = $_SESSION['report_ou'];
}
if (isset($_POST['child_ou'])){
$child_ou_id = $_POST['child_ou'];
} else {
$child_ou_id = $_SESSION['report_child_ou'];
}
if (isset($_POST['pm'])){
$pm_id = $_POST['pm'];
} else {
$pm_id = $_SESSION['report_pm'];
}
if (isset($_POST['child_pm'])){
$child_pm_id = $_POST['child_pm'];
} else {
$child_pm_id = $_SESSION['report_child_pm'];
}
if (isset($_POST['dm'])){
$dm_id = $_POST['dm'];
} else {
$dm_id = $_SESSION['report_dm'];
}
if (isset($_POST['child_dm'])){
$child_dm_id = $_POST['child_dm'];
} else {
$child_dm_id = $_SESSION['report_child_dm'];
}
if (isset($_POST['customer'])){
$cus_id = $_POST['customer'];
} else {
$cus_id = $_SESSION['report_customer'];
}
if (isset($_POST['sort_by_cust'])){
$sort_by_cust = 1;
} else {
if(isset($_SESSION['report_sort_by_cust'])){
$sort_by_cust = $_SESSION['report_sort_by_cust'];
} else {
$sort_by_cust = 0;
}
}
if (isset($_POST['end_date'])){
$edate = $_POST['end_date'];
} else {
$edate = $_SESSION['report_end_date'];
}
$job_type = implode(",",$_POST['job_type']);
//Prepare to output report
$filename = "Project Review Report.xls";
if (isset($_POST['print'])){
//Prepare the output file
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Pragma: public");
} else {
//Save the report parameters to enable printing from the preview
$_SESSION['report_job'] = $job_id;
$_SESSION['report_job_type'] = $job_type;
$_SESSION['report_child_type'] = $child_type;
$_SESSION['report_exclude_type'] = $exclude_type;
$_SESSION['report_job_status'] = $job_status;
$_SESSION['report_child_status'] = $child_status;
$_SESSION['report_ou'] = $ou_id;
$_SESSION['report_child_ou'] = $child_ou_id;
$_SESSION['report_pm'] = $pm_id;
$_SESSION['report_child_pm'] = $child_pm_id;
$_SESSION['report_dm'] = $dm_id;
$_SESSION['report_child_dm'] = $child_dm_id;
$_SESSION['report_customer'] = $cus_id;
$_SESSION['report_sort_by_cust'] = $sort_by_cust;
$_SESSION['report_end_date'] = $edate;
//Output a print button at the start of the preview
preview_print_button("load_object.php?&object=52.2");
}
    
//Get the list of jobs based on the given criteria
$job_list = report_job_list($job_id, $job_type, $child_type, $exclude_type, $job_status, $child_status, $ou_id, $child_ou_id, $pm_id, $child_pm_id, $dm_id, $child_dm_id, $cus_id, $sort_by_cust, $selected_by);
//Set the max script execution time to ensure it can finish based on the number of jobs
$num_jobs = $job_list->RecordCount();
set_time_limit(60 + ($num_jobs * 30));

//Parse the template
$template = $GLOBALS['reports_path']."report52.2.htm";
$default_logo = "report52.2_files/image001.gif";
$hdr = null; $ftr = null;
parse_template($template, $default_logo, $hdr, $ftr);

How can I prevent someone from making an ivalid selection in a form? Lets say I had a select dropdown box and someone saved the HTML source from the browser, changed an item in the list, and changed the action to point back to my server eg. action="testsite.com/index.php". Then they open the file and try to submit the form.