CodeIgniter Forums - All Forums

Third Party seeds?

Thu, 10 Sep 2020 11:53:59 +0000

How would I create and run a seed from a Third Party module?

I can seem to only run seeds from App\Database\Seeds ... can I 'somehow' point:

Code:
php spark db:seed DefaultUser -path \App\ThirdParty\Auth

Would be nice ...

how to deal with .com in SQL query?

Thu, 10 Sep 2020 11:15:38 +0000

I am building this string to use in a query.

$where= $where="email=".$this->session->userdata('userid')." AND campaign=".$this->session->userdata('campaign');

In my example this correctly becomes:
"email=richb201@gmail.com AND campaign=Apple"

But when I try running the following line
$crud->set_relation('bus_comp','business_components','bus_comp',$where);

I get an error:

SELECT COUNT(*) AS `numrows` FROM `business_components` WHERE `email` = `richb201@gmail`.`com` AND `campaign` = `Apple`

How do I stop the "." in the email address from being taken as just a "."?

Full list of Database Drivers

Wed, 09 Sep 2020 23:09:53 +0000

Hi, can anyone give me a list of all database drivers for CI3 and CI4. I mean, exactly what to whrite in:

'dbdriver' => ' ';

deleting files with delete_files() in helper

Wed, 09 Sep 2020 16:13:12 +0000

I have two files I am trying to delete programmatically. Here is how I am doing it

$file='/app/assets/uploads/files/'.$user->file_url;
$iRc=delete_files($file); //delete the pdf
//delete the thumbnail
$iRc=delete_files('/app/'.$user->thumbnail_url);

I am running in docker. Both these deletes fail ($iRc=false). So I tried to delete from the cli and that seems to work. I did open a bin/bash session into the running container. I also took a look at the permissions and I see that although I am the owner (ME) and have read/write permissions, my application is running under group richb201 (I think) and that the group has "read only" permissions. How can I be sure that my app is under richb201, btw? How can I change the permissions programatically so that my app can rm these two. I am under Ubuntu.

Images files from javascript

Wed, 09 Sep 2020 14:50:37 +0000

Greetings,

I'm continuing some existing projects referencing images via Javascript files e.g.
var images=["","/images/pig.png'>"]
Is it possible to reference these directly from Javascript files located in the assets folder i.e. C:\xampp\htdocs\game\assets\images just for demo purposes, not best practice.
Cheers

Is there ane way to get all language lines?

Wed, 09 Sep 2020 12:14:58 +0000

In CI3 was ability to get all language lines as array with:

PHP Code:
$this->lang->language 

It is very useful for views - no need to list all the required language fields and just add all of them (from the loaded language files).

I didn't find any way to do this in CI4. Is it possible?

Confusion in documentation

Wed, 09 Sep 2020 09:44:36 +0000

I go thru the documentation of CI4, and am confused in section:

General Topics > Helper Functions > Loading from Non-standard Locations
codeigniter.com/user_guide/general/helpers.html#loading-from-non-standard-locations

There the namespace of the Blog module is 'Example\Blog', but later referred as 'Modules\Blog' when calling helper function, like so:

PHP Code:
helper('Modules\Blog\blog'); 

I finally figured out that the "correct" way to call the helper is helper('Example\Blog\blog'); OR register the namespace in the autoload config files as: 'Example\\Blog' => ROOTPATH . 'Modules/Blog',

It would be a problem to CI4 and PSR-4 PHP namespace newbie. If I am getting it right, we should correct it?

CI4 e-commerce

Wed, 09 Sep 2020 07:51:28 +0000

Hi
anyone can tell me CI 4 opensource e-commerce that i can use for my work?

thank you

Jeewaka

active drop down dynamic menu from database codeigniter 4 and adminlte 3

Wed, 09 Sep 2020 04:45:16 +0000

created application with codeigniter 4 and adminlte 3, I've problem with active dropdown sidebar dynamic menu from database, when menu is clicked drop down menu not open, but menu inside dropdown is active. how to make dropdown menu is always open menu when menu inside there is active. here's my code:

Code:

   
        $request = \Config\Services::request();

        $uri = $request->uri;

        foreach ($menu as $a) : ?>

          
          if ($submenu) : ?>

            

              

                

                

                  

                  

                


              

              

                

                  

                    ">

">

helper

Code:
function amenu(){

$db = \Config\Database::connect();

$session = \Config\Services::session();

$role = $session->get('users_role_id');

$query = "SELECT `menu_id`,`menu_name`,`menu_url`,`menu_icon`,`menu_is_active`

            FROM `users_menu` JOIN `users_access_menu`

            ON `users_menu`.`menu_id`=`users_access_menu`.`am_menu_id`

            WHERE `users_access_menu`.`am_role_id`= $role

            and `menu_is_active`=1

            ORDER BY `users_access_menu`.`am_menu_id` ASC";

return $db->query($query)->getResultArray();

}

function aSubMenu($sm){

$db = \Config\Database::connect();

$query = "SELECT *

            FROM `users_sub_menu`

            WHERE `sm_menu_id`= $sm and `sm_is_active`=1";

return $db->query($query)->getResultArray();

}

Cannot load manifest.json file

Wed, 09 Sep 2020 03:02:33 +0000

Hi all,

I have create a manifest.json file and put it the root same place of index.php file and try to load in in the header tag using the below:

Quote:

But it cannot be loaded, server response with 404 in the console.
Anyone experiencing the same issue or know how to load manifest for CI, please help me.

Thanks a lot!

Regards,
Son

Using Maria/MySQL Internal Time Functions in the Builder Class?

Tue, 08 Sep 2020 22:40:16 +0000

Hi guys,

Quick question, minor problem (I think)!

I am trying to update a 'DateTime' column in MariaDB/MySQL using the builder class but I keep getting this error:

Call to undefined function App\Models\now()

I tried setting the update column using the following methods:

Method 1:

PHP Code:
$UpdateData = [
    'title' => $title,
    'slug' => $slug,
    'updated' => NOW(),
    'post' => $post
];
        
$builder->where('slug',$slug);

$builder->update($UpdateData); 

Method 2:

PHP Code:
$builder->set('updated=NOW()');
$builder->where('slug',$slug);

$builder->update($UpdateData); 

Method 3:

PHP Code:
$builder->set('updated',NOW());
$builder->where('slug',$slug);

$builder->update($UpdateData); 

Is there something I am missing here? Or is it impossible to work with Maria/MySQL's internal functions using the Builder Class?

No biggie if its impossible, as I can always resort to PHP Date/Time functions and have PHP do the work instead of MariaDB doing it.
So this is more of a curiosity question as well as a serious one.

ErrorException Trying to access array offset on value of type null

Tue, 08 Sep 2020 15:08:45 +0000

I just upgraded XAMPP and PHP version 7.49 and opened a project under development getting an error "ErrorException

Trying to access array offset on value of type null" but previously there was no such error. Can anyone solve the problem?

Timestamp Inconsistency

Tue, 08 Sep 2020 12:34:05 +0000

Having recently experimented with time zones, I find there is an inconsistency in the way CI handles its timestamps (mostly used in $useSoftDeletes / $createdField functionality):

The code in Model.php that handles the timestamps is as follows:

Code:
protected function setDate(int $userData = null)

 {

  $currentDate = is_numeric($userData) ? (int) $userData : time();

  switch ($this->dateFormat)

  {

    case 'int':

      return $currentDate;

    case 'datetime':

      return date('Y-m-d H:i:s', $currentDate);

    case 'date':

      return date('Y-m-d', $currentDate);

Case 'int' returns the time in UTC (GMT) whereas 'datetime' and 'date' both return the time in localized time... which makes it a horrible can of worms to manage in the application code if one has users in more than one time zone (or a user reconfigures their time zone).

I'd propose EITHER:

1) standardizing it (and conform to what some believe is 'best practice') to always NOT use zone'd timestamps (ie: making the same timestamp as 'int' be returned in all cases- easily done by using gmdate() in place of the two date() functions.

or

2) add two new (additional) cases, which would make it backward-compatible with what currently exists:

Code:
case 'datetime_utc':

      return gmdate('Y-m-d H:i:s', $currentDate);

case 'date_utc':

      return gmdate('Y-m-d', $currentDate);

Personally, I find 2) less desirable because it leans toward making what should be the 'standard' (and consistent) response a special case. I'd propose implementing 1) and then, if local time options were still desired, implement those as the special cases, perhaps with 'datetime_local' and 'date_local' options.

REST Server Returns 403-Forbidden Error

Tue, 08 Sep 2020 12:18:00 +0000

Hi. I have installed a RESTful Server using https://github.com/chriskacerguis/codeig...restserver. I installed it using Composer and created a controller. When I test it using POSTMAN, I am getting 404 - Forbidden error message. What am I doing wrong.

Here is the controller.

PHP Code:
defined('BASEPATH') OR exit('No direct script access allowed');

use Restserver\Libraries\REST_Controller;
require(APPPATH . 'libraries/REST_Controller.php');

class Webapi extends REST_Controller
{
    // Define global variables
    var $postData;

    /**    
    * @desc Class constructor
    * @author Allie Syadiqin
    * @access public
    * @param void
    * @return NULL
    */
    function __construct()
    {
        // Construct the parent class
        parent::__construct();

        // Load libraries
        $this->load->library('template/acd_api_lib');

        // Load models
        $this->load->model('template/acd_api_model');

        // Set XSS filtering
        $this->postData    = $this->input->post(null, true);

        // Define current time with local timezone
        $currentDateObj            = new DateTime("now", new DateTimeZone('Australia/Brisbane') );
        $this->currentDateTime    = $currentDateObj->format('Y-m-d H:i:s');
    }
    // End class constructor

    /**
     * @desc Endpoint to authenticate user
     * @author Allie Syadiqin
     * @access public
     * @param void
     * @return REST_Controller response
     */
    public function authenticate_post()
    {
        // Define variables
        $apiKey        = $this->postData['apiKey'];
        $providerId    = $this->postData['providerId'];

        printr($this->postData);
    }
    // End method authenticate_post()
}
// End class Webapi 

Sessions, how?

Tue, 08 Sep 2020 12:02:17 +0000

I seem to constantly having a hard time reading and actually USING the docs:

Can someone tell med HOW, WHERE and WHEN to use this:

Code:
$session = \Config\Services::session($config);

or

$session = \Config\Services::session(); // Without the $config

It's the first line of 'code' in the docs about the Session Library (https://codeigniter4.github.io/userguide...ht=session) ... but I cannot – from the docs – figure out HOW to implement and USE it.

If I put it into a Controller, I get this:

Code:
syntax error, unexpected '$session' (T_VARIABLE), expecting function (T_FUNCTION) or const (T_CONST)

Can somone explain why I'm getting this, and what it is that I seem to be constantly missing when 'reading' the docs?

I see this a LOT in the docs '$variable = something … ', but WHENEVER I try to implement what I'm reading in the docs I ALWAYS get errors.

Now, does:

Code:
$variable = ...

in the docs have some 'magical' meaning (should it be 'read' in some particular way)? Or is it simply because the docs 'assume' YOU know where you're supposed to 'put' this code ... and therefore leaving out the (not so) 'obvious'?