lib my old.php

lib_my.php

• mysql용 PHP 함수 모음
• 구식이므로 lib_my.php 사용을 권장함

1 global

$link = mysql_connect('localhost', '계정명', '패스워드');
if(!$link) die('Cannot connect: ' . mysql_error());
$db = mysql_select_db('디비명', $link);
if(!$db) die ('Cannot use db: ' . mysql_error());
mysql_set_charset('utf8', $link);

2 insert_rows

function insert_rows($arr, $table_name, $mode='APPLY') {
	foreach($arr as $row) {
 
		$keys = array_keys($row);
		$keys = array_map('mysql_real_escape_string', $keys);
 
		$values = array_values($row);
		$values = array_map('mysql_real_escape_string', $values);
		$values = array_map('single_quotes', $values);
 
		$keys_str = implode(',', $keys);
		$values_str = implode(',', $values);
 
		if($mode == 'TEST') echo "INSERT INTO $table_name ($keys_str) VALUES ($values_str);<br/>";
		else query("INSERT INTO $table_name ($keys_str) VALUES ($values_str)");
	}
}

3 print_rows

function print_rows($rows) {
	echo "<table><tr>";
	foreach($rows[0] as $key => $value) {
		echo "<th>$key</th>";
	}
	echo "</tr>";
	foreach($rows as $row) {
		echo "<tr>";
		foreach($row as $key => $value) {
			echo "<td>$value</td>";
		}
		echo "</tr>";
	}
	echo "</table>";
}

4 query

function query($qry, $mode='APPLY')
{
	if($mode == 'TEST') {
		echo "<font color=red>$qry;</font><br />";
		return;
	}
	if($mode == 'SHOW')echo "$qry<br>";
	$result = mysql_query($qry);
	if($result === FALSE) die("query_error ($qry)");
	return $result ;
}

5 query_one

function query_one($qry) {
	$result = mysql_query($qry);
	if($result === false) die("query_error [ $qry ] message : ".mysql_error());
	$row = mysql_fetch_array($result, MYSQL_NUM);
	return $row[0];
}

6 query_arr

function query_arr($query) {
	$result = mysql_query($query);
	if($result === false) die("query_error [ $query ] message : ".mysql_error());
	$arr = array();
	while($row = mysql_fetch_array($result, MYSQL_NUM)) $arr[] = $row[0];
	return $arr;
}

7 query_rows

function query_rows($query) {
	$result = mysql_query($query);
	if($result === false)	die("query_error [ $query ] message : ".mysql_error());
	$rows= array();
	eval('while(@$row = mysql_fetch_assoc($result)) array_push($rows, $row);');
	return $rows;
}

8 single_quotes

function single_quotes($value) {
	return "'$value'";
}

9 같이 보기

• lib_my.php