Lib my old.php

1 global

$link = mysql_connect('localhost', '계정명', '패스워드');
if(!$link) die('Could not connect: ' . mysql_error());
$db = mysql_select_db('디비명', $link);
if(!$db) die ('Can\'t 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 wrap

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