Scripts n'Stuffs
Directory

Subscribe to this category

Top > PHP > Tips and Tutorials > Database-Related  

Web Links
Sort By :
81. Website Database Basics With PHP and MySQL



As 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.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 3 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

82. 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.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 1 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

83. PHP and Writing to MySQL Databases



This simple tutorial shows you how to write form data to MySQL database using PHP. Includes a sample code and instructions.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 2 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

84. PHP and Accessing MySQL Databases



PHP can be used for many things, including grabbing your MySQL database entries. Here we learn two methods of doing so.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 2 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

85. Script Web databases quickly with PHP



In 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.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 24 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

86. 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.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 2 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

87. MySQL Table Joins



One 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.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 3 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

88. Setting Up Database Driven Websites



This 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.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 7 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

89. MySQL Administration



MySQL Administration correctly administering the MySQL server, including the manipulation the privilege system, and making intelligent decisions about the capabilities (permissions) given to users.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 7 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

90. 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 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.
Category:   PHP > Tips and Tutorials > Database-Related

Date Added: Jun 30, 2006 Hits: 2 Rating: 0.00 Votes: 0
Pick
Member Reviews Visitor Ratings

Pages:          9  


Home      New Listings      Hot Listings      Top Rated      Editor Pick      Add a Listing      Update a Listing      Get Rated
Copyright © 2006 SCRIPTSANDSTUFFS.COM. All Rights Reserved. Powered by INDEXU 5.2.0
Valid XHTML 1.0 Transitional   Valid CSS