Returning MYSQL DB results with array_map

Question

I'm currently using a custom PHP framework. It has a Class designed to handle interaction with the MYSQL database.

The select function, takes the table and a query, generates rows via mysqli_fetch_array($result, MYSQL_ASSOC) and either returns a regular array (each row is one element in the array) or FALSE if there are no results returned.

I'm thinking about adding the following statement to automatically always remove escaping slashes from the results

$data[] = array_map('stripslashes',$row );

As this class is used all over the application for returning anything from the database, would this be a sensible idea, versus always remembering to output data with stripslashes whenever it's from user or third party input?

If you add this to the Class it will executed for all. Rather execute this whenever needed after fetching data. — Sougata Bose
– Sougata Bose, Commented Dec 16, 2015 at 9:01
mentioning the framework and tagging it accordingly always helps — bIgBoY
– bIgBoY, Commented Dec 16, 2015 at 9:05

Amit Shah · Accepted Answer · 2015-12-16 09:55:41Z

1

It would be good to add config switch to class, and when fetching data from it

you should pass the switch if want to stripslashes the data otherwise not,

Thanks Amit

answered Dec 16, 2015 at 9:55

Amit Shah

1,3801 gold badge10 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

thatguy Over a year ago

Thanks. The question I'm really trying to work out is on a relatively busy web app, is running array_map on all rows to stripslashes by default a bad idea for performance or is the difference likely to be negligible?

Amit Shah Over a year ago

the difference is going to be very negligible so you can use it. @thatguy

Collectives™ on Stack Overflow

Returning MYSQL DB results with array_map

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related