Web design, dynamic PHP web sites, databases and other technical advice


This web site contains a plenty of resources on programming, web design and system administration. If you are a webmaster, programmer or system administrator - you'll find advice on topics such as initial creation of web site with PHP and МySQL, articles on CSS design, resolution of complex database issues and automatic input of large data sets.

Also here are topics on email systems administration and support, Linux and Windows setup, as also automating tasks with bash scripts.

In the hints and tips section there are irreplaceable one-liners.

Most viewed articles

Sending mails with PHPMailer. HTML content, inline images, attachments, SMTP, cyrillic support - PHPMailer is a PHP class for sending email. It has far more funtionality compared to the regular mail() function, including attachments and inline images. It is very usefull for actions like...

Reading data from Excel files using PHP class Spreadsheet_Excel_Reader - If you have already read th article about generating Excel workbooks using PHP, this is an addition. Here's an example how to read these files. It is useful if you have large database and need...

Installation of phpBB forum MySQL and non-latin character support - Here are a few steps to install phpBB without having the problem regarding wrong display of forum topics containing non-latin symbols. This happens, because phpBB converts those symbols in...

List of world countries in php array - $country_list = array( "Afghanistan", "Albania", "Algeria", "Andorra", "Angola", "Antigua and Barbuda",...

Remove mail from postfix queue based on from email or rcpto email address - Here is a simple perl script to delete messages from postfix queue based on email #!/usr/bin/perl -w # # pfdel - deletes message containing specified address from # Postfix queue. Matches...

Most recent articles

Regular check for changes of MySQL database - Below outlined script implements regular check of a MySQL database for modifications. Modifications can be detected using two approaches - last modification timestamp of a table or row count...

Serving pre-compressed js and css when mod_deflate is not available or not desirable. - Serving compressed static contents like javascript and CSS files has become a must-have for every modern website. It helps mitigating the growing size of client side scripts in the modern Web 2.0...

Grepping multiline log messages - Grep is very useful when browsing a lot of log messages for specific terms. However some applications don't always adhere to the concept one message - one line. So sometimes you end up with...

Basic file operations. Searching for string in a file line by line - Basic file operations like open, read, write etc. are essential part of every programming language. In this article we'll make a comparison between implementations in several different...

MySQL exercises: getting the previous and the next message for each thread - Here's an interesting problem: we have a table thread and table messages, containing messages threaded in each thread. The question is if we have given message id, how to retrieve this message...

Link to us!

Pick a logo that you like and just copy/paste HTML code to your personal page