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.

• Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
• Discuss Programming Problems and Freshers Jobs related issues here.
• Discuss Final Year Project Ideas here.

Script Name 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. Basics of MySQL with PHP Ever wondered how the big sites can change their content so quickly Inside we'll show you how, using databases and dynamic content. The basics of MySQL are explored and a simple address book is created. Oracle vs. MySQL: loading the data Even though loading data from a text file into the database is not a task that user would perform on a daily basis, there are several cases when the speed of this process is important to DBA and company management. One example would be having a "database guy" receive the daily reports from the field offices or sales people on daily basis. Reports come as Excel documents or delimited spreadsheets of some kind, and DBA's responsibility includes updating the database on constant basis, so that by the end of the day, he is able to give the management a report on the amount of daily sales or field office transactions. Here you will find a MS Word-format downloadable file that examines the benchmark results for Oracle and MySQL speed of loading the data from a text file.

Google Search