Targeting Specific Data

lazzerous

ok... I'm working with a table in a database that consists of an ID number and a blob field.

each entry of the blob field is populated with a gigantic multi-dimensional array that's been serialized.

no - i didn't create this monster

There are some pieces of data in each entry that I need to replace... but I'm not sure of the best way to do this with a 100% guarantee that all data will be modified correctly.

Within each serialized multidimensional array there will be several chunks similar to this:

<a href=\"javascript:stockCheck(\'DGP-100L-1\')\">DGP-100L-1</a>

the values within the (\' and \'), along with the values between \"> and </a> are always different.

I want to pull that whole chunk out, throw the value from between the \"> and </a> into a different table, and replace the chunk with something along the lines of DB_PART_NUM('$id')

I'm a little unsure of the best way to do this to all entries in the db in one fell swoop - there's a lot of them

any suggestions as the best route to go?

Thanks.
-=Lazz=-

lazzerous

just for reference, here's what one of the smaller entries looks like:

a:3:{s:7:\"caption\";a:1:{i:0;a:4:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:5:\"value\";s:46:\"D*A Series Crimp and Poke Loose-Piece Contacts\";}}s:6:\"header\";a:3:{i:0;a:5:{i:0;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:16:\"Contacts per Bag\";}i:1;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:3:\"100\";}i:2;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:3:\"100\";}i:3;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:4:\"1000\";}i:4;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:4:\"1000\";}}i:1;a:5:{i:0;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:10:\"Wire Gauge\";}i:1;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:9:\"20-24 AWG\";}i:2;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:9:\"26-30 AWG\";}i:3;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:9:\"20-24 AWG\";}i:4;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"2\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:9:\"26-30 AWG\";}}i:2;a:9:{i:0;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:7:\"Plating\";}i:1;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:10:\"Gold Flash\";}i:2;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:16:\"30μin. Gold\";}i:3;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:10:\"Gold Flash\";}i:4;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:16:\"30μin. Gold\";}i:5;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:10:\"Gold Flash\";}i:6;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:16:\"30μin. Gold\";}i:7;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:10:\"Gold Flash\";}i:8;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:16:\"30μin. Gold\";}}}s:4:\"data\";a:2:{i:0;a:9:{i:0;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:3:\"Pin\";}i:1;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGP-100L-1\')\">DGP-100L-1</a>\";}i:2;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGP-100L-2\')\">DGP-100L-2</a>\";}i:3;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGP-100L-3\')\">DGP-100L-3</a>\";}i:4;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGP-100L-4\')\">DGP-100L-4</a>\";}i:5;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:62:\"<a href=\"javascript:stockCheck(\'DGP-1000L-1\')\">DGP-1000L-1</a>\";}i:6;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:62:\"<a href=\"javascript:stockCheck(\'DGP-1000L-2\')\">DGP-1000L-2</a>\";}i:7;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:62:\"<a href=\"javascript:stockCheck(\'DGP-1000L-3\')\">DGP-1000L-3</a>\";}i:8;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGP-100L-4\')\">DGP-100L-4</a>\";}}i:1;a:9:{i:0;a:6:{s:1:\"b\";s:4:\"true\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:6:\"Socket\";}i:1;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGS-100L-1\')\">DGS-100L-1</a>\";}i:2;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGS-100L-2\')\">DGS-100L-2</a>\";}i:3;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGS-100L-3\')\">DGS-100L-3</a>\";}i:4;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGS-100L-4\')\">DGS-100L-4</a>\";}i:5;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:62:\"<a href=\"javascript:stockCheck(\'DGS-1000L-1\')\">DGS-1000L-1</a>\";}i:6;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:62:\"<a href=\"javascript:stockCheck(\'DGS-1000L-2\')\">DGS-1000L-2</a>\";}i:7;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:62:\"<a href=\"javascript:stockCheck(\'DGS-1000L-3\')\">DGS-1000L-3</a>\";}i:8;a:6:{s:1:\"b\";s:5:\"false\";s:1:\"u\";s:5:\"false\";s:1:\"i\";s:5:\"false\";s:7:\"colspan\";s:1:\"1\";s:7:\"rowspan\";s:1:\"1\";s:5:\"value\";s:60:\"<a href=\"javascript:stockCheck(\'DGS-100L-4\')\">DGS-100L-4</a>\";}}}}

lazzerous

This is my current plan of action...

select each entry from the db
unserialize and rebuild as a milti dim array
find each value that has '<a href' (eregi())
grab data between \"> & </a>
throw that into a a diff table
grab the id of that entry
replace value in milti dim array with "DB_PART_NUM($id)"
re-serialize the array
update the db

lazzerous

ok... for grabbing only that piece of data from the entry... we'll call if $value

$value = "<a href=\"javascript:stockCheck(\'DGP-100L-2\')\">DGP-100L-2</a>";

$value = str_replace("<a href=\"javascript:stockCheck(\'", "", $value);

$value = str_replace("\')\">", "", $value);

$value = str_replace("</a>", "", $value);

// need to cut it in half as this will leave the part number repeated
$value_length = strlen($value);
$new_length = ($value_length / 2);
$value = substr($value, $new_length)

// $value = "DGP-100L-2"

lazzerous

ok... duh.. striptags...