- Simplifying the Webmasters Job with PostgreSQL and PHP4
The author writes "How many of you would like to reduce the amount of text-based maintenance that you do\? One of my biggest fears in doing a website for a client is that they will shy away from using my services because of the long-term maintenance fees. I have a solution to present to you that will get you a little more money up front, while allowing a HTML illiterate person to change the content within the website!"
http://www.newbienetwork.net/sections.php?op=viewarticle&artid=21
(Rating: 0.00 Votes: 0)
Rate It
Review It
- So you want to use a database in your site\?
In 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.
Price: Free
http://www.phpbuilder.com/columns/jesus19990308-1.php3
(Rating: 0.00 Votes: 0)
Rate It
Review It
- SQL Database Function Wrappers
When interacting with a database, functions are called that are common to every transaction; functions to establish a connection, execute the query and then close the connection. This article shows how to create functions that will eliminate this redundancy. The tutorial uses MySQL as the database, but the database layer is irrelevant. These functions can be adapted to use other databases.
Price: Free
http://www.phpworld.com/articles/2000.07/sqlwrapper_000.html
(Rating: 0.00 Votes: 0)
Rate It
Review It
- 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.
http://www.phpbuilder.com/columns/joe20010104.php3
(Rating: 0.00 Votes: 0)
Rate It
Review It
- The MySQL Grant Tables
One of the most powerful aspects of the MySQL server is the amazing amount of control the administrator has over each users 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.
Price: Free
http://www.devshed.com/Server_Side/MySQL/Grant_Tables/
(Rating: 0.00 Votes: 0)
Rate It
Review It
- 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 for all the scripts involved.
http://www.oreillynet.com/pub/a/370
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Using PHP to Connect to MySQL: A Newbie Tutorial
This simple tutorial will show you the way you connect to a MySQL Database, and how to select data from the database. First thing you need to do is get your user name/password to the mysql database, and the domain of the databse.
http://www.newbienetwork.net/sections.php?op=viewarticle&artid=3
(Rating: 0.00 Votes: 0)
Rate It
Review It
- 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.
http://www.zend.com/zend/tut/odbc.php
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Web Database Tutorial (PHP & MySQL)
This is a tutorial on how to create a web database application using PHP and MySQL on a Linux platform. 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... All are based on inserting, displaying and managing data in a database.
Price: Free
Platform: Unix
http://blazonry.com/scripting/linksdb/
(Rating: 0.00 Votes: 0)
Rate It
Review It
|
