Od2dev.be    Web Development

Olivier De Waele – WebDev freelance

 

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • Bulletinscolaire.be : Bulluc
  • Dehollander.net
  • Links
  • Contact us
  • About
  •  
  • rss   
  •  

Post navigation

← Older posts
Newer posts →

Database normalization

Posted on February 6, 2010 by admin
Reply

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 →

Posted in MySql | Tagged 1NF, 2NF, 3NF, database, db, normalization | Leave a reply

CMS Made Simple

Posted on January 22, 2010 by admin
1

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 →

Posted in CMS | Tagged cms, cms made simple, cmsms, tutorial | 1 Reply

MySql Fulltext search

Posted on January 7, 2010 by admin
Reply

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 →

Posted in MySql, PHP5 | Tagged boolean search, fulltext search, MySql | Leave a reply

Backups and Storage media

Posted on January 6, 2010 by admin
Reply

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 →

Posted in Hardware | Tagged backups, cd, dvd, hd, iomega REV, nas | Leave a reply

PHP5 to watch over MySql queries

Posted on January 2, 2010 by admin
Reply

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 →

Posted in MySql, PHP5 | Tagged efficiency, mysql queries, static variables | Leave a reply

MySql5 – Multiple queries

Posted on January 2, 2010 by admin
Reply

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 →

Posted in MySql | Tagged insert into, mysql5, on duplicate key update | Leave a reply

PhpMyadmin no authentication

Posted on December 23, 2009 by admin
Reply

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 →

Posted in MySql | Tagged authentication, phpmyadmin | Leave a reply

Testing websites on multiple browsers

Posted on December 22, 2009 by admin
Reply

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 →

Posted in OS & Software | Tagged browsers, testing | Leave a reply

Preventing [F5] submission

Posted on December 22, 2009 by admin
Reply

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 →

Posted in PHP5 | Tagged f5, form, submit | Leave a reply

PHP editors

Posted on December 22, 2009 by admin
Reply

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 →

Posted in OS & Software, PHP5 | Tagged bluefish, notepad++, notepad2, php editors, php ide, quanta plus | Leave a reply

Post navigation

← Older posts
Newer posts →

Language

  • English
  • Français

Tags

1NF 2NF 3NF abstract classes Ajax Aptana boolean search clickheat cms cms made simple cmsms Codeigniter Framework crazy egg cuterank db dual boot eyeos fulltext search Google adwords Google analytics grub interfaces JQuery keywords kohana Linux Mac MySql notepad++ notepad2 nvidia nvidia drivers OpenSuse page rank php plugin plugins SEO seo tools twinview windows7 wordpress WP Zazou Zend Framework ZMWS

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Categories

  • Analytics
  • Aptana
  • CMS
  • Codeigniter Framework
  • Hardware
  • JQuery
  • MySql
  • OS & Software
  • PHP5
  • SEO
  • Server-side scripting
  • Wordpress
  • Zend Framwork

Archives

  • November 2011
  • October 2011
  • March 2011
  • December 2010
  • September 2010
  • August 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
Proudly powered by WordPress