DaniWeb Forum Index > Web Development > PHP

Storing checkbox values.............

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 145

Reputation: ishlux is an unknown quantity at this point

Solved Threads: 0

ishlux

Offline

Junior Poster

Storing checkbox values.............

Aug 8th, 2008

Hi all,
I am storing check box values with comma separated into db like this , the code given below

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php 	
	include 'database.php';
 
$servicec = addslashes(serialize($a1)); 
$servicet = addslashes(serialize($b1)); 
$services = addslashes(serialize($c1)); 
 
 
 
$query1 = "insert into autoalto_contractor( 	service_category,service_type,services) values ('".$servicec."',
'".$servicet."','".$services."')";
<?php 	
	include 'database.php';

$servicec = addslashes(serialize($a1)); 
$servicet = addslashes(serialize($b1)); 
$services = addslashes(serialize($c1)); 
		 


$query1 = "insert into autoalto_contractor( 	service_category,service_type,services) values ('".$servicec."',
'".$servicet."','".$services."')";

but while retrieving from the db i am not able to display it properly the code is given below

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
session_start();
include('database.php');
$result = mysql_query("SELECT * FROM  autoalto_contractor" );
 
while($row = mysql_fetch_array($result))
 {
	?>
	<tr>
		<td width="5%"></td>
 
		<td><?echo $row['service_category'];?></td>
		<td><?echo $row['service_type'];?></td>
		<td><?echo $row['services'];?></td>
 
	</tr>
	<tr>
		<td width="5%"></td>			
		<td colspan="4" style="background-repeat: repeat-x;" background="images/dot.jpg" height="0" width="300"></td>
	</tr>
	<?		
}
mysql_close();
?>
<?php
session_start();
include('database.php');
$result = mysql_query("SELECT * FROM  autoalto_contractor" );
	
while($row = mysql_fetch_array($result))
 {
	?>
	<tr>
		<td width="5%"></td>
				
		<td><?echo $row['service_category'];?></td>
		<td><?echo $row['service_type'];?></td>
		<td><?echo $row['services'];?></td>

	</tr>
	<tr>
		<td width="5%"></td>			
		<td colspan="4" style="background-repeat: repeat-x;" background="images/dot.jpg" height="0" width="300"></td>
	</tr>
	<?		
}
mysql_close();
?>

its giving the o/p like this

a:3:{i:0;s:18:"vehicle Inspection";i:1;s:14:"batteryservice";i:2;s:10:"oil canhge}
i want only vehicle inspection , battery service like this...........can anybody help me pls...........i am trying this from long time.

•

Join Date: Jun 2008

Posts: 133

Reputation: vicky_rawat is an unknown quantity at this point

Solved Threads: 17

vicky_rawat vicky_rawat is offline

Offline

Junior Poster

Re: Storing checkbox values.............

Aug 8th, 2008

Hi,

I think you will need to unserialize the values after retrieving them from db.

Vivek

Vivek Rawat
Keep solving complexities.

•

Join Date: Jun 2008

Posts: 145

Reputation: ishlux is an unknown quantity at this point

Solved Threads: 0

ishlux

Offline

Junior Poster

Re: Storing checkbox values.............

Aug 8th, 2008

ok where to write unserialize and how to write unserialize method......

•

Join Date: Jun 2008

Posts: 145

Reputation: ishlux is an unknown quantity at this point

Solved Threads: 0

ishlux

Offline

Junior Poster

Re: Storing checkbox values.............urgent plz help me

Aug 8th, 2008

Hi all,
i used unserialize method but its displaying like this

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
		<td><?echo unserialize($row['service_category']);?></td>
		<td><?echo unserialize($row['service_category']);?></td>

o/p is
emailId zipcode service_category service_type services

ishu@gmail.com 3333 Array N; N;

Instead displaying value its displaying Array so what to do now..........pls help me

•

Join Date: Aug 2008

Posts: 381

Reputation: langsor is an unknown quantity at this point

Solved Threads: 33

langsor

Offline

Posting Whiz

Re: Storing checkbox values.............

Aug 9th, 2008

If you are using mysql_fetch_row it returns your data as an array ... thus the array in your output.

You should manage your database output before writing it to the html page.
Something like this ...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$arr = mysql_fetch_row( $result );
$str = implode( " ", $arr );
print $str;
$arr = mysql_fetch_row( $result );
$str = implode( " ", $arr );
print $str;

•

Join Date: Jun 2008

Posts: 145

Reputation: ishlux is an unknown quantity at this point

Solved Threads: 0

ishlux

Offline

Junior Poster

Re: Storing checkbox values.............

Aug 11th, 2008

I used the implode function, but still its not working........................

•

Join Date: Aug 2008

Posts: 381

Reputation: langsor is an unknown quantity at this point

Solved Threads: 33

langsor

Offline

Posting Whiz

Re: Storing checkbox values.............

Aug 11th, 2008

You don't really say what is not working, or how?
I'm assuming your database query is giving you results,
That the results have been serialized as demonstrated above,
And you're just still having trouble unserializing the results and getting them into your <td> fields ...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
session_start();
include('database.php');
$result = mysql_query( "SELECT * FROM  autoalto_contractor"  );
 
while( $row = mysql_fetch_array( $result ) ) {
  $service_category = unserialize( $row['service_category'] );
  $service_type = unserialize( $row['service_type'] );
  $services = unserialize( $row['services'] );
 
print <<<endline
  <tr>
    <td width="5%"></td><!--??? WHY THIS width="5%" ???-->
    <td>$service_category</td>
    <td>$service_type</td>
    <td>$services</td>
  </tr>
  <tr>
    <td width="5%"></td><!--??? colspan="3" below ???-->
    <td colspan="4" style="background-repeat: repeat-x;" background="images/dot.jpg" height="0" width="300"></td>
  </tr>
endline;
}
mysql_close();
?>
<?php
session_start();
include('database.php');
$result = mysql_query( "SELECT * FROM  autoalto_contractor"  );

while( $row = mysql_fetch_array( $result ) ) {
  $service_category = unserialize( $row['service_category'] );
  $service_type = unserialize( $row['service_type'] );
  $services = unserialize( $row['services'] );

print <<<endline
  <tr>
    <td width="5%"></td><!--??? WHY THIS width="5%" ???-->
    <td>$service_category</td>
    <td>$service_type</td>
    <td>$services</td>
  </tr>
  <tr>
    <td width="5%"></td><!--??? colspan="3" below ???-->
    <td colspan="4" style="background-repeat: repeat-x;" background="images/dot.jpg" height="0" width="300"></td>
  </tr>
endline;
}
mysql_close();
?>