U E D R , A S I H C RSS

이승한/mysql

한/mysql

PHP 한 mysql .

mysql .
ASP.net <form> PHP HTML .
. mysql -u root -p (u: user, p: password)
MySql
  • MySql
  • PHP MySql API 함

mysql - - 테. //mysql - 테 . // .

: show databases; ( s .)
: create database ;
: drop database ;
택하 : use ;

: create table 테( type(크), eng integer, date date);
: drop table 테;
: show tables;
: show colums from 테;
: ??;

key

: index, unique, primary
: add index (, );

<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 <>

<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);
	}
?>
 

Thread

Valid XHTML 1.0! Valid CSS! powered by MoniWiki
last modified 2021-02-07 05:30:31
Processing time 0.0149 sec