+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Best Practices (https://forum.codeigniter.com/forumdisplay.php?fid=12)
+--- Thread: Mysql start-complete (/showthread.php?tid=66910)
Mysql start-complete - Marcel - 12-16-2016
Hi all .
could someone please tell me if this is good code for mysql.
PHP Code:
function get_cities_from_id( $cityid )
{
$this->db->select( '
app_cities.city_id,
app_cities.city_fr ,
app_cities.city_zip,
app_cities.city_latitude,
app_cities.city_longitude' );
$this->db->from( 'app_cities' );
$this->db->where( 'city_id', $cityid );
$this->db->trans_start();
$this->db->trans_complete();
$result = $this->db->get();
if ( $result->num_rows() > 0 ):
return $result->first_row();
else:
return false;
endif;
}
thanks alot.
RE: Mysql start-complete - Wouter60 - 12-16-2016
You only need the trans_start and trans_complete functions if you want to update or insert records in multiple tables. If one of the updates or inserts fails, the entire transaction will be rolled back.
If you retrieve records by a unique ID, the result can only be one record (row).
PHP Code:
return $result->row();
RE: Mysql start-complete - Marcel - 12-16-2016
(12-16-2016, 03:55 AM)Wouter60 Wrote: You only need the trans_start and trans_complete functions if you want to update or insert records in multiple tables. If one of the updates or inserts fails, the entire transaction will be rolled back.
If you retrieve records by a unique ID, the result can only be one record (row).
will do.PHP Code:return $result->row();
ok thanks alot for the info ill surely be back
