Hello I'm facing a problem with a Mysql view.
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Lstmatfinal extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->helper('url');
$this->load->library('grocery_CRUD');
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('Inscriptos');
$crud-> $this->set_primary_key('inscfinal_id','Inscriptos');
$output = $crud->render();
$this->_example_output($output);
}
function _example_output($output = null)
{
$this->load->view('Principal.php', $output);
}
}
and the error is the following
A PHP Error was encountered
Severity: 4096
Message: Object of class Lstmatfinal could not be converted to string
Filename: controllers/Lstmatfinal.php
Line Number: 19
Backtrace:
File: /var/www/html/CodeIgniter/application/controllers/Lstmatfinal.php
Line: 19
Function: _error_handler
File: /var/www/html/CodeIgniter/index.php
Line: 292
Function: require_once
A PHP Error was encountered
Severity: Notice
Message: Object of class Lstmatfinal to string conversion
Filename: controllers/Lstmatfinal.php
Line Number: 19
Backtrace:
File: /var/www/html/CodeIgniter/application/controllers/Lstmatfinal.php
Line: 19
Function: _error_handler
File: /var/www/html/CodeIgniter/index.php
Line: 292
Function: require_once
A PHP Error was encountered
Severity: Notice
Message: Undefined property: Grocery_CRUD::$Object
Filename: controllers/Lstmatfinal.php
Line Number: 19
Backtrace:
File: /var/www/html/CodeIgniter/application/controllers/Lstmatfinal.php
Line: 19
Function: _error_handler
File: /var/www/html/CodeIgniter/index.php
Line: 292
Function: require_once
( ! ) Fatal error: Call to a member function set_primary_key() on a non-object in /var/www/html/CodeIgniter/application/controllers/Lstmatfinal.php on line 19
Call Stack
# Time Memory Function Location
1 0.0001 231320 {main}( ) ../index.php:0
2 0.0003 234632 require_once( '/var/www/html/CodeIgniter/system/core/CodeIgniter.php' ) ../index.php:292
3 0.0068 1041944 call_user_func_array ( ) ../CodeIgniter.php:514
4 0.0068 1042248 Lstmatfinal->index( ) ../CodeIgniter.php:514
A PHP Error was encountered
Severity: Error
Message: Call to a member function set_primary_key() on a non-object
Filename: controllers/Lstmatfinal.php
Line Number: 19
Backtrace:
Any help will be highly appreciated!! :)
--- More information added to the question ---
Table "Inscriptos" is the Mysql view, it's somethins like this
CREATE VIEW Inscriptos AS SELECT inscfinal_id, materia.materia_nombre AS Materia,
fechafinales.final_fecha as Fecha, alumno_nombre AS Alumno, alumno_dni AS DNI ,
insfinal_datetime_stamp as Timestamp
FROM inscripcionfinales INNER JOIN alumno ON insfinal_alumno_id = alumno_id
INNER JOIN fechafinales ON inscfinal_final_id = fechafinales.final_id
INNER JOIN materia ON fechafinales.final_mat_id = materia.materia_id
Regards,
Pablo
