|
|
Database-Related
PHP » Tips and Tutorials » Database-Related
A D V E R T I S E M E N T
Want free Oracle Magazine? Apply here now!
Simple Connection to Informix - FreeThis tutorial explains how to make a simple connection to Informix and select some data using PHP. Oracle and PHP - FreePHP provides built in functions to access just about every database that exists, including Oracle. This 8-page tutorial illustrates how to use these built in functions to communicate with an Oracle database. Interfacing With MS Access 97+ - FreeHere, 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. A Contact Database using MySQL and PHP - FreMySQL has a small, highly optimized database engine that implements the entry-level SQL92 specification. Its rich set of support tools lets you create dynamic Web applications such as catalogs, shopping carts, and contact lists. This article introduces MySQL and shows how to develop a simple Web interface to a contact database using MySQL and PHP. MySQL and PHP - FreePHP provides built in functions to access just about every database that exists. MySQL is well designed, powerful and most importantly free in some situations. In this tutorial, you will learn how to access MySQL using PHP. Main topics include: Create A Database, Create A Table, Insert Entries Into The Table, and Retrieve All Entries Into The Table. Website Database Basics With PHP and MySQL - FreeAs your website grows you may run into two problems: Your website has so much information that visitors can't quickly find what they want and visitors want to give you information. Both of these problems can be solved by building a database on a website. This introductory article shows you how to do this using basic PHP-MySQL interaction. DBM Functions Demo - FreeThis tutorial explains how to access dbm files from PHP using various dbm-PHP functions. mSQL Functions Demo - FreemSQL is a lightweight SQL database engine for Unix systems. It is extremely easy to install and configure and it does a great job of handling simple SQL queries. This tutorial shows you how to communicate with the mSQL database engine using various mSQL-PHP functions. So you want to use a database in your site - FreeIn this two-page online tutorial you will learn how to create a database-driven site that can display content on request. It covers topics on a simple SQL query interface and more complex example of parsing and querying. PHP and Writing to MySQL DatabasesThis simple tutorial shows you how to write form data to MySQL database using PHP. Includes a sample code and instructions. PHP and Accessing MySQL DatabasesPHP can be used for many things, including grabbing your MySQL database entries. Here we learn two methods of doing so. Script Web databases quickly with PHP - FreeIn this tutorial, you'll learn how to install and configure PHP for use with the Apache Web server on UNIX or the Microsoft Internet Information Server on Windows NT. Then you'll see by example how to use PHP to route HTML conditionally, to develop a simple database-driven Web application, and to track user sessions with cookies. Beginning MySQL Tutorial - FreeThis article will aid the reader in learning the basic operations of the MySQL server, including how to make a proper connection, set up the server for consequential manipulation and execute basic commands. The commands covered within this article are among the most important commands within the language, as they form the basis for the more advanced commands. MySQL Table Joins - FreeOne of the great characteristics of SQL (Structured Query Language) is the fact that one can develop access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, and reduced data redundancy. In MySQL (as well as many other SQL languages), this is accomplished via the join command. This tutorial takes a look at several types of the join command including The Cross Join, The Equi-join, The Left Join, and Self-joins. Setting Up Database Driven Websites - FreeThis tutorial is an introductory guide to get you started in the world of server-side-scripting and web databases. It covers installation and configuration of MySQL, Apache, and PHP. An example script is also included as a guide for making your own server-side-scripts. You will have accomplished after successfully completing this guide: setup the MySQL database server, setup the Apache web server, setup the PHP 3.0 Hypertext Preprocessor for server-side-scripting, and create a simple web enabled database. MySQL Administration - FreeMySQL Administration correctly administering the MySQL server, including the manipulation the privilege system, and making intelligent decisions about the capabilities (permissions) given to users. The MySQL Grant Tables - FreeOne of the most powerful aspects of the MySQL server is the amazing amount of control the administrator has over each user's intended behavior. This control can restrict user privileges over a general part of the server, such as limited access to an entire database, but can also be as specific as limiting privileges for a specific table or even column. This article will serve to explain the process in which the MySQL server grants/revokes these user privileges, highlighting in particular the newest additions to the MySQL privilege system, the tables_priv and columns_priv tables. Please keep in mind that the GRANT/REVOKE commands detailed later in this article are only relevant to MySQL version 3.22.11 and up. PHP/MySQL Tutorial - docGet started in Web databasing the open source way. This three-lesson tutorial covers everything you need to know to begin developing database hubs. Lesson 1 gives instructions for installation on both Unix and Windows, and then goes on to show some simple scripts that will insert information into a database and display that data on a Web page. Lesson 2 covers more PHP/MySQL goodies such as while loops, if-else statement, how PHP can be used with HTML forms, and how to add, edit, and remove information from your database. Lesson 3 covers some of the secrets that will turn your simple data-driven site into a useful application.
|
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
| |
|