Re^4: Writing NULL values to a MySQL record via DBI

Definitely looking at placeholders now :o) Thankfully this code is executing firmly behind closed doors and not on a public server - but I understand this appears to be a much better and secure way do perform database access tasks. But more reading to be done... every day is a school day :o) Thanks

Comment on Re^4: Writing NULL values to a MySQL record via DBI

Replies are listed 'Best First'.
Re^5: Writing NULL values to a MySQL record via DBI by chacham (Prior) on Feb 27, 2015 at 14:43 UTC
Although it is behind closed doors today, there's no telling what will be tomorrow. It also helps by mostly forcing type definition of the parameters. Further, by preparing the statement, it make it more efficient when running it multiple times. It's really easy to do. Just use placeholders, define them with the appropriate statements, and pass them when executing the query.	[reply]