+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Work with result in controller (/showthread.php?tid=41124)
Pages:
1
2
Work with result in controller - El Forum - 04-28-2011
[eluser]MaxEisley[/eluser]
Hello guys,
i really still cannot find how to work with results in Controller. I can work with results only in viewer.
This is my data model, this function check, if the customer with these parameters exists:
Code:
function checkcustomer($phone, $email, $name, $surname) {
$q = $this->db->query('SELECT *
FROM zakaznik
WHERE Telefon = "'.$phone.'"
AND Email = "'.$email.'"
AND Jmeno = "'.$name.'"
AND Prijmeni = "'.$surname.'"');
return ($q->row());
}This is my controller getting valid entries from viewer. I want to check, if customer with these values exists and when yes, then get customer_ID, when doesn't exist, then create customer:
Code:
$data['customer'] = $this->data_model->checkcustomer($this->input->post('Phone'), $this->input->post('Email'), $this->input->post('FirstN'), $this->input->post('SecondN'));
if($customer->zakaznikID == '') {
$id_customer = $this->data_model->createcustomer($this->input->post('Phone'), $this->input->post('Email'), $this->input->post('FirstN'), $this->input->post('SecondN'), $id_address);
}
else {
$id_customer = $customer->zakaznikID;
}And it writes these errors, i dont know how to work with results from Model in Controller:
Message: Undefined variable: customer
Message: Trying to get property of non-object
Work with result in controller - El Forum - 04-28-2011
[eluser]CroNiX[/eluser]
Well, in your controller you store it in $data['customer'] but you are trying to check in $customer. It shows up as $customer only in your view and as $data['customer'] in your controller.
So, in your controller, if you did:
Code:
$customer = $this->data_model->checkcustomer($this->input->post('Phone'), $this->input->post('Email'), $this->input->post('FirstN'), $this->input->post('SecondN'));
$data['customer'] = $customer;
if($customer->zakaznikID == '') {
...
}Code:
if($customer->zakaznikID == '')Code:
if($data['customer']->zakaznikID == '')Work with result in controller - El Forum - 04-28-2011
[eluser]MaxEisley[/eluser]
It doesnt work:
Code:
$customer = $this->data_model->checkcustomer($this->input->post('Phone'), $this->input->post('Email'), $this->input->post('FirstN'), $this->input->post('SecondN'));
if($customer->zakaznikID == '') {
$id_customer = $this->data_model->createcustomer($this->input->post('Phone'), $this->input->post('Email'), $this->input->post('FirstN'), $this->input->post('SecondN'), $id_address);
}
else {
$id_customer = $customer->zakaznikID;
}It still writes Trying to get property of non-object
on line: if($customer->zakaznikID == '') {
Work with result in controller - El Forum - 04-28-2011
[eluser]CroNiX[/eluser]
well, in your query, are you returning the results as an array or object? It would appear an array and you are trying to access it as an object. Do a var_dump($customer) and see what the data looks like.
Work with result in controller - El Forum - 04-29-2011
[eluser]MaxEisley[/eluser]
I am receiving data from this:
Code:
function checkcustomer($phone, $email, $name, $surname) {
$q = $this->db->query('SELECT *
FROM zakaznik
WHERE Telefon = "'.$phone.'"
AND Email = "'.$email.'"
AND Jmeno = "'.$name.'"
AND Prijmeni = "'.$surname.'"');
return ($q->row());
}Work with result in controller - El Forum - 04-29-2011
[eluser]skiter[/eluser]
You have a ROW, so is not an Object, this mean that you have array in array, in array?
Anyway $row[0] is ur's 1 element from 'Select * ...', if you add (row results), to array, you will have multi-dimension array, then access liek others multi-dimension arrays.
Code:
if($data['customer']['ID'] == '') {To many arrays in one post, sorry my en is quite poor
Work with result in controller - El Forum - 04-29-2011
[eluser]MaxEisley[/eluser]
So what i should change in data_model to result it not as an array ?
Work with result in controller - El Forum - 04-29-2011
[eluser]TWP Marketing[/eluser]
The User Guide ( http://ellislab.com/codeigniter/user-guide/database/results.htm ) says that your returned value should be an OBJECT:
Quote:...
row()
This function returns a single result row. If your query has more than one row, it returns only the first row. The result is returned as an object. Here's a usage example:
$query = $this->db->query("YOUR QUERY");
if ($query->num_rows() > 0)
{
$row = $query->row();
echo $row->title;
echo $row->name;
echo $row->body;
}
...
Does your customer file "zakaznik" contain the field zakaznikID?
Second thought, if the query finds NO record it will return FALSE, which could give you the error "Trying to get property of non-object".
You should add the code to test if rows were found (in the User Guide example above).
Work with result in controller - El Forum - 04-30-2011
[eluser]MaxEisley[/eluser]
Yes you are right, thanks for help man
Work with result in controller - El Forum - 05-03-2011
[eluser]MaxEisley[/eluser]
I have still problem with that, this is my model:
Code:
function getcar($id) {
$q = $this->db->query('SELECT *
FROM vozidlo
WHERE vozidloID = '.$id);
return $row = $q->row();
}Controller:
Code:
$car = $this->data_model->getcar($this->input->post('Car'));
///input post car containt valid ID car from form
echo $car->Cost;
echo $car->Color;all writes this is non object property.
But when i write it in viewer like this, i got good result:
Code:
CT:
$car['car'] = $this->data_model->getcar($this->input->post('Car'));
Viewer:
echo $car->Cost;
echo $car->Color;