Sometimes you have to manage memory in PHP

I’m currently working on a Google maps based project for a client, which deals with large numbers of points and overlays. At one point in the program I was getting around 16,000 Lat/Lng points from the database, which formed 70 polygons. Before the polygons could be rendered on Google Maps, I needed to group the points by polygon in an array. (more…)

Posted in: Programming by Matt Bearman on 2nd December 2011 at 3:53 pm
Tags: , , ,

Fork Me!

…on GitHub.

So I’ve just set up a GitHub account and put a couple of little projects on there, I’ve always been an SVN man, so bare with me while I’m still getting to grips with Git.

My GitHub account is https://github.com/mattbearman I’ll be adding a lot more to it in future, so be sure to keep an eye out.

- MB

Posted in: Programming by Matt Bearman on 5th May 2011 at 6:18 pm
Tags: , , , , ,

Six ways to protect yourself from SQL Injection

There’s been a  recent resurgence of SQL injection themed tech news as of late, including a Welsh Government site that was aparently try to protect itself with JavaScript, and the SQL homepage it’s self falling pray to an injection attack.

In the last few years I’ve learned a lot in this area and I thought I’d share my knowledge with the world. I realise there are other, possibly better techniques than the ones I list here, and I’d love to hear about them in the comments. (more…)

Posted in: Programming,Technology by Matt Bearman on 29th March 2011 at 10:53 pm
Tags: , , , , ,