google_forms/application/models/Frontend_model.php

<?php

defined('BASEPATH') or exit('No direct script access allowed');

class Frontend_model extends CI_Model
{
    public function getforms()
    {
        // Get the user_id from session
        $user_id = $this->session->userdata('user_id');

        // Ensure user_id is set
        if (!$user_id) {
            return [];
        }

        // Filter forms by user_id and order by created_at in descending order
        $this->db->where('user_id', $user_id);
        $this->db->order_by('created_at', 'DESC');
        $query = $this->db->get('forms');

        return $query->result(); // Return the result as an array of objects
    }

    public function deleteForm($id)
    {
        return $this->db->delete('forms', ['id' => $id]);
    }
    public function getFormById($form_id)
    {
        $query = $this->db->get_where('forms', ['id' => $form_id]);
        return $query->row_array();
    }
    public function getforms_draft($user_id)
    {
        $this->db->where('is_published', 0);
        $this->db->where('user_id', $user_id);
        $this->db->order_by('created_at', 'DESC');
        $query = $this->db->get('forms');
        return $query->result();
    }
}