I am new to Codeigniter and PHP..
while doing some operations i have some doubts ,especially in the database libraries .
$get = "select filed_1 from tbl_ctc where ctc=?";
$get = $this->db->query($get,array($ctc_n));
if ($get)
{
//do some operations
}
else
{
//do some another operations
}
What will be the return value of $get if it is success ?
Expecting opinion & suggestion [downvotes too]
Thank you.
What "opinions and suggestions" do you expect?
The query() method returns a result object when you use read queries (like a select), while with write queries (like an insert or update) it returns TRUE or FALSE.
In case of a SELECT, i.e., you might want to check if it has any result:
$query = $this->db->query($select_query);
if($query->num_rows() > 0)
{}
While, in case of an INSERT for ex.:
$query = $this->db->query($insert_query);
if($query) // or if(FALSE !== $query)
{}
else
{}
Note that if you are using Active Record, you'll have the result() / row() and result_array() / row_array() methods that will return either a full object/array or an empty one, so you'll need to check for those values instead.
The result will be an object. You have to go one step further to get the expected value, e.g.
$get = $this->db->query($get,array($ctc_n));
$res = $get->result_array();
echo $res[0]['filed_1'];
See Active Record Class and examples from the user guide for further reference.
row_array too ,but i have trouble with that IF loop can i do like this if ($get) ??
if ($get->num_rows() > 0) {}FALSE if the query failed ,so can i use if($get != FALSE) ?? also what about insert functionality ??if ($get) {} will still return as true...it's not a reliable way of checking if there has been a result or not. As for insert functionality, you can use if ($this->db->insert('yourtable', $data)) {}, which will return true if the query was successful.