problem reciving check box values using post metho

method · February 20th, 2006, 03:44 AM

Hi all i got a form with many checkboxes and i want to pass checkbox varaibles to a new page using post method but the problem is that each time the first variable get pasted .Beleow u see part of php code that recives the passed variables. When i run this script by selecting 3 check boxes which has values :1 first check box, 2 second checkbox and 3 3th checbox. i get this

select filename,title from wimpy where id=1

instead of

select filename,title from wimpy where id=1 OR id=2 OR id=3

I be happy if an expert help me fix this problem and be able to pass all values of check box to second page and be able to buil query such :
select filename,title from wimpy where id=1 OR id=2 OR id=3
Thanks

part of check box form code:

Code:

<form method="POST" action="./playlist.php"  name="mp3Play">
...
...
...

playlist.php code

Code:

<?php

//echo $_POST['id']; 

$user = "root";
$pw = "";
$db = "mp3sversion5";
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);


if (isset($_POST['Id'])) {
    $fragments = explode(',',$_POST['Id']);
    $loopCount = sizeof($fragments);
    for ($loop = 0; $loop < $loopCount; $loop++) {
        if ($where != '') $where .= ' OR';
        $where .= ' id='.$fragments[$loop].' ';
    }    }
$query = "select filename,title from wimpy where $where";

echo $query;

$result = mysql_query($query);

Mantis · March 10th, 2006, 08:27 PM

>> playlist.php code
I use :
<Form action=Play_MP3.php' method='POST'>
<SELECT SIZE="22" NAME="MP3_Selection[]" MULTIPLE>
<?php
$NBFile=$NBFile-1;
for ($i=0; $i<=$NBFile; $i++) {
$file_Name1=$FileArray[$i];
?>
<OPTION><?php echo substr($file_Name1, 0, strlen($file_Name1)-4); ?></OPTION>
<?php } ?>
</SELECT>
<p style="margin-top: 10; margin-bottom: 0" align="center">
<input type="submit" value="Play Selection" name="Juky">
</p>
</form>

To play my mp3..
on the Play_MP3.php it looks like this:
$NBFile=0;
foreach($_POST['MP3_Selection'] as $name)
    {
        $FileArray[]=stripslashes(stripslashes($name)).".mp3";
    $NBFile=$NBFile+1;
    }
Somehow I couldn't associate the array directly to another.. but hey whatever works..

I hope that will help you :)