define('PLUGIN_COUNTER_DB_CONNECT_STRING', 'sqlite:counter/counter.db');
define('PLUGIN_COUNTER_DB_USERNAME', '');
define('PLUGIN_COUNTER_DB_PASSWORD', '');
define('PLUGIN_COUNTER_DB_CONNECT_STRING', 'sqlite:counter/counter.db');
define('PLUGIN_COUNTER_DB_USERNAME', '');
define('PLUGIN_COUNTER_DB_PASSWORD', '');
-define('PLUGIN_COUNTER_DB_OPTIONS', null);
+$plugin_counter_db_options = null;
+// For MySQL
+// $plugin_counter_db_options = array(PDO::MYSQL_ATTR_INIT_COMMAND =>
+// "SET NAMES utf8mb4 COLLATE utf8mb4_bin");
try {
$pdo = new PDO(PLUGIN_COUNTER_DB_CONNECT_STRING,
PLUGIN_COUNTER_DB_USERNAME, PLUGIN_COUNTER_DB_PASSWORD,
try {
$pdo = new PDO(PLUGIN_COUNTER_DB_CONNECT_STRING,
PLUGIN_COUNTER_DB_USERNAME, PLUGIN_COUNTER_DB_PASSWORD,
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$pdo->setAttribute(PDO::ATTR_TIMEOUT, 5);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$pdo->setAttribute(PDO::ATTR_TIMEOUT, 5);
* php -r "include 'plugin/counter.inc.php'; plugin_counter_tool_setup_table();"
*/
function plugin_counter_tool_setup_table() {
* php -r "include 'plugin/counter.inc.php'; plugin_counter_tool_setup_table();"
*/
function plugin_counter_tool_setup_table() {
$page_counter_t = PLUGIN_COUNTER_DB_TABLE_NAME_PREFIX . 'page_counter';
$pdo = new PDO(PLUGIN_COUNTER_DB_CONNECT_STRING,
PLUGIN_COUNTER_DB_USERNAME, PLUGIN_COUNTER_DB_PASSWORD,
$page_counter_t = PLUGIN_COUNTER_DB_TABLE_NAME_PREFIX . 'page_counter';
$pdo = new PDO(PLUGIN_COUNTER_DB_CONNECT_STRING,
PLUGIN_COUNTER_DB_USERNAME, PLUGIN_COUNTER_DB_PASSWORD,
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$r = $pdo->exec(
"CREATE TABLE $page_counter_t (
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$r = $pdo->exec(
"CREATE TABLE $page_counter_t (
total INTEGER NOT NULL,
update_date VARCHAR(20) NOT NULL,
today_viewcount INTEGER NOT NULL,
total INTEGER NOT NULL,
update_date VARCHAR(20) NOT NULL,
today_viewcount INTEGER NOT NULL,