Welcome Guest, Not a member yet? Register   Sign In
Model files in CI4
#14

Got it!
I must use $this->db->query($sql);
So, now my Model is:

<?php
namespace App\Models;
use CodeIgniter\Database\ConnectionInterface;

class M_Comuni_2db
{
protected $db;
public function __construct()
{
$this->db = \Config\Database::connect();
}
public function leggi_lingue($lingua = FALSE)
{
if ($lingua === FALSE)
{
$sql = "SELECT * FROM AA_Tabella1";
$query = $this->db->query($sql);
$Risultato_Obj = $query->getResultObject();
}
else
{
$sql = "SELECT * FROM AA_Tabella1 where Lingua='".$lingua."'";
$query = $this->db->query($sql);
$Risultato_Obj = $query->getRow();
}
$query->freeResult();
return $Risultato_Obj;
}
}

It works.

I'll check if the Query Builder Class can work here too. If not, I can maybe make my own class for setting up the $sql string.
Reply


Messages In This Thread
Model files in CI4 - by Filippo65 - 07-06-2021, 10:39 AM
RE: Model files in CI4 - by MGatner - 07-07-2021, 06:14 AM
RE: Model files in CI4 - by paliz - 07-07-2021, 09:17 AM
RE: Model files in CI4 - by Filippo65 - 07-12-2021, 10:06 AM
RE: Model files in CI4 - by includebeer - 07-12-2021, 03:44 PM
RE: Model files in CI4 - by InsiteFX - 07-12-2021, 09:04 PM
RE: Model files in CI4 - by davis.lasis - 07-13-2021, 03:29 AM
RE: Model files in CI4 - by Filippo65 - 07-14-2021, 11:18 AM
RE: Model files in CI4 - by includebeer - 07-14-2021, 02:23 PM
RE: Model files in CI4 - by Filippo65 - 07-19-2021, 10:57 AM
RE: Model files in CI4 - by includebeer - 07-19-2021, 02:45 PM
RE: Model files in CI4 - by Filippo65 - 07-20-2021, 10:52 AM
RE: Model files in CI4 - by Filippo65 - 07-20-2021, 12:47 PM
RE: Model files in CI4 - by Filippo65 - 07-21-2021, 10:30 AM
RE: Model files in CI4 - by includebeer - 07-23-2021, 04:52 AM
Model files in CI4 - by Filippo65 - 08-20-2021, 09:28 AM
RE: Model files in CI4 - by ikesela - 08-20-2021, 12:50 PM
RE: Model files in CI4 - by includebeer - 09-05-2021, 03:39 PM
RE: Model files in CI4 - by Filippo65 - 09-23-2021, 07:44 AM
RE: Model files in CI4 - by InsiteFX - 09-06-2021, 12:56 AM
RE: Model files in CI4 - by Filippo65 - 09-25-2021, 09:34 AM
RE: Model files in CI4 - by InsiteFX - 09-26-2021, 12:43 AM



Theme © iAndrew 2016 - Forum software by © MyBB