Mysql + PHP + Flash simple message book creation _ MySQL

Mysql + PHP + Flash simple message book was created at the beginning of this message book, even Mysql and PHP were not touched. After a week of hard work, I completed my simple message book. There are no good PHP message book tutorials on the internet. The N multiple source files I downloaded are all in the fog of the cloud, and many of them write code on MC. Maybe I haven't found any good tutorials, but in any case, I have to make an axe at this class.

Purpose:

Use flash + php + mysql to create a simple message book.

Configuration environment:

You must first configure the corresponding environment. I downloaded the environment package configuration, which is a silly method and simple installation, which is suitable for me. : Http://phpnow.org/download.html (including: Apache, PHP, MySQL, Zend Optimizer, phpMyAdmin, eAccelerator)

The folder is described as follows (Init. cmd installation; PnCp. cmd control panel .) :

　　

Apache folder: PHP Server (similar to IIS ).

MySQL-5.0.15b folder: MySQl database server.

Data folder: stores the website database. (The message book database is stored in this, background)

Bin folder: files in it are used to operate databases (DOS mode)

Php-5.2.6-Win32 folder: PHP library, explained by Apache.

ZendOptimizer folder: accelerates PHP execution.

Htdoc (or www): stores webpage files. (The webpage file of the message book is stored at the front-end)

PhpMyAdmin folder: operate databases (in Windows mode)

Note:

1. during installation, you will be prompted to enter the MySQl database password. here, the password is "sun. (The user name is "root ")

　　

2. enter "http: // 127.0.0.1" in the browser and the configuration information is displayed. you can enter the MySQl password for connection testing.

　　

3. The website directory index is disabled by default. you can enable it on the console to facilitate subsequent tests on the website (message board.

　　

　　

Knowledge preparation:

1. first introduce how to use PHP to connect to the database (database username "root", password "sun", database "myguestbook ")

　　

2. communication between PHP and MySQl (SQL statement: INSERT, SELECT ):

PHP prepare MySQl: SELECT * FROM myguestbook;

PHP → MySQL: insert into myguestbook (name, comment) VALUE ("zhang san", "This is a message ");

3. SWF and PHP communication (the sendAndLoad method of the LoadVars class is saved, and the XML Parsing method is used ):

SWF merge PHP: PHP uses echo to write an xml file, and SWF directly parses the file. (I used to wonder why the blue RSS is in the PHP format. I learned it here to understand it .)

SWF → PHP: swf uses "sendAndLoad" (data_lv.uname = "Zhangsan") to send Variables. php uses $ name =Mysql + PHP + Flash simple message book production-webmaster College

Future Chinese webmasters will focus more on the development of China's networksAdvertisement service | latest update | add to favorites | set as Homepage

• Homepage
• Internet software
• IDC products
• Webmaster transaction
• Project outsourcing
• Business Information
• Recruitment
• Company Database
• Webmaster Mall

• Asset Information
• Downlink
• School
• Work Tools
• Tan

Popular keywords:For CSS layout color, see Dreamweaver8 apacheApacheIIS6AjaxWML

Homepage | HOME webmaster getting started operation planning search optimization website profit webpage design HtmlCSS/XhtmlDhtmlWAPDreamweaver design principles graphic animation photoshopFireworkFlash website development Asp. NetPhpJspMssqlAccessOracleMysql server FressbsdLINUXWindows

Video tutorial

Frequently used manual

Common advertisement code

Js special effect code

Webmaster College> Website Development technical tutorial> mysql tutorial> Mysql + PHP + Flash simple message book production

Mysql + PHP + Flash simple message book creation

21:55:00 view learning experience

{GetProperty (Content )}