Building a dynamic WML site (1)_PHP tutorial

There are more and more mobile phones supporting WAP function. Therefore, you should also consider building your own WML website. This article will introduce how to build a PHP/WML page site. Using a MySQL database, the content of the site can be dynamically updated. Specific examples are the teaching hours and teaching hours of professors in a certain college. Quiz Timetable. It’s not complicated at all :-)
Before you start, you should prepare the following things:

1. You have correctly installed PHP and MySQL, and have experience in programming with both.
2. You have SQL knowledge
3. You are running Apache and can write .haccess files; or you are running IIS and you can add mappings (or you can ask the system administrator to help you) ;
　4. You have relevant knowledge of WML;

Okay, the first step is to let your server know to use PHP to process WML files. Here is how to do this.

Set up the server

If you are using Apache, you must find a .htaccess file in your directory. Then, add the following lines:

　 AddType application/x-httpd-php3 .wml

If you can’t find the file, you can add one and add the above lines and put it in your directory middle.

If you are using IIS, you have to make some changes, similar to when installing PHP: look at the mapping of .php and .php3 extensions, and add the same mapping for .wml.

Typically you will find PHP mapped to:

C:phpphp4isapi.dll

or

C:phpphp.exe

Preparation

If you are using Microsoft’s operating system, you can install NOKIA’s development tool kit. It checks your syntax and lets you preview WML pages through a phone-like interface. The toolkit also comes with reference documentation on WML and WML scripting. This can be a big help if your phone doesn't have WAP support, or if you can't use a WAP gateway.

To download this tool, you must first register on this website as a WAP developer (http://www.forum.nokia.com/main/0,6668,1_1_4,00.html) , what you need to remember is that you need Java2 Runtime Enviroment support (Java2 runtime environment support). You can use any text editor to write the page.

Before writing any PHP/WML code, you need to create a MySQL table.

The database consists of 4 tables.

1. The professors table includes data related to professors;
2. The subjects table includes data related to topics;
3. The exams table includes data related to tests;
4. The teach table includes Information about the relationship between professors and the subjects they teach

When connecting to MySQL, you can create a table through the following code

CREATE TABLE professors (
Id int(11) DEFAULT '0' NOT NULL auto_increment,
Surname varchar(24) NOT NULL,
Name varchar(24) NOT NULL,
Email varchar(48) DEFAULT 'Not avaliable',
Cod_course varchar(16) DEFAULT 'Not avaliable',
Consulting_hour varchar(128) DEFAULT 'Not avaliable',
Consulting_place varchar(128) DEFAULT 'Not avaliable',
PRIMARY KEY (Id)
);

These statements establish the professors table structure. ID assigns a unique identification number to each professor and is the primary key of the table. Other fields, Surname, Name, and Email are used to represent the last name, first name, and e-mail address of each professor. Cod_course is a value that uniquely identifies each subject. Finally, Consulting_hour and Consulting_place represent the teaching time and location.


CREATE TABLE subjects (
Subject varchar(96) NOT NULL,
Cod_Subject varchar(24) NOT NULL,
Cod_number varchar(12) NOT NULL,
PRIMARY KEY (Cod_subject )
);

Subject is the name of the subject. Cod_subject is the name used by the college to represent each subject. Its value is unique and is the primary key of this table. Cod_number is a numeric field. Different courses of the same subject belong to a group. This number is the identification number of the group.

CREATE TABLE exams (
Cod_Subject varchar(24) NOT NULL,
Id int(11) NOT NULL,
Date date DEFAULT '0000-00-00',
Time time DEFAULT '00:00:00',
Room varchar(64),
Test varchar(16) DEFAULT 'Oral'
); The name of the subject is unique, ID is the professor’s unique identification number, Date, Time and Room are used to record the date, time and location of the test, and Test is used to indicate the type of test (including written, oral, etc.)

CREATE TABLE teach (
Cod_Subject varchar(16) NOT NULL,
Id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (Id, Cod_subject )
);

In the teach table, ID is the professor’s identification number, and Cod_Subject has the same meaning as above. The two constitute the primary key of the table.

The next step is to fill in some data in the database. This step can be completed by yourself.

http://www.bkjia.com/PHPjc/315785.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/315785.htmlTechArticleMore and more mobile phones support WAP function. Therefore, you should also consider building your own WML website. This article will introduce how to build a PHP/WML page site using MySQL data...