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.
Time: 17:10 min
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.
Time: 04:53 min
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.
Time: 04:94 min
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.
Time: 31:88 min
Sebastian Sulinski on 12th Sep 2011
In this tutorial you will learn how to apply two layers of validation to your online form. First layer is the client based javascript validation and the second one - server site validation. Using this approach we are saving the use of the bandwidth and number of calls made to the server.
Time: 55:55 min / Price: £26.00
Sebastian Sulinski on 6th Sep 2011
Today we will have a look at how to create a web based file browser. Once completed, you will be able to browse through the files and folders on your web server or local computer using your favorite web browser.
Time: 50:57 min
Sebastian Sulinski on 4th Sep 2011
Today we will have a look at how we can select a number of records using their associated checkboxes and how to remove them from the database with just one click of a button using jQuery and PHP.
Time: 19:14 min
Sebastian Sulinski on 2nd Sep 2011
Today we are going to have a look at the ways of adding and subtracting dates and time as well as showing the difference between two dates in MySQL.
Time: 06:17 min
Sebastian Sulinski on 1st Sep 2011
