Building a dynamic WML site (3)_PHP tutorial

The user must then enter in the next file (index3.wml). We ask the user to enter the subject's first name or the professor's last name. You need to pay attention to how variables are transferred between pages. The syntax seems a bit complicated, but it gives you an idea of ​​how the entire process is accomplished through several files.
Header("Content-type: text/vnd.wap.wml");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no -cache");
echo ("＜?xml version='1.0'?＞;");
＞;
＜!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1// EN"
"http://www.wapforum.org/DTD/wml_1.1.xml" ＞; ＜WML＞
＜CARD id=card3 title=Name＞
＜? php
echo ("＜p＞Insert ");
if (${$choice} == "surname") {
echo ("professor's surname (or part of it).n");
} else if (${$choice} == "subject") {
echo ("the subject (or part of it).n");
} else {
echo (" Maybe there is some problem.n");
} echo ("＜INPUT name='"${$choice}"' type='"text"'＞");

? >
＜DO type="text" label="Go"＞
＜GO href="query.wml" method="get"＞

echo ("＜POSTFIELD value='"$"."$choice".""/' name='"$choice"'＞");

echo ("＜ POSTFIELD value='"$"."${$choice}".""/' name='"${$choice}"'＞");

? >
＜/GO＞
＜/DO＞
＜P＞＜/P＞
＜/CARD＞
＜/WML＞



＜DO type="text" label="Go"＞
＜GO href="index3.wml#card3" method="get"＞
echo ("＜POSTFIELD value='"$"."$choice".""/' name='"$choice"'＞");
echo ("＜POSTFIELD value='"$ choice"/' name='"choice"'＞");
? >



＜/CARD＞
＜/WML＞
Write query code

The following files are responsible for processing queries. Its name is query.wml and we will analyze it in more detail.

<？php  

Header("Content-type: text/vnd.wap.wml");  
printf("<？xml version="1.0"？>n");
printf("n");
printf("n");


// The following lines are used to construct SQL statements for querying teaching time


$consulting_tables =
"(professors left join teach on (professors.Id = teach.Id), subjects)";
$consulting_columns =
"professors.Surname, professors.Name, subjects.Subject , ";
$consulting_columns .=
"subjects.Cod_number, professors.Consulting_hour, professors.Consulting_place"; Cod_subject ";


// The following lines are used to construct SQL statements for query test time

$exams_tables= "(exams left join professors ON (exams.Id = professors. Id), subjects)";
$exams_columns= "subjects.Subject, subjects.Cod_number, professors.Surname, ";
$exams_columns.= "professors.Name, exams.Date, exams.Time, exams. Room, exams.Test";
$exams_query= "exams.Cod_Subject = subjects.Cod_Subject ";

// The following lines are used to add query restrictions to the sql statement for querying the test schedule


if ($exams_data) {

switch($exams_data) {
case "subject":
$exams_query.= " and subjects.Subject like '%$subject% '";
break;
case "surname":
$exams_query.= " and professors.Surname like '%$surname%'";
break;
}
}


// The following lines are used to add query restrictions to the sql statement for querying teaching time

if ($consulting_data) {
switch($consulting_data) {
case "subject":
$consulting_query
.= " and subjects.Subject like '%$subject%'";
break;
case "surname":
$consulting_query.= " and professors.Surname like '%$surname%'";
break; >function connect($tables, $data, $condition_passed) {  
//  
// put your password and username in next line  
//  

$db = mysql_pconnect("localhost ","***","***");

// put your database name in next line

mysql_select_db("lanfranchi_co_uk",$db);

$sql = "SELECT $data FROM $tables WHERE $condition_passed order by professors.Surname";
$result = mysql_query($sql,$db);
return $result;
}


// This function generates the wml code of the teaching time

function consulting_print($consulting_result) {
global $file;
printf("n");
printf(" ＜P＞Receiving hours ＜🎜>
n"); ＜🎜>while ($myrow = mysql_fetch_row($consulting_result)) { ＜＜P＞$myrow[0], $myrow [1]＜/P＞n");
printf(" ＜P＞$myrow[2]＜/P＞n"); ＞n");
printf(" ＜P＞$myrow[4]＜/P＞n"); 🎜>}
printf("＜/CARD＞n");
}


// This function generates the wml code of the test timetable

function print_exams( $exams_result) {
global $file;
printf("＜CARD id='"card1"' title='"hours"'＞n");
printf(" ＜P＞Examinations hours

n");
while ($myrow = mysql_fetch_row($exams_result)) {
printf(" ＜P＞$myrow[2], $myrow[3]＜/P＞n" );
printf(" ＜P＞$myrow[0]＜/P＞n");
printf(" ＜P＞$myrow[1]]＜/P＞n"); printf(" ＜P＞$myrow[4], $myrow[5]＜/P＞n");
printf(" ＜P＞$myrow[7]＜/P＞n"); printf("＜P＞$myrow[6]＜/P＞n");
}
printf("＜/CARD＞n"); // Check when you select the teaching time or test time, connect to the database and call the function that generates wml code

if ($consulting_data) {
$connection_result =
connect($consulting_tables, $consulting_columns, $consulting_query);
consulting_print($connection_result);
}
if ($exams_data) {
$connection_result =
connect($exams_tables, $ exams_columns, $ exams_query);
print_exams($connection_result);
}
printf("＜ /WML＞n");

? >

OK, done. You have created your first PHP/WML page based on MySQL database. Continue to practice it yourself.​

http://www.bkjia.com/PHPjc/315787.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/315787.htmlTechArticleThen the user must enter in the next file (index3.wml). We ask the user to enter the subject's first name or the professor's last name. You need to pay attention to how variables are transferred between pages. ...