Webサイトでライブ情報をデータベース化して自動表示する－PHP、MySQL

<?php
function get_db(){
    $dsn = "mysql:host=".DB_HOST.";dbname=".DB_NAME.";charset=".DB_CHARSET;
    try{
        // DB接続
        $db = new PDO($dsn, DB_USER, DB_PASSWORD);
    }catch (PDOException $e){
        echo "Error:".$e->getMessage();
        die();
    }
    return $db;
}

<?php
function get_live($hi){
    global $vars_db;
    $today = date("Ymd");
    $data = array();
    $week = array("日", "月", "火", "水", "木", "金", "土");

    if($hi != ''){
        $where = "live_sche.live_date = '$hi'";
    }else{
        $where = "live_sche.live_date > '$today'";
    }
    
    $sql = "SELECT * 
            FROM live_sche 
                LEFT OUTER JOIN m_live_place ON live_sche.live_place_id = m_live_place.live_place_id 
            WHERE {$where}";
    $res = $vars_db->query($sql);
    if(!$res){
        echo "res error";
    }else{
        $data = $res->fetchAll(PDO::FETCH_ASSOC);
    }

    $data_cnt = count($data);
    if($data_cnt > 0){
        for($i = 0; $i < $data_cnt; $i++){
            // 年月日
            $data[$i]['y'] = intval(substr($data[$i]['live_date'], 0, 4));
            $data[$i]['m'] = intval(substr($data[$i]['live_date'], 4, 2));
            $data[$i]['d'] = intval(substr($data[$i]['live_date'], 6, 2));
            $data[$i]['youbi'] = $week[date("w",mktime(0,0,0,$data[$i]['m'],$data[$i]['d'],$data[$i]['y']))];
        }
    }
    return array($data_cnt,$data);
}

<?php
require_once "../blog/wp-config.php";
require_once "../func_db.php";
require_once "../func_live.php";
require_once "../smarty/smarty-4.3.4/libs/Smarty.class.php";
$smarty = new Smarty();
$smarty->template_dir = "./templates/";
$smarty->compile_dir = "./templates_c/";
$smarty->config_dir = "./config/";
$smarty->caching = "./cache/";

$vars_db = get_db();

list($data_cnt,$data) = get_live('');

if($data_cnt == 0){
}else{
  for($i = 0; $i < $data_cnt; $i++){
	  $data[$i]['img_url'] = "../live/".$data[$i]['y']."/img/".$data[$i]['live_date'].".webp";
   }
}

$vars_db = null;

html_out:

$smarty->assign([
	        "t_data_cnt" => $data_cnt,
    			"t_data" => $data,
        ]);

$smarty->display("index.tpl");

{if $t_data_cnt == 0}
    <p class="al_c"><br><br>ライブの予定は未定です<br><br><br></p>
{else}
    {foreach from=$t_data key=k item=dt}
        {if $k > 0}
            <hr /><br>
        {/if}
        <p class="al_c">{$dt.y}. <span class="b pt25">{$dt.m}.{$dt.d}</span>（{$dt.youbi}）</span></p>
        <p class="al_c pt25">『 {$dt.live_name} 』</p>
        <p class="al_c"><img src="https://vasofatum.jp/{$dt.img_url}" alt="{$dt.live_name}" width="424" height="600" style="width:100%;max-width:500px;"></p>
        <p> </p>
        <p class="al_c">【 会場 】<br>{$dt.live_place}{if $dt.prefecture!=''}<br>（{$dt.prefecture}）{/if}</p>
        <p class="al_c">OPEN {$dt.live_open} / START {$dt.live_start}</p>
        <p> </p>
        {if $dt.booking_band != ''}
            <p class="al_c">【 出演 】<br>{$dt.booking_band}</p>
            <p> </p>
        {/if}
        {if $dt.stream > 0}
    		<p class="al_c">【 配信チケット 】<br>¥{$dt.stream|number_format}</p>
        {/if}
        {if $dt.advance > 0}
		    <p class="al_c">【 会場チケット 】<br>前売 ¥{$dt.advance|number_format} / 当日 ¥{$dt.at_the_door|number_format} {if $dt.one_drink>0}<br>(＋1DRINK ¥{$dt.one_drink}){/if}</p>
            <p> </p>
        {/if}
        {if $dt.stream > 0}
            <p class="al_c">↓配信チケットはこちら↓</p>
            <p class="al_c"><a href="live_twitcasting.php?hi={$dt.live_date}"><img src="img/ticket-twicas.png" alt="ツイキャスチケット" style="margin-left:10px;width:200px;"></a></p>
            <p> </p>
        {/if}
        <p class="al_c">↓会場チケットはこちら↓</p>
        <p class="al_c"><a href="ticket.php?hi={$dt.live_date}"><img src="img/ticket-django.png" alt="VARSライブ会場チケット" style="margin-left:10px;width:200px;"></a></p>
        <p> </p>
        {if $dt.map != ''}
            <p class="al_c">{if $dt.live_place_site_url != ''}<a href="https://k-django.jp/" target="_blank" rel="noopener noreferrer">{/if}{$dt.live_place}{if $dt.live_place_site_url != ''}</a>{/if}へのアクセスはこちら↓</p>
            <div class="v-wrap al_c">{$dt.map}</div>
            <p> </p>
        {/if}
    {/foreach}
{/if}