EVOLUTION-NINJA

Edit File: Update.php

<?php 
namespace App\Controllers\Subscription;
use App\Controllers\BaseController;
use CodeIgniter\RESTful\ResourceController;
use CodeIgniter\API\ResponseTrait;
use App\Models\RegisterUserModel;

class Update extends BaseController
{
    public function index()
    {

// $newEndingDate = date("Y-m-d", strtotime(date("Y-m-d") . " + 365 day"));
        // echo $newEndingDate;
        // die();
        // $date = array(    
        //     'suscription_till'=>'2023-12-31',
        // );
        // $model = new RegisterUserModel(); 
        // $model->set($date);
        // $model->where('created_at <','2023-01-01');
        // $update = $model->update();

// $model1 = new RegisterUserModel();
        // $model1->where('created_at >=','2023-01-01');
        // $model1->where('valid_user','1');
        // $model1->select('*');
        // $all_user  = $model1->get()->getResultArray();

// foreach ($all_user as $key => $value) {

//     $id = $value['id'];
        //     $adding_date = $value['created_at'];
        //     $new_date = date('Y-m-d',strtotime($adding_date . " + 365 day"));
        //     $date1 = array(    
        //         'suscription_till'=>$new_date,
        //     );

//     $model = new RegisterUserModel(); 
        //     $model->set($date1);
        //     $model->where('id',$id);
        //     $update = $model->update();
        // }

//$oneYearOn = date('Y-m-d',strtotime(date("Y-m-d", mktime()) . " + 365 day"));

$db = \Config\Database::connect();
        $query = $db->getLastQuery();
        echo $query;
    }
}