한/mysql ¶
PHP 한 mysql .
¶
: show databases; ( s .)
: create database ;
: drop database ;
택하 : use ;
: create database ;
: drop database ;
택하 : use ;
테 ¶
파 테 하 : create table 테( type(크), eng integer, date date);
테 : drop table 테;
테 : show tables;
테 항 : show colums from 테;
테 : ??;
테 : drop table 테;
테 : show tables;
테 항 : show colums from 테;
테 : ??;
key ¶
<SQL> ¶
: insert into table (colums...) values (data...);
: delete from <table> where <>;
테 키 : delete from score;
테 : select * from score; // * .
: update <tableName> set <colum Name> = <update val> where <>
: delete from <table> where <>;
테 키 : delete from score;
테 : select * from score; // * .
: update <tableName> set <colum Name> = <update val> where <>
<PHP API> ¶
DB파 . // xpweek 했 java 향 한 .
~cpp <? $dbconn = mysql_connect("localhost", "<userName>", "<userPassword>"); //localhost . $is_connect = mysql_select_db("beonit", $dbconn); if(!$is_connect) { echo("MySql 패하."); } else{ echo("Hello Mysql"); } ?>
~cpp <? include "connect.inc"; //DB하 헤 $query = "select name, eng, math from score"; $result = mysql_query($query, $dbconn); $totalRecord = mysql_num_rows($result); for($i =0; $i< $totalRecord; $i++){ $name = mysql_result($result, $i, 0); echo("$name"); } if( $totalRecord == 0 ){ echo( " ."); } ?>
~cpp <? if(!$mode) { $mode = "form"; } if(!strcmp($mode, "form")) { ?> <form name = "write_form" method = "post" action = "./new.html?mode=process"> : <input type = "text" name = "name" size = "10"><br> : <input type = "text" name = "eng" size = "5"><br> 학 : <input type = "text" name = "math" size = "5"><br> <input type = "submit" value = " "> </form> <? } else if(!strcmp($mode, "process")) { $query = "insert into score (name, eng, math) values ('$name', '$eng', '$math')"; $result = mysql_query($query, $dbconn); } ?>