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

出自六年制學程
跳轉到： 導覽、 搜尋
 
（未顯示同用戶所作出之5次版本）
第 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
 +
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
 +
?>
 +
 +
 +
 +
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>

取自「http://jendo.org/wiki1231/index.php?title=網頁程式撰寫/2017/黃柏實&oldid=33980」