PHP Question. Help me out here, folks. - Page 2

**Mark** · March 12th, 2008, 5:07 PM

PHP: mysql_real_escape_string - Manual
(edit: by that i mean the function mysql_real_escape_array())
I use that in all of my applications when i have large amounts of posts. However it doesn't work when passing arrays through POST, such as multiselect boxes or multiple checkboxes; it will null the array. Haven't figured out why yet

**Roxy** · March 12th, 2008, 5:09 PM

Quote:

Originally Posted by Mark

That is true. I also don't like restoring databases

LOLZ

cass_is_awesome · March 12th, 2008, 5:18 PM

Quote:

Originally Posted by Mark

That is true. I also don't like restoring databases

That, my friend, is some epic stuff right there.

**Thomas** · March 12th, 2008, 5:47 PM

Quote:

Originally Posted by Mark

That is true. I also don't like restoring databases

muhahahaha!!! and I was thinking of naming my kid Thomas v2.0, but never mind I found a new name!

H · March 12th, 2008, 6:34 PM

Quote:

Originally Posted by Mark

PHP: mysql_real_escape_string - Manual
(edit: by that i mean the function mysql_real_escape_array())
I use that in all of my applications when i have large amounts of posts. However it doesn't work when passing arrays through POST, such as multiselect boxes or multiple checkboxes; it will null the array. Haven't figured out why yet

You have to use a weird array_map conditional to check to see if it's an array or not. I have a code snippet somewhere... I may look it up and post it later.

cass_is_awesome · March 12th, 2008, 6:46 PM

Apparently, they don't want anyone to understand it.

H · March 13th, 2008, 12:11 PM

I remember it being pretty simple.. Have a custom function run through array_map on $_POST, then do a conditional to see if it's an array or not... if it is, run an array_map on that one, yada yada yada...

**Mark** · March 13th, 2008, 1:13 PM

I've used something like that:

PHP Code:


			
   function escape_array($array) {

       foreach ($array as $key => $value) {

               if (is_array($value)) {

                       $array[$key] = escape_array($value);

               } else {

                       $array[$key] = mysql_real_escape_string(trim($value));

               }

       }

       return $array;

    }

However this eats them too

stupid php

March 12th, 2008, 5:07 PM	#10 (permalink)
Mark Surpass Developer On a golden path... Joined in Jan 2004 Lives in Florida Hosted on decc.surpasshosting.com 396 posts Gave thanks: 10 Thanked 68 times	PHP: mysql_real_escape_string - Manual (edit: by that i mean the function mysql_real_escape_array()) I use that in all of my applications when i have large amounts of posts. However it doesn't work when passing arrays through POST, such as multiselect boxes or multiple checkboxes; it will null the array. Haven't figured out why yet __________________ Mark Surpass Hosting Developer sɹnoʎ uɐɥʇ ɹǝʇʇǝq sı bıs ʎɯ

March 12th, 2008, 6:46 PM	#15 (permalink)
cass_is_awesome Cass Doesn't Sleep Seasoned Poster Joined in Mar 2008 Lives in Michigan Hosted on SH138 78 posts Gave thanks: 5 Thanked 6 times	Apparently, they don't want anyone to understand it. __________________ rockin' contrabandheart.net on SH138

March 13th, 2008, 1:13 PM	#17 (permalink)
Mark Surpass Developer On a golden path... Joined in Jan 2004 Lives in Florida Hosted on decc.surpasshosting.com 396 posts Gave thanks: 10 Thanked 68 times	I've used something like that: PHP Code: `function escape_array($array) { foreach ($array as $key => $value) { if (is_array($value)) { $array[$key] = escape_array($value); } else { $array[$key] = mysql_real_escape_string(trim($value)); } } return $array; }` However this eats them too stupid php __________________ Mark Surpass Hosting Developer sɹnoʎ uɐɥʇ ɹǝʇʇǝq sı bıs ʎɯ

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

March 13th, 2008, 12:11 PM	#16 (permalink)
H after g, before i Super #1 Joined in Jul 2004 Hosted on Gojira 7,870 posts Gave thanks: 44 Thanked 127 times	I remember it being pretty simple.. Have a custom function run through array_map on $_POST, then do a conditional to see if it's an array or not... if it is, run an array_map on that one, yada yada yada...

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)