lib my.php

• com_idb.php

1 global

$mysqli = new mysqli('localhost', '계정명', '패스워드', '디비명');
if($mysqli->connect_errno) die "Connect failed: ".$mysqli->connect_error;
$mysqli->query("SET NAMES 'utf8'");

2 query

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

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

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

5 query_all

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

6 single_quotes

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

==insert_rows==
<source lang='php'>
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)");
	}
}

7 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>";
}

</source>