Object of class stdClass could not be converted to string ERROR

Question

I am trying to pass a value from my database to an input, but I throw the following error.I'm not sure if for this case you should use return $ this-> db-> get () -> row (); in the model. Any help is welcome.

A PHP Error was encountered

Severity: 4096

Message: Object of class stdClass could not be converted to string

Filename: usuarios/vConsulta_Horarios.php

Line Number: 590

Backtrace:

File: C:\xampp\htdocs\SAE\application\views\usuarios\vConsulta_Horarios.php
Line: 590
Function: _error_handler

File: C:\xampp\htdocs\SAE\application\controllers\cCalendar.php
Line: 26
Function: view

File: C:\xampp\htdocs\SAE\index.php
Line: 315
Function: require_once

Model (mCalendar)

public function lunes(){


$this->db->select('MIN(horario.hrs_ini)');
$this->db->from('horario');
$this->db->join('usuarios','horario.rut_usu = usuarios.rut_usu');
$this->db->where('usuarios.rut_usu','17811942-4'); 
$this->db->where('horario.lunes','ATTE. ESTUDIANTES');


return $this->db->get()->row();

Controller (cCalendar)

public function index(){


        $this->load->view('layouts/header.php');
        $this->load->view('layouts/menu.php');

        $this->load->model('mCalendar');
        $data['start_lunes'] = $this->mCalendar->lunes();
        $this->load->view('usuarios/vConsulta_Horarios.php',$data);
        $this->load->view('layouts/footer.php');

}

View

    <div class="col-md-2">

        <div class="form-group">
          <label>fecha</label>
          <input tupr="text" id="fecha_actual" name="fecha_actual" value="<?php echo $start_lunes;?>">
        </div>
     </div>

ah, sorry, my misread! What do you use to manage db? probably the result of "row()" is not a single value but an object — Roberto Bisello
– Roberto Bisello, Commented Oct 4, 2017 at 16:06

Don't Panic · Accepted Answer · 2017-10-04 16:53:21Z

1

Even though you are only selecting one column, you still need to specify it when you output, because $start_lunes is the object that represents the entire row, and as the error tells you, it can't be converted to a string.

I think echo $start_lunes->hrs_ini should work.

Based on your updated function, I think it would be easier if you aliased the MIN expression in your select

$this->db->select('MIN(horario.hrs_ini) AS min_hrs');

Then refer to that in your view: echo $start_lunes->min_hrs

edited Oct 4, 2017 at 16:53

answered Oct 4, 2017 at 16:10

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

CristianOx21 Over a year ago

<input type="text" id="fecha_actual" name="fecha_actual" value="<?php echo $start_lunes->hrs_ini;?>"> it does not work :C

parpar Over a year ago

do var_dump($start_lunes); and let us know what's the output

Don't Panic Over a year ago

How so? What does it do? Same error? Different error? Nothing?

CristianOx21 Over a year ago

$data['start_lunes'] = $this->mCalendar->lunes(); var_dump($start_lunes);should it go this way? I've never used it

parpar Over a year ago

just add the var_dump() on top of the view's page... <?php print "<pre>"; var_dump($start_lunes); die(); ?>... this will show you the content of variable

|

Abhijit Kumbhar · Accepted Answer · 2017-10-04 17:31:15Z

0

As return $this->db->get()->row(); returns object you are getting this error You need to refer this link

So now, I will suggest you one thing to return data properly. In your Controller change return $this->db->get()->row();

to

  return $this->db->get()->result_array();

Now you are getting data in the format of Array and you can echo this in your View using

// In your view

foreach($start_lunes as $var){
        $value = $var['MIN(horario.hrs_ini)'];
    }

<input type="text" id="fecha_actual" name="fecha_actual" value="<?php echo $value?>"

edited Oct 4, 2017 at 17:31

answered Oct 4, 2017 at 16:58

Abhijit Kumbhar

9613 gold badges24 silver badges50 bronze badges

12 Comments

CristianOx21 Over a year ago

<input type="text" id="fecha_actual" name="fecha_actual" value="<?php foreach($start_lunes as $var){ echo $var['hrs_ini']; } } ?>" ???

Abhijit Kumbhar Over a year ago

<?php foreach($start_lunes as $var){ $value = $var['hrs_ini']; } ?> <input type="text" id="fecha_actual" name="fecha_actual" value="<?php echo $value?>">

Abhijit Kumbhar Over a year ago

try to print_r($start_lunes);

Abhijit Kumbhar Over a year ago

tell me the result of that

CristianOx21 Over a year ago

Array ( [0] => Array ( [MIN(horario.hrs_ini)] => 15:30:00 ) )

|

Collectives™ on Stack Overflow

Object of class stdClass could not be converted to string ERROR

2 Answers 2

10 Comments

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related