I was asked the other day by someone about some software that could Join/Merge two tables (fields and rows). I thought it’d be pretty easy with some MySQL query but couldn’t find any solution. Then I turned to google in search of any software or any other source that could help me out… but still […]
Category: PHP
Change Filenames to Upper or Lower Case (in bulk) in PHP
Atlast I overcame my laziness and wrote a long overdue script to change filenames. Before writing this code, I couldn’t find a reasonable solution in PHP despite a major search operation. The need, infact, arose when I copied my PHP code from windows to linux machine, and it refused to show alot of images, which […]
Fetch Fields (of one row) from a MySQL Table
I was sick and tired of writing small queries where I had to retrieve one or few or even all records of one row against an id. E.g. when I had a userid and I had to fetch firstname, lastname and/or email against that id, I had to write a query each time and then […]
Simple User Search in PHP
A friend of mine asked me to give him a sample code of some sort for search. He’s a newbie to PHP. I wrote him a piece of code for convenient search and he was like ‘AWSOME!!!’. I thought it was such a simple script that it took me less than 5 minutes to type.. […]