lib my old.php

• com_db.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 arr2table

function arr2table($arr, $table_name) {
	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('wrap', $values);

		$keys_str = implode(',', $keys);
		$values_str = implode(',', $values);
		query("INSERT INTO $table_name ($keys_str) VALUES ($values_str)");
	}
}

3 query

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

4 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];
}

5 query_arr

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

6 wrap

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