In this tutorial we will have a look at how we can change the timezone settings for your application within PHP and MySQL.
Sebastian Sulinski on 31st Oct 2011
Today we will take a look at how we can generate an array with the range of dates using the PHP's DateTime, DateInterval and DatePeriod classes.
Sebastian Sulinski on 19th Oct 2011
In this tutorial we will learn how to use Apache's mod_deflate in order to compress the output from the server before sending it to the client over the network.
With mod_deflate you can compress files to approximately 20% - 30% of their original sizes, save your server traffic and increase the performance of the website.
Sebastian Sulinski on 7th Oct 2011
Today we will take a look at how we can create a dependency between the dropdown menus in our form.
Based on the previous selection, the following menu is filled in with relevant data and so on. In order to create it we will use jQuery.getJSON() method and PHP with PDO and MySQL database.
Sebastian Sulinski on 23rd Sep 2011
Today I will give you an overview of a useful ssh commands, that every web developer should be familiar with.
We will have a look at how you can copy files and folders, how you can move them from one location to the other, how you can remove folders and files, how you can change permissions and ownership of the folder and a few more commands that will make your life easier when dealing with your files on the Linux web server.
Sebastian Sulinski on 22nd Sep 2011
In this short series we will have a look at the very useful functions inside of MySQL database, which allow us to deal with numerical values such as quantities, prices etc. We will have a look at COUNT, SUM, AVG, ROUND, MIN and MAX functions in order to get totals, average, minimum, maximum values and price range from our books table.
Sebastian Sulinski on 19th Sep 2011
Today we will have a look at MySQL and its INSERT INTO SELECT statement in order to copy records across to another or within the same table as well as TRANSACTION statement, which allows us to execute several SQL statements in one go.
Sebastian Sulinski on 15th Sep 2011
Today we will look at how we can export MySQL table and its specific fields as CSV file using PHP. Our export option will allow you to select the fields you wish to export after initial selection of the table from the database.
Sebastian Sulinski on 12th Sep 2011