Building A Dynamic MySQL Paging Class With PHPOne handy class that Joe always keeps in his PHP toolbox is a custom MySQL recordset paging class, which he developed about 5 months ago. In this article Joe describes how he created the MySQL recordset paging class with PHP and also shows us how to use it with three cool examples!As PHP developers, we can develop pretty much anything that we can think of: database driven sites, complete GUI applications with PHP-GTK, ...

Implementing a Template Based Web Site With PHPTemplate based web sites allow you to produce dynamic web content and give your visitors the appearance that each page on your site is different. In this article James shows us how to implement a template based web site using two methods: a MySQL database and a flat file approach.This article was contributed by James Crowley from DeveloperFusion.com. If you're after free programming tutorials, source code and reviews you can click ...

Finding How Many Users Are On Your Site With PHPCounting the number of users that are currently browsing your site is a great way to brag about your high number of unique visitors if you're running a busy web site. In this article Joe shows us how to use PHP and a MySQL database to show the common "There are currently 23 users online" text on our web site. He uses two very simple scripts to do this, and the ...

SQL In Simple English Part 1/2SQL is the backbone of all databases. It is flexible, robust, and can be used to extract and manipulate data from databases. In this two part article, Kiran is going to describe the basics of SQL, as well as the more advanced features and functions, such as group by's, joins, etc. If you're new to SQL then this article will get you up to scratch in no time.SQL is the backbone of all databases. It ...

SQL In Simple English Part 2/2In part one of this article, Kiran looked at the basics of SQL including SELECT, INSERT, UPDATE and DELETE queries. In this, the final part of the article, Kiran's going to teach us about joins and sub queries. After reading both part 1 and 2 of this article, you should be able to construct intermediate SQL queries to extract and manipulate data from both single and multiple tables.In part one of this article we looked ...

Building A Persistent Shopping Cart With PHP and MySQLIf you take a look around any PHP resource site, you'll notice an exorbitant amount of shopping cart scripts. The fact of the matter is that shopping cart scripts aren't hard to develop. In this article Mitchell shows us how to build a simple shopping cart that persists across multiple browser sessions. He uses PHP, MySQL, and JavaScript to implement each part of the shopping cart.If you take a look around any ...

Creating Users and Setting Permissions in MySQLMySQL is an extremely powerful database, but in order to properly maximize its potential you may need to learn how to set up users and their respective permissions. In this article Ryan takes a look at using the MySQL console application to create users and grant permissions to them. He also shows us how to grant permissions from remote hosts, how to reduce user privledges and more.MySQL is an extremely powerful database, but in ...

SQL Injection Attacks: Are You Safe?Is your database safe from SQL injection attacks? In this article Mitchell tells us exactly what they are and shows us how to prevent them from occuring.The database is the heart of most web applications: it stores the data needed for the web sites and applications to "survive". It stores user credentials and sensitive financial information. It stores preferences, invoices, payments, inventory data, etc. It is through the combination of a database and web scripting ...

MySQL Made Easy With MySQL FrontMySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial Ryan shows us how to get up and running with MySQL Front.For many, the task of creating and manipulating MySQL databases is a daunting task. It is often difficult to master the complex commands required by the MySQL console and MySQL Admin. Luckily there is hope. With the increasing popularity of MySQL, many 3rd party tools have been developed to ...

Quick and Dirty EmoticonsEver wondered how forums like VBulletin display emoticons? In this article Havard shows us a quick and dirty way to create and use our own emoticons with PHP and MySQL.You've probably seen the new trend of replacing standard smilies with emoticons. Emoticons are images that represent the common emotes like ":)", ":(", ";)" and ":P". You can see examples of emoticons in use if you visit one of the popular forums, such as the DevArticles forum.In this ...