::::::통합 APM 설치하기 :::::::::::::::::::::::::
:::::::테스트.PHP:::::::::::::::::::::::::::::::::::
$connect=mysql_connect(``localhost``,``root``,``apmsetup``);
$db=mysql_select_db(``test``,$connect);
$query=``create table memo(
num int not null,
name varchar(20) not null,
memo varchar(100) not null)``;
$result=mysql_query($query,$connect);
if($result){
echo ``테이블 생성 성공!``;
}else {
echo ``테이블 생성 실패!``;
}
?>
.......................................................
***위문서를 C:APM_Setup\htdocs\폴더속에 db.php저장한다.
:::::::MYSQL작업해주기:::::::::::::::::::::::::::::::::::::
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\Documents and Settings\Administrator>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.0.21-nt
Type `help;` or `\h` for help. Type `\c` to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
+----------+
1 row in set (0.05 sec)
mysql> create database test;
Query OK, 1 row affected (0.02 sec)
mysql> show tables;
ERROR 1046: 선택된 데이타베이스가 없습니다.
mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| memo |
+----------------+
1 row in set (0.00 sec)
mysql> desc memo;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| num | int(11) | | | 0 | |
| name | varchar(20) | | | | |
| memo | varchar(100) | | | | |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.02 sec)
mysql>
mysql>
mysql>
::::::::::: 연결테스트하기:::::::::::::::::::::::::::::::
http://localhost/db.php
##############2교시####################
---정리노트---
i
---문서를 memoinput.html저장하세요--------------------
(C:APM_Setup\htdocs\폴더속에 memoinput.html저장)
메모입력
| 
방송
