String2Array??

[mystic]

I have a variable that looks like this

$result="10:S MW/20:DHTS/10:D HCS/60:HH DC";

(it is retreived from a MySQL table(VarChar))

I want to make in into an PHP array so that looks like this

"10:S MW","20😃HTS","10😃 HCS","60:HH DC"

Here is the deal..
I have a PAGE.PHP that gets that $result, seperates it by slash and displays them on the screen as links..
I want to be able to remove that portion of the string by clicking on the approriate link..

 
$V = EXPLODE("/",$result);
$Count = count($V);
$X = 0;
while ($X < $Count) {
 echo "<a href='delete.php?D=".$V[$X].">".$V[$X]."</A><BR>";
 $X = $X+1;
}

When the link is clicked, and delete.php is loaded it
does a GET_PARAM("D") to see which one I need to delete

the entire original $result is still there also

How to I get $D out of $array so I can update the MySQL table with $NewArray?

like if they clicked on one that says 20😃HTS I want the NewArray to be stored in a variable like this:

$NewArray="10:S MW/10:D HCS/60:HH DC";

so I can do this:

$Query="UPDATE Table_Name SET Field_Name = '".$NewArray."' WHERE ID='".$ID."' ";

Any Suggestions?
Thanx,
Mystic

by the way, I have spent the past 3 hours trying everything from ARRAY_DIFF() to str_replace()
(I went to PHP.NET and after playing with several things, just decided to try all the commands that looked like they might work..
I think they didnt becasue my $result is not a 'propor' array even though I tried EXPLODE and then did $VALUE=Array($result)..which didnt work either.. )

[[deleted]]

Check this code out..it should give you an idea on how to accomplish it...

<?
$result="10:S MW/20:DHTS/10:D HCS/60:HH DC";

echo "$result<BR>\n";

$V = EXPLODE("/",$result);

foreach($V as $part) {
    echo "$part<BR>\n";
}

//ok, let's say we want to delete part 1 (20:DHTS)

array_splice($V, 1, 1);

foreach($V as $part) {
    echo "$part<BR>\n";
}

$result = implode('/', $V);

echo "$result<BR>\n";
?>

[mystic]

Here is where I have the problem though..

array_splice($V, 1, 1);

I need to be able to get the location of a particular part of the array (not passed from the form)

As I mentioined before it does a GET_PARAM("D")

Lets say D='20😃HTS'
(that part is passed from the form.. can be changed a little if needed (but cannot get the #)

Anyway, How can I count my way through the $result
and if $Count == $D then remove only that one (using splice I guess)

$result="10:S MW/20:DHTS/10:D HCS/60:HH DC";
$ResultX = explode("/",$result);
$Count = count($ResultX);
$X = 0;

while ($X < $Count) 
{
     if ($ResultX[$X] == $Count) 
    { 
    array_splice($ResultX, $X, 1); 
    } else {  

    }
 $X = $X+1;
}

$result = implode("/",$ResultX);

echo "<BR>NewResult: ".$result."<BR>";

I need it to be able to dynamically delete whatever portion matched $D (from the URL) out of the $result

does that make sence?
I dont know anymore.. this stuff is giving em a headache.. mainly because it SEEMS like it should be simple.. yet here I am..
(sigh)

Thanx for all your help mattwade!!
(suggestions from others are welcome..please..)
-Mystic

[mystic]

arghh!!
I goofed.. it should be more like

$result="10:S MW/20:DHTS/10:D HCS/60:HH DC";
$ResultX = explode("/",$result);
$Count = count($ResultX);
$X = 0;

while ($X < $Count) 
{
     if ($ResultX[$X] == $D) 
// this part should check to see if the current $ResultX[$X]
// is equal to the one form ther URL and if it is, remove it 
//from the array
    { 
    array_splice($ResultX, $X, 1); 
    } else {  

    }
 $X = $X+1;
}

$result = implode("/",$ResultX);

echo "<BR>NewResult: ".$result."<BR>";

I'm pretty tired..
eagerly awaiting your reply..
Thanx,
-Mystic

[[deleted]]

Try this..using the array_search function:

<?
$result="10:S MW/20:DHTS/10:D HCS/60:HH DC";

echo "$result<BR>\n";

$V = EXPLODE("/",$result);

foreach($V as $part) {
    echo "$part<BR>\n";
}

//ok, let's say we want to delete part 20:DHTS

$D = "20:DHTS";

array_splice($V, array_search($D,$V), 1);

foreach($V as $part) {
    echo "$part<BR>\n";
}

$result = implode('/', $V);

echo "$result<BR>\n";
?>

[mystic]

IF I COULD REACH THROUGH THIS SCREEN I WOULD HUG YOU!!..

Thank you SOO much!!

It works great!!!

If there is ever anything I can help with, just let me know..
even though it is pretty obvious I couldn't help with much, it wouldnt stop me from trying..

Thank you mattwade!

-Mystic

[mystic]

by the way, I dont guess you would happen to know off-hand how I can add up all the numbers in that $result to make sure they = '100' before I run that UPDATE query would ya?

I though of using soemthing like

if ( is_numeric($result[$X]) ) {
 $SUM = $SUM + array_sum($result[$X]);
}



if ($SUM == '100') {
RUN_UPDATE_QUERY();
} else {
echo "The numbers dont add up to 100.<BR>";
}

THANK YOU SOOooo MUCH!
(kneeling and bowing repeatedly to the kind PHPMaster mattwade)

-Mystic

[[deleted]]

<?
$result="10:S MW/20:DHTS/10:D HCS/60:HH DC";

echo "$result<BR>\n";

$V = EXPLODE("/",$result);
$sum = 0;
foreach($V as $part) {
   $sum += $part;
}
echo $sum;

/* as long as the numbers always start each part of the array,
 * we can add them up. PHP will toss out any extra data after
 * the number. if the part starts with something other than
 * a number, we get unexpected results */
?>

Also, when doing numerical evaluations, make sure you drop the quotes:

if ($SUM == 100) {