網頁程式撰寫/2017/黃柏實：修訂版本之間的差異

2017年9月7日 (四) 12:01的修訂版本

Class resources: Hand-out: http://jendo.org/wiki1231/index.php?title=%E7%B6%B2%E9%A0%81%E7%A8%8B%E5%BC%8F%E6%92%B0%E5%AF%AB/2017 Hand-out print version: http://jendo.org/printOut/%E7%B6%B2%E9%A0%81%E7%A8%8B%E5%BC%8F%E6%92%B0%E5%AF%AB2017.html form.php link: http://6years.jendo.org/~%E9%BB%83%E6%9F%8F%E5%AF%A6/php/form.php Book chapter one test criteria: http://jendo.org/wiki1231/index.php?title=PHP,MySQL,AJAX,%E7%B6%B2%E9%A0%81%E8%A8%AD%E8%A8%88%E7%AF%84%E4%BE%8B%E6%95%99%E6%9C%AC

Copy past code from hand-outs and change personal info to own r.php calls your name and phone number from form.php and sends it to the server so that its put into a list that the server admin can see

Browser: a program that communicates with the server and sends it back to the user Server: this is the place where all the information gets processed and translated back to us

<> = Tags Tags must be in pairs

<Meta> = Define
= Break

form.php: <meta http-equiv='content-type' content='text/html;charset=UTF-8'> //the above line defines the attributes of this program <form action='r.php'> //action to send information requested by r.php to the server 姓名：<input type='text' name='__' value='____' />
email：<input type='text' name='email' value='alledu2@gmail.com' />
電話：<input type='text' name='phone' value='0987466665' />
//defines the input to text setting the name of this variable to what is typed in, and
stands for break which moves everything you type after this to the next line <input type='submit' value='送出' /> //as we can see the input type is no longer "text" but instead "submit" therefor this will become a button that submits the information to r.php </form> //closing bracket of the <from> tab, meaning everything between the two will get sent to r.php for processing

r.php: <?php

$connect=mysql_connect('localhost','assistant','aide');

//connects r.php to the local server MySQL in which the information will be processed

mysql_select_db('助理們');

//requests MySQL to select the variable "db"

mysql_query("insert into web set 姓名='".$_REQUEST['姓名']."',phone='".$_REQUEST['phone']."'");

//inserts the information needed from form.php into the query which will be shown to the server admin

mysql_close($connect);

//closes the connection after receiving the needed data ?>