Wordpressの記事の中で独自のmysqlテーブルを操作する

> mysql -uxxx -pyyy -Dzzz
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.36-community MySQL Community Server (GPL)
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> CREATE TABLE `test_run_post` (
    -> `strkey` varchar(32) ,
    -> `numkey` int         ,
    -> PRIMARY KEY (`strkey`) );
Query OK, 0 rows affected (0.11 sec)
 
mysql>

<?php
global $wpdb;
 
$html = '';
//	delete all table values.
$sql   = 'DELETE FROM `test_run_post`';
$query_result = $wpdb->query($sql);
if($query_result!==false){
	//	OK
	//	insert table values.
	for($ni=1;$ni<10;$ni++){
		$sql   = "INSERT INTO `test_run_post`(`strkey`,`numkey`) values('testkey".$ni."',".$ni.")";
		$query_result = $wpdb->query($sql);
		if($query_result===false){
			$html .= "*** table insert error\n$sql";
			break;
		}
	}
	if(empty($html)){
		//	no-error 
		//	print table values.
		$html .= '<table><tr><td><b>strkey</b></td><td><b>numkey</b></td></tr>';
		$sql   = 'SELECT * FROM `test_run_post`';
		$results = $wpdb->get_results($sql , ARRAY_A);
 
		foreach($results as $row){
			$html .= '<tr><td>'.$row['strkey'].'</td><td>'.$row['numkey'].'</td></tr>';
		}
		$html .= '</table>';
	}
}  else {
	$html .= "*** table delete error\n";
}
 
//	print out results.
echo $html;
?>