Here is a quick way to read a csv file hosted remotely, download its contents and store it to a local csv file. Once the file have been saved open the file loop through the data and display it. Equally this can be used to import data into a database.
Perfect for a daily task by calling the script with a cron job.Continue Reading
Keep rows that would normally be lost when selecting rows using a COUNT and GROUP By. To keep say another column and merge them into a column comma separated by using a GROUP_CONCAT function.Continue Reading
This tutorial will cover creating a login system with registration upon registering an activation link will be emailed containing a link to activate the account. Once active the user can login, a reset option is available to reset the password.Continue Reading
On a recent project I had the needed to modify an existing PDF, the modification would be done dynamically so I needed to use PHP for this, upon searching Google for 'php edit pdf' I came across a very useful script called FPDIContinue Reading
Using PHP connecting to an POP/IMAP server is a relatively easy process, it can be useful for using webmail or to allow a script to download all emails and store in a database for instance.
The function required to make the connection is imap_open, it expects three parameters first the connection string made up of the remote host and mailbox folder, followed by the username and password.Continue Reading
Convert currency from one country to another easily with Google's finance calculator, using that it's possible to collect the output using PHP.Continue Reading
Here's a very simple way to detect if a form has been submitted, I've recently wrote a plugin for dynamic forms. The problem I had was being able to detect when a form was submitted, normally I would check for submit name array within the post array but since the plugin allows for full control over the form's elements including the submit button's name I had to do it a different way.Continue Reading