Add to Favorites    Make Home Page 34569 Online  
 Language Categories  
 Our Services  

PHP » Tips and Tutorials » Database-Related » Web Database Tutorial (PHP & MySQL)

A D V E R T I S E M E N T

Search Projects & Source Codes:



Title Web Database Tutorial (PHP & MySQL)
Platform n/a
Price Free
Author Visit Author Website
Website Visit Website of - Web Database Tutorial (PHP & MySQL)
Category PHP » Tips and Tutorials » Database-Related
Hits 571
Description 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... All are based on inserting, displaying and managing data in a database.

A D V E R T I S E M E N T




Google Groups Subscribe to SourceCodesWorld - Techies Talk
Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.


Scripts Related to - Web Database Tutorial (PHP & MySQL)

Script Name

LDAP to SQL

The author writes: Whilst working on the automatic production of web statistics - came across the following problem: "How do I get relational data from an Hierarchical structure " It didn't take long to realize - I'd have to use PHP to talk to LDAP, pull off records & upload into a series of tables, using the cn as primary key. Which then could be queried relationally. Pulling off large, queries and repeatedly transcending LDAP trees is pretty slow - so I built my LDAP to SQL engine, by flattening dns into table names. Then used PHP scripts to query & produce daily snap shots.

MySQL query execution time

This interemediate tutorial shows you a way to capture time spent for MySQL tasks. Find out how to output page generation time and percent when MySQL was running.

Outputting any MySQL table in HTML format

Find out and learn this beautiful technique how to output any MySQL table to the HTML page. The source code shown here will teach you how to create a function that is useful on any web site having MySQL backend database.

Sorting Database Results with PHP

This tutorial will show you how to display data from a database and allow the user to sort it.

Static HTML Generation With PHP and MySQL

Want to reduce the load that MySQL has on your web server Generating Static HTML pages to replace queries is the solution. Read this tutorial to learn how.

Database Abstraction with PEAR

So you've written a great application with PHP and it is up and running smooth. Then, your boss calls and tells you that your company won't be using MySQL anymore. You're moving to Oracle. Your application is dead in the water. You should have used database abstraction.

Multicolumn Output from a Database with PHP

Putting your data into multiple columns with PHP is a snap. This tutorial will show you how it is done.

Tips on Writing Portable SQL for Multiple Databases with PHP

If you are writing an application that is used in multiple environments and operating systems, you need to plan to support multiple databases. This article is based on my experiences with multiple database systems, stretching from 4th Dimension in my Mac days, to the databases I currently use, which are: Oracle, FoxPro, Access, MS SQL Server and MySQL. Although most of the advice here applies to Perl, Python and other programming languages, we will focus on PHP and how the ADOdb database abstraction library offers some solutions.

Alternating row colors with PHP and mySQL

A quick tutorial explaining how to alternate table row colors using PHP and MySQL.

Previous and Next Links

After reading this tutorial, you should be able to add previous and next links to your pages that display data from a database.

Google Search

Google

Source Codes World.com is a part of Vyom Network.

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

Sitemap | Privacy Policy | Terms and Conditions
Copyright ©2003-2019 SourceCodesWorld.com, All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/scripts/Web-Database-Tutorial-PHP-MySQL--19882/Default.asp


Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review


 Advertisements