Home / Questions

Questions[codeigniter]

Martin Hope
Emmanuel Gonzalez
Asked: 2022-08-04 09:52:12 +0800 CST
  • 2

I have the following code in codeigniter 4:

$recordset=$this->db->select('turno_id, paciente,date_format(fecha, "%W %d-%M-%Y %H:%i") as fecha,observaciones,obra_social,usuario_id' , false)
                                        ->where('year(fecha)','year(now())', false)
                                        ->where('usuario_id',$usuario_id)
                                        ->get("turnos");

That returns the date to me in this way: Wednesday 22-June-2022 23:16and through Datatables I dump it into a table. How do I get it to return to me in Spanish or translate it into Spanish?

codeigniter
Martin Hope
Marlon Manuel Romero Blanco
Asked: 2022-06-05 17:59:26 +0800 CST
  • 1

Configure CodeIgniter 4 to run directly without the need to put the path to the public folder in the url, example:

http://localhost/ci4login/

And not having to put the full path for it to run.

http://localhost/ci4login/public/

This without the need to delete the public folder, or remove the file index.phpand the file from it .htaccess and thus be able to maintain all the security.

I use CodeIgniter 3 and I want to migrate to CI4 and this part stops me since the ideal is to use the framework as its use was designed

codeigniter
Martin Hope
Pag
Asked: 2020-03-29 05:19:37 +0800 CST
  • 1

Hello, I would like to know how I can give the email a cell format with the codeigniter email library.

I leave you the code of the controller that in the post the body of the mail.

<?php
if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Cronjob_send_email extends CI_Controller {

    const NOMBRE_FICHERO = "Resumen_Registro";
    const ASUNTO_MAIL = "Resumen de registros";
    const TEXTO_MAIL = "Se han realizado<br> <br> en el hotel {nombreHotel}<br><br> con fecha de hoy.";

    public function __construct(){
        parent::__construct();

        $this->load->model('empleado_model');
        $this->load->model('parametros_model');
    }
    public function index(){
        $this->envioMail();
    }

    public function envioMail(){

        $registroBcn = $this->empleado_model->getBarcelona();
        $registroMlg = $this->empleado_model->getMalaga();
        $registroMallorca = $this->empleado_model->getMallorca();

        $textoEnvio = '<html>
            <head>
            <title>Resumen de registros por hotel</title>
            </head>
                <body>
                <h3>Resumen de registros por hotel</h3>
                    <p style="text-align: justify">Se adjunta recuento de registros por Hotel</p>
                <table>
                    <tr style="padding:15px; text-align: center;" >
                        <th>Barcelona</th><span></span>
                        <th>M&aacutelaga</th><span></span>
                        <th>Mallorca</th><span></span>
                    </tr>
                    <tr style="padding: 15px; text-align: center;">
                        <td> '.$registroBcn.' </td>
                        <td> '.$registroMlg.' </td>
                        <td> '.$registroMallorca.' </td>
                    </tr>
                </table>
                </body>
                </html>';
//        $textoEnvio = "Adjuntamos recuento de los registros de ayer<br><br>- Barcelona: ".$registroBcn."<br><br>- Málaga";
        $this->load->library('email');
        $config = Array(
            'protocol' => 'smtp',
            'smtp_host' => 'in-v3.mailjet.com',
            'smtp_port' => 587,
            'smtp_user' => '379227d6e1fc18db44209b7e264d8186', // change it to yours
            'smtp_pass' => 'b65e8f015ba7e44ce8d585f812aefb89', // change it to yours
            //'smtp_timeout'=>20,
            'mailtype' => 'html',
            'charset' => 'iso-8859-1',
            'wordwrap' => TRUE
        );
//        $dest = '[email protected]';
//        $from = '[email protected]';
        $dest= $this->parametros_model->get_parametros('destinatario');
        $from=  $this->parametros_model->get_parametros('from');
        $this->email->initialize($config);

        $this->email->from($from);
        $this->email->to($dest);
        $this->email->cc ('[email protected],[email protected],[email protected]');
//        $copiauno= "[email protected]";
//        $copiados= "[email protected]";
//        $copiados= "[email protected]";
//        $this->email->cc ($copiauno.','.$coipados.','.$copiatres);
        $this->email->subject("Recuento de registros diario");
        $this->email->message($textoEnvio);
        //$this->email->send();
        if($this->email->send()){
            echo 'si lo envia '.$from." - ".$dest;
        }
        echo $this->email->print_debugger();





//        /*
//         * Cuando cargamos una librería
//         * es similar a hacer en PHP puro esto:
//         * require_once("libreria.php");
//         * $lib=new Libreria();
//         */
//
//        //Cargamos la librería email
//        $this->load->library('email');
//
//        /*
//         * Configuramos los parámetros para enviar el email,
//         * las siguientes configuraciones es recomendable
//         * hacerlas en el fichero email.php dentro del directorio config,
//         * en este caso para hacer un ejemplo rápido lo hacemos
//         * en el propio controlador
//         */
//
//        //Indicamos el protocolo a utilizar
//        $config['protocol'] = 'imap';
//
//        //El servidor de correo que utilizaremos
//        $config["smtp_host"] = 'imap.gmail.com';
//
//        //Nuestro usuario
//        $config["smtp_user"] = '[email protected]';
//
//        //Nuestra contraseña
//        $config["smtp_pass"] = 'joaoymichu2';
//
//        //El puerto que utilizará el servidor smtp
//        $config["smtp_port"] = '993';
//
//        //El juego de caracteres a utilizar
//        $config['charset'] = 'utf-8';
//
//        //Permitimos que se puedan cortar palabras
//        $config['wordwrap'] = TRUE;
//
//        //El email debe ser valido
//        $config['validate'] = true;
//
//
//        //Establecemos esta configuración
//        $this->email->initialize($config);
//
//        //Ponemos la dirección de correo que enviará el email y un nombre
//        $this->email->from('[email protected]', 'Oscar');
//
//        /*
//         * Ponemos el o los destinatarios para los que va el email
//         * en este caso al ser un formulario de contacto te lo enviarás a ti
//         * mismo
//         */
//        $this->email->to('[email protected]');
//        $this->email->cc ( '[email protected]' );
//
//        //Definimos el asunto del mensaje
//        $this->email->subject("Mi asunto");
//
//        //Definimos el mensaje a enviar
//        $this->email->message("Mi mensaje");
//
//        //Enviamos el email y si se produce bien o mal que avise con una flasdata
//        if($this->email->send()){
//            echo 'si';
//        }else{
//            echo 'no';
//        }

        //redirect(base_url("contacto"));
    }



//    public function envioMail(){
//        $this->email->from ( '[email protected] ' ,  'Joao' );
//        $this->email->to ( ' [email protected] ' );
//        $this->email->cc ( '[email protected]' );
//        $this->email->bcc ( '' );
//
//        $this->email->subject ( 'Test de correo electrónico' );
//        $this->email->message ( 'Probando la clase de correo electrónico' );
//
//        $this->email->send ();
//    }

}

This is how the mail currently looks, what I would like is to put the cell borders, I have tried to put the style itself in the label but it does not change it

I would appreciate your help.

enter image description here

codeigniter
Martin Hope
Javier fr
Asked: 2020-09-01 08:48:25 +0800 CST
  • 2

I have a problem.

How do I put the security seal on my website?

I already bought it, but the security seal is not put on the index. In the https://www.mipagina.mx (suppose this is like the address of my index). it comes out like this

enter image description here

But since the page has several sections, if I go to the other sections I get the security seal.

enter image description here

How do I put it on my first page?

codeigniter
Martin Hope
Sonia Toledo
Asked: 2020-01-25 12:03:37 +0800 CST
  • 3

I already tried with the directive init_set, the file index.phpis set to ENVIRONMENT=DEVELOPMENT, I have searched a lot on the web and nothing has worked for me.

I don't have access to server configuration files, that's why I need to activate the messages, because debugging is complicated like that.

Solution This was the modification I made in the index.php

define('ENVIRONMENT',   'development');
/**** ERROR REPORTING
Different environments will require different levels of error reporting.
By default development will show errors but testing and live will hide them.*/

switch (ENVIRONMENT)
{
case 'development':  
    error_reporting( E_ALL );
    ini_set('display_errors', 1 );
break;

case 'testing':
case 'production':
    ini_set('display_errors', 0);
    if (version_compare(PHP_VERSION, '5.3', '>='))
    {
        error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT & ~E_USER_NOTICE & ~E_USER_DEPRECATED);
    }
    else
    {
        error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_USER_NOTICE);
    }
break;

default:
    header('HTTP/1.1 503 Service Unavailable.', TRUE, 503);
    echo 'The application environment is not set correctly.';
    exit(1); // EXIT_ERROR
}
codeigniter