MySQL : PHP로 만든 폼에서 입력 및 출력, 확인. another exercise..

웹에서 데이타 입력하고, 나타내기.

===============================================

1. j_form.php	invalid-file
2. db_info.php	invalid-file
3. j_insert.php	invalid-file
4. j_list.php	invalid-file

===============================================

1. 테이블 만들기.

create table jusolist (
no int(11) not null auto_increment,
name varchar(30),
tel varchar(40),
juso varchar(50),
email varchar(30),
primary key (no)
);

 

 

mysql> create table jusolist (
    -> no int(11) not null auto_increment,
    -> name varchar(30),
    -> tel varchar(40),
    -> juso varchar(50),
    -> email varchar(30),
    -> primary key (no)
    -> );
Query OK, 0 rows affected (0.11 sec)

mysql> desc jusolist;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| no    | int(11)     |      | PRI | NULL    | auto_increment |
| name  | varchar(30) | YES  |     | NULL    |                |
| tel   | varchar(40) | YES  |     | NULL    |                |
| juso  | varchar(50) | YES  |     | NULL    |                |
| email | varchar(30) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
5 rows in set (0.03 sec)