For the latest information on what I am working on, what I am doing or even my random thoughts, click on the articles below.
Today I was playing my current MYSQL database where all 35 the tables where set as MyISAM. Thinking that doing each table 1 at a time would be very annoying for me I search the net to see if there was a quick way to do this and luckily for me, found a neat way of doing it via SQL.
Of recent we had issues with our HP laserjet pro 200 where randomly it would complain about the memory being low. After some research via the HP forums, below is the resolution.
Previously I wrote a script example of merging transparents PNG's side by side so here is a JPG version of the code.
I had to work on a small script for a front developer at work where he wanted to view a single image which basically merged 40 images side by side.
We are working on a bespoke API platform on this "hush hush" project and rather then sending data to the API in the usual way via PHP and cURL, we changed the game a bit for when we were importing chunks of data which was uploaded in a CSV file.
Today a friend and I were working out how to get a basic version of SVN installed on our own hosting platform as a sort of learning curve.
Working on an internal timesheet system at @TSLDigital where I display a list of users with their timesheet approval status. Currently I was just displaying the week number and year but to some extent was not really informative enough for the resource manager.
On rare occasion, I need to up the memory allowed for PHP.
(or 10 Tips for Securing your Web Application)
The below MYSQL query came into use for me as a sort of "house keeping" script where I had a 2 tables, products and product_reviews and although product_reviews stored the rating (out of 5) that a user would have entered, I wanted to keep an average rating value within the products table so I did not have to calculate it during my select statement.
Working on a small project whereby I need to tap into my clients Flickr account and display the images on his site. He wants them to loop through with jQuery but I will not showcase that code but will show the initial code to load in 5 images from Flickr and hold them in an array for later use.
First is the class code (flickr.cls.php):
Currently working on a project where by I need to allow the user to enter a time value along side the date and rather then allowing the user to enter the values manually, found this jQuery UI Datepicker plugin that works a treat.
Quick code sample on how to use jQuery Validation with AJAX based on a successful page validation...
Now this is a fairly common request on the net so I thought I put in my two pence and showcase how I upload and resize images... Below is my class that handles all my uploading and resizing functionality:
Further searches on understanding node.js, I found this article which explains how it works through 2 analogies:
Although this is something I have not worked with before, a potential client made a request in his brief that node.js was something that was required and with no knowledge of it I think IBM helped explained it better.
Just this week I was supporting a collegue of mine where he has WAMP installed on his Windows 7 (64bit) machine but had issues using cURL with a twitter plugin he was working on.
Just a quick overview to explain who does what :-)
Had to use PHPMailer to send emails via Gmail SMTP and the PHPMailer version I was using was old skool but with a download of the latest code everything was good :-)
On project I am working on it requires me to let the user know what position they are ranked amongst other users with their bid that have assigned to a product.
This week one of our Windows 2008 servers was slowly grinding to a halt and after 2 days of running tests (via Rackspace) various options were thrown to work out what was going on.
SQL Server: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Today (10/04/2012), I imported a csv file with over 8million rows into SQL Server which created the database table for me which I mapped out via the import method.
Since Facebook is slowing pushing the timeline feature across its Pages I noticed that assigning Apps to Pages also changed compared to how easy it was before but Chris from Feed London enlightened me to this Facebook page: http://developers.facebook.com/docs/reference/dialogs/add_to_page/
Although I have used the FB Open Graph META tags before, more so when sharing URL's of everything I have developed, the META tags came in useful when I wanted a personalised description and image to appear on my FB wall.
Supporting a Wordpress website for a client and came across an issue where when they were adding in <iframe> tag into the WYSIWYG and switching from html to visual - visual to html, the code would disappear.
I had a task for a potential project where I required PHP to print to a network printer.
Recently, and its been a while since I did it, had to basically assign some bespoke Google Analytics tracking to various links on a website I was working on.
Had this issue where when I made an ajax call with JQuery 1.5.0, Firebug would throw an error saying "Invalid label".
Heard some really good news this morning coming into the Saint London office.
Today I had to create short list of timezones for a project I was working on and basically created a list that I used within a MYSQL database, which I hope saves someone else the hassle. Once in database, it can be used in selectlists using PHP, etc.
Working on a project called Can You Draw The Internet? I was hit with a problem with my thickbox modal when content was loaded via AJAX. The thickbox modal would appear twice as the function TB_init() would be initiated twice.
From time to time there will be a situation where you would need to disable open_basedir if you are hosting with Plesk.
Simon Labbett sent some very good news around the Saint office today saying that three of our projects were awarded Commendations by Creative Circle.
Working on a small website for a friend where he wanted a clean way for users to view some of his images similar to how Apple deals with album covers in iTunes.
Working on my latest baby www.twitterknitter.co.uk one of the features was to add in a "like" tweet button. Catch - to prevent the user from liking if they had already liked.
Ahhh!!! Got a Word Press setup and wanted to add in other rules to the .htaccess.
Working on this art gallery competition project for Internet Week where one of the request was:
"Rather then have pagination links, can we have it so that when the user scrolls to the bottom of the browser, new content is loaded in?"
PHPology have recently taken on CSSology for all our HTML/CSS/JS work.
Had to read in an external RSS file from T3 and needed to drill into the "content" node which had a namespace. Using traditional ways of echoing out this node was not working so searching the net found a nice simple solution.
Working on a new project and one of the questions asked by the client was "will Cufon work with screen readers?", as accessibility needs to be considered.
Installed WAMP on my new work machine and jumping the gun a bit I went in and set my vhost config with the rest of it before actually starting WAMP.
Recently hit an issue where when I was converting a video file to a FLV format via FFMpeg (PHP) the duration of the video was lost during the export.
Man, something funny happened at work today.
During the Xmas period, a Word Press blog I was working on required the use of Disqus widgets.
Any junior PHP web developers out and about?
Whilst coding HTML newsletters, found a very useful list of special HTML characters from WebMonkey. Hope you guys find it useful.
Something really quick about upgrading your Parallels Plesk to 9.2.3.
Working with designers and developers who work in remote locations tends to cause problems when trying to merge their code whether HTML/CSS or Server side (PHP) with mine, but Ben from StudioMohu introduced me to something called Source Repo.
Sooo chuffed, one of our clients just notified us that a custom built shopping cart we built was rated 5 out of 50 recently:
Today (Tuesday 4th Auguest '09) was put in a situation where I had to reorder one of the columns from my 3D array and initially started to use array_multisort as described on php.net.
Getting annoyed that it was not giving me what I needed, I started to read through the comments others had left, and tried cagret at gmail dot com example which worked a treat for me.
Yesterday I was told that we were using the Rackspace Cloud server to store our files rather than on the local server itself.
Working on this flash website for Virgin Media and ran into an issue with @ symbols appearing as " in Firefox and Chrome with flash parameter wmode="transparent" enabled. Works totally fine in IE 7 (not tested other IE browsers).
The latest redesign of ESPN Classic went live recently, thanks to Ralph and Co for the project.
Ilford, east of London is the area I live in. If you are near or live in that surrounding and are looking for some one who can help you locally then you have came right place. Just give me a call or drop an email; you will get an instant reply from me.
Been keeping myself busy with these 3 projects which over the week have been put live.
I need a freelance PHP developer to work on a new web application for approx 2 to 3 months. The developer will join a small team based on site in central London, England, close to Liverpool Street Station who are already working on the project. Must have excellent skills in PHP and MySQL integration and be experienced in working with a large and complex database structures. Must provide own computer to work on, with connection to our onsite server. Experience in Google maps, geocoding, address databases and video uploading would be an advantage.
Any one for drum and bass at church, check this out, will make you laugh out loud.
Man, its been a hectic few weeks since I've been back, trying to find work here and there, all good though, got loads going on at the moment. At times I feel like I am a women, you know multi tasking and all that with loads of projects lol.
Ohh man, Manali, Goa and Kerala is all now completed, ohh now legally married too which was actually different, indians dont normally marry with a sunset behind them. haha :-)
Man, its been a hectic few weeks to the run up to my wedding. Been working my butt off on finishing projects as well as giving headache to my wife to be.