need help with serialize() again

ungovernable

here's what i'm trying to do

i have a field in my database (options in table quebec_calendarcustomfield) used in vbulletin for calendar custom fields. I want to allow a group of users to add and delete fields...

So now i'm trying to make a page where my users are able to delete a field.

All fields are serialized and stored in quebec_calendarcustomfield WHERE calendarcustomfieldid = '1'

so i tryed to unserialize it, do a str_replace to delete the field i want, and serialize it back....

but i'm stuck at serializing back, i can't find out how to serialize the whole array

include("db.php");
$query = "SELECT options FROM quebec_calendarcustomfield WHERE calendarcustomfieldid = '1'";
$res = mysql_query($query) or die(mysql_error());  

while($row = mysql_fetch_array($res)) { 
$a = $row["options"];

$unseri = unserialize($a);

foreach($unseri as $value)
{
$hmm = str_replace("$legroupe", "", "$value");
   echo $hmm;
} 

echo "<br><br>";
$uhh = serialize($value);
echo $uhh;

$cc = mysql_real_escape_string($uhh);
$zxc = "UPDATE quebec_calendarcustomfield SET options = '$uhh' WHERE calendarcustomfieldid = '1'";
$res = mysql_query($zxc) or die(mysql_error());  

}

$legroupe is a defined $_GET value and it contains the line i want to delete

$a = $row["options"]; is the serialized array of ALL the fields, including the one i want to delete

halojoy

ungovernable wrote:
bump

As your bump did not work, I jump in here.
I think the other 'are sleeping'.
Normally NogDog would reply to every unanswered topic.
It's his job and without him I would have to jump in
and do every unheard call for HELP!!!!
Do this just out of my pure mercyful feeling for the poster.
Like this time.

I am halojoy.
I have posted like 1.800 helpful posts.
Many with code I have re-worked and test run at my personal PHP Server.

Likeso with this code, that maybe can solve your issue.
Think it will work at your server, as well as it did at mine.

I don't think I would have to add much explaning to this code.

I have used 2 test variables:

$legroupe = 'x'; .... which would be to remove 'x'
$arr = a number of array items, having an 'x'

Regards 🙂
your ... halojoy

<?php
/*
include("db.php");
$query = "SELECT options FROM quebec_calendarcustomfield WHERE calendarcustomfieldid = '1'";
$res = mysql_query($query) or die(mysql_error());  

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

$a = $row["options"];
*/

$legroupe = 'x';
$arr = array(
    'k1' => 'aaxa',
    'k2' => 'bbxb',
    'k3' => 'ccxc'
    );

/// START
$a = serialize($arr);
echo 'string: '. $a;
echo '<hr />';

$unseri = unserialize($a);
$new_arr = array();
foreach( $unseri as $k => $value )
{
    $new_arr[$k] = str_replace( $legroupe, "", $value );

echo $k.'='.$new_arr[$k].'<br />';
} 

echo '<hr />';
$uhh = serialize($new_arr);
echo 'string: '.$uhh;

/*
$cc = mysql_real_escape_string($uhh);
$zxc = "UPDATE quebec_calendarcustomfield SET options = '$uhh' WHERE calendarcustomfieldid = '1'";
$res = mysql_query($zxc) or die(mysql_error());  

}
*/

?>

ungovernable

thanks for the help and for the cool introduction 😃 Yeah NagDog is cool he's usually the one answering my topics 🙂

The script you gave me is working with your test variables, but i tryed putting back my settings (database and $_get value)

here is the result:

string: a:8:{i:1;s:18:"111111111111111111";i:2;s:18:"222222222222222222";i:3;s:13:"3333333333333";i:4;s:13:"4444444444444";i:5;s:10:"gggggggggg";i:6;s:14:"55555555555555";i:7;s:12:"666666666666";i:8;s:12:"777777777777";}1=111111111111111111
2=222222222222222222
3=3333333333333
4=4444444444444
5=gggggggggg
6=55555555555555
7=666666666666
8=777777777777
string: a:8:{i:1;s:18:"111111111111111111";i:2;s:18:"222222222222222222";i:3;s:13:"3333333333333";i:4;s:13:"4444444444444";i:5;s:10:"gggggggggg";i:6;s:14:"55555555555555";i:7;s:12:"666666666666";i:8;s:12:"777777777777";}

and the code i used:

<?php

 include("db.php");
$query = "SELECT options FROM quebec_calendarcustomfield WHERE calendarcustomfieldid = '1'";
$res = mysql_query($query) or die(mysql_error());  

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

$a = $row["options"];



/// START

echo 'string: '. $a;
echo '<hr />';

$unseri = unserialize($a);
$new_arr = array();
foreach( $unseri as $k => $value )
{
    $new_arr[$k] = str_replace( $legroupe, "", $value );

echo $k.'='.$new_arr[$k].'<br />';
}

echo '<hr />';
$uhh = serialize($new_arr);
echo 'string: '.$uhh;
}
/*
$cc = mysql_real_escape_string($uhh);
$zxc = "UPDATE quebec_calendarcustomfield SET options = '$uhh' WHERE calendarcustomfieldid = '1'";
$res = mysql_query($zxc) or die(mysql_error());  

}
*/

?>

the string is empty, there seems to be a problem with it :/

sorry for bothering you again, but i'm still a beginner :queasy: Anyway, thanks for your time!

halojoy

first,
to get colored PHP code here in forum,
you should use [ PHP ] your code [ /PHP ]
instead of the bbcode for [ CODE ]
There is a button (far right) marked php for posting php code.

The output you post, is just what we can expect from the script:

string: a:8:{i:1;s:18:"111111111111111111";i:2;s:18:"222222222222222222";i:3;s:13:"3333333333333";i:4;s:13:"4444444444444";i:5;s:10:"gggggggggg";i:6;s:14:"55555555555555";i:7;s:12:"666666666666";i:8;s:12:"777777777777";}

1=111111111111111111
2=222222222222222222
3=3333333333333
4=4444444444444
5=gggggggggg
6=55555555555555
7=666666666666
8=777777777777

string: a:8:{i:1;s:18:"111111111111111111";i:2;s:18:"222222222222222222";i:3;s:13:"3333333333333";i:4;s:13:"4444444444444";i:5;s:10:"gggggggggg";i:6;s:14:"55555555555555";i:7;s:12:"666666666666";i:8;s:12:"777777777777";}

You have not done any replacement, removing in those values.
Can you show the problem with 'empty string' 😕
Thank you 🙂
halojoy

Here is the code you used, in your last post

<?php

include("db.php");
$query = "SELECT options FROM quebec_calendarcustomfield WHERE calendarcustomfieldid = '1'";
$res = mysql_query($query) or die(mysql_error());  

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

$a = $row["options"];
}


/// START

echo 'string: '. $a;
echo '<hr />';

$unseri = unserialize($a);
$new_arr = array();
foreach( $unseri as $k => $value )
{
    $new_arr[$k] = str_replace( $legroupe, "", $value );

echo $k.'='.$new_arr[$k].'<br />';
}

echo '<hr />';
$uhh = serialize($new_arr);
echo 'string: '.$uhh;
}
/*
$cc = mysql_real_escape_string($uhh);
$zxc = "UPDATE quebec_calendarcustomfield SET options = '$uhh' WHERE calendarcustomfieldid = '1'";
$res = mysql_query($zxc) or die(mysql_error());  

}
*/

?>

halojoy

think I know what we need

when is no result, $a gets no value
So let us set a value for a, before we start pull the result
See code below.

But better 🙂
See this MySQL script, with results

that I posted today for another topic:

In this post you will find how to deal, if is 0, 1 or several RESULTS of query.

http://phpbuilder.com/board/showthread.php?p=10861851#post10861851

It is a very useful piece of code.

So copy it and save it 🙂

Here is a try to fix our code here.
It is not complete, but I point to possible way to go.
halojoy

$res = mysql_query($query) or die(mysql_error());  


//$a = array(); //for several hits, will need some other additions, too 
//$a = ""; for one result, will not work for several rows
while($row = mysql_fetch_array($res)) {
    $a = $row["options"];
}

ungovernable

Ooops that's not what i meant, sorry, the string is displayed correctly, but with the code I used no replacements are done...

Thanks anyway for the other explanations, this will help me to solve a problem on another script i was working on 🙂

this is the content of $row["options"]; in my database: ($a)

a:8:{i:1;s:18:"111111111111111111";i:2;s:18:"222222222222222222";i:3;s:13:"3333333333333";i:4;s:13:"4444444444444";i:5;s:10:"gggggggggg";i:6;s:14:"55555555555555";i:7;s:12:"666666666666";i:8;s:12:"777777777777";}

I was trying to take out entry called "gggggggggg"
so i access my script with "?legroupe=gggggggggg" after the .php extension, which should set $_GET['legroupe'] to "gggggggggg" thus determining it is what must be deleted

but the result is what i posted, and "gggggggggg" is still here... I must have done something wrong, because your code was working at beginning (it took off the x between other letters)

Piranha

halojoy wrote:
As your bump did not work, I jump in here.
I think the other 'are sleeping'.
Normally NogDog would reply to every unanswered topic.
It's his job and without him I would have to jump in
and do every unheard call for HELP!!!!
Do this just out of my pure mercyful feeling for the poster.
Like this time.

The bump did work, you answered and it didn't take long.

Why should NogDog answer all questions? This is a community forum where everyone can and should help out with what they know.

I don't intend to make this thread into a discussion about this, if someone want to discuss it further I suggest starting a new thread to avoid this thread being about things that won't help the poster.