Tutlist.com - Browse by Tag: mysql

If you are a regular at Reddit, you must have noticed the way people vote there. You can either vote up or vote down. Pretty interesting, huh? This tutorial will show you how to create such a voting system with jQuery, PHP and MySQL.

Submitted by: JohnGalt
Submitted on: May 5, 2009

The MySQL CLI is a great tool to test queries, but output containing many columns usually breaks onto new lines, rendering the results unreadable.

Submitted by: willemvzyl
Submitted on: Apr 11, 2009

Today, we're trying to recreate the effect from that website by creating a fancy apple.com-style search suggestion. Make sure you check out the demo (or visit Apple.com) to see this awesome effect work.

Submitted by: JDStraughan
Submitted on: Apr 6, 2009

Most new web developers have heard of SQL injection attacks, but not very many know that it is fairly easy to prevent an attacker from gaining access to your data by filtering out the vulnerabilities using MySQL extensions found in PHP. An SQL injection attack occurs when a hacker or cracker (a malicious hacker) attempts to dump the data in a database table in a database-driven web site. In an unprotected and vulnerable site, this is pretty easy to do.

Submitted by: JDStraughan
Submitted on: Mar 6, 2009

Apple's OS X 10.5.* (Leopard) comes with Apache2 and PHP5 preinstalled, but the PHP5 module is disabled by default. This tutorial demonstrates how to enable it and install MySQL, the MySQL Query Tools and phpMyAdmin.

Submitted by: willemvzyl
Submitted on: Feb 28, 2009

Backing up data is extremely important. Most of the time the database is the most important piece of the puzzle. Imagine losing all of the data in your database — it would be tragic. Here’s a PHP snippet that outputs your database as XML.

Submitted by: JohnGalt
Submitted on: Feb 27, 2009

On Wednesday I wrote a post about how to copy a table in MySQL using the SHOW CREATE TABLE sql query. Since then Paul Williams in the UK emailed me to let me know that there's a much easier way to do this using CREATE TABLE LIKE, a function which was depths of my brain somewhere but I'd since forgotten. This post revises and republishes my previous post using this simpler process.

Submitted by: JDStraughan
Submitted on: Feb 16, 2009

Soon you will know just how easy it is to build dynamic web pages using PHP and MySQL. Really, PHP and MySQL is easy to learn, and I hope this tutorial will help you realize that :-). I'm sure that by the end of this tutorial you will have enough knowledge to build your own database driven website using PHP & MySQL.

Submitted by: JohnGalt
Submitted on: Aug 12, 2008