/**
 * Plugin Name: BMI Calculator
 * Description: BMI Calculator To Content
 */
function BmiCalculator() { return 'BMI Calculator'; }
add_shortcode('GenBmiCal', 'BmiCalculator');
// https://www.thaiall.com/perlphpasp/source.pl?key=9152
/**
 * Plugin Name: My First Plugin
 * Plugin URI: http://www.mywebsite.com/my-first-plugin
 * Description: The very first plugin that I have ever created.
 * Version: 1.0
 * Author: Your Name
 * Author URI: http://www.mywebsite.com
 */
/*
  plugin นี้จะเพิ่มข้อความต่อท้าย $content
  มีตัวอย่างโค้ดที่ https://www.wpbeaverbuilder.com/creating-wordpress-plugin-easier-think/
  ใน filter : the_content
  และมี filter อื่น ๆ ที่ https://codex.wordpress.org/Plugin_API/Filter_Reference
*/
add_action( 'the_content', 'my_thank_you_text' );
function my_thank_you_text ( $content ) { return $content .= 'Thank you for reading!'; }

/**
 * Plugin Name: Read WP Posts
 * Description: Read WP Posts
 */ 
function ReadWPPosts() { 
	$path = $_SERVER['DOCUMENT_ROOT'];
	include_once $path . '/wordpress/wp-load.php';
	include_once $path . '/wordpress/wp-config.php';
	$db = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	if (mysqli_connect_errno()){
		exit("Couldn't connect to the database: ".mysqli_connect_error());
	}
	$sql = "select * from wp_posts";
	$res = mysqli_query($db, $sql);
	if ($res) {
		while ($row = $res -> fetch_assoc()) {			 
			$sql .= "\n".$row["ID"]." ".$row["post_title"]; // case sensitive
		}
	}
	mysqli_close($db);
	return $sql . 'ok';
}
add_shortcode('GenReadPosts', 'ReadWPPosts');