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....
Version: 1 Platform(s): linux, windows Updated: Mon Dec 20 2004
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.
Version: n/a Platform(s): n/a Updated: Thu Jun 24 2004
Everyone who likes MS HTML Help (.chm extension) can now obtain complete conversion of MySQL manual into this format. This conversion tries to bring additional functionality and make using of MySQL manual more comfortable.
Version: 5.0.0-alpha Platform(s): Win 9x/NT/2000/XP Updated: Mon Mar 8 2004
This tutorial will hopefully teach you some basics of how to access data with your PHP scripting to gather information with in a MySQL database.
The first step you need to do is get a basic understanding of what MySQL is. If your site can handle or has access to a MySQL database you should try using the PHP Myadmin application to help you use and access your MySQL datases fast and easy.
Version: 1.0 Platform(s): Unix, Win NT, XP, etc. Updated: Sun Feb 1 2004
In PHP every database is accessed slightly differently. To connect to MySQL, you would use mysql_connect(). When you decide to upgrade to Oracle or Microsoft SQL Server, you would use ocilogon() or mssql_connect() respectively. What is worse is that the parameters you use for the different connect functions are different also.. That's why a database wrapper library such as ADODB comes in handy when you need to ensure portability.
<p>
This tutorial has been translated into multiple languages, including German, Spanish, Polish, Thai and Chinese.
After having worked through this tutorial you will be able to:
* know how the additional phpMyAdmin features using special seperate tables work and how to set them up
* store pictures inside a MySQL table and view them from within phpMyAdmin
* put specific transformations on any of your columns
* create your own transformations, even with active PHP-code in it!
* create PDF pages of your table layout, with relations and individually positioned ER-models
At the end of this tutorial there's also some hints on getting the most out of your phpMyAdmin config file, showing you some configuration directives which seem to get less public attention.
Version: 0.9 Platform(s): All Updated: Sun Jul 27 2003
A detailed introduction to PHP and mySQL interaction. Includes detailed comments to help newbies get used to PHP and understand what is happening in each script.
The usage of databases in larger web-based applications is essential. By using basic object-orientated techniques we can minimize the fuss of connecting and interacting with a database. We can also reuse this code in other applications: a huge benefit of 'OO' programming.
