story of my life

<?php

require 'vendor/autoload.php';//絶対パスが宜しいかと

use Illuminate\Database\Capsule\Manager as Capsule;
use Illuminate\Database\Capsule\Manager as DB;
use Illuminate\Database\Schema\Blueprint;

class counter
{
    public $targetId = 1;
    public $cnt = 0;
    public $dbPath = 'counter/cnt.db';//絶対パスが宜しいかと

    public function __construct($dbPath = null,$targetId=null)
    {
        $dbPath = $dbPath ?? $this->dbPath;
        $this->targetId = $targetId??$this->targetId;

        // DBファイルが無ければ作成（空ファイル）
        if (!file_exists($dbPath)) {
            touch($dbPath);
        }

        // Capsuleインスタンス
        $capsule = new Capsule();

        // SQLite接続
        $capsule->addConnection([
            'driver'   => 'sqlite',
            'database' => $dbPath,
            'prefix'   => '',
        ]);

        $capsule->setAsGlobal();
        $capsule->bootEloquent();

        /**
         * zcnt テーブルが無ければ作成
         */
        if (!DB::schema()->hasTable('cnt_tbl')) {
            DB::schema()->create('cnt_tbl', function (Blueprint $table) {
                $table->integer('id')->primary();
                $table->integer('cnt');
            });

            // 初期データ投入
            DB::table('cnt_tbl')->insert([
                'id'  => $this->targetId,
                'cnt' => 1,
            ]);
        }

        return $this;
    }

    public function getCounter()
    {
        $zcnt = DB::table('cnt_tbl')->where('id', $this->targetId)->first();
        $this->cnt = $zcnt?->cnt;
        return $this;
    }

    public function setCounter()
    {
        if (!is_null($this->cnt)) {
            $this->cnt++;
            DB::table('cnt_tbl')->where('id', $this->targetId)->update([
                'cnt' => $this->cnt
            ]);
        }
    }

    public function output()
    {
        print json_encode([
            'cnt' => $this->cnt
        ]);
    }
}