This post will treat the case of one record treatment and counting in active record through the CodeIgniter’ core. Suppose you are displaying a user’s profile. It’s good practice to store all database queries in the MODEL. I use this:<\/p>\n
CONTROLLER:<\/strong><\/p>\n MODEL:<\/strong><\/p>\n In the model you can have all your other database functions (create, delete, update)<\/p>\n VIEW:<\/strong><\/p>\n Finally in the view you can echo any rows from the table that belong to the user.<\/p>\n $query->row() just fetches the first row.<\/strong><\/p>\n So instead of looping through the result, you could just do:<\/p>\n OR<\/p>\n Assuming the query will always return a row. There are two ways to count total number of records that the query will return. First this<\/p>\n This will return number of rows the query brought.<\/p>\n Second<\/p>\n Simply count_all_results will require to run the query again.<\/p>\n Cheers,<\/p>\n","protected":false},"excerpt":{"rendered":" This post will treat the case of one record treatment and counting in active record through the CodeIgniter’ core. Suppose you are displaying a user’s profile. It’s good practice to store all database queries...<\/p>\n","protected":false},"author":1,"featured_media":2841,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[348,250],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1590"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1590"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1590\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2841"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}$this->load->model('Profile');\r\n$data['row'] = $this->Profile_model->profile_read(); \/\/get profile data\r\n$this->load->view('profile_view', $data); \/\/load data to view\r\n<\/pre>\n\r\nfunction profile_read()\r\n{\r\n$this->db->where('user_id', $user_id);\r\n$query = $this->db->get('user_profiles'); \/\/get all data from user_profiles table that belong to the respective user\r\nreturn $query->row(); \/\/return the data\r\n}\r\n<\/pre>\n\r\n<?php echo $row->name; ?>\r\n<?php echo $row->email; ?>\r\n<?php echo $row->about; ?>\r\n<\/pre>\n
$student_id = $query->row()->student_id;<\/pre>\n
\r\n$row = $query->row();\r\n$student_id = $row->student_id;\r\n<\/pre>\n
\nIn the other case, the normal result parsing is :<\/p>\n$query = $this->db->query(\"YOUR QUERY\");\r\n\r\nforeach ($query->result() as $row)\r\n{\r\n echo $row->title;\r\n echo $row->name;\r\n echo $row->body;\r\n}<\/pre>\nDifference between $query>num_rows() and $this->db->count_all_results()<\/h2>\n
$query = $this->db->query('select * from users'); \r\nreturn $query->num_rows();<\/code><\/pre>\nreturn $this->db->count_all_results('select * from users');<\/code><\/pre>\n