Scribbles about MySQL & PHP

PHP / MySQL – Strip Content And Only Display Images From A MySQL Table

This is another one of those quite specific pieces of code, so I doubt many people will need it. I think the code is quite useful, so I thought i’d make a post about it. Anyways, I’m going to show you how you can pull just images out of a field in a MySQL table. [...]

Maruf scribbled this post.

MySQL & PHP

Jun 20th, 2010

PHP/MySQL- Escape All POST Or GET Variables For MySQL INSERT

I’m quickly going to demonstrate how to escape special characters in a string for all POST/GET variables safe for a MySQL INSERT query when passing values from a HTML form. So, let’s say we have a form like this on index.php: Details First Name: Surname: Email: View Code HTML1 2 3 4 5 6 7 [...]

Maruf scribbled this post.

MySQL & PHP

Feb 16th, 2010

MySQL & PHP- Show Tables In Database

Someone asked me the other day how to display the existing tables in their database with a PHP script. The query itself is pretty simple, but people seem to get confused about the PHP side of it. Then again, once you look at the code, you might be surprised how easy it really is… Printing [...]

Maruf scribbled this post.

MySQL & PHP

Nov 14th, 2008