1. CSS
  2. Flash
  3. HTML
  4. Illustrator
  5. Java
  6. JavaScript
  7. Maya
  8. Photography
  9. Photoshop
  10. PHP
  11. Ruby
  12. Ruby on Rails
  13. 3ds Max

Newest Tutorials

PHP » Database Interactions — about 9 years ago
This tutorial covers the basics of using MySQL's aggregate functions (SUM(), MIN(), MAX() etc) to generate report-style data and to summarise complex sets of information
PHP » Database Interactions — about 9 years ago
Sometimes when working with a MySQL powered website in PHP, we’ll come across situations where we have multiple records that we wish to display to the visitor. If there are many tens, hundreds or more of these results, we might not want them all shown on the one page as this would increase the loading time, and make the list harder to navigate. To solve this problem, we introduce the concept of pagination in MySQL, which makes use of the handy LIMIT keyword and information passed by GET fro
PHP » Database Interactions — about 9 years ago
PhpMyAdmin is a popular open-source application used to remotely manage and modify MySQL databases and is particularly useful for use on websites as it can be placed within a secure directory on a remote web server and accessed via a specific URL. This allows you to easily and quickly access your data to make changes, to download backups or perform a range of other useful operations.
PHP » Database Interactions — about 9 years ago
This tutorial contains a step-by-step guide to building an IP Address and Visitor tracking log tool using PHP and MySQL. When running a website, whether it’s a small personal homepage, or a large site for a company, it’s useful to be able to know who is visiting your site, and what they’re up to while they’re there.
PHP » Database Interactions — about 9 years ago
In this tutorial we will work on building ourselves a very simple PHP application to accept user data and save it into a MySQL database. This information will then be displayed to anyone visiting the site. We’ll also take a quick look at how we can generate a script to authenticate administrative users based on a username and password combination and allow those admin users to delete unwanted comments from the database.
PHP » Database Interactions — about 9 years ago
In this tutorial we’re going to look at an example where it becomes useful to use more than one table at a time while still using the powerful features of MySQL to query this data in a simple, straightforward manner Multiple tables can be queried using one statement via the JOIN command, to join together multiple tables at a time
PHP » Database Interactions — about 9 years ago
This tutorial covers the basics of using MySQL to update existing records and insert new records into a table using PHP There is also a section on auto-incrementing values and table indexes to improve performance
PHP » Database Interactions — about 9 years ago
A query in MySQL is an expression which we can send to the database which returns a specific set of results based on the values and conditions we’ve set in the query string. In less technical terms, you can think of it as a statement which defines a question that we wish to ask the database. This tutorial covers the basics of querying a MySQL database from PHP to get result sets from queries
PHP » Database Interactions — about 9 years ago
This tutorial introduces you to some of the basic datatypes MySQL uses to store your data. There are also a few tips about data management in MySQL
PHP » Database Interactions — about 9 years ago
One of the things you’re going to encounter when using MySQL with PHP sooner, rather than later, is the issues that arise when you start accepting user input in the form of comments or blog posts. When dealing with the general public, we can’t assume anything about the data they submit into our database. In fact, we have to assume the worst! Making sure your data is "cleaned" and "sanitized" is very important to ensure smooth running of your site and your database.
Help us out! More and more tutorials are submitted to Good-Tutorials each day. We could use your help with finding good tutorials. Mind lending a hand?