Web Development company

XDebug for developing, debugging and profiling PHP

2010-11-22T18:16:00.000-08:00

XDebug is one of the essential PHP extensions for PHP developers. The name is a bit misleading, as it implies that it is just a debugging tool. This can put people off, since getting the debugger to work with your personal editor requires an understanding of networking, and can often be confusing. Even if you can't immediately get XDebug to work as a debugger, it is still valuable as a stack trace tool, or as a color coded replacement for PHP's var_dump, or as a code coverage analysis tool, and most importantly as a profiler. In this tutorial I'll attempt to cover installation, and most of XDebug's standard features.

Install XDebug

Anyone who spends any time doing PHP development soon finds that PHP is not a one size fits all world. Thanks to its efforts to be a portable and extensible platform, PHP offers developers a wide array of platforms, installation methods, and configurations. Since XDebug needs to play within the ecosystem of PHP, there are a variety of different ways you can install it including compiling it from source.

The important thing to keep in mind is that XDebug is something you want installed on your development server, not on your production server! For that reason, I'm not going to cover compiling from source. All the installation options are covered in the XDebug manual.

For most people, the easiest way to install XDebug is to use PEAR/PECL. On a unix system that involves running pecl install.
# pecl install xdebug
Upon completion, you can check that everything has installed correctly.
debian:~# pecl list Installed packages, channel pecl.php.net: ========================================= Package Version State xdebug 2.0.5 stable
On a Debian system, the build process included adding an ini file in an include directory that php utilizes to configure its modules, and I did not need to make further adjustments -- just restarted apache. On a 64bit Centos 5.5 install, the php.ini needed to be manually updated. In order to find the location of the xdebug.so, you can run pecl list-files.


[root@localhost ~]# pecl list-files xdebug
Installed Files For xdebug
==========================
Type Install Path
doc /usr/share/pear/doc/xdebug/contrib/tracefile-analyser.php
doc /usr/share/pear/doc/xdebug/contrib/xt.vim
doc /usr/share/pear/doc/xdebug/Changelog
doc /usr/share/pear/doc/xdebug/CREDITS
doc /usr/share/pear/doc/xdebug/LICENSE
doc /usr/share/pear/doc/xdebug/NEWS
doc /usr/share/pear/doc/xdebug/README
src /usr/lib64/php/modules/xdebug.so

When you run the pecl install you'll see an erroneous message indicating that you should add an extension=xdebug.so to your php.ini. IGNORE THIS!!!
You actually need to load XDebug using either:
; Enable xdebug zend_extension="/usr/lib64/php/modules/xdebug.so"
--or if you're setup with the threaded environment that has enabled "thread safety" then:
; Enable xdebug zend_extension_ts="/usr/lib64/php/modules/xdebug.so"
The cleanest way to set this up under Centos is to create a file in the /etc/php.d directory named xdebug.ini. You can also just manually add the lines above to your php.ini file. The comment "; Enable xdebug" isn't necesssary but it's helpful for documentation purposes to have it, so why not?

If you've followed these instructions and you still don't see xdebug in your phpinfo() page, make sure you have permanently disabled selinux, as it can interfere with the ability for php to load the XDebug module.

Once you've installed XDebug, an XDebug section will be visible in the phpinfo() page, along with a list of default settings.

var_dump()

One of the first things that XDebug will do by default is replace php's var_dump() with a nicer version that is also configurable in a variety of ways.
In this example, I've inserted:
var_dump($mainframe); die();
--into the index.php file for the CMS joomla. The $mainframe object is the main application/controller object for Joomla, so inspecting it might be useful for understanding more about how Joomla works. Without XDebug, this is what the output looks like:
object(JSite)#2 (7) { ["_clientId"]=> int(0) ["_messageQueue"]=> array(0) { } ["_name"]=> string(4) "site" ["scope"]=> NULL ["_errors"]=> array(0) { } ["requestTime"]=> string(16) "2010-10-09 23:56" ["setTemplate"]=> string(13) "rhuk_milkyway" }

With it turned on we get this:

XDebug adds nesting, color coding and scope identification to the output.
Consider a more complicated object:

Trying to make sense out of all this jumbled output isn't easy. With XDebug you can see the forest through the trees.

Stack Trace dump

A stack dump is what PHP spits out when you have a runtime error in your script. During development you want to have display_errors turned on, so you can easily see these when they occur. Vanilla PHP might show you something like:
Fatal error: Uncaught exception 'Zend_Controller_Dispatcher_Exception' with message 'Invalid controller specified (tutorials)' in /var/sites/flingbits.com/library/Zend/Controller/Dispatcher/Standard.php:248 Stack trace: #0 /var/sites/flingbits.com/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #1 /var/sites/flingbits.com/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch() #2 /var/sites/flingbits.com/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #3 /var/sites/flingbits.com/public/index.php(10): Zend_Application->run() #4 {main} thrown in /var/sites/flingbits.com/library/Zend/Controller/Dispatcher/Standard.php on line 248
With XDebug, your Stack dump looks like this:

The XDebug version is not only a lot easier to read, but it also adds profiling and memory usage information to the trace. However, there are a number of additional options you can turn on to make this even more useful.

xdebug.collect_params

This setting will provide you a variable level of information about parameters being passed. Setting this to "4" gives you the maximum amount of parameter information available.
xdebug.collect_params=4

xdebug.show_local_vars=1

This is a kitchen sink setting that will dump out every variable in the local scope. In a smaller application or when confronted with a particularly confusing problem, this might be useful, but in most cases where you have a script of any sophistication, it simply produces too much output.

Dumping superglobals

You can add some or all of the various superglobals to your stack trace, by setting the xdebug.dump.SUPERGLOBALNAME=*.
For example:
xdebug.dump.SESSION=* xdebug.dump.COOKIE=* xdebug.dump.GET=* xdebug.dump.POST=* xdebug.dump.FILES=* xdebug.dump.REQUEST=* xdebug.dump.ENV=* xdebug.dump.SERVER=*
Most of the time, you will probably want to limit the output to a handful of commonly useful variables, so instead of setting the variable to the wildcard '*', you can instead pass a list of the specific variables you are interested in.
For example:
xdebug.dump.SERVER=SCRIPT_FILENAME,REQUEST_METHOD,QUERY_STRING,HTTP_COOKIE,REMOTE_ADDR

Profiling

The XDebug profiler outputs "cachegrind compatible files" that can be analyzed with a variety of tools, depending on your platform. If you're developing on a linux workstation use kcachegrind, or on windows wincachegrind.

The best way to enable profiling is to set XDebug so that you can pass a parameter to the script via a GET, POST or COOKIE that will enable it. There's also a setting that defines the name of the cachegrind file(s) generated. I recommend these settings, and by default your files will be deposited in the /tmp directory of the server.
;profiling xdebug.profiler_enable_trigger=1 xdebug.profiler_output_name=cachegrind.out.%s.%t
Now you can selectively trigger profiling by passing a GET param in the URL:

http://www.gizlocal.com/?XDEBUG_PROFILE

Once the script has run, you should find the profile output file in your temp directory. The file will be namedcachegrind.out.{path_and_filename}.{timestamp}

Using these settings will allow you to generate multiple profilings for the same script, as well as allowing you to easily identify the script that actually generated the profiling data.



debian:/tmp# ls -lath | grep cachegrind*

... 4.5M 2010-11-16 13:04 cachegrind.out._var_sites_flingbits.com_public_index_php.1289941492

Once you have a profiling data file, you will need to load it into an analysis tool. There are analysis tools available for most common operating systems, although the features of the various tools differs. For an Xwindows Linux workstation, KCachegrind provides the timing and call data as well as graphical visualizations like the "Call Graph" screen. WinCacheGrind is a native windows application which doesn't provide graphs, but does show the calls and timings, and allows you to sort the profile data in a variety of ways. Here's a screenshot showing the functions which take the most time.

Regardless of the tool, your primary goal is to determine which blocks of code are taking the most time. The analysis tool will show you how many times each function was called, along with aggregate and average execution times. Often you will have functions or methods that call other functions. The local time is totalled seperately from the cumulative time so you can determine where the majority of the time is being spent.

Debugging

Getting the XDebug remote debugger to work with your favorite IDE will probably require looking up configuration instructions for your IDE. These settings are typical, and reflect the process of setting things up to work with Eclipse PDT.

Remember that whenever you make changes to any of these serverside settings, in the php.ini or an included .ini, you must restart Apache!

The first thing you need to do is configure XDebug on your server to turn on remote debugging support. While a number of these settings are also the default it doesn't hurt to include them, in case you need to make tweaks.
;Debugger xdebug.remote_enable=1 xdebug.remote_mode=req xdebug.remote_port=9000 xdebug.idekey=ECLIPSE_DBGP xdebug.remote_handler=dbgp xdebug.remote_host=10.1.0.2
Reviewing these settings:
-- you need to enable the debugger using xdebug.remote_enable=1.
-- The xdebug.remote_port is the port the debugger will use to connect back to your IDE once the debugging session is started. It defaults to port 9000.
-- xdebug.idekey needs to be set to whatever your IDE will use to instantiate the session. This gets passed as a url parameter by the eclipse debugger as ?XDEBUG_SESSION_START=. For Eclipse with PDT, the session id will be ECLIPSE_DBGP. For other IDE's or editors that support XDebug this could very well be something different. Ultimately it is an identification mechanism, which simply has to be agreed upon for the editor to connect to XDebug. When everything is setup correctly, you can expect to see something like this in the browser URL when your eclipse debug sessions starts.

http://www.gizlocal.com/?XDEBUG_SESSION_START=ECLIPSE_DBGP&KEY=12900687508406

-- xdebug.remote_handler specifies the debug protocol, which in this case should be dbgp.
-- Last but not least, the xdebug.remote_host needs to be an IP address for your workstation that can be reached by the server. If for example, your workstation is behind a NAT firewall, you'd have to setup a port forward rule for your workstation that forwards port 9000 traffic back to your workstation. If you're using a WAMP or virtual server environment using VMware or Sun Virtualbox, then chances are this is going to be an internal IP address like the one I included in my example. I highly recommend using a virtual server for your development environment.

If you're not sure how to do this, I have a detailed 2 part article on setting up your own virtual Centos Lamp server running inside Sun Virtualbox on a PC running Windows here.

Configuring Eclipse PDT for XDebug

There are many things that can go wrong with the debugging configuration. Keep in mind that Eclipse PDT's debugger is generic and setup to support different debuggers. This section is not meant to be exhaustive, but should give you an idea of how to get started.

When the debug session starts and your workstation browser is opened, you should see a valid URL (see above) and the page should be blank. If the full page is displayed this is a good indication that you need to check your settings, and that Eclipse didn't connect to XDebug!

When configuration is complete you will open the PHP Debug perspective, and choose a debug configuration. For any specific script you want to debug, you'll need to create a Debug configuration for it. In other words, if you reach a script via a particular URL, you'll need a debug configuration unless it can be reached via another script that you have already setup. For a framework style application, you can set skip to the points you're interested in via breakpoints, but you'll need to have the files you want to set breakpoints in, open in the IDE, and then once you start the debugger, you switch to the file you want to set the breakpoint in, and choose "Run to line". It's not pretty but it works.

From the Menu choose the Run | Debug Configurations panel.

-- When you get into this panel, give the Debug configuration a name representing the script. This will make it easy for you to choose the right config to debug. In this example, I called it "Index" because I'm debugging the index.php of this framework application.
-- Set the server debugger to XDebug.
-- Browse your project and find the script you want to debug. The script has to actually be executable.
-- Uncheck URL - Auto Generate. This is bugged in my version of Eclipse PDT, and it also seems to add slashes in the neighboring path box that you want to clear out whenever you see them.
-- Save
-- Reopen your freshly created debug configuration, and now "Add" a new PHP Server.

-- Give this a name representing your development server that is running XDebug.
-- Enter the domain name, and provide a path if you've got an application running in a subdirectory off the site root. Leave off the closing '/'!
-- The configuration wizard will take you to the next step, which is adding at least one "Path Mapping".

-- This maps the base location for your workspace files to the path on the server.

Ready to debug?

If everything has gone as planned you should now have a working configuration. Change to the "PHP Debug" perspective. Click on the Debug button, and choose your Debug configuration based on the name you gave it when you set the configuration up in eclipse. You can switch to the browser and should see it loaded with the proper url and the added XDebug parameters discussed previously. The screen should be blank and Eclipse should load up the debugged file into the editor, fill the variable window and set things so that you can step through the code using the "step into", "step over", and "step and return" buttons on the debug button bar.

Summary

XDebug is more than a debugger, even though for PHP it can be used as one. It's an invaluable development tool that will help you during the development process. Hopefully you learned more about how to set it up and start to make use of it. If you have questions or comments, reply here or make a thread in the forum.

Original Article Source: http://www.flingbits.com/tutorial/view/xdebug-for-developing-debugging-and-profiling-php

Making SEO Friendly Websites

2010-07-21T22:53:00.000-07:00

Website designing does not only involve giving it an attractive and professional look. It must bring in more business output. For this the website has to have a good page rank with all search engines.

The basic idea of creating a successful website is to make it SEO friendly. This means to say that before building a website you must conduct an extensive and in depth research about the keywords for the content and name of the website, the competition it faces from the other websites that provides same service and information.

But this doesn’t mean that creating a SEO friendly site is hard. All you need is a proper conception and in-depth knowledge about search engine optimization and how to plan your strategies to give the website a healthy page rank on the search engine results.

Here are a few tips for making a SEO friendly site:
Make sure that the website doesn’t take much time to load as this would make the visitors to drift away to other websites and you shall be losing customers and hence revenue.

The HTML codes must not have error. This shall show broken and ineligible elements in the website and thus greater chances of miscommunication and you shall loose repeat visitors to your website.

The keywords that are to be used must be well researched and placed with proper density that can bring about proper page rank in search engine listing.

Do not use too much designer font style that would make the content ineligible. The main purpose is to communicate with the visitor and achieve the goal. Miscommunication would destruct the whole purpose.

Give emphasis on pictures. As the saying goes a picture says thousand words. Not only would it make the website attractive, at the same time it would help to communicate with the visitor with much less chances of miscommunication.

The sole purpose of search engine optimization is to achieve a good page rank in the search engine results and bring in more visitors. Whatever you do make sure that the website is user friendly and that it attracts more and more visitors and helps in enhancing business output.

Guidelines to design a Jewelry Website

2010-04-12T09:38:00.000-07:00

Jewelry Design web pages generally come under online shopping and promotional sites. The top rated jewelry designing site is constructed in an elegant way with a classy appeal that creates a nice impression in the minds of fashion conscious surfers. Jewelry sites are particularly chosen amongst women of particularly high class. Therefore, it is to be noted that the jewelry design web page should be designed to grab the attention of fashionable women or else by the people of luxury.

Before designing a jewelry site, it should be kept in mind that the home page is to be formatted to highlight the exclusive designs that are available in the Jewelry shop. Also, the layout of the page should display decent style without making it jumbled. Now, regarding the content of the site, it should be given care that the text is written in a simple yet ornate way. Hence content writing should me done by keeping the objective of the website in mind.

There are some of the basic things that should be taken into care while designing a jewelry site:

• Domain Name: As these sites are classified as marketing site, so proper care should be taken in mentioning the Domain name. Otherwise, there can be problem in searching issues.

• Security Check: As these sites are visited by the surfers who make a heavy amount of online financial dealings, so it is to be noted that the online transactions should be kept in high security mode. Any of the personal details of any of the customers should not be hacked by any means. While designing a page, member and customer database should be kept in total privacy in server side.

• Layout: The layout of a good jewelry-designing page should not be over cluttered. It should display an exquisite taste of style and modernity. Also, the layout should not be designed in such brilliance that it crosses the budget. So, while designing a jewelry site, it should be kept in mind to create a tasteful site that comes under budget.

• Maintenance of the site: A web developer should design a jewelry site such that it provides easy option of appending, deleting or modifying from server side. This type of sites claim constant updates and changes in products, prices, member lists and many other parts that should be taken care of.

Image Selection solutions for a Web Design Company

2010-03-22T21:15:00.000-07:00

A web page is constructed for attracting a viewer and the more a viewer stays in a particular page, the more profitable a website becomes, particularly for the business websites.

Visitor retention is the ultimate objective of website design. A number of methods are being employed for enhancing the overall look and feel of a website and among them image insertion plays a pivotal role. Graphical elements, like images and animations play a vital role in making a web page attractive and alluring. Therefore, the web design company that includes elegant and useful images to convey vital messages for the website is considered to be a good website design company. Also, images should not be more that 2-3 for a particular page. There are certain aspects that are to be followed before inserting an image while doing a website design.

A website design company should look after certain things before choosing images for a particular website. It is totally depending on the requirement of the client that an image is chosen. Also, the image is chosen as per the budget that is allotted for a web page. Sometimes clients themselves provide images that are mandatory to be used in a particular page. In other cases, website design company chooses images for their own client. This is done as per the money estimate that is provided by the client.

Some of the things that a website design company should remember while making use of images:

• Image resolution and size: Depending on the budget estimate and also the size of the web page, a particular image is selected. This image is to be placed in such a way to fit in the page properly and in a place that never blocks or disturbs any other part of the page. A good website design company always chooses an image that has the same of nearly the same dimension of the image placeholder.

• Meaningful Images: The images that convey the ideas of the web page are to be selected. Also, minimal number of images is to be placed in a page that matches with the content of the page.

• Images in header: Header images are to be chosen in a particular way to focus the purpose and objective of the site.

• Use of genuine images: The images that are to be placed in a web page should be cleared from any type of copyright problems.

Web Design and the Use of SEO

2010-03-22T21:12:00.000-07:00

For a successful web design it is essential to build a web page that is very much visible over the net. For that it is necessary to optimize the page in a way to get it easily through search engine tools. Web development is not at all simple and it requires a lot of technical planning before a web page is built. The first and foremost thing that a web development company should take care of is the search engine optimality issue and accordingly the site should be built. The basic purpose of web design is to build an effective web site that can be easily obtained through any of the standard search engine.

The basic thing that should be taken care while building a particular web page is that the requisite keywords are chosen properly and in accordance to the utility of the site. The content should be written in a way to make use of as much keywords as possible so that the search engine crawlers can hunt it easily. A web page is consisted of several other components. These can be images, down-loadable links, video files, music files or some other external links. For any types of media files a particular ID is allotted so that it can be found easily when given a search.

The purpose of SEO is to make the entire component of a web page visible and search-able with a standard search engine. The Content should be the prime focus for any of the web site and web content writing involves maximized use of the relevant keywords. The keywords are to be chosen keeping in mind the simplicity of the phrases. Mostly commonly used phrases are allotted as keywords and these are included in the content to make a meaningful content.

Also, a website design company plans to keep the layout simple and easy for the search engine crawlers to retrieve the required keywords. In all, the effectiveness of a good web design fully depends on the strong SEO planning and development.

Microsoft Q&A: Microsoft and Open Source

2010-02-08T19:25:00.000-08:00

by Tomas Gonsorcik on Feb 8, 2010 5:59:06 PM - 90 views

Microsoft has continued to engage with the open source community over the last year. Following up on the Q&A from last May, they would like to share their progress as well as hear your thoughts on how you see PHP working on Windows Server and Microsoft stack in general.

The improvements include:

SQL Server driver for PHP
Windows Cache Extension 1.0 for PHP
Integration into open source Content Management System (CMS) with platforms such as Wordpress and Drupal

There is a good deal of work being done on making PHP run on Azure as well.

Now they would like to hear about the impact of these improvements on your work and what could be done in future to help your apps interoperate with Microsoft stack better.

We decided to restart a dedicated board for the Microsoft Q&A to run a Q&A session with Tom Hanrahan, Director of Microsoft’s Open Source Technology Center, where we ask you to post questions and comments for Tom.

On February 22 at 4.30 GMT, Tom will join the forum and answer all your questions. He will also stay on the forum for the day with his technical team to answer that arise during the live session.

We invite you post your questions freely and with intention to improve your experience with PHP interop. This is an exclusive opportunity to shape the future release of PHP for Windows Server as well as exciting new technologies like PHP on Azure.

We look forward to hearing from you. Ask your questions in the forum now.

Source: http://www.phpfreaks.com/blog/microsoft-qa-microsoft-and-open-source

Media Buying - Media buying & planning, including digital from Space & Time Media

Creativity in Education - Creativity is not unique to the arts. Creativity in education is equally important in mathematics, science, technology, in business - indeed in all areas of life. Neither is creativity simply about letting go, after all creative achievement relies on knowledge, control of materials and command of ideas.

no exam life insurance

50 Extremely Useful PHP Tools

2009-12-03T21:17:00.000-08:00

By Jacob Gube

PHP is one of the most widely used open-source server-side scripting languages that exist today. With over 20 million indexed domains using PHP, including major websites like Facebook, Digg and WordPress, there are good reasons why many Web developers prefer it to other server-side scripting languages, such as Python and Ruby.

PHP is faster (updated), and it is the most used scripting language in practice; it has detailed documentation, a huge community, numerous ready-to-use scripts and well-supported frameworks; and most importantly, it’s much easier to get started with PHP than with other scripting languages (Python, for example). That’s why it makes perfect sense to provide the huge community of PHP developers with an overview of useful tools and resources that can make their development process easier and more effective.

This post presents 50 useful PHP tools that can significantly improve your programming workflow. Among other things, you’ll find a plethora of libraries and classes that aid in debugging, testing, profiling and code-authoring in PHP.

Debugging Tools

Webgrind
Webgrind is an Xdebug profiling Web front end in PHP 5. It implements a subset of the features of kcachegrind, installs in seconds and works on all platforms. For quick ‘n’ dirty optimizations, it does the job.
Xdebug
Xdebug is one of the most popular debugging PHP extensions. It provides a ton of useful data to help you quickly find bugs in your source code. Xdebug plugs right into many of the most popular PHP applications, such as PHPEclipse and phpDesigner.
Gubed PHP Debugger
As the name implies, Gubed PHP Debugger is a PHP debugging tool for hunting down logic errors.
DBG
DBG is a robust and popular PHP debugger for use in local and remote PHP debugging. It plugs into numerous PHP IDE’s and can easily be used with the command line.
PHP_Debug
PHP_Debug is an open-source project that gives you useful information about your PHP code that can be used for debugging. It can output processing times of your PHP and SQL, check the performance of particular code blocks and get variable dumps in graphical form, which is great if you need a more visual output than the one given to you by print_r() or var_dump().
PHP_Dyn
PHP_Dyn is another excellent PHP debugging tool that’s open-source. You can trace execution and get an output of the argument and return values of your functions.
MacGDBp
MacGDBp is a live PHP debugger application for the Mac OS. It has all the features you’d expect from a fully featured debugger, such as the ability to step through your code and set breakpoints.

Testing and Optimization Tools

PHPUnit
PHPUnit is a complete port of the popular JUnit unit testing suite to PHP 5. It’s a tool that helps you test your Web application’s stability and scalability. Writing test cases within the PHPUnit framework is easy; here’s how to do it.
SimpleTest
SimpleTest is a straightforward unit-testing platform for PHP applications. To get up and running with SimpleTest quickly, read through this pragmatictutorial that shows you how to create a new test case.
Selenium
Selenium Remote Control (RC) is a test tool that allows you to write automated Web application UI tests in any programming language against any HTTP website using any mainstream JavaScript-enabled browser. It can be used in conjunction with PHPUnit to create and run automated tests within a Web browser.
PHP_CodeSniffer
PHP_CodeSniffer is a PHP 5 script for detecting conformance to a predefined PHP coding standard. It’s a helpful tool for maintaining uniform coding styles for large projects and teams.
dBug
dBug is ColdFusion’s cfDump for PHP. It’s a simple tool for outputting data tables that contain information about arrays, classes and objects, database resources and XML resources, making it very useful for debugging purposes.
PHP Profile Class
PHP Profile Class is an excellent PHP profiling tool for your Web applications. Using this class will help you quickly and easily gain insight into which parts of your app could use some refactoring and optimization.

Documentation Tools

phpDocumentor
phpDocumentor (also known as phpdoc and phpdocu) is a documentation tool for your PHP source code. It has an innumerable amount of features, including the ability to output in HTML, PDF, CHM and XML DocBook formats, and has both a Web-based and command-line interface as well as source-code highlighting. To learn more about phpDocumentor, check out the online manual.
PHP DOX
An AJAX-powered PHP documentation search engine that enables you to search titles from all PHP documentation pages.

Security Tools

Securimage
Securimage is a free, open-source PHP CAPTCHA script for generating complex images and CAPTCHA codes to protect forms from spam and abuse.
Scavenger
Scavenger is an open-source, real-time vulnerability management tool. It helps system administrators respond to vulnerability findings, track vulnerability findings and review accepted and false-positive answered vulnerabilities, without “nagging” them with old vulnerabilities.
PHP-IDS
PHP-IDS (PHP-Intrusion Detection System) is a simple-to-use, well-structured, fast and state-of-the-art security layer for your PHP-based Web application.
Pixy: PHP Security Scanner
Pixy is a Java program that performs automatic scans of PHP 4 source code, aimed to detect XSS and SQL injection vulnerabilities. Pixy takes a PHP program as input and creates a report that lists possible vulnerable points in the program, along with additional information for understanding the vulnerability.

Image Manipulation and Graphs

PHP/SWF Charts
PHP/SWF Charts is a powerful PHP tool that enables you to create attractive Web charts and graphs from dynamic data. You can use PHP scripts to generate and gather data from databases, then pass it to this tool to generate Flash (SWF) charts and graphs.
pChart – a chart-drawing PHP library
pChart is a PHP class-oriented framework designed to create aliased charts. Most of today’s chart libraries have a cost; this one is free. Data can be retrieved from SQL queries or CSV files or can be manually provided.
WideImage
WideImage is a PHP library for dynamic image manipulation and processing for PHP 5. To be able to use the library, you should have the GD PHP extensioninstalled on your Web server.
MagickWand For PHP
MagickWand For PHP is a PHP module suite for working with the ImageMagickAPI, which lets you create, compose and edit bitmap images. It’s a useful tool for quickly incorporating image-editing features in your PHP applications.

PHP Code Beautifier

PHP_Beautifier
PHP Beautifier is a PEAR package for automatically formatting and “beautifying” PHP 4 and PHP 5 source code.
PHPCodeBeautifier
PHPCodeBeautifier is a tool that saves you from hours of reformatting code to suit your own way of presenting it. A GUI version allows you to process files visually; a command-line version can be batched or integrated with other tools (like CVS, SubVersion, IDE, etc.); and there is also an integrated tool of PHPEdit.
GeSHi – Generic Syntax Highlighter
GeSHi is designed to be a simple but powerful highlighting class, with the goal of supporting a wide range of popular languages. Developers can easily add new languages for highlighting and define easily customizable output formats.

Version-Control Systems

Phing
Phing is a popular project version-control system for PHP. It is a useful tool for organizing and maintaining different builds of your project.
xinc
xinc is a continuous integration server version-control system written in PHP 5 (i.e. continuous builds instead of nightly builds). It works great with other systems such as Subversion and Phing.

Useful Extensions, Utilities and Classes

SimplePie
SimplePie is a PHP class that helps you work with RSS feeds. Check out the online RSS and Atom feed reader, which demonstrates a simple Web application that uses SimplePie.
HTML Purifier
HTML Purifier is a standards-compliant HTML filter library written in PHP. HTML Purifier not only removes all malicious code (better known as XSS) with a thoroughly audited, secure yet permissive white list, it also makes sure your documents are standards-compliant. Open source and highly customizable.
TCPDF
TCPDF is an open-source PHP class for generating PDF documents.
htmlSQL
htmlSQL is a unique tool. It is a PHP class for querying HTML values in an SQL-like syntax. Check out the live demonstration of how htmlSQL works.
The Greatest PHP Snippet File Ever (Using Quicktext for Notepad++)
“A little something for all coders: a snippets file that I use for PHP coding. This is designed to be used with Quicktext for Notepad++, but feel free to adapt it to whatever text editor you prefer.”
Creole
Creole is a database abstraction layer for PHP5. It abstracts PHP’s native database-specific API to create more portable code while also providing developers with a clean, fully object-oriented interface based loosely on the API for Java’s JDBC.
PHPLinq
LINQ is a component that adds native data querying capabilities to PHP using a syntax reminiscent of SQL. It defines a set of query operators that can be used to query, project and filter data in arrays, enumerable classes, XML, relational databases and third-party data sources. [via]
PHPMathPublisher
With PhpMathPublisher, you can publish mathematical documents on the Web using only a PHP script (no LaTeX programs on the server and no MathML).
phpMyAdmin
If you’re working with PHP, there’s a big chance you’re set up in a LAMP configuration. phpMyAdmin is Web-based tool for managing, building, importing, exporting and exploring MySQL databases.
PHPExcel
PHPExcel is a set of useful PHP classes for working with Microsoft Excel files. PHPExcel allows you to read Excel files and write to them. This is useful for dynamically generating Excel spreadsheets for downloading.
Phormer
Phormer is a PHP-based photo gallery management application that helps you to store, categorize and trim your photos online.
xajax PHP Class Library
xajax is a PHP class for easily working with PHP AJAX applications. It gives you an easy-to-use API for quickly managing AJAX-related tasks. Check out thexajax Multiplier demo and the Graffiti Wall demo to see the xajax PHP class in action.
PHP User Class
PHP User Class is an excellent script that helps you create a system for user authentication (i.e. registration, log in, account profile, etc.). It’s a useful utility to have around if you require user registration for your Web applications.
PHP-GTK
PHP-GTK is a PHP extension for the GTK+ toolkit (a robust toolkit for developing GUIs). It is a suite of useful OOP functions and classes to help you rapidly build cross-platform, client-side GUI’s for your application.

PHP Online Tools and Resources

Minify!
Minify is a PHP 5 app that can combine multiple CSS or JavaScript files, compress their content (i.e. remove unnecessary white space and comments) and serve the results with HTTP encoding (via Gzip/deflate) and headers that allow optimal client-side caching. This will help you follow several of Yahoo!’sRules for High Performance Websites.
HTTP_StaticMerger: Automatic “merging” of CSS and JavaScript files
This library automatically merges sets of static files (CSS or JavaScript) and speeds up page loading (by lowering the number of HTTP queries). It is recommended to use this together with caching reverse-proxy to minimize the response time.
PHP Object Generator
PHP Object Generator is an open-source Web-based tool that helps you quickly construct PHP objects and leverage object-oriented programming (OOP) principles in your code.
gotAPI/PHP
gotAPI is a useful online tool for quickly looking up PHP functions and classes. Also check out the Quick PHP look-up widget example in case you’d like to include this awesome look-up feature on your website.
koders
koders is a search engine for open-source and downloadable code. It currently has over a billion lines of code indexed and isn’t limited to just PHP.
PECL
PECL is a directory of all known PHP extensions and a hosting facility for downloading and developing PHP extensions.

In-Browser Tools (Firefox Add-Ons)

FirePHP
FirePHP is a Firefox extension that allows you to log data in Firebug. It has a variety of useful logging features, such as the ability to change your error and exception handling on the fly and to log errors directly to the Firebug console. To learn more about what FirePHP can do, check out the FirePHP guide onhow to use FirePHP. For developers using the Zend PHP framework, you might find this guide on using FirePHP with Zend useful.
phpLangEditor
phpLangEditor is a very handy Firefox add-on for translating language files and variables in your script.
PHP Lookup
PHP Lookup is a built-in search bar to help you quickly look up references to PHP syntax.
PHP Manual Search
PHP Manual Search is a handy search bar that searches official PHP documentation from within your Web browser.

Frameworks for PHP

Dwoo
Dwoo is a PHP 5 template engine positioned as an alternative to Smarty. It is (nearly) fully compatible with its templates and plug-ins, but it is being written from scratch and is aimed to go one step further with a cleaner code base.
CodeIgniter
CodeIgniter is a powerful, high-performance, open-source PHP framework that helps you author PHP applications rapidly. CodeIgniter is known for having a light footprint, thereby reducing your server’s work. You can get up and running with CodeIgniter in a jiffy: it has an awesome online manual, a couple of helpful video tutorials and an active user forum.
YII Framework
Here is a high-performance component-based PHP framework that is supposed to be more efficient than CodeIgniter, CakePHP, ZF and Symfony. An optimal solution for developing large-scale Web applications. Yii supports MVC, DAO/ActiveRecord, I18N/L10N, caching, jQuery-based AJAX support, authentication and role-based access control, scaffolding, input validation, widgets, events, theming and Web services.
NetBeans
A dedicated PHP coding environment and complete integration with web standards. The NetBeans PHP editor is dynamically integrated with NetBeans HTML, JavaScript and CSS editing features such as syntax highlighting and the JavaScript debugger. NetBeans IDE 6.5 fully supports iterative development, so testing PHP projects follows the classic patterns familiar to web developers.
Solar
Solar is a PHP 5 development framework for Web applications derived from the Savant templating engine. Solar uses the MVC architectural pattern and has a host of classes and functions for securing your Web app against SQL injection, cross-website scripting (XSS) and other common exploits.
symfony
symfony is an open-source PHP 5 Web application framework that is well known for its modularity and useful library of classes. To get up and running as fast as possible, you should check out the pragmatic symfony online tutorial called “The symfony 1.2 advent calendar tutorial,” which takes you through a step-by-step example of building your own symfony-based Web application.
PEAR – PHP Extension and Application Repository
PEAR is a popular framework and distribution system for reusable PHP components. The purpose of the framework is to provide a structured library of open-source code for PHP users, a system for code distribution and package maintenance and a standard style for PHP code.
Propel
Propel is an Object-Relational Mapping (ORM) framework for PHP 5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data.
{{macro}} template engine
{{macro}} compiles initial templates into executable PHP scripts with very clean syntax (much cleaner than WACT and Smarty) and executes them very fast. The engine doesn’t use an XML-like syntax; there are only two data scopes, global and local, and no more data sources (all data is displayed with regular PHP variables); and the system supports all WACT features such as templates wrapping and including.
Zend Framework
The Zend Framework by Zend Technologies (the creators of PHP’s scripting engine) is a popular PHP Web application framework that embraces the principles of PHP OOP; it’s very extensible and has built-in utilities for working with free Web service APIs, such as those of Google, Flickr and Amazon.
Qcodo
Qcodo is an excellent open-source PHP Web application framework. It’s subdivided into two parts: (1) Code Generator, and (2) Qforms. Code Generator handles the creation of object code and PHP and HTML front-end code from your data model. Qforms is an intuitive system for handling and creating complex PHP-driven HTML Web forms. Check out demos of applications that use Qcodo and presentational material that covers Qcodo.
SAJAX
SAJAX is a JavaScript and AJAX application framework that works well with PHP (as well as several other server-side scripting languages). See SAJAX at work by going to Wall live demonstration.
Smarty
Smarty is a popular PHP templating system to help you separate PHP logic and front-end code (HTML, CSS, JavaScript). It will keep your projects modular and easier to maintain.
CakePHP
CakePHP is one of the leading PHP frameworks for creating robust, fully-featured Web applications. CakePHP has an extensive and well-organizedonline manual. If you want to learn via video tutorials, check out the CakePHP screencasts.
Savant2
Savant2 is another popular object-oriented PHP templating system. Instead of a special syntax unique to Savant2, you use PHP syntax to develop your project’s template.
PHPSpec
PHPSpec is a simple and intuitive PHP framework. It follows the Behavior-Driven Development principle and therefore allows you to write behavior-oriented code, oftentimes in plain English.

PHP IDEs and Editors

PHPEclipse
PHPEclipse is a popular PHP source-code editor that is open source and runs on all the major operating systems, such as Windows, Linux and Mac OS. It has all the features you’d expect from a PHP source-code editor, such as code-folding, syntax highlighting, hover-over tool tips and support for XDebug and DBG.
PhpED
PhpED is an excellent IDE for Windows users. It is one of the most robust and feature-packed IDEs currently out on the market and has useful features such as a built-in source-code profiler to find bottlenecks in your PHP source code and excellent integration with third-party apps and services just as front-end code validation.
phpDesigner
phpDesigner is a lightweight PHP editor/IDE that also handles front-end code and markup remarkably well. Check out the phpDesigner online tutorials, as well as screencasts on phpDesigner to help you learn more about the IDE.
Zend Studio
Zend Studio is an excellent PHP IDE for Eclipse. It’ll help you develop, deploy and manage Rich Internet Applications (RIAs) in an intuitive interface.
Aptana PHP
Aptana PHP is an open-source IDE extension/plug-in to be used in conjunction with Aptana Studio. To learn more, be sure to check out the online documentation about Aptana PHP.
PDT
PDT is a PHP Development Tools framework that’s part of the Eclipse project. PDT includes all the necessary tools for you to create PHP-based Web applications.
VS.Php
VS.Php is a PHP IDE for MS Visual Studio, making it a great IDE for recently converted ASP developers who have used MS VS to develop Web applications. To get you up and running ASAP with VS.Php, check out Jcx.Software’s online tutorials as well as its online documentation.
PHPEdit
PHPEdit is an excellent PHP editor/IDE with a ton of useful features and a very intuitive user interface. To learn more about why PHPEdit is a good IDE, read the 10 reasons to use PHPEdit and view the introductory screencast about PHPEdit.

Source: http://www.smashingmagazine.com/2009/01/20/50-extremely-useful-php-tools/

Software Testing Services

NoSQL Ecosystem

2009-11-19T20:57:00.000-08:00

I found a very interesting article entitled "NoSQL Ecosystem" from The Rackspace Could. It dove into the fact that we need an alternative for relational databases to handle the high volume of data these days. Some examples the article gave:

The fundamental problem is that relational databases cannot handle many modern workloads. There are three specific problem areas: scaling out to data sets like Digg’s (3 TB for green badges) or Facebook’s (50 TB for inbox search) or eBay’s (2 PB overall), per-server performance, and rigid schema design.

It's a good read, I would like to hear your thoughts around this NoSQL Movement idea.

By Jonathan Ellis, Systems Architect

Unprecedented data volumes are driving businesses to look at alternatives to the traditional relational database technology that has served us well for over thirty years. Collectively, these alternatives have become known as “NoSQL databases.”

The fundamental problem is that relational databases cannot handle many modern workloads. There are three specific problem areas: scaling out to data sets like Digg’s (3 TB for green badges) or Facebook’s (50 TB for inbox search) or eBay’s (2 PB overall),per-server performance, and rigid schema design.

Businesses, including The Rackspace Cloud, need to find new ways to store and scale large amounts of data. I recently wrote a post on Cassandra, a non-relational database we have committed resources to. There are other non-relational databases being worked on and collectively, we call this the “NoSQL movement.”

The “NoSQL” term was actually coined by a fellow Racker, Eric Evans when Johan Oskarsson of Last.fm wanted to organize an event to discuss open source distributed databases. The name and concept both caught on.

Some people object to the NoSQL term because it sounds like we’re defining ourselves based on what we aren’t doing rather than what we are. That’s true, to a degree, but the term is still valuable because when a relational database is the only tool you know, every problem looks like a thumb. NoSQL is making people aware that there are other options out there. But we’re not anti-relational-database for when that really is the best tool for the job; it’s “Not Only SQL,” rather than “No SQL at all.”

One real concern with the NoSQL name is that it’s such a big tent that there is room for very different designs. If this is not made clear when discussing the various products, it results in confusion. So I’d like to suggest three axes along which to think about the many database options: scalability, data and query model, and persistence design.

I have chosen 10 NoSQL databases as examples. This is not an exhaustive list, but the concepts discussed are crucial for evaluating others as well.

Scalability

Scaling reads is easy with replication, so when we’re talking about scaling in this context, we mean scaling writes by automatically partitioning data across multiple machines. We call systems that do this “distributed databases.” These include Cassandra, HBase, Riak,Scalaris, Voldemort, and more. If your write volume or data size is more than one machine can handle then these are your only options if you don’t want to manage partitioning manually. (You don’t.)

There are two things to look for in a distributed database: 1) support for multiple datacenters and 2) the ability to add new machines to a live cluster transparently to your applications.

Non-distributed NoSQL databases include CouchDB, MongoD B, Neo4j, Redis, and Tokyo Cabinet. These can serve as persistence layers for distributed systems; MongoDB provides limited support for sharding, as does a separate Lounge project for CouchDB, and Tokyo Cabinet can be used as a Voldemort storage engine.

Data and Query Model

There is a lot of variety in the data models and query APIs in NoSQL databases.

(Respective Links: Thrift, map/reduce views, Thrift, Cursor, Graph, Collection, Nested hashes, get/put, get/put, get/put)

Some highlights:

The columnfamily model shared by Cassandra and HBase is inspired by the one described by Google’s Bigtable paper, section 2. (Cassandra drops historical versions, and addssupercolumns.) In both systems, you have rows and columns like you are used to seeing, but the rows are sparse: each row can have as many or as few columns as desired, and columns do not need to be defined ahead of time.

The Key/value model is the simplest and easiest to implement but inefficient when you are only interested in querying or updating part of a value. It’s also difficult to implement more sophisticated structures on top of distributed key/value.

Document databases are essentially the next level of Key/value, allowing nested values associated with each key. Document databases support querying those more efficiently than simply returning the entire blob each time.

Neo4J has a really unique data model, storing objects and relationships as nodes and edges in a graph. For queries that fit this model (e.g., hierarchical data) they can be1000s of times faster than alternatives.

Scalaris is unique in offering distributed transactions across multiple keys. (Discussing the trade-offs between consistency and availability is beyond the scope of this post, but that is another aspect to keep in mind when evaluating distributed systems.)

Persistence Design

By persistence design I mean, “how is data stored internally?”

The persistence model tells us a lot about what kind of workloads these databases will be good at.

In-memory databases are very, very fast (Redis achieves over 100,000 operations per second on a single machine), but cannot work with data sets that exceed available RAM. Durability (retaining data even if a server crashes or loses power) can also be a problem; the amount of data you can expect to lose between flushes (copying the data to disk) is potentially large. Scalaris, the other in-memory database on our list, tackles the durability problem with replication, but since it does not support multiple data centers your data will be still be vulnerable to things like power failures.

Memtables and SSTables buffer writes in memory (a “memtable”) after writing to an append-only commit log for durability. When enough writes have been accepted, the memtable is sorted and written to disk all at once as a “sstable.” This provides close to in-memory performance since no seeks are involved, while avoiding the durability problems of purely in-memory approaches. (This is described in more detail in sections 5.3 and 5.4 of the previously-referenced Bigtable paper, as well as in The log-structured merge-tree.)

B-Trees have been used in databases since practically the beginning of time. They provide robust indexing support, but performance is poor on rotational disks (which are still by far the most cost-effective) because of the multiple seeks involved in reading or writing anything.

An interesting variant is CouchDB’s append-only B-Trees, which avoids the overhead of seeks at the cost of limiting CouchDB to one write at a time.

Conclusion

The NoSQL movement has exploded in 2009 as an increasing number of businesses wrestle with large data volumes. The Rackspace Cloud is pleased to have played an early role in the NoSQL movement, and continues to commit resources to Cassandra and support events like NoSQL East.

NoSQL conference announcements and related discussion can be found on the Google discussion group.

Source: http://www.rackspacecloud.com/blog/2009/11/09/nosql-ecosystem/

MySQL University: GRAPH computation engine for MySQL

2009-11-04T18:27:00.000-08:00

One of the things relational databases are not very good at is handling structures like trees (for example structure of categories in forum) or graphs (for example network of friends on social networking site).

GRAPH is a MySQL plugin which promises to handle such data in an easy and efficient manner using normal SQL syntax. I don't know any details, as MySQL University announcement was the first time I ever heard of this. Nevertheless the topic seems interesting, so if you would like to know more, attend MySQL Uni session this Thursday, November 5th at 10:00 GMT.

As usual session recording in flash format will also be available at a later time.

More information about GRAPH is available at OpenQuery's site

For more information about MySQL University, go to my introductory post

Source: http://www.phpfreaks.com/blog/mysql-university-graph-computation-engine-for-mysql

11 Popular Open Source Enterprise Software

2009-09-07T20:10:00.000-07:00

A report by Gartner predicts that the open source software (OSS) model will be adopted by at least 90% cloud-computing providers by the year 2013. As incredible as it sounds, the OSS model is an emerging key component for organizations that are looking for cost effective, reliable solutions for their operations.

Each year, InfoWorld reviews hundreds of open source organization as part of its ‘Best of Open Source’ / BOSSIE Awards. We’ve compiled a list of open source applications that made their way to this year’s BOSSIE Awards winners:

Compiere
Compiere

Compiere is a commercial open source Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) application. It allows you to automate all your financial, distribution, sales and service processes. It uses a model-driven application platform that provides customers with adaptability, rapid deployment, and low cost of ownership.

DimDim

Dimdim is a simple to use browser-based web conferencing service. You can show presentations, collaborate via whiteboards, chat, talk and broadcast via webcam with absolutely no download required to host, attend or even record meetings. It is similar to solutions like WebEx andGotoMeeting. The free version of DimDim allows you to host event with up to 20 people, but if you’d like more attendees, you can upgrade for their pro plans.

Drupal

Drupal is an open source content management platform that supports a variety of sites ranging from blogs to large community driven web portals. Some of its built-in modules include user administration, publishing workflow, discussion capabilities, news aggregation, and metadata functionalities using controlled vocabularies and XML publishing for content sharing purposes.

Intalio BPM

Intalio is a Business Process Management (BPM) solution that provides all the components required for the design, deployment and management of most complex business process. It is based on the Eclipse standard and Apache engine. Intalio PM is available as either a downloadable software or as Software as a Service.

JasperSoft BI Suite
JasperSoft BI Suite

JasperSoft Suite is a Business Intelligence (BI) application that provides integrated reporting and analysis and data integration. It is is comprised of an interactive reporting server, graphical and ad hoc report design interfaces, OLAP analysis, an ETL tool for data integration, and a Java reporting library for use with either stand-alone or embedded business intelligence applications..

Magento
Magento

Magento is an open source PHP and MySql ecommerce script bundle with tons of features like catalog management, marketing and promotion tools, analytics and reporting. The Magento Community Edition is available for free and best suited for small businesses looking for an ecommerce solution. Its enterprise edition is more geared towards corporations looking for a production-ready solution with SLA agreements.

OpenBravo ERP
OpenBravo ERP

OpenBravo is an Enterprise Resource Planning (ERP) web-based open source solution. It has several functionalities tailored to manage accounting, sales, CRM, inventory and projects for any organizations. It is scalable and can be easily deployed on premise or on the cloud. It supports an add-on system whereby you can use 3^rd-partymodules or write your own to add new features adapted to your needs.

Pentaho BI Suite

Pentaho is an open source data warehousing and Business Intelligence (BI) suite available as downloadable or as SaaS. It supports query and reporting, interactive analysis, dashboards, data integration/ETL, data mining. Its dashboards feature allow you to get immediate visibility into metrics while the data mining feature can help you discover hidden patterns and indicators of future performance for your business.

Piwik
Piwik

Piwik in a nutshell is a free open source alternative to Google Analytics. It is a PHP/MySQL based web analytics script that can be downloaded and installed on your own web server. Similar to Google Analytics, all you need to add to your website is a copy-and-paste JavaScript tracking code. It will then provide you with detailed reports about your website’s visitors, the search engines and keywords they used, etc. Learn more in this post.

SugarCRM
SugarCRM

SugarCRM is a Customer Relationship Management script that has been constantly evolving since the past few years. It is bundled with a set of tools for salesforce automation (leads, pipeline forecasting, and account management), e-marketing, and online lead capture, as well as customer support and automated service handling.

WordPress
WordPress

WordPress is a state-of-the-art semantic personal publishing platform with a focus on aesthetics, web standards, and usability. It supports multiple users, categories, comments, bookmarklets, RSS syndication, several APIs, weblogs.com ping, and more!

Source: http://www.hotscripts.com/blog/11-popular-open-source-enterprise-software/

How to Create an RSS Feed

2009-09-06T20:20:00.000-07:00

RSS is a method of distributing links to content in your web site that you'd like others to use. In other words, it's a mechanism to "syndicate" your content.

Steps
What is RSS?
How does RSS syndication work? Say you publish a new web page about a particular topic. You want others interested in that topic to know about it. By listing the page as an "item" in your RSS file, you can have the page appear in front of those who read information using RSS readers or "news aggregators". RSS also allows people to easily add links to your content within their own web pages. Bloggers are a huge core audience that especially does this.
What does RSS stand for? There's a can of worms. RSS as introduced by Netscape in 1999 then later abandoned in 2001 stood for "Rich Site Summary." Another version of RSS pioneered by UserLand Software stands for "Really Simple Syndication." In yet another version, RSS stands for "RDF Site Summary."
History buffs might be interested that there's been some rivalry over who invented RSS. This is why we have both different names and indeed different "flavors" or versions of RSS.
At the heart of an RSS file are "items." No matter what version of RSS you settle on, your file will have to include at least one item. Items are generally web pages that you'd like others to link to. For example, let's say you just created a web page reviewing a new cell phone that's being released. Information about that page would form an item.
To enter your item into the RSS file, you'll need three bits of information:

Title
Description
Link

The title and description of your item need not match exactly the HTML title tag of the web page that the item refers to, nor the meta description tag, assuming you use these. You can write any title and description that you think will describe the page. However, using your page's title and meta description tag certainly makes it easy to copy and paste to build your RSS feed.

In the case of our example page, let's say this is the information we settle on to define it as an item:

Recent Changes - WikiHow
Patrol all the edits that people have recently made to wikiHow!
http://www.wikihow.com/Special:Recentchanges

Now we have to surround that information with xml tags. These are similar to HTML tags, with the exception that unlike with HTML, there's no set definition of xml tags. Anyone can make up a particular xml tag. Whether it is useful depends on the program that reads the resulting xml file. In the case of RSS feeds, they have their own unique set of XML tags that are defined. Use these correctly, and then anything that reads RSS will understand your information.

Did that make your head spin? If so, don't reread - just carry on to see how simple it is. First, open a text editor like Notepad. We're going to build our RSS file using it.

For your title, you need to start it with the title tag, then follow this with the text of the title, then end with the title tag.

For your description, you do the same, starting out with the opening description tag, then following with the actual description, then closing with the description tag.

Next, we add the link information, beginning with link, following with the actual hyperlink, then closing with .
Now there's one more thing we need to do. We actually have to define all this information as forming a particular "item," which we do using a special item tag.

You place the opening item tag, "item" at the top or start of all the information we've listed. You then place the closing item tag, "item", at the bottom or "end" of the item information.

Congratulations! You've now made your first item. There's a bit more to do to finish our RSS file. First, what if we have other items we want to syndicate? Then we simply add more item elements, just as we did above. You can have up to 15 items. New items tend to be inserted at the top, with old items removed from the bottom, to make room for new stuff.
With our example, let's see how things look if we add two more items:

Now, how does something reading our RSS file know that the information above is for our "channel" when it looks just like item information? Simple. As long as we don't surround this information with an opening and closing item tags, it won't be seen as item information but rather as channel information.
There are a few last things we need to do. First, we need to add a tag at the very top of the file saying that this is written according to the XML 1.0 specifications. Right under this, we also have to say what RSS version we are using.

So far, everything we've done is compatible with UserLand's popular RSS 0.91 version. However, it also matches UserLand's latest RSS 2.0 version, as well, so we'll define the file as meeting that specification. This will allow us to add other neat features in the future, if we want.

Finally, after the RSS tag, we need to add an opening "channel" tag. That gives us this at the top of the file:

At the bottom of the file, after all the items we want to syndicate, we have to insert a closing channel and RSS tag, in that order. Those look like this:

This means our complete file looks like this:

Saving The File - Now that we're done adding to the file, we need to save it. But what name shall we give it? As for the first part, that really can be whatever you like. For our example, let's say we just call it "feed.xml".

Now that our file is saved, we can place it anywhere we want on our web server. Let's say we put it in the root or home directory. Then the address to our RSS file would be:

http://www.wikihow.com/feed.xml
Adding the Feed to Your Page - There is one more thing left to do. To make it obvious that you have a feed on your page you should declare it in the head tag on your web page. To do this add the following code:

If everything worked, you should see the little orange RSS icon in your browser's address bar. (Firefox,Opera)

Tips
Getting started will take time and isn't that easy, but after you know the basics it gets easier.
For more technical details on RSS, read the RSS 2.0 specification

Determining Programming Language Popularity

2009-08-24T21:44:00.000-07:00

One common question that members ask us is which language is most popular? While there is no definitive answer to this question, it all depends on which statistics and rankings you are looking at and how you interpret the results. There are several organizations that publishes regular reports or tools that provides trends to measure popularity of a programming language. In this post, we take a look at some of these reports and tools along with the metrics they use.

TIOBE – Popularity by Community Index

TIOBE

The TIOBE Programming Community index gives a monthly indication of the popularity of programming language based several factors - the number of skilled engineers world-wide, courses and third party vendors. The popular search engines Google, MSN, Yahoo!, Wikipedia and YouTube are used also to calculate the ratings.

LangPop - Popularity by Search and Discussions

LangPop

LangPop uses some metrics similar to TIOBE, but also takes into consideration some other channels like Craiglist, Amazon’s books index, del.icio.us and open source project hosting site like Google Code and Freshmeat. It also aggregates data based on what people are talking about on IRC, Reddit and Slahsot.

Ohloh - Popularity by Commits

Ohloh

Ohloh is a project hosting site for open source projects and has a strong community of developers. Their monthly language comparison is calculated based on the number of commits made by source code developers for that particular month, A commit is a change done to the code and Ohloh requires at least one line change for that language.

BlackDuck - Popularity by Lines of Code

BlackDuck

BlackDuck publishes regular analysis of language usage used in open source projects. It determines this by counting lines of source code across all open source projects. Black Duck Software gathers information by continuously spidering the Internet collecting open source code and binary files into its database from over 200,000 projects.

Google Trends - Popularity by Search Trends

Google Trends

Google Trends is a powerful tool to see how often a particular search-term is used relative to the total search-volume. The best thing about Google Trends is that results are in real time and you can group any programming language of your choice to be included in the result.

Indeed - Popularity by Job Trends

Indeed

Indeed is a search engine that aggregates job listings from the web. It provides a trend tool to compare jobs with particular term. You can use it to search job trends based on the different programming language.

O’Reillly - Popularity by Book Sales

O'Reillly

O’Reilly publishes regular posts on their blog about programming lanaguage trends based on computer book sales. These statistics rough ballparks and are based on O’Reilly published books only but they still provides a relative demand of each language.

http://www.hotscripts.com/blog/determining-programming-language-popularity/

6 iPhone Apps for Web Developers

2009-07-31T18:43:00.000-07:00

Perhaps the biggest reason for the staggering success of the iPhone is its thousands of applications that are available. iPhone apps ranges from games, productivity tools, entertainment programs but there are also apps that can be a great addition to a web developer’s toolbox. If you have an iPhone, here are some apps that you’ll find useful. Please note that the URLs for the applications below will automatically load the Apple Store within iTune.

Developer Notes

Developer Notes is an application built exclusively for software and web development community. It allows you to organize development tasks with ease. Each tasks can be assigned to a specific type like todo, fixme, idea with different tracking status like new, pending, on-hold or done. You can also prioritize tasks and set their due dates or move tasks between different versions. DeveloperNotes also comes with built-in email features that allows you to email tasks to yourself or your lead developer.

iCheatSheets

CheatSheets is for every seasoned developers that needs a quick refresher course. It is a free reference application that gives web developers quick reference to a variety of useful functions right at their finger tips. It has quick function and command references for most popular web technologies like ASP, PHP, HTML and also includes reference for topics like Mod Rewrite and Regular Expressions.

FTP on The Go

FTP on The Go is an FTP client for the iPhone with all features of a desktop FTP client. It allows you to fix your web site, and view files on your FTP server from anywhere. Other than the default FTP features like upload and download, it also support editing text file with its built-in editor. Its Find/Replace and Go To Line Number enables you to fix your codes faster. FTP on The Go can also store your files on your iPhone and you can view,edit or email any of the saved files.

DatabaseViewer

DatabaseViewer is a commercial application with its price tagged at $19.99 - a little expensive for an iPhone application, in my opinion. It will allow you to view any database on your iPhone and you can synchronize data wirelessly. It support SQL select queries, filters and you can sort the fields. DatabaseViewer currently supports most of the popular databases like MS Access, SQL Server, MySQL, PostegreSQL and any other ODBC compliant database.

WorkTimer

WorkTimer is a time management application that allows you to track how long you’ve spent on various project so that you can eventually bill your client accordingly. This is pretty useful for web developers that works both from office and home and need a convenient way to track their hours. At the end of each month, you can email yourself (or anyone else) a monthly report of all the hours worked in different projects.

Source Viewer

Source Viewer is a handy application that enables you to view a web site’s HTML source code - just as you would with the ‘view source’ option in your web browser. The source code of the web site is presented in an easy to read format with code highlighting feature. The best thing about this application is that it also collects all images and links (CSS links, JS links) from the source code and these can then be viewed separately.

Source : http://www.hotscripts.com/blog/iphone-apps-for-web-developers/

10 Ways to Avoid Writing Crappy Code

2009-07-03T21:39:00.000-07:00

1. Learn OOP and common OO principles

This is an absolute requirement. If you are still coding procedural, this is no small task. What are you waiting for?

1. Employ Test Driven Design

Code that is buggy or simply doesn't work at all can safely be considered "crappy code". TDD gives you the confidence that your code works, and the side effects force better and more flexible software design.
If you are not familiar with TDD yet, and this post has prompted you to try it, be warned: at first it will seem very cumbersome. What definitely will help is this piece of advice, which is at the core of Test Driven Design: don't write tests afterwards, write them first. Without going to much into the details, and somewhat simplified the general mantra is this: write a test first, make it work by writing the application code, refactor, write another test, make it work, refactor, etc etc. It's a cycle. The application code follows the test code, not the other way around.
I recommend PHPUnit. It has the most features and the largest adoption.

2. Refactor, refactor, refactor

Refactoring means "to improve the design of existing code". Making changes to code results in an increasing loss of quality of that code, this is known as "software decay". To battle this phenomenon, you have to constantly evaluate if the code hasn't lost it's quality, and look for opportunities to improve the design beyond it's original. But there's a catch. And it isn't the time that refactoring takes, if you do it properly you'll save those hours by having avoided software decay. It is the risk of change.
I can understand if you are hesitant to change code that works (at least for now). But this is where number two comes back into play: as long as you've written the right tests, you can make sure your changes don't break anything.

3. Simpler is better

Your mind should constantly be waging a battle between simplicity and flexibility. Avoid unnecessary complication.

4. Use Design Patterns

Design Patterns describe real world software design problem and solutions. Make sure you are familiar with them, buy some books. If you encounter a design problem that seems familiar take your trusty GoF and PoEAA from the shelf and look it up.

5. Don't Use Design Patterns

Once you are familiar with Design Patterns, or even just with the existence of them, it can be tempting to start sprinkling pattern implementations over your application code, just because you can. Don't. Remember a Design Pattern consists of a problem and one or more solutions to that problem. Until you have the problem, don't use the solution.

6. Accept the limitations of your language

Believe me, I know that as a programmer it is difficult to accept limitations on bending your code to your will, but trying to change the behaviour of PHP is not the solution. PHP has limitations, you'll have to live with them. If you try to "patch" them, chances are you will do more harm than good.

7. Pretend you are writing a book

It has been said that "code should be easy to read rather than easy to write". Maybe somebody else will need to understand your code at some stage. Maybe two years from now, you will revisit this code and need to re-learn it's inner workings.
Semantics, meaningful docblocks and clear execution flow are everything. Imagine reading an instruction manual without pictures, filled with meaningless abbreviations, and with the pages in arbitrary order, without page numbers. That's how someone, maybe you, will feel if you ignore this advice.

8. Peer Review

Believe it or not, you don't know everything and you aren't always right. Nobody is. Getting a "second opinion" can only improve the end result.

9. E_STRICT is your friend

Make sure your code runs properly with E_STRICT turned on. Although, if you have gotten this far, I don't think that will be a problem.

10. Create a distinction between "source code" and a "build"

Even though PHP is an interpreted language, this is an important distinction in my opinion, even though practically noone employs this in the PHP world. A build in PHP is a copy of (part of) the source code, which includes assets like HTML, CSS and JavaScript, and is stripped of anything not necessary for running the application. Maybe your build is a Phar file, or maybe you have combined some source files into a single file (like the guys at Doctrine do). Maybe you can provide different build of the same project to server different purposes..
How does this help you avoid crappy code? It allows you to have the source code and build differ, avoiding any compromises you might be tempted to make to facilitate runing or developing the application. Bonus points if you allow the user to choose between placing everything in the server document root or just a bootstrap and the static files.

There are various build tools available, personally I use PHPUnderControl, which is a patch for CruiseControl and gives you a variety of build server features. It uses Ant by default, but I also use Phing.

10 Signs of Crappy PHP Software

2009-07-02T23:58:00.000-07:00

Like it or not, as a professional developer, sooner or later you are going to do some customising (if you are lucky, "extending") of existing software.
If you are not familiar with the software, it is good advice to look into it before accepting the job. I had to learn that the hard way. But how do you recognize crappy applications without getting knee deep into the code? 10 pointers to identify crappy PHP software quickly...
1. The software tries to reinvent the object model, or "fix" language features.

See if you can find a class called "Object". If you find it, it's a pretty clear indication that the author is in the business of trying to reinvent the object model (most commonly because of his own lacking understanding of OO). It is safe to assume that his "fixes" won't stop there. Unplug your phone and hide under your desk.
2. The code includes user defined global variables

A search in the code for "global" or "$GLOBALS" may reveal something like this:
global $database, $my, $mainframe;
The infamous global variable. If you can tell me what those last two variables contain you are either intimate with the software I pulled it from, or you're psychic. Unlimited bonus points if you can say what code has had it's claws on it before execution flow got to this point. In short, steer well clear.
3. Scattered HTML and SQL

Search for some common SQL and HTML strings. You should be able to determine very quickly whether these are appropriate places for HTML or SQL. If you find HTML and SQL in the same file, "crappyness" is most definitely confirmed.
4. Classes do too much

Find the 3 largest class files by bit size. Take a look at the class name. Does it indicate a distinct responsibility? Look at the methods. Are the tasks they perform closely related? If not, run away screaming.
5. Lots of properties are public or lots of properties are static

If lots of properties are declared "public static", triple your quote. If I have to explain why, maybe there's an open position on the development team of the software for you.
6. Multiple levels of inheritance

More than 2 levels inheritance should be avoided like the plague. I stake my life on the resulting objects having too much unrelated behaviour (ok, maybe not my life, but if you find a proper use of more than 2 levels of inheritance, I'll buy you a beer).
7. The authors try to use Design Patterns

Whether or not the authors have a clue is easily determined by searching for some of the most common design patters. Search the code base and/or documentation for "factory", "decorator", "strategy" etc. If present, you can pretty quickly determine whether the authors know their stuff or are trying to look interesting. That is, if you know how the code should look. If not, refuse to take the project until you do.
8. The software messes with the error level

Well written applications run fine at any error level. Searching the files for /error_level$.*$/ should do the trick. In case of hits, try replacing the value with E_STRICT. That's little more than a formality though.
9. In the code base, there is a directory called "core"

This is usually used as an excuse to have the whole application dependent on whatever is in there. Despite the appeal of the term (it does make the contents sound pretty cool and important), defining a "core" is a sign of bad design.
10. The software uses it's own template language.

Be afraid. Very afraid. These guys are definitely in the business of reinventing the wheel. Ignore this warning and you will find yourself spending the better part of a day simulating a "for" loop.

fine arts prints - Outpost makes it easy to create large prints and Art from your Photos and Illustrations on multiple types of fine art papers and artist canvases
gaming computer - Computers - Buy new custom built gaming computers from $499.
Chinese SEO
SEO Company
Marketing Lists - Accurate and targeted UK consumer mailing list selectable from over 1000criteria.
Work from home - Moolahology is a work from home guide that focuses on helping people start their own internet business through affiliate marketing.
seo company india - INFOCARE India provides Search Engine Marketing solutions like SEO, Link Building, PPC, Web Development and Web Design services at very affordable prices.
Link building services india - cheapest SEO Company in India offers free SEO consultation and Search Engine Optimization.
EDI solutions - EDI solutions without buying EDI software. Complete outsourced systems.
Web design company in Miami
ipod software
Eci software
California seo services
SEO
IT Support IT Services
Mikes Live Meeting

Using MySQL Administrator with WampServer

2009-06-23T01:44:00.000-07:00

For those readers who do not develop PHP on Windows platform WampServer is probably the most popular Apache + MySQL + PHP package for Windows. MySQL Administrator on the other hand, is a part of MySQL GUI Tools package.

The problem with this pair, is that they don't want to work together. At least not right out of box. MySQL Administrator fails to find mysql service process as installed by WampServer. This leads to infamous 'Could not find settings' error message.

You still will be able to use MySQL Administrator, but some of its features will be unavailable - among them quite important 'Startup variables' that lets you configure your server.

The reason is simple. WampServer keeps MySQL's config file in a directory, that is not checked by MySQL Administrator's searching algorithm.

Luckily, the solution is also simple.

Open registry editor
Windows XP: Go to Start > Run... type in regedit and press Enter
Vista: Go to Start, type regedit into search box and press Enter

A word of warning: be careful when using registry editor, as you might break your system if you change wrong variables.

Using tree on the left go to:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\wampmysqld

In the window on the right find ImagePath variable, double click it's name.

In the dialog that opens you should see something like this:
c:\wamp\bin\mysql\mysql5.1.33\bin\mysqld.exe wampmysqld
(MySQL's version may vary)

Change it like this:
"c:\wamp\bin\mysql\mysql5.1.33\bin\mysqld.exe" --defaults-file="c:\wamp\bin\mysql\mysql5.1.33\my.ini" wampmysqld
(be careful not to miss any double quotes!

Close registry editor, then restart you MySQL server from WampServer's tray menu.

MySQL Administrator should work fine now.

That would be it ;)

----

MySQL Forums post, where I've found this solution|Database Software Development by Expert Developers, UK

SSH Auto-mount Network Share

2009-06-18T04:01:00.000-07:00

(Beware - This blog/tutorial is directed towards linux based users)
When doing any type of work, especially web work, one of the royal pains is FTPing to your server, or any type of file transfer. Well now you can make it quick and painless. Let me introduce SSHFS. There are 3 major components when creating the SSHFS, and I will guide you through creating and installing all of the necessary steps. Now you can mount and use your file system to automatically upload files and folders to your server with ease.

The 3 Major components:

SSH Automatic Login
Install SSHFS
Mount your folder(s)

SSH Automatic Login

Run this command (with the obvious variable substitutions). It should create a public ssh key on your server.

ssh-copy-id [-i [identity_file]] [user@]machine

ssh-keygen -t dsa
ssh-copy-id user@machiner.

Check to make sure it's there, the file should be called, "authorized_keys".

ls -al ~/.ssh/

If you're having trouble with this part, you can reference this tutorial which breaks this component into smaller steps: SSH Automatic Login.

Install SSHFS

sudo apt-get install sshfs

Or use whatever package manager your distribution provides.

Mount

Create a shell script, we'll call it "mount.sh", and add the contents:

sshfs [user]@[your_server].com:/dir/on/server /dir/to/mount

Run the script:

./mount.sh

Go to the mounted directory and run the 'ls' command to make sure all of your files/folders from your server show up in your local directory.

After you have this successfully working you should at it to your startup scripts.

System >> Preferences >> Sessions >> [add_a_new_entry]

You should be all set. You should have an automatic SSH login (no prompt for a password) from your computer to your server and a mounted folder to your server that acts as an automatic FTP client. The files in your mounted directory should be synced with that of your server. Now all you have to do is move or copy your desired files/folders into the mounted directory, and voila, they're on your server.

MySQL University: Boosting Performance With MySQL 5.1 Partitioning

2009-05-29T18:20:00.000-07:00

It's been some time some time since we had a MySQL Uni session subject that could be interesting to an 'average' PHP developer. The one that's going to take place next Thursday will definitely be of this sort.

Introduced in MySQL 5.1, partitioning lets you divide your tables into smaller chunks of data... while still keeping them in one table. No more need for `invoices2006`, `invoices2007`, `invoices2008` tables to cope with archival data, no more wicked UNIONs. Now you can tell MySQL to keep invoices (or whatever you need to keep) from one year separate from all other years, thus improving queries that only deal with records from one year.

That's just a simple example, as there are much more to partitioning than that. I urge you therefore to attend MySQL Uni's Dimdim session this Thursday, June 4th at 13:00GMT.

The session will be presented by Giuseppe Maxia a.k.a. The Data Charmer. I attended one of his sessions in the past, and he seems like a very interesting person to listen to.Check the MySQL University home page for details (and possible last minute schedule changes!)For more information about MySQL University, see my introductory post

Personality Development - a slide I liked

2009-04-25T22:13:00.000-07:00

Personality Development

View more presentations from Related List.

Too much information about the MySQL TIMESTAMP

2009-04-25T18:46:00.000-07:00

Source:http://www.gizmola.com/blog/archives/93-Too-much-information-about-the-MySQL-TIMESTAMP.html

The MySQL timestamp is an oddity, being both a mySQL "Data Type" as well as a type of specialty column that provides a built in default. It doesn't help matters, that the timestamp was changed significantly around mysql version 4.1.

The Old TIMESTAMP

In older mysql versions, the TIMESTAMP was not in the same format as a DateTime column, and you could also set up truncation by defining the TIMESTAMP to have a fixed size. For example, you could define a TIMESTAMP column to be a TIMESTAMP(4) which would then only store the 4 digit Year portion of a DateTime value. I won't go into much detail on the pre version 4.1 TIMESTAMP, however, if you're stuck with an older version of MySQL I recommend you read the manual carefully before you attempt to use any of the information here. I'm going to concentrate on the current TIMESTAMP.

TIMESTAMP Properties

At its most fundamental, the TIMESTAMP is really nothing more than a Unix TimeStamp, which is to say, that internally it is stored as an integer value of seconds. Where a MySQL DATETIME column can be used to store any date and time from Jan 1, 1000 to 12/31/9999, the TIMESTAMP is limited in the same ways that the Unix timestamp is currently limited -- it can only store values from Jan 1, 1970 to Jan 9, 2038.

Those familiar with Unix design, will recognize the Jan 9, 2038 date as being the next big "Y2K" computing panic, and if you're young enough, you may realize a large payday in your future, selling remediation services to companies in roughly another 28 years. The folks at http://www.y2038.com/ are already estimating this to be as much as a 10 trillion dollar jackpot, although no doubt by that time most of the coding will be done by the Morlocks from their underground cave cities. Outsourcing of IT to Morlocks will be a major industry trend by the year 2020, mark my words.

Saving bytes

MySQL stores a timestamp as a 32 bit integer, which of course requires 4 bytes of storage. This is one reason why you might want to use a TIMESTAMP over a DATETIME, which requires 8 bytes. Primarily, people look to the TIMESTAMP because, as its name implies, it can be utilized to stamp the time on a row at the point it's inserted. Let's take a look at a mysql TIMESTAMP in action.

First let's create a table with a single TIMESTAMP column in it. We will not refer to this column, and observe what happens when we insert a new row into the table. In case you're keeping score:

mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.0.45 |
+-----------+
1 row in set (0.00 sec)

CREATE TABLE atimestamp (id INT PRIMARY KEY AUTO_INCREMENT, justnow DATETIME, created TIMESTAMP);

So here we have the table, along with a datetime column that we will set to the magic value of NOW().

mysql> insert into atimestamp (justnow) values (NOW());
Query OK, 1 row affected (0.00 sec)

mysql> select * from atimestamp;
+----+---------------------+---------------------+
| id | justnow | created |
+----+---------------------+---------------------+
| 1 | 2009-04-23 14:29:58 | 2009-04-23 14:29:58 |
+----+---------------------+---------------------+
1 row in set (0.00 sec)

Just as one would hope, MySQL automatically sets the value of TIMESTAMP column I named "created" to be the same as the Server time. So if our primary goal is to have a column that keeps track of when the row was created, our TIMESTAMP does a great job.

Or does it?

Stopping an UPDATE from overwriting the TIMESTAMP

What happens if, at later time, we UPDATE a column in the table?

mysql> update atimestamp set justnow = NOW();
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from atimestamp;
+----+---------------------+---------------------+
| id | justnow | created |
+----+---------------------+---------------------+
| 1 | 2009-04-23 14:30:32 | 2009-04-23 14:30:32 |
+----+---------------------+---------------------+
1 row in set (0.00 sec)

This is not good. Our created time has been lost, because the default behavior of a TIMESTAMP is to update the value to NOW(), any time the row is changed.

The TIMESTAMP Defaults

Setting a column to be a MySQL TIMESTAMP is equivalent to also giving the column a default of CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP. For those not familiar with Mysql Defaults, when creating a table, you can specify a default value for a column to receive if it is not specifically assigned a value during an INSERT. You do this using the DEFAULT keyword, and for all columns other than a TIMESTAMP this must be a constant value. Timestamp columns can specify the CURRENT_TIMESTAMP default which tells mySQL to default this column to NOW().

Stopping UPDATE on TIMESTAMP

The only way not to get the update behavior is to specifically declare the TIMESTAMP to DEFAULT CURRENT_TIMESTAMP. This seems to me to defeat the purpose of having the default behavior in the first place but might be understandable if it was possible for you to have a second TIMESTAMP column, perhaps named "updated".

Unfortunately, you can't have one TIMESTAMP with DEFAULT CURRENT_TIMESTAMP, and a second one with ON UPDATE CURRENT_TIMESTAMP. More often than not, what people really want is only the DEFAULT CURRENT_TIMESTAMP behavior, so it's very important to remember this workaround, if you are using a TIMESTAMP as for example, the "signup date" in a User table. See this in action below:

CREATE TABLE atimestamp (id INT PRIMARY KEY AUTO_INCREMENT, justnow DATETIME, created TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

mysql> describe atimestamp;
+---------+-----------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-----------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| justnow | datetime | YES | | NULL | |
| created | timestamp | NO | | CURRENT_TIMESTAMP | |
+---------+-----------+------+-----+-------------------+----------------+
3 rows in set (0.00 sec)

mysql> insert into atimestamp (justnow) values (NOW());
Query OK, 1 row affected (0.00 sec)

mysql> select * from atimestamp;
+----+---------------------+---------------------+
| id | justnow | created |
+----+---------------------+---------------------+
| 1 | 2009-04-23 18:15:38 | 2009-04-23 18:15:38 |
+----+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> update atimestamp set justnow = NOW();
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from atimestamp;
+----+---------------------+---------------------+
| id | justnow | created |
+----+---------------------+---------------------+
| 1 | 2009-04-23 18:15:56 | 2009-04-23 18:15:38 |
+----+---------------------+---------------------+
1 row in set (0.00 sec)

Now we have automatic timestamping on INSERT, but without the timestamp being overwritten on UPDATE.

What about an UPDATE only TIMESTAMP?

Perhaps there's a really good reason to dedicate a TIMESTAMP to only apply the time when the row is updated. I can't think of one, but for the sake of completeness, here's how you can define the Default.

CREATE TABLE atimestamp (id INT PRIMARY KEY AUTO_INCREMENT, justnow DATETIME, updated TIMESTAMP DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP);

Many Timestamps, but only one that's magical

MySQL will allow you to declare multiple columns of type TIMESTAMP, but only the first timestamp in the table will have the built in Default.

CREATE TABLE bigtimestamp (id INT PRIMARY KEY AUTO_INCREMENT, justnow DATETIME, created TIMESTAMP, updated TIMESTAMP, verified TIMESTAMP);

mysql> describe bigtimestamp;
+----------+-----------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| justnow | datetime | YES | | NULL | |
| created | timestamp | NO | | CURRENT_TIMESTAMP | |
| updated | timestamp | NO | | 0000-00-00 00:00:00 | |
| verified | timestamp | NO | | 0000-00-00 00:00:00 | |
+----------+-----------+------+-----+---------------------+----------------+
5 rows in set (0.00 sec)

mysql> insert into bigtimestamp (justnow) values (NOW());
Query OK, 1 row affected (0.01 sec)

mysql> select * from bigtimestamp;
+----+---------------------+---------------------+---------------------+---------------------+
| id | justnow | created | updated | verified |
+----+---------------------+---------------------+---------------------+---------------------+
| 1 | 2009-04-24 23:39:19 | 2009-04-24 23:39:19 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 |
+----+---------------------+---------------------+---------------------+---------------------+
1 row in set (0.00 sec)

Even with this limitation, it may still be a good idea to declare your Date columns as TIMESTAMP type, as the savings of 4 bytes per date per row can easily be significant if your table will have a lot of rows in it.

Single table Insert and Update Timestamp Workaround

It is actually possible to trick mysql into providing the default timestamp behavior for "created' and "updated" columns, despite the documented limitation of only having one default timestamp per table. If you define the first timestamp column to have a default of 0, while also being NOT NULL, you can trick mysql into supplying today's date by explicitly setting the column to be NULL on insert. In this case, mySQL decides to be helpful and for no logical reason, to set the value to NOW(). The second TIMESTAMP which has the explict TIMESTAMP defaults, works normally, and is set to NOW() on insert and update.

CREATE TABLE atimestamp (id INT PRIMARY KEY AUTO_INCREMENT, justnow DATETIME, created TIMESTAMP NOT NULL DEFAULT 0, updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);

mysql> describe atimestamp;
+---------+-----------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-----------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| justnow | datetime | YES | | NULL | |
| created | timestamp | NO | | 0000-00-00 00:00:00 | |
| updated | timestamp | NO | | CURRENT_TIMESTAMP | |
+---------+-----------+------+-----+---------------------+----------------+
4 rows in set (0.00 sec)

mysql> insert into atimestamp (justnow) values (NOW());
Query OK, 1 row affected (0.00 sec)

mysql> select * from atimestamp;
+----+---------------------+---------------------+---------------------+
| id | justnow | created | updated |
+----+---------------------+---------------------+---------------------+
| 1 | 2009-04-24 23:54:23 | 0000-00-00 00:00:00 | 2009-04-24 23:54:23 |
+----+---------------------+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> insert into atimestamp (created, justnow) values (NULL, NOW());
Query OK, 1 row affected (0.00 sec)

mysql> select * from atimestamp;
+----+---------------------+---------------------+---------------------+
| id | justnow | created | updated |
+----+---------------------+---------------------+---------------------+
| 1 | 2009-04-24 23:54:23 | 0000-00-00 00:00:00 | 2009-04-24 23:54:23 |
| 2 | 2009-04-24 23:55:35 | 2009-04-24 23:55:35 | 2009-04-24 23:55:35 |
+----+---------------------+---------------------+---------------------+
2 rows in set (0.00 sec)

mysql> update atimestamp set justnow=NOW() WHERE id = 2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from atimestamp;
+----+---------------------+---------------------+---------------------+
| id | justnow | created | updated |
+----+---------------------+---------------------+---------------------+
| 1 | 2009-04-24 23:54:23 | 0000-00-00 00:00:00 | 2009-04-24 23:54:23 |
| 2 | 2009-04-24 23:56:48 | 2009-04-24 23:55:35 | 2009-04-24 23:56:48 |
+----+---------------------+---------------------+---------------------+
2 rows in set (0.00 sec)

While this technique works at present, I would consider it an undocumented hack, based on a side effect. It also requires you to explicitly specify NULL in the values for the created column. If you forget to reference the column in the INSERT statement, it will not set the value to NOW() as illustrated above. This technique works for now, but who knows what will happen in future versions of mySQL? Use at your own risk.

PST Password Recovery Software

2009-04-20T22:34:00.000-07:00

Stellar Phoenix Outlook PST Repair Software is designed to recover lost or forgotten PST file password instantly. Stellar also provide recovery of your lost or corrupt outlook email file and s allow splitting PST file into smaller files when PST file size exceed from 2 GB and Outlook can’t recognize the PST files. This Software completely recovers all of Microsoft Outlook Problems.

Microsoft Outlook is a Personal information manager used to receive confidential, personal and business important client mails .It used mainly for email, contacts, notes, messages, calendar entries, journal all these features are stores in Personal Storage Table (PST). PST is a password protection feature also adds to its data security. To protect your client mail and other outlook features you must set a password. The PST password may get lost or forgotten. This is the time when you need your outlook password recovery.
Key Features:

Instantaneous PST password recovery
Mail account password recovery
Generation of several passwords for a single file
Can save recovered passwords in notepad or any other text editor
PST password recovery options for Outlook 2007, 2003, 2002, 2000 and 98
Passwords having special characters and numbers can be recovered
Interactive interface
PST repair ability
Can split PST into smaller PST files
Live Update feature to help software constantly updated

Cases, when PST password recovery may be needed:

Lost or forgotten the PST or mail account password
The bit of paper or file is missing where the password was written
Password was set a long ago and now you have no clue of
Outlook is not accepting your password

Stellar Phoenix Outlook PST Repair Software has designed the program to recover forgotten, lost or missing PST password in any case along with intuitive interface. PST Password Recovery program gives a set of new passwords to access PST.

Stellar Phoenix Application is most powerful to recovery lost Password. It supports Outlook 2007, 2003, 2002 and 2000. The application can also be used to split large PST file into smaller parts. This Stellar product is efficient enough to give you PST password recovery, PST repair and split PST options in a single fusion. All three jobs are productive, valuable and viable through Stellar Phoenix Outlook PST Repair Software. You can download free version of windows data recovery then please Visit here…..

Vizuality Marketing and Design Doncaster
Vizualitys marketing, PR, public relations, graphic and media design expertise will transform your ideas into brand development and corporate identity. Based in Doncaster, South Yorkshire we are leaders in our field.Design and print services also avaiable.

Instant Blaupunkt Radio Codes
It`s so easy to get your Blaupunkt Radio Code! And our fully automated process will guide you through the entire procedure. After you have entered your radio details into the boxes provided, you will be directed to the PayPal website to make a secure payment, and once completed, your Blaupunkt Radio Code will be ready for you to view Online. We will also send a copy via E-Mail for your to print off for your records.
Data Recovery Software
Buy award winning hard drive data recovery software and utilities or try the demos free. Stellar offers a complete solution of file recovery software and lost data restoration programs for Windows (Windows 95, 98, ME, NT, 2000, 2003, XP), Apple Macintosh, Novell, Linux, Unix operating system and FAT, NTFS,NTFS5,HFS, HFS+, NWFS, EXT2 and EXT3 file systems.

Data Recovery Services
Offers data recovery, data recovery services from crashed hard drives, laptops and damaged Mac drive. Stellar provides data recovery in New Jersey, data recovery services in USA, ASIA & European Countries.

File Recovery
Stellar offers you hard drive disk & file recovery and protection software and data file eraser utility for complete protection of your data.

Partition Recovery
Windows data recovery software, an easy to use NTFS & FAT partition recovery Utility that examines inaccessible hard drives for damages and corruptions and recovers the data back.

Hard Drive Recovery
Try our data recovery software. Available are Data recovery software download for windows 95,98,Me,Novell,Unix,Linux,windows NT,XP,2000 which give you easy recovery decision of try before you buy.

Atlassian offering licenses to Confluence and Jira for $5

2009-04-20T22:29:00.000-07:00

Atlassian has made a name for itself with its java based opensource development tools. Confluence (an Intranet Wiki tool) and Jira (a bug tracker) are two of the companies Flagship products. Calling this their "Atlassian Stimulus Project", they are offering 5 user licenses for $5 each, and donating the proceeds to "Room to Read".

I have used both Confluence and Jira as well as Fisheye, and they are all excellent products, that don't quite have competitors in the LAMP world. Any small development company will find Jira a great bug tracker, capable of complex workflows. Confluence is a Wiki on steriods, that can be used in a variety of ways as an interanet tool, and for design, and internal and external documentation. Both products are modular and there are a substantial number of plugins that increase their functionality. I'd urge any small company to take a look at this offer, which is only good for the next 5 days.

Visit http://www.atlassian.com/starter/ for the details.

Share Technology Documents - Upload and download technology documents online. Share technology documents and reports with friends at latestt.com

Microsoft Q&A: Running PHP on Windows Server 2008

2009-04-09T18:14:00.000-07:00

Microsoft has been recently engaging in a number of open source projects. They have been working on enhancing performance, security and stability of PHP applications on Windows Server platforms.

In relation to that we would, in cooperation with Microsoft, invite you to trial a Windows based web stack consisting of IIS 7, PHP 5 and SQL Server. Via the PHP on WS 2008 website you will be able to request a 30-day trial with a Microsoft hosting partner, and you'll be able to request a downloadable trial for installation on your own computer. You will be able to find more information on that page as well. Alternatively, if you have Windows Vista you can install IIS 7 and test its FastCGI capabilities.

We have setup a dedicated board, PHP on Windows Server 2008 - Microsoft Q&A, where you will be able to post your feedback and discuss it in general. Commencing April 20th, Hank Janssen and his team from the Microsoft Open Source Center will be available to respond on the feedback, and answer whatever questions that may arise.

We hope you will take part in this Q&A to enhance PHP, and specifically to enhance it on the Windows platform.

Do feel free to ask in the board if you have any questions.

PHP Web Development services at Script2please.com

SEO Web Design - Web Rankings - UK based White Label SEO Web Design Agency. Search Engine Optimisation, Search Engine Marketing, Web Design, PPC, Conversion Specialists.

Web Design Agency - Web Design, Web Development & Web Marketing Agency based in Surrey

Media Buying - Media planning & buying, including digital from Space & Time Media.

SEO - Learn how search engine marketing, PPC management, conversion enhancement and web analytics tracking can boost your online profitability. Visit our website and harness the web with Alkemi

Solve your site rendering problem with Google Chrome

2009-03-26T21:27:00.000-07:00

By Glenn Wilson, Product Manager, Google Chrome
http://googlewebmastercentral.blogspot.com/2009/03/helping-your-site-look-great-with.html

Since launching Google Chrome last September, we received a number of questions from webmasters and web developers about how to make their sites look great in Google Chrome. The questions were very insightful and illuminating for the Chrome team, and I want to respond with a few helpful tips for making your site look stellar in Google Chrome.

Detecting Google Chrome

Most sites will render the same in both Safari and Google Chrome, because they're both WebKit-based browsers. If your site looks right in Safari, then it should look right in Google Chrome, too.

Since Chrome is relatively new, many sites have confused Google Chrome with another browser. If your site doesn't look quite right in Chrome but works fine in Safari, it's possible your site may just not recognize Chrome's user-agent string.

As platforms and browsers adopt WebKit as their rendering engine, your site can detect and support them automatically with the right JavaScript checks. Commonly, sites use JavaScript to 'sniff' the navigator.userAgent property for "Chrome" or "Safari", but you should use proper object detection if possible. In fact, Gmail has been detecting WebKit properly in Chrome since day one!

If you must detect the user-agent type, you can use this simple JavaScript to detect WebKit:

var isWebkit =
navigator.userAgent.indexOf("AppleWebKit") > -1;

Or, if you want to check that the version of WebKit is at least a certain version—say, if you want to use a spiffy new WebKit feature:

var webkitVersion =
parseFloat(navigator.userAgent.split("AppleWebKit/")[1]) ||
undefined;
if (webkitVersion && webkitVersion > 500 ) {
// use spiffy WebKit feature here
}

For reference, here are a few browser releases and the version of WebKit they shipped:

Browser Version of WebKit
Chrome 1.0 525.19
Chrome 2.0 beta 530.1
Safari 3.1 525.19
Safari 3.2 525.26.2
Safari 4.0 beta 528.16

You can find more information about detecting WebKit at webkit.org.

Other helpful tips
Google Chrome doesn't support ActiveX plug-ins, but does support NPAPI plug-ins. This means you can show plug-in content like Flash and Java in Google Chrome the same way you do with Firefox and Safari.
If text on your site looks a bit off, make sure you provide the proper content type and character encoding information in the HTTP response headers, or at the beginning of your pages, preferably near the top of the section.
Don't put block elements inside inline elements.
Wrong:

This will look wrong.

Right:

This will look right!

If your JavaScript isn't working in Google Chrome, you can debug using Chrome's built-in JavaScript debugger, under the "page" menu -> 'Developer' -> 'Debug JavaScript' menu option.
To help webmasters and web developers find more answers, we created a support center and forum specifically to answer your questions. Of course, if you find something you think is really a bug in Chrome, please report it to us!

Help us improve Google Chrome!

If you'd like to help even more, we're looking for sites that may be interested in allowing Google to use their site as a benchmark for our internal compatibility and performance measurements. If you're interested in having Google Chrome development optimized against a cached version of your site, please contact us about details at chrome-webmasters@google.com.

Please keep the feedback coming, and we'll keep working to improve Google Chrome!

Develop new gadgets with support from Google.

2009-03-23T00:21:00.000-07:00

http://www.google.com/gadgetventures/

Try your hand on Google pilot program dedicated to helping developers create richer, more useful gadgets. Inspired by the success of iGoogle, which has been driven by the creation by 3rd-party developers of a broad range of gadgets, Gadget Ventures provides two types of funding:

Grants of $5,000 to those who’ve built gadgets we’d like to see developed further. You’re eligible to apply for a grant if you’ve developed a gadget that’s in our gadgets directory and gets at least 250,000 weekly page views. To apply, you must submit a one-page proposal detailing how you’d use the grant to improve your gadget.
Seed investments of $100,000 to developers who’d like to build a business around the gadgets platform. Only Google Gadget Venture grant recipients are eligible for this type of funding. Submitting a business plan detailing how you plan to build a viable business around the gadgets platform is a required part of the seed investment application process.

Chrome Experiments - The Power of JavaScript!

2009-03-20T23:34:00.000-07:00

http://tnerd.com/2009/03/20/5-best-chrome-experiments-the-power-of-javascript/

Google has always been a step ahead when it comes to creating a buzz for its products and attracting great talent to build upon its tools.

ChromeExperiments.com is one such example. Applications showcased on this site are mostly built on JavaScript technologies and are a showcase of out-of-the-box thinking and creativity. These Applications/Experiments might not be put to use as it is, however, they serve their purpose of demonstrating the power of JavaScript and the Browser.

Following are the top 5 experiments from the bunch.. (I recommend viewing these experiments in Google Chrome. Click here to download Chrome if you don’t have it installed already)

BallDroppings: It’s a musical app which looks like pong. The balls are dropped one after the other, users can draw lines/bars to keep the balls from going off the screen. The balls bounce off the bar drawn on the screen creating a sound every time a ball hits the bar.

Click here to launch the experiment or watch the video below to see it in action.

Browser Ball: This is another fun application which shows the power of JavaScript and how well Chrome handles it.

All you have to do is Open windows and throw the ball through them. Not only that but you can also add new windows on the fly.

Click here to launch the app or watch the following video to see it in action

Ball Pool: Ball Pool works on the laws of physics. Shake the browser, move or throw the balls around and see how the browser and see how the onscreen objects react to it.

From the Author: Start by shaking the browser, then create new balls (click on empty space), move some others (drag) and reset the screen (double click).

It’s like the old days once again!

Click here to launch the experiment or watch the following video to see the app in action

Boombox: This application lets you control the volume of the sound by resizing the channel window.

For demo purpose the application plays a song online, however, it would be great if it can be integrated with any of the music services online.

Click here to launch the application or watch the video below to see the app in action

Monster: This application demonstrates how JavaScript is used instead of Flash to create 3D objects and animation in the browser.

Click here to launch the animation or watch the video below to see it in action.

Abhishek Rungta interviewed at SES London 2009

2009-03-03T05:12:00.000-08:00

Show You’re a Professional with Isilon Certification

2009-03-02T05:12:00.000-08:00

In the IT industry you can show you’re a professional with Isilion and the Isilion certification. With the Isilion certifications training and the Isilion practice exams, you cannot go wrong in any way. You will be able to pass your exams with flying colors.
Everything that you need will be made available to you including Isilion training tools, Isilion exams preparation and the Isilion study guide prepared by certified exams expert. With all of this and so much more, you will not fail in the task you have set for yourself.
After all of the effort that you have put forth, studying day in and day out, the Isilion exams will be a walk in the park by the time that you are done. There are professional instructors and teachers that are at your disposal to help you every step of the way.

Move On With Your Career
They want to make sure that you get your certifications with Isilion and move forward in the career and field of your choice. By getting your certifications, you are showing the IT world that you are ready to undertake one of the most challenging careers in today’s market place.
Employers will see you as someone that is taking their career seriously and will not let anything stand in their way of getting what they want. You will have the opportunity to shine above all others when you can show a potential employer that you are certified.

Use the Guidelines

By following the study guide for Isilion that is made available to you by you are getting all of the information that you could possible need to help you succeed. Although they cannot take the test for you, with all of the support that you will receive you will feel as though they are actually there helping you with every question that you have to answer for the Isilion exam or other exams preparation study guides , tutorial, practice tests, 200-045 practice exam.
So, what are you waiting for? There is no time like the present to jump on board with Isilion and start studying for your future. This is a choice and a decision that you will never regret working with Isilion. Secure your future and get your certifications with exams experts today and Isilion so you will never look back again.

Zend Framework 1.7.5 released - contains important security fix

2009-02-18T23:45:00.000-08:00

Zend Framework 1.7.5 has been released, and as always you can download the latest copy of Zend Framework for free from:

http://framework.zend.com/download/latest/

Besides the normal small enhancements and bug fixes that come with an incremental release such as this, there is also a rather important (and somewhat controversial) security fix that was added. This security fix breaks backwards compatibility with the previous version, because it simply must in order to exist. There is however a way to turn the security fix off to keep your current applications working in the case that this change breaks you.

5 Popular CSS Frameworks + Tutorials & Tools for Getting Started

2009-02-02T06:13:00.000-08:00

CSS frameworks have grown in popularity recently, enabling developers to rapidly prototype designs. The idea of CSS Frameworks is to do all the heavy lifting of the repetitive tasks you do over and over again on each site, allowing you to get faster results and get to the fun stuff designers love.

Main features of good CSS Framework is to 1) rapidly speed up our development time, 2) should have a very small size, 3) have good documentation and tutorials and 4) have clean grid structure. You will need a basic understanding of the CSS framework you are going to use to understand why and how things get solved.

In today’s post we present an overview of the 5 most popular CSS Frameworks; showcasing handpicked tutorials for using each of them among other useful tools and resources you will definitely find useful and time-saving.

1. 960 CSS Framework

The 960 Grid System is an effort to streamline web development workflow by providing commonly used dimensions, based on a width of 960 pixels. There are two variants: 12 and 16 columns, which can be used separately or in tandem. The 960.css file itself is only 3.6 KB compressed.

Demo can be found here

Tutorials Explaining how to use 960 CSS Framework

A Detailed Look at the 960 CSS Framework

“Jeffrey Way” takes a close look at the 960 CSS Framework, explaing the pros and cons of using it. He also takes us step by by step and create a simple “12 column” layout with a simple header and two column structure. Most important tip here is : you must assign a class to each div. Naming conventions require that that the class name begins with “grid_” and ends with the number of columns needed.
960 CSS Framework - Learn the Basics

Stefan Vervoort takes the heavy work for you and explains the basics of this framework so you can start developing with 960 pretty fast. Basics principles explained here include: not to edit 960.css, Loading the grid, Containers, Grids / Columns, Margins and styling. Another post by Stefan where he solves some of the problem he faced while working with this framework.
Fluid 960 Grid System

The Fluid 960 Grid System templates have been built upon the work of Nathan Smith and his 960 Grid System using effects from the Mootools JavaScript library.

2. Blueprint CSS Framework

Blueprint is a CSS framework, which aims to cut down on your CSS development time. It gives you a solid CSS foundation to build your project on top of, with an easy-to-use grid, sensible typography, nice-looking forms and even a stylesheet for printing. One of its main feature is performing a mass reset of browser default styles, offering a methodology to use for customizable layout grids and most important is that all elements are override-able.

There are several Blueprint plugins available which can overwrite aspects of the framework or add new styles for you to use.

Check out the Live Demos

Tutorials Explaining how to use Blueprint CSS Framework and tools using it

BlueprintCSS 101

Jeff Croft explains Blueprint’s core feature, how we use it, how it has impacted our workflow, and what we like about it.
A Closer Look At the Blueprint CSS Framework

In this tutorial we will get a look at the inner workings of Blueprint and we’ll take a look at demo application that uses Blueprint to get a better idea of how to actually use the framework.
Blueprint CSS Cheat Sheet
Blueprint Grid CSS Generator

This tool will help you generate more flexible versions of Blueprint’s grid.css and compressed.css and grid.png image file for use as a background image during development- very handy for making sure everything lines up properly. Whether you prefer 8, 10,16 or 24 columns in your design, this generator now enables you that flexibility with Blueprint.
PXtoEM

PXtoEM.com is a website that makes converting PX values to EM values easier. The CSS file of the values you’ve choosen can be get based on the typography.css portion of Blueprint CSS to setup a default typography.
Construct

Construct, a visual layout editor based on Blueprint & jQuery, Construct, a useful tool for CSS designers and as proof that a visual layout editor is possible to acheive with clean CSS & semantic HTML.

3. The jQuery UI CSS Framework

jQuery UI includes a robust CSS Framework designed for building custom jQuery widgets. The framework includes classes that cover a wide array of common user interface needs, and can be manipulated using jQuery UI ThemeRoller. By building your UI components using the jQuery UI CSS Framework, you will be adopting shared markup conventions and allowing for ease of code integration across the plugin community at large.

Styling Buttons and Toolbars with the jQuery UI

A real-world examples of themeable buttons and toolbars using the jQuery UI CSS framework, a system of classes developed for jQuery UI widgets that can easily be applied to any plugin, and even static content. Here are button examples that demonstrate how to incorporate the power of the CSS framework classes in a custom widget.

Check out the Live Demos here

4. YAML

Yaml (Yet Another Multicolumn Layout) focused on flexible layouts and offers column and grid based design elements for flexible, elastic or fixed layouts. You will need a license to use it.

YAML comes with a a very nice Ajax builder, a handy tool for visual development of YAML-based CSS layouts which allows you to put the containers of the layout visually together via drag-n-drop. The valid HTML- and CSS-code is generated automatically on the fly.

Check out the Live Demos here

Flexible Layouts with YAML

Dirk Jesse, the developer of YAML (Yet Another Multicolumn Layout), an (X)HTML&CSS framework which explains his motivation for YAML in the last paragraph of the article, providing an overview of what is possible with YAML and may deliver some ideas for your future layouts.

5. Yahoo YUI Grids CSS

The foundational YUI Grids CSS offers four preset page widths, six preset templates, and the ability to stack and nest subdivided regions of two, three, or four columns. The 4kb file provides over 1000 page layout combinations. Features include: Self-clearing footer, customization of width for fixed-width layouts, Supports fluid-width (100%) layouts and more.

The YUI Grids Builder — a simple interface for Grids customization.

Don’t forget to check the CSS Reset/Base/Fonts/Grids Cheat Sheet

Dynamic Image Generation

2009-01-29T03:25:00.000-08:00

Long and boring back-story....

One of the standard features of a message board is allowing members to have a signature, which is appended to the bottom of each post they make. Posters can put whatever they want into the signature (within forum settings). Putting quotes in one's signature is one of the more popular things to do.

A lot of people put in some motto they live by, some funny quote by some famous person, whatever. Some people like to quote things other posters on the board have said. I am one of those people. I think it's fun and promotes a sense of belonging to the community.

I've been a member of the phpfreaks forum for a number of years now, and over the years, I have posted and come across quotes that were (to me, anyways) worth collecting. But having a bunch of quotes in a sig isn't very convenient.

Click Here to Read Full Article from www.phpfreaks.com

MySQL University

2009-01-27T23:29:00.000-08:00

MySQL University is a series of free web seminars. Each week (on Thursdays) you have a unique opportunity to learn something interesting from MySQL developers and professionals.

MySQL University sessions cover wide range of topics including server administration, extending MySQL functionality, or just tips for better performance of your queries.

The sessions are conducted using DimDim, a web based conference tool build in Flash. It works really good even if your connection is not the fastest one.
During the session, the presenter will show slides and talk about the topic (so it's pretty important that you can understand spoken English), and you and other participants can ask questions using built in chat.
I strongly recommend you to take part in 'live' sessions as it is pretty unique experience, but if for some reason you can't, then there is archive of past sessions, often with flash recording, available at MySQL University's home page.
On the same page you will also find more detailed information on participation, as well as a schedule of upcoming sessions with abstracts and presentation slides, to help you decide if particular subject will be interesting to you or not.

There's also a Google Calendar with MySQL University Schedule available, to which you can subscribe.

From now on, I will (if time permits) post here on PHPfreaks about upcoming sessions that might be interesting for an 'average' PHP developer.

The one that takes place next Thursday is titled 'Scalability Challenges in an InnoDB-based Replication Environment' and seems to be directed more to server administrators. If however, you run your website on a VPS or a dedicated server, you might as well take a look at it.

Have fun!

Where can I learn about PHP and MySQL ?

2009-01-22T05:24:00.000-08:00

The official PHP site is http://www.php.net and the online documentation is found at http://www.php.net/manual

If you would rather follow a tutorial, then check out http://www.devshed.com (this covers PHP and others) or http://www.phpbuilder.com or just do a search on google for PHP Tutorials.

Especially look into how PHP integrates with MySQL so you can program database powered websites. If you are the type of person who likes to dive in the deepend, try downloading some basic scripts from http://www.hotscripts.com and/or http://php.resourceindex.com and start ripping apart the code to see what's being done.

The official MySQL site , is www.mysql.org, also look into a great mysql tutorial at

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

lastly below is a link to a dozen php and mysql tutorials frm webreference.com http://www.webreference.com/programming/php/

php mysql training cources at Kolkata, India

PHP 5.3 on Windows

2009-01-22T04:36:00.000-08:00

Congratulations to the PHP community on its PHP 5.3 alpha 2 release in December. In roughly one month, there have been over 80,000 downloads of the alpha 2 release from unique IP addresses.

You can see that interest in PHP on Windows is growing significantly when you compare this to the 40,000 or so Windows downloads of PHP 5.2 alpha and beta combined over nearly five months.

One of the critical accomplishments in 5.3 has been updating the code base so that the core engine can be built under the latest version of Visual C (VC9). This update has enabled members of the community to focus on optimizing the PHP core to run on Windows. Already, with alpha 2, the release is proving itself to be a stable, robust implementation.

The community anticipates hitting general availability for 5.3 in the spring. Interest in that release is already running high and should continue to grow in the coming weeks.

Source: http://port25.technet.com/archive/2009/01/16/php-5-3-on-windows-update.aspx

PHP Cheat Sheet

2009-01-16T06:35:00.000-08:00

The PHP cheat sheet is a one-page reference sheet, listing date format arguments, regular expression syntax and common functions.

You may down load the orginal image from the below links
http://www.addedbytes.com/download/php-cheat-sheet-v1/png/
http://www.addedbytes.com/download/php-cheat-sheet-v2/png/

Find some other interesting and helpful Cheat sheets
http://feeds.feedburner.com/CheatSheets-ILoveJackDanielscom

Maloy Bookmarks

Standardizing Variables to Code Faster

2009-01-05T22:25:00.000-08:00

If you’ve been coding for a while you probably have some set ways in which you work. I recommend you also widen this method to naming variables, which when done consistently can be a huge help, especially when you are using some fancy MySQL along with your PHP code. If you are building a site with 15 MySQL tables it is helpful if you know all the column names because you always name them in the same way, but the same thing goes for simple variables, and even ids and classes for HTML elements.

A very common example can be variables which hold a user’s data. In my case I always use the variable ‘$u’ for holding the username, and the variable ‘$p’ for holding the password. If you are grabbing a lot of data, like first name, last name, email and so on you can make up your own standard set, I use ‘$fn’, ‘$ln’ and ‘$e’ respectively for the three.

Since you usually use these variables in the same script the importance of naming them consistently may not seem like a huge time saver. However when you get into session variables it saves you a lot of time if you don’t always have to look at where you are defining them to find out the names of each. I pull user data using a mysql query when a user logs in and I immediately place the whole array in a session variable name “$_SESSION['user']“. The names of the columns represent the values of this array, so the username and email would respectively become “$_SESSION['user']['Username']“, “$_SESSION['user']['Email']“. This is the same in my case for every single website I build where applicable.

User data naming consistency is also very prominent in the MySQL tables themselves. As you can see above my columns are also named the same in each case, a user’s email is always “Email”, his last name is always “LastName”. I steer clear of abbreviations with MySQL tables so other coders can easily see what’s going on as well. Consistency doesn’t just apply to the actual names, you can also apply it to cases. As you can see all my column names are always capitalized, they are like wikiwords, but user session variables which don’t come from MySQL are not capitalized. For example, when a user logs in he is assigned a time, which is usually one hour. If he/she is inactive for more than this time (no refreshes), he/she is logged out. There is no need to store this in the database, and so I know that this is not in there the session variable here is “$_SESSION['user']['time']“. This means that if I come back to work on a site a year after completion I know exactly where variables come from.

Even if you don’t yet know any PHP, you’re just getting into HTML and CSS you can still use these good practices. When assigning ids and classes to elements try and work out a structure for yourself that you always use. I use empty div tags to clear floats a lot, so I have a separate class named “cl” for this purpose. Whenever I start out a new webpage I include this class by default in the stylesheet since I know I will most likely need it.

That’s about it for standardizing your coding work, most of it is just common sense really. Try and work out your own method which works best for you. It takes time and a lot of practice to get a system working well since there is so much to think of, but if you always keep this in mind somewhere while coding you’ll be a faster and better coder in no time at all!

Script2please.com is one of the leading offshore outsourcing companies in India, We Offer Rich php web development services, and custom web development

Source: http://www.ghacks.net/2009/01/02/web-development-standardizing-variables-to-code-faster/

PHP 5.2.7 Released

2008-12-05T00:44:00.000-08:00

Security Enhancements and Fixes in PHP 5.2.7:

Upgraded PCRE to version 7.8 (Fixes CVE-2008-2371)
Fixed missing initialization of BG(page_uid) and BG(page_gid), reported by Maksymilian Arciemowicz.
Fixed a crash inside gd with invalid fonts (Fixes CVE-2008-3658).
Fixed a possible overflow inside memnstr (Fixes CVE-2008-3659).
Fixed incorrect php_value order for Apache configuration, reported by Maksymilian Arciemowicz.
Fixed safe_mode related security issues detailed in CVE-2008-2665 and CVE-2008-2666.
Crash with URI/file..php (filename contains 2 dots) (Fixes CVE-2008-3660)
IMAP toolkit crash: rfc822.c legacy routine buffer overflow. (Fixes CVE-2008-2829)

Some of the key enhancements in PHP 5.2.7 include:

Fixed several memory leaks inside the readline and sqlite extensions
A number of corrections relating to date parsing inside the date extension
Fixed bugs relating to data retrieval in the PDO extension
A series of crashes in various areas of code were resolved
Several corrections were made to the strip_tags() function interms of <>
A number of bugs were fixed in extract() function when
EXTR_REFS flag is being used
Added the ability to log PHP errors to the SAPI (Ex. Apachelog) logging facility
Over 170 bug fixes.

For users upgrading from PHP 5.0 and PHP 5.1, an upgrade guide is available here http://www.php.net/migration52), detailing the changes between those releases and PHP 5.2.7. For a full list of changes in PHP 5.2.7, see the ChangeLog (http://www.php.net/ChangeLog-5.php#5.2.7).

PHP Web Development - PHP mysql web development services, php solutions, custom development of Internet applications using PHP for high performance and enterprise ready web application.

3 best ways to Optimize your wordpress theme

2008-11-25T21:45:00.001-08:00

One of most powerful and advance feature of wordpress is it themes. There are thousands of FREE and paid themes available for wordpress. It is not harder to create a new theme for wordpress even if you have only a little knowledge of php web development or html. Wordpress themes are what display everything on your blog, including pages, posts, categories, archives and your front page.You can create your own theme or you can use the Yvo Schaap’s online theme designer to create wide range of colorful and beautiful themes easily.Every wordpress theme uses many different functions, loops to load content on your blog. Wordpress’s core system itself calls many queries before loading your theme files. With few of following tweaks, you can easily optimize your wordpress themes to reduce server load and to provide faster output.

1. Define variables instead of calling functions each time
There could be many functions being used in themes. You can define variables in your header file to avoid calling those functions again and again and just use the pre-define variable by a single function call. For example, you may be using bloginfo, the_permalink, get_option etc. Define their variables and avoid using them again and again for same purpose.

2. Avoid loading unnecessary javascript, css
At some of your pages you may need additional javascript or css files to be loaded.

3.Use WP super cache is one of best plugins for me.
It generate static content for your blog. Even the function calls. It can generate static front page, single posts, category pages in form of html. So until the cache time is over, those html files will be loaded to user’s browser and generate only a tiny bit of load to your server.

Submit Your Design News

2008-11-12T02:53:00.000-08:00

if you have facts related to design and want to spread, convey the message to large number of online visitors then these are the resources which will take you a step ahead to be published. just register and submit your news their.

http://www.designfloat.com/submit
http://designbump.com/submit
http://graphic-design-links.com/submit.php
http://devmarks.com/
http://www.wscoop.com/
http://www.dzone.com/
http://designm.ag/
http://design-related.com/
http://www.fuelyourcreativity.com/
http://cssglobe.com/
http://sharebrain.info/
http://www.youthedesigner.com/
http://help-developer.com/index.php/2008/07/community-links/
http://abduzeedo.com/user_news/
http://scriptandstyle.com/submit
http://kailoon.com/
http://www.crazyleafdesign.com/blog/submit-news/
http://www.stylegala.com/
http://www.noupe.com/
http://psdtuts.com/userlinks/user-link-feed/
http://vectortuts.com/features/user-link-feed/#add
http://nettuts.com/userlinks/user-link-feed/
http://csscreme.com/submit_news/
http://psdlearning.com/2008/07/user-links/
http://www.brushking.eu/submit_news.php
http://www.cssleak.com/submit_news.php
http://www.myinkblog.com/2008/07/06/user-link-feed-my-ink-blog/
http://www.knowtebook.com/community-link-feed-1112.htm
http://www.cssdrive.com/index.php/main/submit/
http://www.visual-blast.com/
http://www.smashingapps.com/news/linkslist.php?TB_iframe=true&height=300&width=450
http://freelancefolder.com/submit-link/
http://www.QBN.com
http://www.naldzgraphics.com:
http://styl.eti.me/
http://vot.eti.me/
http://www.psdtop.com/

Why Shopping Cart Software?

2008-11-12T02:35:00.000-08:00

Don't let the name fool you, shopping cart software is a lot more than just a cart. Good shopping cart software can help your Internet business in other capacities as well, including:

Payment Processing – Many programs offer credit card processing as well as check, COD or other methods of possessing payments.
Webpage Design – Many merchants are not web designers, so some programs will include wizards to help you build your webpage without requiring you to know HTML.
Storefront Design – Store front wizards incorporate templates or other tools to help you set up your storefront.
Inventory Control – Good programs will keep track of your inventory and generate reports.
Shipping – Nearly all software offer a shipping tool that calculates shipping costs for customers based on parameters that you set, some can even link up to common shipping methods like FedEx.
Tax Calculation – Most shopping cart programs can calculate taxes, a valuable tool, especially since many states are considering requiring that merchants collect taxes for online sales.
Customer Management – Many shopping carts programs have features that will let customers view their previous purchases. The program will also recognize the customer when they come back for a return visit.
Marketing – A shopping cart is useless if you don't sell anything. Marketing help can be invaluable, some programs offer information on affiliate programs and help with merchandising. Many are able to create coupons, gift certificates or other incentives. In addition, they provide sales reports and 'hit' or traffic information as well.
Security – Customers will not want to purchase online if they feel the website cannot protect their personal information. Many shopping cart programs will offer protection by encrypting information, processing credit cards through reputable processing services and by allowing customers to move through their program without having to download cookies.
On this site, you'll find articles on shopping cart software and services and reviews so you can decide which software will best fit your business plans. At TopTenREVIEWS - We do the research so you don't have to.™

What to Look for in Shopping Cart Software

Choosing the right shopping cart is one of the most crucial steps to making your online business a success. Your customers need to be able to purchase your product(s) as easily as possible, with a sense of security. For the business owner, the software should be simple to use, with lots of useful features and great customer support when needed.

We reviewed 22 of the leading shopping carts programs to help you find the program that will improve your chances of reaching your sales goals.

Below are the criteria TopTenREVIEWS used to rate shopping cart software:

Feature Set – The features range from a simple shopping cart to accounting and inventory functions. The programs that offered the most features and in turn, the most flexibility received high scores in this area. The most important goal is to find the program that includes desired features at a desirable cost.
Ease of Use – Good programs are easy for the entrepreneur and the customer to use. Wizards are helpful in webpage and storefront development, menus and help should be easily assessable and presented in a logical manner.
Ease of Setup – The software should install quickly and without errors. If it is a program that is accessed online, it should be easy to get to and use.
Help/Documentation – Excellent customer and technical support is paramount. The program should offer inner program support in help menus, user manuals, FAQs pages or other methods. The manufacture should offer support through telephone, email, mail or chat. The help should be useful and prompt.

Once your have your DBA ("Doing Business As") established, a bank account open, market desirable products and the perfect shopping cart software, you may be well on your way to a successful Internet business. If you're already in business, but are not happy with your shopping cart program or have out grown it, look into a new program that will help you manage all of your concerns more efficiently.

Top E-commerce Software

www.shopsite.com/
www.merchandizer.com/
ecommerce.networksolutions.com/
www.storefront.net
www.mercantec.com/
www.freemerchantcredit.com/
www.goemerchant.com
www.mivamerchant.com/
www.1shoppingcart.com
www.x-cart.com
www.vpasp.com/
www.actinic.co.uk/
www.justaddcommerce.net/
www.cubecart.com/
www.webmastercart.com
www.webgenie.com
www.salescart.net/
www.easycart.net/
www.americart.com

PHP web development, E-Commerce Solutions

10 Promising Content Management Systems

2008-11-06T01:28:00.000-08:00

When it comes to content management systems (CMS) and publishing platforms, there are plenty to choose from. They vary in technologies used, organization structure, performance, and license. You’ve probably heard of popular content management systems such as Drupal, WordPress, Movable Type, Joomla!, and Textpattern, but if you want to try a platform that’s a little less main stream – check out these excellent alternatives.

In this article, you’ll find 10 terrific content management systems that may not garner as much attention as their more popular counterparts - but should.

There’s a large amount of content management systems out there, so if your favorite isn’t on here, share it with us in the comments.

ExpressionEngine

Go to ExpressionEngine demo

ExpressionEngine is a powerful and easy-to-use content management system. ExpressionEngine is known for its flexibility and intuitive Template Engine that lets developers easily mold the CMS into its intended use. It has a built-in caching feature that significantly reduces server load (helpful in times of high traffic). Check out the Showcase section on EE’s website to see live sites that use ExpressionEngine.

Concrete5

Go to Concrete5 demo

Concrete5 is a solid content management system that’s a breeze to use. You can edit a web page live by entering "edit mode", which makes the regions and elements on the web page you are viewing editable. It has a very robust administration panel with a built-in system for gathering statistics so you don’t need to install a plugin/extension or use a third party application like Google Analytics to monitor your site traffic.

Radiant CMS

Go to Radiant CMS demo

Radiant CMS focuses itself for use in small teams. It’s designed as a simple and elegant CMS akin to 37 Signals applications, holding out on complicated and unnecessary features to provide users a straightforward interface for creating and editing website content.

CushyCMS

CushyCMS is a "plug-and-play" content management system that doesn’t require you to install anything to get it working, which can greatly reduce your maintenance cost and development time. With CushyCMS, you define which areas are editable, making it a safe option to your not-very-tech-savvy clients. CushyCMS is currently being used by about 10,000 websites and is gaining popularity as a no-hassle, user-friendly CMS.

Symphony

Go to Symphony demo

Symphony, created by Overture, is a CMS designed for developers, utilizing XSLT to provide developers flexibility in customizing Symphony. If you don’t know much about XSLT, Overture provides a large number of tutorials and screencasts on their resource center. With that said, Symphony isn’t for everybody and those looking for a content management system that requires little technical expertise should probably consider another option.

MODx

MODx is both a content management system and a PHP web application framework. MODx puts a high emphasize on web standards, allowing you to build XHTML 1.1 strict compliant websites easily. It comes with a build-in CSS menu builder for hassle-free site navigation development. For less-experienced users, MODx comes with a graphical user interface installer so you can get up and running quickly.

Plone CMS

Plone CMS is a feature-packed content management system built on the Zope web application framework. It’s supported by a large and active developer community so you won’t have any trouble finding help. Plone has extensive documentation in a wiki format to help you get started and help you take advantage of its more advanced features.

Railfrog

Railfrog is one of the few CMS’s built on top of the Ruby On Rails web application framework (the same technology powering popular web applications such as Twitter and Basecamp). To help you get started on Railfrog, check out its Developer Portal where you’ll find guides that you can follow to get rolling.

TYPO3 CMS

TYPO3 is an open-source, enterprise-level content management system focused on providing companies a solution for websites and their intranet. While many CMS’s try to be simple and basic, TYPO3 provides users complex and powerful features to help you achieve complicated tasks and ability to integrate with other applications.

SilverStripe

Go to SilverStripe demo

SilverStripe is a PHP-based, open-source content management system. It uses the MVC coding framework to offer developers great flexibility and potential for scalability. Check out the live demo on their site to see a basic installation of SilverStripe as well as to take a peak at how the administration system looks like.

Content Management System Resources

The CMS Matrix - A Tool for comparing Content Management Systems.
CMS Watch - A news portal for Content Management Systems.
CMS Toolbox: 80+ Open Source Content Management Systems
CMS Report - A website that reports on Content Management Sytems.
How to Build a Maintainable Site using CushyCMS and Twitter