How to use your original mysql table in Wordpress post.

This time, I will show how to use (search, update, etc.) your original mysql table in WordPress post.

You know how to use mysql tables for WordPress. So, you may use some WordPress API(TAG).

But can you use your original mysql table ( not provided by WordPress ) ?
This way only uses WordPress API(TAG) too. It is very easy.

The following will show how to use WordPress API(TAG) for it.

1st step, runPHP and create table for test

1st step, you should install the plugin for use php in WordPress post.
I wrote the post before about it.( See ;WordPress in PHP to run the article )

Also, you should create original mysql table for test.

The following example, I create simple sample mysql table for test.

* You may use the following example, If you can log on your web-server by SSH (or telnet).

But if you can not log on , you should use phpAdmin. So, you should run only the following SQL for table create.

1
2
3
4
5
6
7
8
9
10
11
12
13
14

> 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>

CREATE TABLE `test_run_post` (
  `strkey` varchar(32) ,
  `numkey` int         ,
  PRIMARY KEY (`strkey`) );

How to use your original mysql table in WordPress post

You will write php codes for operation your original mysql table in WordPress post.

The following table records removed for testing and record addition, record an example reference is made.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

<?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;
?>

The following will actually work with it.

You might also like:

• How to search table name with MySQL
• How to get last insert auto increment id.
• One single database for multiple WordPress, Joomla! To operate
• HTML to adjust the width
• how to sort post with WordPress

2 Responses to “How to use your original mysql table in WordPress post.”

1. Neethu
   July 19th, 2011 @ 20:51:09

   Good one.This is veryhelpful for the wordpress beginners.Thanks for such a interesting tutorial.

2. taro
   August 4th, 2011 @ 17:55:52

   This is Admin.
   Thanks.

Leave a Reply