/PHP ¶
1.2.1. DB ¶
~cpp $dbconn = mysql_connect("<>", "<근>", "<>"); $is_connect = mysql_select_db("<DB >", <mysql_connect , DB>); // if(<mysql_select_db 공 true, false>){ echo("MySql 결 ."); } else{ echo("connected<br>"); }
1.2.2. query과 그 ¶
~cpp $query = "select name, eng, math from score";// . $result = mysql_query($query, $dbconn); //<결과값> = mysql_query(< >, <DB>); //결과값 2 . $totalRecord = mysql_num_rows($result); //<> = mysql_num_rows(<결과값>); // if( $totalRecord == 0 ){ echo( " ."); }else{ echo("<tr><td></td><td></td><td></td><td></td>"); for($i =0; $i< $totalRecord; $i++){ $name = mysql_result($result, $i, 0); $eng = mysql_result($result, $i, 1); $math = mysql_result($result, $i, 2); $no = $i + 1; echo("<tr><td>$no</td>"); echo("<td>$name</td>"); echo("<td>$eng</td>"); echo("<td>$math</td></tr>"); } }
1.3.2. 기 ¶
- getenv() //경값.
- REMOTE_ADDR: IP
- HTTP_USER_AGENT :
- REMOTE_ADDR: IP
- flush() // // 겠.
- sleep() //windows sleep과 .
- exit() //그 exit()
1.3.4. string ¶
PHP . // 겟.
- addslashes(); // . / .
- strcmp($val1, $val2); // 1 0
- htmlspecilchars(); //& " ' < > HTML 꿔. ex>& -> & " ->"
- nl2br() // n <br> 꾸 .
- explode() // 기 겨. array 겠.
- implode() //explode
~cpp //explode $array_string = explode(" ", $string); //implode $array_string = array("Apple", "Orange", "Banana", "Grape"); $string = implode(" or ", $array_string);
- substr($, , ) // 길 . excel middle과 . substr($string, 0, 5);
- strlen() //C .
- str_replace("", "", $) // replace
- ord() // ascii값
- chr() // ascii 값