Php/mysql 3rd Pass (1)

This paper introduces how to build a network database application method by Php/mysql of the golden combination of Web database, PHP is a server-side embedded hypertext Processing language similar to Microsoft ASP, it is a powerful tool to build dynamic website. While MySQL is a lightweight SQL database server that runs on a variety of platforms, including Windows NT and Linux, and has a GPL version, MySQL is considered the best product for building a database-driven dynamic Web site. PHP, MySQL, and Apache are the best partners for Linux platform sites. This tutorial is a 3rd course that is described in detail from installation to application.

Introduction of Php/mysql

You should have heard of open source software (OSS) unless you've been living on Mars for the last 6-8 months. The movement has a tremendous impact and has attracted the attention of some big companies. Like Oralce, Informix, and a number of companies are starting to migrate their main database products to one of the products of OSS-the Linux operating system.

If you have enough technical power, having a complex and huge relational database system (RDBMS) is a powerful force. But maybe you're just getting started with the database, and you've just read Jay's article and decided to work on a data-driven Web site. But you may find that you lack the necessary resources to run an ASP server or an expensive database system (and you don't need those things). You need some free, UNIX-enabled stuff.

Then I suggest you use PHP and MySQL. Together, these two things are the best combination for developing data-driven Web sites. In fact, I don't have to bother to explain. The number of hosts applying PHP jumped from 7,500 units in June 1998 to 410,000 in March 1999, according to an unofficial survey organized by Netcraft. Nice, huh? The combination of the two software also won the annual Database Product award at the Webcon98 conference, and won a beautiful trophy.

MySQL is a small and long database server software, for small (and not necessarily very small) application system is very ideal. In addition to supporting standard ANSI SQL statements, it supports a wide variety of platforms, while on UNIX systems the software supports multithreading and can achieve fairly good performance. For users who do not use UNIX, it can be run as a system service on a Windows NT system, or run as a normal process on a Windows 95/98 system.

PHP is a scripting language for server-side interpretation. If you have contacted ASP, you should be more familiar with embedding code in HTML pages. The PHP code is interpreted at the end of the server into a normal HTML page content and sent to one end of the browser. This pattern allows us to use it to perform quite complex functions.

In addition to the free one (of course, MySQL also has some restrictions on licensing), the Php-mysql combination can also run across platforms, which means you can develop on Windows and then run Qiaoqi on UNIX platforms duo Yili HP can also run as a standard CGI process, At this point it is a standalone script interpreter, or an embedded module of Apache.

If you are interested in using a different database server, PHP also supports Informix, Oracle, Sybase, solid, and PostgreSQL, as well as common ODBC.

PHP supports some cutting-edge technologies for Internet development. These technologies include identity authentication, XML, dynamic image generation, WDDX, shared memory, and dynamic PDF documents, among other things. If you are not satisfied, PHP is very easy to expand, so as long as you have the ability to programming, you can do your best.

The last thing to say is that both software are developed by a large number of programmers, so there are many ways to support documents and mailing lists. Bug fixes are fast, and if you ask for a new feature, someone will always consider your request and implement it if the feasibility is high enough.

That's enough! Let's take a look at what's in this tutorial.

The first lesson is about installing both software in a UNIX and Windows environment. If you are not too concerned about this (perhaps you are developing it on your ISP's server), you can skip to the first sample program and start your wonderful journey there.

In the second lesson, we want to learn some more complex scripting features, such as looping, processing user input, and exchanging data with databases, and so on.

The third lesson is about validation and how to make your scripts clear and concise.

Here we go