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 Formatting Date/Time value in SQL query Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal. Web Database Tutorial (PHP & MySQL) 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. 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.

Google Search