-
Recent Posts
Blogroll
Categories
- Application Tips (2)
- CSS (6)
- Database (10)
- DHTML (2)
- DOS & DOS Scripting (2)
- Graphics (3)
- iPhone (1)
- JavaScript (3)
- Joomla! (11)
- Linux (2)
- MySQL (25)
- Networking (2)
- Operating Systems (5)
- PHP (24)
- Resources (2)
- Snippet (1)
- Uncategorized (38)
- Vista (2)
- Web Development (18)
- WordPress (12)
Tutorius Archives
- January 2012 (1)
- December 2011 (1)
- November 2011 (2)
- October 2011 (4)
- September 2011 (2)
- March 2011 (3)
- December 2010 (1)
- November 2010 (2)
- September 2010 (2)
- August 2010 (5)
- June 2010 (5)
- May 2010 (8)
- April 2010 (6)
- March 2010 (5)
- January 2010 (3)
- December 2009 (2)
- November 2009 (11)
- October 2009 (12)
- September 2009 (3)
- August 2009 (8)
- July 2009 (9)
- June 2009 (4)
- May 2009 (1)
- April 2009 (1)
- February 2009 (3)
- January 2009 (3)
- December 2008 (1)
- November 2008 (3)
- October 2008 (3)
- September 2008 (5)
- August 2008 (7)
- June 2008 (3)
- March 2008 (3)
- February 2008 (1)
- January 2008 (1)
- November 2007 (3)
MySQL Archive
-
Building a dynamic SELECT list with PHP and MySQL
Posted on March 23, 2010 | No CommentsA common scenario in web applications is the need to create a <SELECT> list using a set of values extracted from a lookup table in a database. This article will... -
Quick and Dirty: List records in a table using PHP and MySQL
Posted on October 23, 2009 | No CommentsThis code lists reads a dataset from the database and lists all attributes in a table. This code sample is deliberately quite basic, though CSS is used (through the $bgcolour... -
Selecting Field Names in MySQL
Posted on October 6, 2009 | No CommentsSelecting field names in MySQL is pretty easy, though it's not quite like the SELECT syntax we're all used to: SHOW COLUMNS FROM TABLE; To select all fields that start... -
Prevent SQL Injection attacks in PHP and MySQL
Posted on August 17, 2009 | No CommentsPlace this code in your database connect include, just before the database connection is made. This ensures that SQL injection attempts are handled before the database is opened. By doing... -
Resetting a MySQL Password
Posted on August 5, 2009 | No CommentsResetting a MySQL root password (or other password, for that matter) is easy enough if you have admin access to the server. First go to the command line (Start >...