Home » SQL / MySQL Tips and Tutorials

Programming Tips & Insights

All things considered about programming and development, though mostly for the web, like how to do stuff, problem troubleshooting, performance tips, structure optimization & trade-offs and design issues.


MySQL: Export Table to CSV Text Files for Excel

by Yang Yang on November 18, 2010

MySQL log files are taking a lot of disk space – How to disable and delete them?

by Yang Yang on October 25, 2010

MySQL: Change Default Character Set or Default Collation in phpMyAdmin

by Yang Yang on October 16, 2010

PHP: Get Human Readable Time from Seconds

by Yang Yang on September 29, 2010

Regular Expression for Date and Time Strings

by Yang Yang on September 29, 2010

Regular Expressions for Natural Numbers or Positive Integers (1, 2, 3, …), Negative Integers and Non-negative Integers

by Yang Yang on September 29, 2010

PHP: True empty() function to check if a string is empty or zero in length

by Yang Yang on September 29, 2010

PHP: Checking Text Strings against Reserved or Censored Words

by Yang Yang on September 27, 2010

How to create / generate .htpasswd password with PHP dynamically?

by Yang Yang on September 18, 2010

Check how much memory your PHP script is using. (PHP script memory usage)

by Yang Yang on September 18, 2010

How to get all the sub-directories of a given directory in PHP?

by Yang Yang on August 1, 2010

How to check if a MySQL database connection is successful in PHP?

by Yang Yang on July 30, 2010

MySQL: Check if a table exists

by Yang Yang on July 30, 2010

How to include a JavaScript file inside a JavaScript file?

by Yang Yang on July 22, 2010

JavaScript: How to set focus to form elements?

by Yang Yang on July 22, 2010

← Previous Entries

Next Entries →

1234567891011121314Last »