You may know how to use SQL to extract data from a table in a MySQL database, and how to run a query that combines data from more than one table. But what about multiple databases? Or even multiple databases on multiple servers?
Useful links for web developers
UTF-8 Helper functions for PHP. These functions are replacements for PHP’s inbuilt functions which mangle up UTF-8 character sets
“Darn near impossible� is perhaps too extreme but, certainly in PHP, if you simply “accept the defaults� you probably will end up with all kinds of strange characters and question marks the moment anyone outside the US or Western Europe submits so
DecisionStudio Professional is a desktop BI platform. It is an advanced and comprehensive data mining, reporting, modeling, and analysis environment that is empowering individuals and organization to actualize their highest potential through data-mining,
Dynamically call functions, variables, object and static methods in PHP
Free open-source disk encryption software for Windows XP/2000/2003 and Linux
There are different reasons for logging information, different strategies for what and how to log, and of course different ways of implementing it. This article will look at why you would want to log, what you want to log and how to do it.
The mission: I want you together with me to collect stuff and build a taxonomy of things that are special to a PHP programming culture, and then to name these things to make them searchable and to enable reflection on them.
Browser Capabilities Project
Last week, we began our discussion of PHP standalone scripts. This week, we’ll be talking about child processes, shared resources, signals, and writing daemons.
Evolution on Win32
MySQL Connection Management in PHP with lazy loading to reduce connections to the database
sing JavaScript and PHP, we can generate accessible image-headings using any font we like. And we don’t have to change the structure of our HTML or CSS at all.
SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load.
150+ clean and clear icons to use in your nifty web application. They are licenced under a Creative Commons licence, so commercial use is fine. Also feel free to make derivatives with the included Photoshop documents.
Unobtrusive javascript for applying expand/shrink behaviour
curvyCorners is a free JavaScript program that will create on-the-fly rounded corners for any HTML DIV element, that look as good as any graphically created corners.
This book explains the design of Apache, mod_perl, and the Apache API, then demonstrates how to use them to rewrite CGI scripts, filter HTML documents on the server-side, enhance server log functionality, convert file formats on the fly, and more.
ive common database problems that occur in PHP applications — including database schema design, database access, and the business logic code that uses the database — as well as their solutions. My experience in the field differs slightly from his
If you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (or select any other number) rows by some of the users. On other hand it is well known with
A PHP Class for manipulating images. It features the ability to scale by percentage, width, height, and to create a square crop of an image.
AIDE – Advanced Intrusion Detection Environment
Microsoft has over 150 FREE Windows & Office Programs available for download — finding them all is extremely difficult.
the latest web2.0 news from around the internet
hexadecimal HTML color codes
Reflection.js 1.5 allows you to add reflections to images on your webpages. It uses unobtrusive javascript to keep your code clean.
A cool site which allows you to design databases online.
AutoHotkey is a free, open-source utility for Windows. With it, you can:
The goal of this project is to adds information about the HTTP headers in two ways:
This script can be customized to meet your own needs, such as allowing for cookies or even sessions to be considered in whether a page is different.To demonstrate how this is used, Listing 9.6.2 is included that just uses the cache mechanism and outputs t
The only thing that’s certain to happen quite regularly on a web page are page requests. This is where pseudo-cron comes into play: With every page request it checks if any cron jobs should have been run since the previous request. If there are, they are
Bambalam PHP EXE Compiler/Embedder is a free command line tool to convert PHP applications to standalone Windows .exe applications. The exe files produced are totally standalone, no need for php dlls etc.
ounded in 2004 by three Security Researchers from Germany, the Hardened-PHP Project has the goal to help you with securing your applications and webpages
TaskFreak! is a simple but efficient web based task manager written in PHP.
FPDF is a PHP class which allows to generate PDF files with pure PHP, that is to say without using the PDFlib library. F from FPDF stands for Free: you may use it for any kind of usage and modify it to suit your needs.
Well, it’s actually so simple it’s not really a tutorial at all so much as a snippet with a bit of explanation. But I’ve had some people ask how it’s done, so here’s how I do it.
Wildfire is an enterprise instant messaging (EIM) server dual-licensed under the Open Source GPL and commercially
Play all the old video games you grew up with – online and free. Nintendo, Sega, Gameboy and more
Cut and Paste date_format strings for MySQL
This is a Firefox extension that allows you to manage multiple Gmail accounts and receive new mail notifications. Displays account details including unread messages, saved drafts, spam messages, labels with new mail, space used, and new mail snippets.
From time to time you hear about multithreading in PHP and how it is impossible. Yes, PHP does take the top-down approach to execution. It is possible to do multitasking by using Process Control Extension, but multitasking isn’t exactly the same thing a
Virtual PC allows you to maintain the compatibility of legacy and custom applications during migration to new operating systems and increases the efficiency of support, development, and training staffs.
For many of us we have a configuration file for our web applications. In that configuration file there is usually a DEBUG constant that we can turn on to print out helpful debug statements on the screen or to a flat file.
Come to discover XnView, a software to view and convert graphic files, really simple to use ! Support of more than 400 graphics formats ! It’s free, so do not hesitate !
PHP Interactive is a simple PHP program that lets the user to write code in a text area (actually multiple text areas, with tabs to switch), and see the output of the code just pressing the update button.
am in a situation where I need to protect some intellectual property in a PHP script. The recommended solution is to use a code obfuscator (or compiler) to encode the script. Currently the landscape leaves much to be desired in this area as far as PHP i
The following methods can help improve scalability with php applications.
In this article we will start with the absolute basics – plotting a single location on a pre drawn map of the world.
# 1 AJASON (added November 2005)
The automation of a business process, in whole or part, during which documents, information or tasks are passed from one participant to another for action, according to a set of procedural rules.
