php help? (unique unserialize)

woopwoop · 05-08-2010, 06:17:38 PM

Need a bit of help with some php and a few kind members helped me in the past.

My code is:

PHP Code:

  $query = "SELECT names FROM table WHERE type='$type'";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) { 
foreach(unserialize($row['names']) as $key => $value){ 
echo $value . '<br />'; 
} 
}

Basically, a field on my table is called names. The information in this field is serialized (so many names are together in a single field, for a single row).

I want to be able to search the whole table (where type='$type' - so many rows) for all names and then show unique names only.

My code above unserializes the names from each field and then lists them, but doesn't deal with any duplicates (which I need removing).

I have looked at functions like "unique_array()", and have tried using it in different places but it isn't doing the job.

Any help appreciated.

JDubya · 05-08-2010, 06:54:21 PM

PHP Code:

  $new_array = array();

 
while($row = mysql_fetch_array($result)) { 

    foreach(unserialize($row['names']) as $key => $value){ 

    //echo $value . '<br />'; 

    $new_array[] = $value

    } 

}

 
$unique_array = array_unique( $new_array );

var_dump( $unique_array );

Try this quick fix...

woopwoop · 05-08-2010, 07:08:50 PM

Many thanks for your reply jDubya.

I just took someone's advice on another forum and the following code worked:

PHP Code:

  $names = array();
while($row = mysql_fetch_array($result)) { 
   $names = array_unique(array_merge($names, unserialize($row['names'])));
}
foreach($names as $value){ 
   echo $value . '<br />'; 
}

Will take a look at your code later. I love PHP but the more i learn the more i don't understand!

Appreciate your help.

JDubya · 05-08-2010, 08:27:02 PM

Your welcome - one thing to keep in mind though is that a solution like this doesn't scale well so on a larger data set performance would degrade massively... If working with larger data sets the DB should be doing the work instead of PHP.

My problem when I first started learning PHP I wasn't properly shown Mysql - didn't learn for a long time things like EXPLAIN, INDEXES, DISTINCT(), DATE_SUB() etc instead of relying completely on PHP. Probably the single most useful period of learning I went through.

Good luck!

05-08-2010, 06:17:38 PM	#1 (permalink)
woopwoop Join Date: Jan 2007 Posts: 1,586 No Classified Ratings Domain Trader Rating: (100% / 20)	php help? (unique unserialize) Need a bit of help with some php and a few kind members helped me in the past. My code is: PHP Code: `$query = "SELECT names FROM table WHERE type='$type'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)) { foreach(unserialize($row['names']) as $key => $value){ echo $value . '<br />'; } }` Basically, a field on my table is called names. The information in this field is serialized (so many names are together in a single field, for a single row). I want to be able to search the whole table (where type='$type' - so many rows) for all names and then show unique names only. My code above unserializes the names from each field and then lists them, but doesn't deal with any duplicates (which I need removing). I have looked at functions like "unique_array()", and have tried using it in different places but it isn't doing the job. Any help appreciated. __________________ Connect with me @ TW:LI:FB \| MyWeb \| D/L domains4sale \| Morecambe London Student Forums Student Books UK promotions agencies

05-08-2010, 06:54:21 PM	#2 (permalink)
JDubya Member Join Date: Apr 2010 Location: Buenos Aires Posts: 83 No Classified Ratings Domain Trader Rating: (100% / 1)	PHP Code: `$new_array = array(); while($row = mysql_fetch_array($result)) { foreach(unserialize($row['names']) as $key => $value){ //echo $value . '<br />'; $new_array[] = $value } } $unique_array = array_unique( $new_array ); var_dump( $unique_array );` Try this quick fix...

05-08-2010, 07:08:50 PM	#3 (permalink)
woopwoop Join Date: Jan 2007 Posts: 1,586 No Classified Ratings Domain Trader Rating: (100% / 20)	Many thanks for your reply jDubya. I just took someone's advice on another forum and the following code worked: PHP Code: `$names = array(); while($row = mysql_fetch_array($result)) { $names = array_unique(array_merge($names, unserialize($row['names']))); } foreach($names as $value){ echo $value . '<br />'; }` Will take a look at your code later. I love PHP but the more i learn the more i don't understand! Appreciate your help. __________________ Connect with me @ TW:LI:FB \| MyWeb \| D/L domains4sale \| Morecambe London Student Forums Student Books UK promotions agencies

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Domain Name Community	Replies	Last Post
unique seo minisite offer /3 review copy going cheap	domain7172	Mini Sites	1	16-01-2010 05:07:32 AM
PHP include in a Smarty Template	admin	Scripts and Coding	1	13-05-2008 06:37:26 AM

05-08-2010, 08:27:02 PM	#4 (permalink)
JDubya Member Join Date: Apr 2010 Location: Buenos Aires Posts: 83 No Classified Ratings Domain Trader Rating: (100% / 1)	Your welcome - one thing to keep in mind though is that a solution like this doesn't scale well so on a larger data set performance would degrade massively... If working with larger data sets the DB should be doing the work instead of PHP. My problem when I first started learning PHP I wasn't properly shown Mysql - didn't learn for a long time things like EXPLAIN, INDEXES, DISTINCT(), DATE_SUB() etc instead of relying completely on PHP. Probably the single most useful period of learning I went through. Good luck!