Active Articles: 2038
Total Categories: 16
Sub Categories:616
PHP MySQL Tutorial | ||||||||
This is a PHP and MySQL tutorial. With code examples like uploading files to database, creating guestbook, contact form, Content Management System (CMS), User Authentication etc. ... learn more
| ||||||||
| ||||||||
SImple PHP Database Abstraction Class | ||||||||
This DB connectivity class makes it even easier to work with data from MySQL databases. It handles errors, features a better result object, and allows you to iterate through the rows returned by a SELECT query. ... learn more
| ||||||||
| ||||||||
Best Practices: Database Abstraction | ||||||||
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. ... learn more
| ||||||||
| ||||||||
Importing csv data into MySQL with php script | ||||||||
This tutorial will show you how to import csv data into MYSQL with a simple PHP script. Many times you have to write a script because the import function in phpMyAdmin will not import the way you want. ... learn more
| ||||||||
| ||||||||
Mastering phpMyAdmin for Effective MySQL Management | ||||||||
This is the Full chapter 6 from the recently published book 'Mastering phpMyAdmin for Effective MySQL Management'. The Chapter 'Changing Table Structure' give a great step by step guide with diagrams. Publshed in HTML for your enjoyment. ... learn more
| ||||||||
| ||||||||
Interfacing With MS Access 97+ | ||||||||
Here, you will learn how to create an MS Access database and interface with it using PHP on Windows platform. Main topics include: Creating an Access database, Setting up an ODBC Connection, and Interfacing with database. ... learn more
| ||||||||
| ||||||||
Are PHP and MySQL the Perfect Couple? | ||||||||
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. ... learn more
| ||||||||
| ||||||||
Alternate row colours using MySQL | ||||||||
This tutorial teaches you how to number rows and give them alternate colours! ... learn more
| ||||||||
| ||||||||
Uploading, Saving and Downloading Binary Data in a MySQL Database | ||||||||
This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. This article is split into three pages: Setting up the database, Creating the 'upload' scripts, and Creating the 'download' script. Includes the complete source code ... learn more
| ||||||||
| ||||||||
Configuring PHP with ORACLE 8i Support | ||||||||
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 ... learn more
| ||||||||
| ||||||||
Web Database Tutorial (PHP & MySQL) | ||||||||
This is a tutorial on how to create a web database application using PHP and MySQL on Mac OS X or Linux platforms. The example used is a database to manage web site links. The same ideas used in this tutorial can be expanded to most web applications like phone directories, personalization, survey polls, etc... ... learn more
| ||||||||
| ||||||||
A Framework for Persisting Data Relationships | ||||||||
This tutorial will show you how to create relationships in your databases. PHP classes are provided that will perform the job. ... learn more
| ||||||||
| ||||||||
SQLite: A Lightweight Alternative | ||||||||
In this tutorial, Timothy shows you how to get started using SQLite starting with how to obtain it and install it and progressing through example usage. ... learn more
| ||||||||
| ||||||||
Using PHP with ODBC | ||||||||
This is a detailed tutorial intended for the PHP programmer interested in learning more about database connectivity - using the ODBC standard. You should be familiar with PHP syntax and have a working knowledge of databases. ... learn more
| ||||||||
| ||||||||
SQL Theory & How-To | ||||||||
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. ... learn more
| ||||||||
| ||||||||
MySQL - Connecting PHP to Database | ||||||||
This article provides tutorial notes on connecting PHP scripts to MySQl servers. Topics include creating database connection objects; executing INSERT INTO, SELECT, and UPDATE statements from PHP scripts. ... learn more
| ||||||||
| ||||||||
Table Editor Comparison | ||||||||
This article provides a comparison of three popular table editor libraries and applications. Namely, the TableEditor Library (available form phpguru.org), phpMyEdit and dbPerceptor. ... learn more
| ||||||||
| ||||||||
Admin user interface: adding and deleting users | ||||||||
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. ... learn more
| ||||||||
| ||||||||
PHP/MySQL database search | ||||||||
Got a MySQL database with content within it? Want to be able to search it and display paged search results on screen? This tutorial and script will do just that. (Apache, PHP, MySQL database required) ... learn more
| ||||||||
| ||||||||
Database frontend with PEAR DataGrid and DataObject | ||||||||
Structures_DataGrid and DB_DataObject are two PEAR components, which can be connected together, to easily display the data contained in a SQL table, and let the user sort and page through it. With minimal typing, this tutorial shows you how you can bypass the usual steps of parsing GET parameters, performing SQL requests, and generating HTML ... learn more
| ||||||||
| ||||||||