PHP - Passing Options To Unserialize

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

My code is:
$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.

I am trying to unserialize this string:

a:3:{s:3:\"zip\";s:5:\"55068\";s:4:\"city\";s:9:\"Rosemount\";s:5:\"state\";s:2:\"MN\";}

but I unserialize is returning false.

Why is it doing that?

$info = unserialize($_COOKIE['zipcode']);
var_dump($info);

I have an array from the database like so


Array (2)
(
|    ['0'] => Array (4)
|    (
|    |    ['f_fid'] = String(1) "1"
|    |    ['0'] = String(1) "1"
|    |    ['f_names'] = String(99) "a:4:{i:0;s:18:"register_user_name";i:1;s:5:"r_u_n";i:2;s:10:"user_alias";i:3;s:12:"nickusername";} "
|    |    ['1'] = String(99) "a:4:{i:0;s:18:"register_user_name";i:1;s:5:"r_u_n";i:2;s:10:"user_alias";i:3;s:12:"nickusername";} "
|    )
|    ['1'] => Array (4)
|    (
|    |    ['f_fid'] = String(1) "2"
|    |    ['0'] = String(1) "2"
|    |    ['f_names'] = String(104) "a:4:{i:0;s:18:"register_password";i:1;s:5:"r_pass_word";i:2;s:10:"user_pass";i:3;s:12:"reg-pass-word";} "
|    |    ['1'] = String(104) "a:4:{i:0;s:18:"register_password";i:1;s:5:"r_pass_word";i:2;s:10:"user_pass";i:3;s:12:"reg-pass-word";} "
|    )
)


So i use a foreach loop to turn the serialized value into an array


foreach($fields as $key => $val)
    {
        $fields[$key]['f_names'] = unserialize($val['f_names']);
    }


But for some reason the last f_names is false


Array (2)
(
|    ['0'] => Array (4)
|    (
|    |    ['f_fid'] = String(1) "1"
|    |    ['0'] = String(1) "1"
|    |    ['f_names'] => Array (4)
|    |    (
|    |    |    ['0'] = String(18) "register_user_name"
|    |    |    ['1'] = String(5) "r_u_n"
|    |    |    ['2'] = String(10) "user_alias"
|    |    |    ['3'] = String(12) "nickusername"
|    |    )
|    |    ['1'] = String(99) "a:4:{i:0;s:18:"register_user_name";i:1;s:5:"r_u_n";i:2;s:10:"user_alias";i:3;s:12:"nickusername";} "
|    )
|    ['1'] => Array (4)
|    (
|    |    ['f_fid'] = String(1) "2"
|    |    ['0'] = String(1) "2"
|    |    ['f_names'] = Boolean(0) FALSE
|    |    ['1'] = String(104) "a:4:{i:0;s:18:"register_password";i:1;s:5:"r_pass_word";i:2;s:10:"user_pass";i:3;s:12:"reg-pass-word";} "
|    )
)


Anyone have any idea why?

Thanks

my user pm table has a touserarray field which is a serialized array that looks like this:
a:1:{s:2:"cc";a:1:{i:15773;s:14:"testusername";}}
i know I can unserialize it with the unserialize() function.
But I need to extract the value corresponding to 'i' field and the 's' field that has the username.

So  from the above array, i need to retrieve the value '15773' and 'testusername'.
Can someone tell me how?
 

Hi,

I'm new to PHP and wondered if anyone could help...

I am consuming an asmx webservice using PHP code. (Later to make a widget for wordpress).

I can receive all the data, but it is in one very big xml file.

I want to be able to convert this data, so I can make it more readable.

Could really do with help as I don't have a clue how to convert it.

ANy ideas?

Hi everyone,

Im trying to serialize the values of checked checkboxes, save them to a database, then on another page retrieve the value from the database, unserialize it, and then write each checkbox value to the database individually.

Using the following test code I'm able to serialize the checkbox values, and then unserialize them and echo them out fine, however im unsure how to separate them and save them individually into the database.


$string = implode($_POST['checkbox']);
$test = serialize($string);
$test2 = unserialize($test);
echo $test2;

<?php $i = 0; ?>
<?php while ($row = mysql_fetch_assoc($query)) { ?>

<tr>
    

<td><input type="checkbox" name="<?php echo "checkbox[$i]"; ?>" value="<?php echo $row['test']; ?>" /></td>
    </tr>
<?php $i++; } ?>


Any ideas?
Thanks

Debian 5
PHP 5.2.6-1

This script works:

       <?
      $output = shell_exec('ls -lart');
      echo "<pre>$output</pre>";
      ?>



This script doesn't work:
      <?
      $vars=unserialize(file_get_contents("file.txt"));
      $output = shell_exec('ls -lart');
      echo "<pre>$output</pre>";
      ?>


I get error:
Quote

Warning: shell_exec(): Unable to execute 'ls -lart'

or
Warning: system(): Unable to fork [ls -lart]

If file.txt has size 500k, the script works without errors.
But my file file.txt has size 30M.

Help.

the code is simple but the output is wrong.

Code: [Select]
$str = <<<EOF
a:2:{s:7:"visible";a:7:{i:0;s:5:"email";i:1;s:5:"print";i:2;s:8:"facebook";i:3;s:4:"digg";i:4;s:11:"stumbleupon";i:5;s:7:"twitter";i:6;s:6:"reddit";}s:6:"hidden";a:0:{}}
EOF;
echo "<textarea rows='10' cols='90'>";print_r(unserialize($str));echo "</textarea>";
the ouput is
Code: [Select]
Array
(
    [visible] => Array
        (
            [0] => email
            [1] => print
            [2] => facebook
            [3] => digg
            [4] => stumbleupon
            [5] => twitter
            [6] => reddit
        )

    [hidden] => Array
        (
        )

)
This is wrong I need something like this:
Code: [Select]
array (
  'visible' =>
  array (
    0 => 'email',
    1 => 'print',
    2 => 'facebook',
    3 => 'digg',
    4 => 'stumbleupon',
    5 => 'twitter',
    6 => 'reddit',
  ),
  'hidden' =>
  array (
  ),
)
What am I doing wrong? How do I fix it?

Hello, I have a call tu function unserialize() in a script that receives a string and has to return an array. In my localhost it works properly but in the server it returns a 1 dimension array with empty value. I'm testing with the string a:1:{s:1:"0";s:8:"value_eq";}

The php.ini configuration for magic_quotes is (in both, server and localhost):

magic_quotes_gpc Off
magic_quotes_runtime Off

Other configurations is difficult to compare, as php info is long and very different in local and server.

Any ideas where the problem might be?

Thank you

Code: [Select]
<?php 
$parentesco .=' 

<ul><li><a href="children.php?category_id='.$idc.'&name= '. $name2 . '">'. $name. ' </a></li></ul>'; ?>
in the url string $idc is passing but $name2 is not. $name2 is pickup from a query, I echo that value everywhere in the code and it echo its value but is not passing so how.

Help

Hello,

I'm just learning php (by force), but am pretty well versed in html and css. I did not rite the following code and I'm not sure how to pull out the php in the following in order to make the page validate.

      <tr>
         <td width="15%"><b><b>Priority</b></td>
         <td>
         <select name="priority" size="1" value="priority">
            <option value=""
<?php if ($row['priority'] == "") echo " selected";?>
            ></option>
            <option value="Normal"
<?php if ($row['priority'] == "Normal") echo " selected";?>
            >Normal</option>
            <option value="Elevated"
<?php if ($row['priority'] == "Elevated") echo " selected";?>
            >Elevated</option>
            <option value="STAT"
<?php if ($row['priority'] == "STAT") echo " selected";?>
            >STAT</option>
         </select>
         </td>
      </tr>

The idea is to prefetch the "priority" info and populate the drop down with that. Afterwards, the user can change the value and once submitted, the value will change in the database. Any pointers would be appreciated - and thanks in advance.

Rich

I have 3 basic questions.  I did a few Google Searches for this data and could not find anything substantion.

What options are available to somewho who wants to send notifications to a Desktop PC (main thing), Android phone, and maybe a few other phone types.  The main thing I need to figure out is about desktop notifications. I heard that GMail was about to release this feature soon, so I know there must be options out there for it.  Are there any options, besides a standard custom desktop application development?

Hi  I have this serach function, wich searches on site by a lot of parameters at the same time (titolo, titolo2, attore1,etc...) , but I want to make them options, so you would have a search field and an options dropdown menu.

Can anyone help me with this?

My code follows:
PHP
Code: [Select]
function jm_search(){
global $database, $sstring, $my, $cinConfig, $Itemid, $option, $mainframe;

$tl_title = _JMOVIES_SEARCHRESULT." ".$sstring;

$suchstring = trim( strtolower( $sstring ) );
$query1   = "SELECT * FROM #__jmovies WHERE"
."\n (titolo LIKE '%".$suchstring."%'"
."\n OR titolo2 LIKE '%".$suchstring."%'"
."\n OR attore1 LIKE '%".$suchstring."%'"
."\n OR attore2 LIKE '%".$suchstring."%'"
."\n OR attore3 LIKE '%".$suchstring."%'"
."\n OR attore4 LIKE '%".$suchstring."%'"
."\n OR nazione LIKE '%".$suchstring."%'"
."\n OR regista LIKE '%".$suchstring."%'"
."\n OR descrizione LIKE '%".$suchstring."%'"
."\n OR anno LIKE '%".$suchstring."%') AND published = 1 AND access <= ".(int)$my->gid." ORDER BY titolo";
$database->setQuery($query1);
//echo $database->getQuery();
$rows = $database->loadObjectList();

if(is_file($mainframe->getCfg('absolute_path')."/components/".$option."/templates/".$cinConfig['template']."/show_search_tpl.php"))
require($mainframe->getCfg('absolute_path')."/components/".$option."/templates/".$cinConfig['template']."/show_search_tpl.php");
else
require($mainframe->getCfg('absolute_path')."/components/".$option."/templates/default/show_search_tpl.php");

}
HTML
Code: [Select]
<td width="44%" valign="middle" bgcolor="#eeeeee" style="text-align:right">
      <input name="sstring" type="text" class="jmoviesInputSearch" title="<?php echo _JMOVIES_SEARCH?>" onfocus="if(this.value=='<?php echo _JMOVIES_SEARCH?>') this.value='';" onblur="if(this.value=='') this.value='<?php echo _JMOVIES_SEARCH?>';" onchange="javascript:document.jmoviesSearchForm.submit();" value="<?php echo _JMOVIES_SEARCH?>" size="50"/><input type="submit" value="OK" class="button"/></td>
Thank you.

Hi, I haven't worked with PHP in years and was asked to debug something.  Maybe you can help me out since I'm stuck.  This error popped up when we upgraded from PHP 5.3 to 5.4.   It is setting LDAP options.   Here is the code: ldap_set_option($ldapconn, LDAP_OPT_PROTOCOL_VERSION, 3);
ldap_set_option($ldapconn, LDAP_OPT_REFERRALS, 0) or die ("Could not set option referrals");     Both of these statement are throwing the following error message to the log.   52 is not a valid ldap link resource   Anything I can check or look at? I am a little clueless here.   Thanks    

I am new to PHP and wasting no time have jumped into creating my own database system. Its actually a psuedo-database, but who cares it works. I've done something some-what similar in Python but with a static single file database.

What I have is directories as like:
./1/index.listing
./2/index.listing
./3/index.listing

The numbers are a product... product 1, product 2, you know..
What I want to do is on the product category page, using:
Code: [Select]
include('./*/index.listing');.. where * would mean for PHP to scan all relative directories and include 'index.listing', which will result in a list being built for the product category, showing all the available products.
There is probably some way to do this in MySQL, but I am already familiur with this style of database, so why waste more Saturday nights learning something I don't have to when I could be out getting drunk and partying with girls 10 years younger than me. LuLz