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 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. MySQL Compiled HTML Manual This is a MySQL CHM (Compiled HTML Manual), based on original html-vsersion of manual from www.mysql.com. Using PHP with ODBC This is a detailed tutorial intended for the PHP programmer interested in learning more about database connectivity - using the ODBC standard. You should be familiar with PHP syntax and have a working knowledge of databases. Best Practices: Database Abstraction PEAR's 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. PostgreSQL and PHP Tutorial This is a nice tutorial on how to use PostgreSQL and PHP together. Topics covered include: Installation of PostgreSQL, PHP, and Apache, A Brief Introduction and Basic Commands, Different Types of Data, Retrieving Data from a Database, Inserting Data into a Database, Updating Data in a Database, Deleting Data from a Database, Dealing with Errors, and Including Files. The tutorial is also available for download. SQL Theory & How-To This article addresses two SQL-related issues in PHP: 1) Creating complex, powerful, queries to take advantage of your table schemas, and 2) Building those queries on the fly according to user input. Doing Simple DB Abstraction in PHP This tutorial explains the need for database abstraction in PHP, and shows how to create your own database API that can be to used with different types of databases. The tutorial uses a PHP PostgreSQL API as an example. Building Next/Prev Buttons for Query Results (Part 2) In this Part 2 of the article "Building Next/Prev Buttons for Query Results," you will be shown a sample code designed to work in most instances (with minor changes). PHP4 Session Handler using ADODB PHP4 is packed with good features. One of the most popular is session variables. These are variables that persist throughout a session, as the user moves from page to page. Session variables are great holders of state information and other useful stuff. PHP4's session variables are stored in files by default. However for true scalability, it is better to store this data in a database using a database wrapper library like ADODB. ADODB supports Oracle, MySQL, PostgreSQL, Interbase, MSSQL, VFP, Access, ADO. ODBC Socket Server This article describes how to make Access and PHP work together using the ODBCSocketServer, an open source socket server, available at http://odbc.linuxave.net/. This tutorial will take you through configuring your machines and using the socket server.

Google Search