PHP/MySQL - Shopping Cart video tutorial playlist

Click > to start, click video to watch video. Click ^ in menu bar to return main menu.

PHP E-Commerce website video tutorial playlist

Click > to start, click video to watch video. Click ^ in menu bar to return main menu.

Check system log in Windows 2003 Server

Click Start->Control Panel->Administrative tools -> Event Viewer
There are three logs:
Application, Security and System.
I checked system log and I found that I can not restart Apache2.2 due to following error message:
"The Apache2.2 service terminated with service-specific  error 1 (0x1)"
First check any syntax  error in httpd.conf using:
httpd -t
return "syntax OK".


According to 
http://www.itauthor.com/2007/05/15/if-apache-fails-to-start-after-a-reboot/
The problem may be due to IIS admin using port 443, or other applications using port 80, or httpd.conf pointed to the no-exsitin directory. Another article for reference:
http://netheadaches.wordpress.com/2007/10/08/apache-not-starting-win32-apache2-service-terminated-with-service-specific-error-1-0x1/

Could not open socket in PHP form

I have a user registration form. I test it in my local sever and it worked fine. But when I tested it in my remote server, the error message "Could not open socket" is shown after submitting the form.
After google, I found the following article quite helpful:
http://ezinearticles.com/?Could-Not-Open-Socket-reCAPTCHA-Error&id=5882695

The reason is due to  recaptcha. In recaptchalib.php
line 40 change
define("RECAPTCHA_VERIFY_SERVER", "www.google.com");
to
define("RECAPTCHA_VERIFY_SERVER", "74.125.227.48");

i.e changing www.google.com to 74.125.227.48 solved the problem.

Create a flash-based website using free flash template

I created a flash-based website based on  the nature template from   free flash templates:
http://www.jiansenlu.zoka.cc/flash_website/

There are a lot of free flash templates you can download from www.flashmo.com. You can modify these templates for your own design. But you may need flash CS3 or CS5.

You can also create a free flash website hosted on www.wix.com

WinMerge - file and folder differencing and merging tool for Windows

WinMerge is an Open Source differencing and merging tool for Windows.
You can download WinMerge from:
http://winmerge.org/downloads/

WinMerge can compare both folders and files, presenting differences in a visual text format that is easy to understand and handle.

More about WinMerge:
http://winmerge.org/about/

On a Mac, you can use the file comparison tool  TextWrangler.

lorem ipsum text generator

lorem ipsum text is fake Latin placeholder text and standard industry dummy text, which you can fill the tbd (to be determined) web content. Example:

Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit.. 

You can generate lorem ipsim text from:
http://www.lipsum.com/

Free Online MySQL designer

I created an Online MySQl designer:
http://www.jiansenlu.zoka.cc/sqldesigner/index.html

You can click add table at the right panel to start. The code is based on Google WWW SQL Designer.
http://code.google.com/p/wwwsqldesigner/
A good looking demo design can be found:
http://ondras.zarovi.cz/sql/demo/?keyword=default

This tool allows you to draw and create database schema (E-R diagrams) directly in browser, without the need for any external programs (flash). You only need JavaScript enabled.

WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.

Reference: A short list of our Favorite Data Modelling Tools:
http://www.databaseanswers.org/modelling_tools.htm

Alleycode - Free fast, Sleek and Highly Productive HTML Editor

Alleycode is a free HTML editor, you can download it from:
http://www.alleycode.com/download.htm

System Requirements
Windows 95/98/Me/NT4/2000/XP/X7

The feature of Alleycode:

Synchro View: synchronize code and design in real time. Covers all essential tags
HTML Toolbar: The main HTML Toolbar gives you quick functionality control such as Synchro View, Browser Preview, Directory (Assignments) View, FTP access, Search and Replace and Preferences while the tabbed toolbar covers Common HTML tags, Optimizer, Properties, Image insert, spans selection, Anchor dialog, Tables Wizard , Forms tags, CSS Wizard and PHP samples and statements.
CSS and PHP Wizard:  Intuitive Style Sheet Wizard allows you to create/update either internal or external style sheets (CSS1 - CSS2). Click'n'Insert HTML3.2, HTML4.1, CSS1-2 and PHP function library
Optimizer: Alleycode includes a very useful "Optimizer" wizard which will help you keep your meta content accurate and search engine friendly.

Solar system 3D model flash

There are a lot of features built-in, click and play!
http://www.solarsystemscope.com/scope.swf