php + mysql 쿼리문 활용 기초 방법

#### php + mysql
1. 레코드셋 - 단일 row

	$sql = "select * from {$g5['event_master_table']} WHERE isUse='T' and ('$event_today' between ev_startdate and ev_enddate) limit 1;";
	$evm = sql_fetch($sql);

	$ev_id = $evm['ev_id'];

2. 레코드셋 list row

	$sql = "select * from {$g5['event_table']} where ev_id='{$evm_id}'";
	$result = sql_query($sql);
	$row = sql_fetch($sql);
	for ($i=0; $row=sql_fetch_array($result); $i++) {
		$evs_img = $row['evs_img'];
	}

3. insert
	$sql = " insert {$g5['event_table']}
					set ev_id ='$ev_id',
						evs_title = '$evs_title',
						evs_subject = '$evs_subject',
						evs_order = '$evs_order',
						wr_ids = '$wr_ids' ";
	sql_query($sql);

    $evs_id = sql_insert_id();

4. update

    $sql = " update {$g5['event_table']}
                set evs_title = '$evs_title',
					evs_subject = '$evs_subject',
					evs_order = '$evs_order',
					wr_ids = '$wr_ids'
              where evs_id = '$evs_id' ";
    sql_query($sql);

5. delete

	$sql = " delete from {$g5['event_table']} where evs_id = '$evs_id' ";
    sql_query($sql);

6. 테이블이 있는지 검사한다.
	if (!sql_query(" DESCRIBE {$g5['event_master_table']} ", false)) {
		$query_cp = sql_query(
			" CREATE TABLE IF NOT EXISTS `{$g5['event_master_table']}` (
					  `ev_id` int(11) NOT NULL AUTO_INCREMENT,
					  `ev_title` varchar(200) NULL,
					  `ev_startdate` varchar(10) NULL,
					  `ev_enddate` varchar(10) NULL,
					  `isUse` char(1) NOT NULL DEFAULT 'F',
					  PRIMARY KEY (`ev_id`)
					) ENGINE=MyISAM DEFAULT CHARSET=utf8 ",
			true
		);
	}

7. 레코드셋 count, paging
	$sql = " select count(*) as cnt from {$g5['event_master_table']}";
	$row = sql_fetch($sql);
	$total_count = $row['cnt'];

	$rows = 10;		//라인수
	$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
	if ($page < 1) {
		$page = 1;
	} // 페이지가 없으면 첫 페이지 (1 페이지)
	$from_record = ($page - 1) * $rows; // 시작 열을 구함

	$sql = "select * $sql_common order by ev_id desc limit $from_record, {$config['cf_page_rows']} ";
	$result = sql_query($sql);

	for ($i = 0; $row = sql_fetch_array($result); $i++) {
		//서브 카운트
		$sql1 = " select COUNT(*) as cnt from {$g5['event_table']} where ev_id = '{$row['ev_id']}' ";
		$row1 = sql_fetch($sql1);
		$cnt = $row1['cnt'];		//서브카운트

		$ev_id = $row['ev_id'];
	}​

출처 : 나