So you want to have the option to let users register on your website and have their information strored in a database? Well, you've come to the right place! We will explain in detail how to create a user registration and login script from the ground up.Since we will be using a database to store the information about our users, we will need to create a table in the database....
This tutorial shows how to store data into a MySQL database and then retrieve it by using a PHP query. This wil teach you the basics behind the use of PHP with databases.A VERY good tutorial for beginners who are interested in learning the language quickly.
Learn how to easily create a comment system. Don't know what a comment system is? Well, it's what you see very often in a news system. Basically it allows your users to give feedback on tutorials, news etc. This tutorial is definitley a must-see.
This is a database driven pagination tutorial. Pagination refers to when return results arebroken up into pages. For example when say a search returns 100 results but 10 results per page is desired and links to the other pages with 10 more results are generated. This is used to avoid scrolling nightmares. A classic example is the google search. This tutorial assumes basic knowledge of php scripting and mysql databases.
One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization of data, you will be better prepared to begin developing your application in PHP. This 6-page article describes the data relationships and the normalization of data using a simple example.
ODBC is one of Microsoft's earliest technologies for connecting to databases. This article describes how to setup and use ODBC from a PHP perspective. Also discusses ODBC extension bugs, database wrapper libraries, Microsoft's ADO (which is Microsoft's recommended API for 4GL programmers) and DSN-less connections.
This sample script produces a result set of random rows from a table. It does so by populating one of the columns with a random number, and then doing a select statement that uses it to sort the results.