檢視網頁程式撰寫/2017/黃柏實的原始碼

[[分類:網頁程式撰寫]]
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
<br/> = 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='____' /><br/>
email：<input type='text' name='email' value='alledu2@gmail.com' /><br/>
電話：<input type='text' name='phone' value='0987466665' /><br/>
//defines the input to text setting the name of this variable to what is typed in, and <br/> 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
?>