As a web programming language, one of PHP’s strengths traditionally has been to make it easy to write scripts that access databases so that you can create dynamic web pages that incorporate database content. This is important when you want to provide visitors with information that is always up-to-date, without hand tweaking a lot of static HTML pages. However, although PHP is easy to use, it includes no general-purpose database access interface. Instead it has a number of specialized ones that take the form of separate sets of functions for each database system. There is one set for MySQL, another for InterBase, and another for PostgreSQL—and others as well.
Read the rest of this entry »
Many developers have learned to use PHP over the years because it’s a good solution for creat- ing Web pages and the price is right. The PHP acronym is like many other new acronyms for the Internet—the acronym is recursive (refers back to itself). PHP stands for PHP Hypertext Processor. This general-purpose HTML scripting language works much like ASP (see Chapter 6) or other page description languages you might have used. Essentially, you mix HTML with scripting information. When the PHP process sees HTML, it sends the text directly to the user. It processes any scripting information, and passes the resulting HTML to the user as well.
Read the rest of this entry »
Writing PHP code is quite a fun task – as we’re sure of you will agree – it’s an easily learnt, flexible, and feature-rich language that lends itself very well to scripts of all shapes and sizes. Almost certainly as a result of this comparative ease of use, many PHP programmers take to re-inventing the wheel a lot and spend much time writing and rewriting ‘new and improved’ code to handle authentication, caching, forums, opinion polls, and other systems that have been coded and recoded in the past.
Read the rest of this entry »
The customizable PHP script Generic HTML Form Processor is intended to assist researchers and students in quickly setting up surveys and experiments that can be administered via the Web. This script relieves researchers from the burdens of writing new cGi scripts and building databases for each Web study. Generic HTML Form Processor processes any syntactically correct HTML form input and saves it into a dynamically created open-source database. We describe five modes for usage of the script that allow increasing functionality but require increasing levels of knowledge of PHP and Web servers: The first two modes require no previous knowledge, and the fifth requires PHP programming expertise. use of Generic HTML Form Processor is free for academic purposes, and its Web address is www.goeritz.net/brmic.
Read the rest of this entry »
Many developers have learned to use PHP over the years because it’s a good solution for creating Web pages and the price is right. The PHP acronym is like many other new acronyms for the Internet—the acronym is recursive (refers back to itself). PHP stands for PHP Hypertext Processor. This general-purpose HTML scripting language works much like ASP (see Chapter 6) or other page description languages you might have used. Essentially, you mix HTML with scripting information. When the PHP process sees HTML, it sends the text directly to the user. It processes any scripting information, and passes the resulting HTML to the user as well.
Read the rest of this entry »
SQL - Structured Query Language
Structured Query Language, is a computer language designed for retrieval and management of data in relational database management systems database schema creation and modification database object access control management.
History:
The first version of SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. Standardized in 1986 by ANSI. Subsequent versions of the SQL standard have been released as ISO standards
Read the rest of this entry »
Over the course of this book, it will be my job to guide you as you take your first steps beyond the HTML world of client-side site design. Together, we’ll explore what it takes to develop the kind of large, content-driven sites that are so successful today, but which can be a real headache to maintain if they aren’t built right. Before we get started, you need to gather together the tools you’ll need for the job. In this first chapter, I’ll guide you as you download and set up the two software packages you’ll need: PHP and MySQL.
Read the rest of this entry »
What is MySQL?
• MySQL is an SQL based relational database management system that runs on more than 20 platforms including Windows, Linux, OS/X, HP-UX and many more.
• The owner and producer of MySQL is a Swedish company called MySQL AB. They provide services and training programs for MySQL users. The software’s official website http://www.mysql.com gives the latest information about the company and MySQL.
Read the rest of this entry »