explode values

[megz90]

hey, ive managed to get working a while loop which displays a check box for each record in a table.

the user can select a number of check boxes which then implode into a string for storage in a database

 

implode...

$glued = implode(',', $_REQUEST['interest']);

if (isset($_REQUEST['interest']))
{
  echo implode(',', $_REQUEST['interest']);
}

ie if check box for serviceID 1 2 4 and 5 from the loop at the top were ticked then the string would read 1,2,4,5

 

so this adds in the database ok. when i take the value out of the database i can use explode to get the array back out on the screen

$serv = "{$row['dbservices']}";
print_r (explode(",",$serv));

the above prints out this : (i had service 1 2 4 and 5 selected from the check boxex)

output=

Array ( [0] => 1 [1] => 2 [2] => 4 [3] => 5 )

 

what i want to do is find out what the values from the out put mean. ie

for each value in the array look at the service table and check for the servicename where the serviceID is the same as each of the array items.

is that somehting the php can do, how would i go about trying to do that ?

thanks for any help

 

[cooldude832]

can I see your form there is  a way simpler way

[megz90]

make booking . php

[code=php:0]<?php 
// admin page
include('../db_connection.php');
if (!isset($_SESSION["sess_loggedon"])) {
        session_start();
        } 
	else header ('location: index.html');
$query  = ("SELECT * FROM xhorse WHERE dbOwnerId='".$_SESSION['sess_loggedon']."'");
$result = mysql_query($query);
$queryser  = ("SELECT * FROM xservice");
$resultser = mysql_query($queryser);
?>

[/code]

...other half with the form

[code=php:0]<form action="bookadd.php" method="POST">
<?php 
echo "Select Your Horse :";
echo "<select name='selecth' id='selecth'>";

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<option value=\"{$row['dbhorseid']}\" >{$row['dbhorsename']}</option>";
}
echo "</select>";
echo "<br/>";
echo "Date : <input name=\"date\" type=\"text\" size=\"10\" maxlength=\"10\" />";
echo "<br/>";
?>
<table border="1">
<tr><td>Tick if needed</td><td>service name</td><td>cost</td><td>description</td></tr>
<?php
while($row = mysql_fetch_array($resultser, MYSQL_ASSOC))
{ 
echo "<tr>";
echo "<td><input type=\"checkbox\" name=\"interest[]\" value=\"{$row['dbserviceId']}\"/></td>";
echo "<td>{$row['dbservicename']}</td>";
echo "<td>£{$row['dbcost']}</td>";
echo "<td>{$row['dbdescription']}</td>";
echo "</tr>";
echo "<br/>";
}
echo "date: ";



?>
</table>
<input name="submit" type="Submit" value="Confirm Booking" />
</form>

[/code]

 

i haven't included the bit where it glues it together or puts it in the DB but if u would like to see it, say..

[cooldude832]

for your check boxes redo them to be in the form

<?php
echo "<td><input type=\"checkbox\" name=\"interest[".$row['dbserviceID']."]\" value=\"1\"/></td>";
?>

and then you can get the ones checked via doing

<?php
foreach($_POST['interest'] as $key => $value){
if($value == "1"){
#Its checked
#the serviceID is $key
}
}
?>

 

[megz90]

hmm. im not sure if i have misunderstood but

each and every checkbox will have the value of 1 from what im reading,

 

value=\"1\"

it'll show all the checkboxes on the screen but they are all one in value when it gets added to the database

 

what would u suggest?

would u care to look at the whole of my code?

[cooldude832]

so the service Tag Names are in a separate table?

if so look into a two table query and restrucutre your checkboxes to be

<?php
<input type=\"checkbox\" name=\"interest[$row['ServiceName]]'\" value=\"$row['ServiceID']."\" />";

?>

[megz90]

yeah the services names are in a table called

xservices containing  (serviceid, sname, cost, description,)

in the booking table i have a field called 'services' which should store all the services that a cust selects and i thought the implode all the selected serviceId would be the best way.

 

so if a cust wants to edit a booking i can just show a edit form with the things they selected and all the other services as well so they can choose.

 

iwas looking at doing this  in a different way to start with.

http://www.phpfreaks.com/forums/index.php/topic,188079.msg843084.html#msg843084

 

but was told not to go that way as it would be very difficult.

 

what do you think ?

 

[cooldude832]

try redoing your query to be a bit better

since I don't know your exact table structure I can't be too specific but try something like

<?php
$q = "Select xhorse.dbhorseid as horseid, xhorse.dbhorsename as horsename, 
xservice.dbserviceID as ServiceID, xserviec.dbservicename as servicename, xserviec.dbdescription as dbdescription from `xhorse`, `xservice` 
where xhorse.dbOwnerID = '".$_SESSION['sess_loggedon']."'" 
Group By xhorse.dbhorseID";
$r = mysql_query($q) or die(mysql_error()."<br /><br />."$q);
while($row = mysql_fetch_assoc($r)){
print_r($row);
echo "\n\n\n\n\n";
}
?>

See how that works.

[megz90]

thankyou, i'll send you a message tomorrow from uni, my internet and localhost setup keep crashing.

thanks for taking the time out to try and help.

i;ll let you know how it goes.