Database normalization provides a set of easy-to-apply principles that can help the developer structuring its database and improve MySql performance. Normalizing a database is to organize its data more efficiently thanks to normal rules or principles. For more efficiency, building … Continue reading
This article is rather long but shows how easy, flexible and fast CMS Made Simple (CMSMS) can be. Following Benoît Henry‘s advice on CMS, I chose CMSMS for my first CMS experience. Before that, I had only developed my own … Continue reading
Scripting an internal search engine requires : a client form to submit requests database fields to search posted keywords database queries to match the form request I want to focus on the database requirements to make such a search. I … Continue reading
The developer in search of a reliable backup strategy can find several solutions. He does not have to choose only one. The chosen strategy may gain reliability if backups are done on devices based on different technologies and if storage … Continue reading
If the developer wants to write more efficient MySql queries, he may want to display all the queries a web page has generated and the time the whole script took to output its Html result. This is useful while developing. … Continue reading
If you want to read more about MySql5 improvements, please read the official release notes. The aim of this post is to write more efficient MySql queries. Some servers watch over the MySql resource a web page uses. If the … Continue reading
PhpMyadmin is a free software developed in PHP to manage MySql databases. For local development purposes only, the developer may want to skip authentication while connecting to PhpMyadmin. For obvious security reasons, do not choose this configuration on a web … Continue reading
Developing websites requires testing them on most browsers, mainly to check CSS interpretation which can differ from one browser to another. You can either install those necessary browsers on your local machine or have your website tested online. I usually … Continue reading
Form handling may require the script to identify if the user has first submitted the form or if he has pressed the key [F5] to submit the form again. Indeed, if form submission triggers an insert into database query, you … Continue reading
There are many PHP editors. I haven’t tested them all and want only to concentrate on the basic ones. My criteria are : free software light interface and above all, no proprietary code Under Windows I have never tried to … Continue reading