網頁程式撰寫/2017/黃柏實：修訂版本之間的差異
| （未顯示同用戶所作出之4次版本） | |||
| 第 1 行： | 第 1 行： | ||
[[分類:網頁程式撰寫]] | [[分類:網頁程式撰寫]] | ||
| + | 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 | ||
| + | |||
| + | Software: | ||
| + | 1. Filezilla | ||
| + | 2. EmEditor | ||
| + | |||
| + | Programs: | ||
| + | 1. form.php | ||
| + | 2. r.php | ||
| + | |||
| + | |||
Copy past code from hand-outs and change personal info to own | 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 | 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 | ||
| 第 14 行： | 第 26 行： | ||
<br/> = Break | <br/> = Break | ||
| + | form.php: | ||
<meta http-equiv='content-type' content='text/html;charset=UTF-8'> | <meta http-equiv='content-type' content='text/html;charset=UTF-8'> | ||
//the above line defines the attributes of this program | //the above line defines the attributes of this program | ||
| 第 26 行： | 第 39 行： | ||
</form> | </form> | ||
//closing bracket of the <from> tab, meaning everything between the two will get sent to r.php for processing | //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 | ||
| + | ?> | ||
| + | |||
| + | |||
| + | |||
| + | Day 2: | ||
| + | |||
| + | Project: Contacts | ||
| + | |||
| + | Files: 網頁程式撰寫 & HTMLeBook | ||
| + | |||
| + | |||
| + | |||
| + | 1. D ✔ | ||
| + | 2. A ✔ | ||
| + | 3. B ✔ | ||
| + | 4. C ✔ | ||
| + | 5. B ✔ | ||
| + | 6. C ✔ | ||
| + | 7. D ✔ | ||
| + | 8. A ✔ | ||
| + | 9. C ✔ | ||
| + | |||
| + | |||
| + | 1. Hyper Text Markup Language, Must have opening and closing brackets | ||
| + | 2. <meta> Defines program content | ||
| + | <i> ''Italic'' | ||
| + | <br> Break | ||
| + | <hr> Thematic break or Horizontal Ruler | ||
| + | <ul> Un-ordered list | ||
| + | <li> List item | ||
| + | 3. Ol & Ul, numbered and dots, div can contain much more information than span | ||
| + | 4. <table> <tr> <td> | ||
| + | 5. <option> <select> & <checked> | ||
2017年9月14日 (四) 11:37的最新修訂版本
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
Software: 1. Filezilla 2. EmEditor
Programs: 1. form.php 2. r.php
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 ?>
Day 2:
Project: Contacts
Files: 網頁程式撰寫 & HTMLeBook
1. D ✔ 2. A ✔ 3. B ✔ 4. C ✔ 5. B ✔ 6. C ✔ 7. D ✔ 8. A ✔ 9. C ✔
1. Hyper Text Markup Language, Must have opening and closing brackets
2. <meta> Defines program content
Italic
Break
Thematic break or Horizontal Ruler
- Un-ordered list
- List item
3. Ol & Ul, numbered and dots, div can contain much more information than span
4.
5. <option> <select> & <checked>
