Social community websites became very popular last few years. One of them is Facebook which has many impressive features and applications based on Ajax. If you like Footer Admin Panel situated on the bottom of the Facebook site, this tutorial provides you with easy way how to create your own one, where you will be able to organize frequently used links and applications. Many useful techniques, for example the...

Many companies have contact information on their websites. Nowadays, inserting Google Maps into contact page is very popular. It helps your customers to find the exact way to your company much easier than before. But now, there is the possibility to make your Google Maps more attractive and helpful. What about adding your logo with description of your company by using an infobox shown after clicking on that...

Suppose, you have a black day, unintentionaly confirmed DROP DATABASE command and your hardly filled tables has gone, forever! Is there any chance to recover dropped database and get your valuable tables back again? This tutorial tries answer this question. The Catastrophe It’s 10:23 p.m. and I’m still working on a project for my customer. It’s just an update for some components and some manual...

Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server variables. It’s easy to use and offers valuable output for MySQL performance optimization. A Bit of Theory In previous three posts of this MySQL Optimizing tutorial mini series (Configuration Directives, Log Slow Queries and Importance...

This third part of MySQL optimizing tutorial mini series shows an importance of table order during JOIN. The difference between regular JOIN and optimized one is dramatic, so keep reading! This post may save your time and headaches in some MySQL problem handling. Once upon a time I bought an application for article submissions, written in PHP. Yes, it sounds incredible, but it happened. Primary reason was my...

This is a second part of MySQL optimizing tutorial mini series. As the title indicates, we’re going focus on MySQL slow queries and their logging. We’ll use the official MySQL manual for version 5.0 as a refernce. After read of this post you should be able to set up logging of MySQL slow queries for further use and be familiar with its basic output. What Is It? As mentioned earlier, in the first...

Are you experienced PHP programmer and would like to use favorite PHP functions in JavaScript too? Sounds interesting, doesn’t it? You wouldn’t have to learn new JavaScript objects and functions, get used to new syntax, just write what you already know and have tested. Put PHP directly into JavaScript code and don’t care! Well, but how? Thank God and the group of PHP.JS developers the answer...

This tutorial should summarize the possibilities of XML handling by PHP. After short introduction what XML can be used for, we’ll move to the PHP world and show how this web oriented programming language supports XML data format. I personaly don’t know anybody who doesn’t know RSS. But to be sure: RSS is an abbreviation for Real Simple Syndication and it’s one of the most widespread content...

Every web developer knows that in these days almost every dynamic web site uses some kind of database to store data. An application generating (X)HTML code sends queries for data to database and database returns this data back to the caller – in this case the application. Also, data from users or content in itself is stored in a database. The most widespread database engine, used primarily for web application...

Previous post Basic Security Related PHP Directives showed us the basic set of PHP directives which significantly affects security of not PHP apps only. This article increases the spectrum of PHP security related configuration directives.