- A Tutorial on Porting MySQL code using ADODB
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.. Thats why a database wrapper library such as ADODB comes in handy when you need to ensure portability.
http://php.weblogs.com/adodb_tutorial
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Access Granted
The author writes "mySQL comes with a pretty powerful security system, the grant tables, which allows database administrators to precisely control access to databases, tables and even specific rows and columns." This article describes how the five grant tables combine to offer power users a tremedous amounts of flexibility and control over database access and operations.
http://www.devshed.com/Server_Side/MySQL/Access/
(Rating: 0.00 Votes: 0)
Rate It
Review It
- An Introduction to Database Normalization (part 2)
The author notes, "Last week we introduced you to the basics of creating an efficient database table structure. After todays concluding article of this series youll be able to create some of your own MySQL-powered applications, or use this syntax as the basis for learning to create normalized databases on your database server of choice."
http://www.devshed.com/Server_Side/MySQL/Normal2/
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Are PHP and MySQL the Perfect Couple\?
Many devs using MySQL have fallen in love with PHP. Jason Gilmore explains why they
e 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.
http://www.oreillynet.com/pub/a/network/2000/06/16/magazine/php_mysql.html
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Beginning MySQL Tutorial
This 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.
Price: Free
http://www.devshed.com/Server_Side/MySQL/Intro/
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Best Practices: Database Abstraction
PEARs 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.
http://www.phpbuilder.com/columns/allan20010115.php3
(Rating: 0.00 Votes: 0)
Rate It
Review It
- Connecting to a mySQL database
This tutorial explains how to use several basic MySQL database functions in PHP. Main topics include: Connecting to a mySQL database using PHP, SHOW available tables, Using telnet to CREATE tables, How to INSERT, QUERY, UPDATE, and DELETE rows in a table, How to ALTER a table, Commenting Your mySQL Tables, and Creating mySQL tables.
Price: Free
http://www.php-scripts.com/php_diary/070700.php3
(Rating: 0.00 Votes: 0)
Rate It
Review It
|
