I am hero from Zero หลังจากที่ผมเข็น wordpress ขึ้นภูเขามาตั้งนาน ตอนนี้มันกลายมาวิ่งเล่นบนฝ่ามือของผมเป็นที่เรียบร้อยแล้วครับทุกคนน

<?php
/**
* Plugin Name: Publisher Map
* Description: Gen map for the publisher.
* Version: 1.0
* Author: Kok Jarukit
* Author URI: https://kokdev.com
*/

require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
include_once("wp-config.php");
include_once("wp-includes/wp-db.php");

function pbmap_install() {
	global $wpdb;
	$wpdb->set_charset($wpdb->dbh, 'utf8');
	global $pbmap_db_version;

	$pbmap_table_name_first = $wpdb->prefix . 'pbmap_maps';
	$charset_collate = $wpdb->get_charset_collate();
	
	$sqlForMaps = "CREATE TABLE IF NOT EXISTS $pbmap_table_name_first (
		`id` int(11) NOT NULL AUTO_INCREMENT,
        `user_id` int(11) NOT NULL,
		`wpgmza_id` int(11) NOT NULL,
		PRIMARY KEY (`id`)
	) $charset_collate;";
	dbDelta( $sqlForMaps );
}

register_activation_hook( __FILE__, 'pbmap_install' );

add_shortcode( 'list_publisher_db', 'render_list_publisher_db');

function render_list_publisher_db(){ 
	try {
		$user = wp_get_current_user();
		$user_id=null;
	    if(isset($user->ID)){
	        $user_id = $user->ID;
	    }
		global $wpdb;
		$sql = "SELECT pb.id, pb.user_id, pb.wpgmza_id, gm.title, gm.description, gm.address, gm.lat, gm.lng FROM V0pAl_pbmap_maps AS pb LEFT JOIN V0pAl_wpgmza AS gm ON pb.wpgmza_id = gm.id WHERE pb.user_id = $user_id";
		$row = $wpdb->get_results( $sql );
		$results = json_decode(json_encode($row));
		$size = count($results);
	?>
		<div class="content pb-0">
		<div class="orders">
		   <div class="row">
			  <div class="col medium-12 small-12 large-12">
				 <div class="card">
					<div class="card-body">
					   <h2 class="box-title">ตำแหน่งสำนักพิมพ์ของคุณ </h2>
					   <h5 style="text-align:end;"><a href="/add-maps-form">เพิ่มตำแหน่งสำนักพิมพ์</a> </h5>
					</div>
					<?php if($size > 0) {?>
					<div class="card-body--">
				   <div class="table-stats order-table ov-h">
					  	<table class="table ">
						 	<thead>
								<tr>
								   <th class="serial">#</th>
								   <th>ID</th>
								   <th>title</th>
								   <th>description</th>
								   <th>address</th>
								   <th>Lattitude</th>
								   <th>Longtitude</th>
								   <th></th>
								</tr>
						 	</thead>
							<tbody>
								<?php 
								foreach ($results as $result) {
								?>
								<tr>
								   <td class="serial"><?php echo $i?></td>
								   <td><?php echo $result->id ?></td>
								   <td><?php echo $result->title ?></td>
								   <td><?php echo $result->description ?></td>
								   <td><?php echo $result->address ?></td>
								   <td><?php echo $result->lat ?></td>
								   <td><?php echo $result->lng ?></td>
								   <td>
									<?php
									echo "<button type='button'><span class='badge badge-delete'><a href='?type=delete&id=". $result->wpgmza_id ."'>ลบ</a></span></button>";
									?>
								   </td>
								</tr>
								<?php } ?>
						 	</tbody>
					  	</table>
				   </div>
					</div>
					<?php } ?>
				 </div>
			  </div>
		   </div>
		</div>
		</div>
	<?php
	} catch (Exception $e) {
		return $e->getMessage();
	}
}

<?php
/**
* Plugin Name: Publisher Map
* Description: Gen map for the publisher.
* Version: 1.0
* Author: Kok Jarukit
* Author URI: https://kokdev.com
*/

require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
include_once("wp-config.php");
include_once("wp-includes/wp-db.php");

$user_id = null;

function pbmap_install() {
	global $wpdb;
	$wpdb->set_charset($wpdb->dbh, 'utf8');
	global $pbmap_db_version;

	$pbmap_table_name_first = $wpdb->prefix . 'pbmap_maps';
	$charset_collate = $wpdb->get_charset_collate();
	
	$sqlForMaps = "CREATE TABLE IF NOT EXISTS $pbmap_table_name_first (
		`id` int(11) NOT NULL AUTO_INCREMENT,
        `user_id` int(11) NOT NULL,
		`wpgmza_id` int(11) NOT NULL,
		PRIMARY KEY (`id`)
	) $charset_collate;";
	dbDelta( $sqlForMaps );
}

register_activation_hook( __FILE__, 'pbmap_install' );


add_shortcode( 'list_publisher_db', 'render_list_publisher_db');
function render_list_publisher_db(){ 
	try {
		$user = wp_get_current_user();
		$user_id=null;
	    if(isset($user->ID)){
	        $user_id = $user->ID;
	    }
		global $wpdb;
		$sql = "SELECT pb.id, pb.user_id, pb.wpgmza_id, gm.title, gm.description, gm.address, gm.lat, gm.lng FROM V0pAl_pbmap_maps AS pb LEFT JOIN V0pAl_wpgmza AS gm ON pb.wpgmza_id = gm.id WHERE pb.user_id = $user_id";
		$row = $wpdb->get_results( $sql );
		$results = json_decode(json_encode($row));
		$size = count($results);
	?>
		<div class="content pb-0">
		<div class="orders">
		   <div class="row">
			  <div class="col medium-12 small-12 large-12">
				 <div class="card">
					<div class="card-body">
					   <h2 class="box-title">ตำแหน่งสำนักพิมพ์ของคุณ </h2>
					   <h5 style="text-align:end;"><a href="/add-maps-form">เพิ่มตำแหน่งสำนักพิมพ์</a> </h5>
					</div>
					<?php if($size > 0) {?>
					<div class="card-body--">
				   <div class="table-stats order-table ov-h">
					  	<table class="table ">
						 	<thead>
								<tr>
								   <th class="serial">#</th>
								   <th>ID</th>
								   <th>title</th>
								   <th>description</th>
								   <th>address</th>
								   <th>Lattitude</th>
								   <th>Longtitude</th>
								   <th></th>
								</tr>
						 	</thead>
							<tbody>
								<?php 
								foreach ($results as $result) {
								?>
								<tr>
								   <td class="serial"><?php echo $i?></td>
								   <td><?php echo $result->id ?></td>
								   <td><?php echo $result->title ?></td>
								   <td><?php echo $result->description ?></td>
								   <td><?php echo $result->address ?></td>
								   <td><?php echo $result->lat ?></td>
								   <td><?php echo $result->lng ?></td>
								   <td>
									<?php
									echo "<button type='button'><span class='badge badge-delete'><a href='?type=delete&id=". $result->wpgmza_id ."'>ลบ</a></span></button>";
									?>
								   </td>
								</tr>
								<?php } ?>
						 	</tbody>
					  	</table>
				   </div>
					</div>
					<?php } ?>
				 </div>
			  </div>
		   </div>
		</div>
		</div>
	<?php
	} catch (Exception $e) {
		return $e->getMessage();
	}
}

?>