Top Rated Scripts | PHP | Tutorials & Tips | Database-Related

This is the second part of creating Web-based admin user interface. This tutorial covers adding and deleting users via Web form using a MySQL database.

A Brief introduction in how to use MySQL, Great tutorial for beginners.

In this PHP MySQL tutorial I will show you how to use basic database manipulation features in PHP.

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.

Sometimes it could be very helpful to select a record from a table randomly. You can find such solution when you see random partners or randomly selected tutorials. This tutorial shows you how to select records randomly from a MySQL database.

Before you can get content out of your MS SQL database, you must know how to establish a connection to MS SQL Server from inside a PHP script. This tutorial describes how to connect to MS SQL database with a DSN and without a DSN.

This example use MySQL functions from PHP to display full MySQL table(every column and every row) as HTML.

PHP4 is packed with good features. One of the most popular is session variables. These are variables that persist throughout a session, as the user moves from page to page. Session variables are great holders of state information and other useful stuff. PHP4's session variables are stored in files by default. However for true scalability, it is better to store this data in a database using a database wrapper library like ADODB. ADODB supports Oracle, MySQL, PostgreSQL, Interbase, MSSQL, VFP, Access, ADO.

1.Creating Database Tables 2.Introduction to the Header/Footer System 3.Getting Ready for Action 4.Displaying the Forum Overview 5.Signing up a User 6.Adding Authentication and User Levels 7.Creating a Category 8.Adding Categories to index.php 9.Creating a Topic 10.Category View 11.Topic View 12.Adding a Reply

Learn the three main basic data types used in MySQL and how to utilize them to build a more effective dynamic web site. Lots of web developers use MySQL but not all of them harness the power of these features.

This code will count the number of entries / records in a MySQL database table and then display it using echo.

Pretty often you need to run a couple of queries against your MySQL database on the client's web server. Usually phpMyAdmin does the job well but there are situations when you just need to upload something to the server and open in the borwser, without any configuration steps. Welcome Bike, lightweight phpMyAdmin replacement. If you already have a CMS installed on the web server (WordPress, Drupal, Joomla), simply upload Bike to CMS's subfolder and open it in the browser.

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.

Many devs using MySQL have fallen in love with PHP. Jason Gilmore explains why they're the perfect couple. This is ore of an introductory article on PHP and MySQL covering such topics as features of PHP and MySQL, and how to use PHP to interact with MySQL.

This 6-page article explains how to create an extension to PHPLIB to work with multiple databases. You may find this article helps you extend PHPLIB in other ways. Read this article to the end and then think about situations where PHPLIB performs 98% of what you want.

In this Part 2 of the article "Building Next/Prev Buttons for Query Results," you will be shown a sample code designed to work in most instances (with minor changes).

This article addresses two SQL-related issues in PHP: 1) Creating complex, powerful, queries to take advantage of your table schemas, and 2) Building those queries on the fly according to user input.

PEAR's DB classes are one of the database abstraction layers. This article takes a look at some traditional database access methods and then compare them with the method employed by PEAR.

This article will briefly describe how to compile PHP with ORACLE 8i support. The author writes "when i try to compile php with oracle support on Solaris 2.6 i got lots of problems. after tedious search in internet i have found solution. I have following configuration: ORACLE 8.1.6; PHP 4.0.6; Apache 1.3.19 (Already Installed)."

This tutorial will teach you how to deal with special characters like HTML tags, white space etc. from a user submitted form and database output.