php를 이용하여 db에 데이터 입력하기

코딩 순서는

1. db 테이블 및 변수 만들기

2. php 코딩

3. client 코딩

1. mysql 

mysql > create table exam( no INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20), kor INT, eng INT, math INT);

mysql > desc exam;

2. php

/*

쓰기   white.php

/*

<?

$dbh = mysql_connect('localhost','root','apmsetup');

mysql_select_db('timo', &dbh);    //  Mysql 에서 use database 와 동일

if( $dbh)

{

//get

$name = $_GET['name']l;

$kor    = $_GET['kor'];

$eng   = $_GET['eng'];

$math = $_GET['math'];

$query = "INSERT INTO exam VALUES('', '$name','$kor', '$eng', '$math');

// enter key

mysql_query($query, $dbh);

echo "success";

}else{

echo "db fail";

}

?>

/*

읽기  Read.php

*/

<?

$dbh = mysql_connet('localhost','root','apmsetup');

mysql_select_db('timo', $dbh);

if($dbh)

{

// 여기에 코딩한다

// skip 만큼 제외하고 num 만큼 가져오기

$skip = $_GET['skip'];

$num = &_GET['num'];

$query = "SELECT * FROM exam1 order by no desc";

$result = mysql_query($query, $dbh);   // 엔터 쳐서 데이터 가져오기

$head = "<main>";

$body = "";

while( $data = mysql_fetech_array($result))

{

$no = $data['no'];

$name = $data['name'];

$kor = $data[''kor'];

$eng = $data['eng'];

$math = $data['math'];

$body = $body."<data><no>$no</no><name>$name</name><kor>$kor</kor><eng>$eng</eng><math>$math</math></data>";

}

$body = $body."</main>";

echo $head. $body;

}else{

echo "<main><result>fail</result></main>";

}

?>

3. Client 코딩

/*

쓰기

*/

var wLoader : URLLoader = new URLLoder();

var wReq : URLRequest = new URLRequest();

var wVars : URLVariables = new URLVariables();

write_mc.addEventListener( MouseEvent.CLICK, onWrite);

function onWrite( e: MouseEvent ) :void

{

wVars.name = name_txt.text;

wVars.kor = name_txt.text;

wVars.eng = kor_txt.text;

wVars.math = math_txt.text;

wVars.rnd = Math.random();   // 캐쉬 해제

wReq.url = "http://localhost/write.php";

wReq.method = URLRequestMethod.GET;

wReq.data = wVars;

wLoader.adeEventListener( Event.Complete, onWComplete);

wLoader.data(wReq);

}

function onWComplete( e : Event) :void

{

readData();    // 저장된 데이터를 새로 고침하여 다시 보여주기

}

/*

읽기

*/

function readData():void

{

var rLoader : URLLoader = new URLLoader();

var rReq :  URLRequest = new URLRequest();

var rVas : URLVariables = new URLVariables();

rVars.rnd = Math.random();     // 캐쉬 해제

rReq.url = "http://localhost/Read.php";

rReq.method = URLRequesetMethod.GET;

rLoader.addEventListener( Event.COMPLETE, onReadComplete);

rLoader.data(rReq);

}

function onReadComplete( e : Event ) :void

{

var rLoader : URLLOader = e.currentTarget as URLLoader;

var xml:XML = XML(rLoader.data);

for( var  i : int = 0 ; i < xml.data.length() ; i++)

{

var list : ListItem = new ListItem();

list.x = 8;

list.y = 120 + 30 * i;

list.no_txt.text = xml.data[i].no;

list.name_txt.text = xml.data[i].name;

list.kor_txt.text = xml.data[i].kor;

list.eng_txt.text = xml.data[i].eng;

list.math_txt.text = xml.data[i].marh;

addChild(list);

}

}

readData();

※ 에러 메세지

parse error  : 세미콜론을 안찍어서 생기는 문제