Articles by Lucas Green

1) Converting a MySQL Injection Script for Use in Microsoft SQL Server
MySQL Server is the most widely used database management system in the world, primarily because it is open source and free. Hence, most databases you may get from outside sources will probably be in the form of a MySQL injection script. This is fine if you use MySQL for your own website databases, but if you use Microsoft SQL Server the script will require a little editing before it will work. The... » read more

2) How to Install a MySQL Database using a MySQL Injection Script
Whenever you purchase or acquire a MySQL database (such as from a website like WebContents.org), chances are it will come as a MySQL injection script. An injection script is simply a SQL script that, when executed, creates the appropriate database tables and inserts the data using INSERT statements (one statement per record of data). Because of this, a SQL injection script is usually very large, but this... » read more

3) Using a Catchall to Avoid and Filter Spam
I only have one e-mail account. That's right, one. In this day and age where it seems like everyone and his grandmother are webmasters, it's a little surprising for someone who runs websites to only have one mail account, isn't it? Truth to tell, I've had this same e-mail mailbox for the last several years, and in that time I've signed up for thousands of web services and countless one-off website... » read more

4) How to Create Web2.0 Applications using AJAX and Clientside HTTP Requests
Web2.0 is a term coined to refer to web applications that run without visible page refreshes. A normal website functions by delivering pages of information, with links that allow a user to move from page to page. A web 2.0 application, or AJAX application, runs on a single web page, and uses clientside javascript to initiate and process additional requests to the server. The additional requests run in... » read more

5) How to Hook Up a TV to a Computer as an Alternate Monitor
My computer right now is hooked up to my 53" TV across the room. It's a pretty cool trick, and if you have a computer and television in the same room you should see if you have a way to hook them up. Doing actual work is best on a real computer monitor (LCD preferred, but CRT acceptable), but watching videos, playing games, and surfing the web are pretty fun things to do from the couch. The resolution... » read more