how to get result from codeigniter model as object
i'm using codeigniter for create a web site. and i need to take result
from mysql table as this
object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=>
int(4) ["lengths"]=> NULL ["num_rows"]=> int(12) ["type"]=> int(0) }
but always i got as a result something efferent from this.
when i'm using result_object() in codeigniter i'm getting something like this
array(12) { [0]=> object(stdClass)#24 (4) { ["id"]=> string(1) "1"
["label"]=> string(15) "Web Development" ["link_url"]=> string(0) ""
["parent_id"]=> string(1) "0" } [1]=> object(stdClass)#25 (4) { ["id"]=>
string(2) "10" ["label"]=> string(19) "Sales and Marketing" ["link_url"]=>
string(0) "" ["parent_id"]=> string(1) "0" } [2]=> object(stdClass)#26 (4)
{ ["id"]=> string(1) "7" ["label"]=> string(18) "Design and Artwork"
["link_url"]=> string(0) "" ["parent_id"]=> string(1) "0" } [3]=>
object(stdClass)#27 (4) { ["id"]=> string(1) "2" ["label"]=> string(16)
"Content Creation" ["link_url"]=> string(0) "" ["parent_id"]=> string(1)
"0" } [4]=> object(stdClass)#28 (4) { ["id"]=> string(1) "4" ["label"]=>
string(19) "OSCommerce projects" ["link_url"]=> string(29)
"/php_web_development_jobs.php" ["parent_id"]=> string(1) "1" } [5]=>
object(stdClass)#29 (4) { ["id"]=> string(1) "3" ["label"]=> string(8)
"PHP Jobs" ["link_url"]=> string(29) "/php_web_development_jobs.php"
["parent_id"]=> string(1) "1" } [6]=> object(stdClass)#30 (4) { ["id"]=>
string(1) "5" ["label"]=> string(22) "Technical Writing Jobs"
["link_url"]=> string(29) "/php_web_development_jobs.php" ["parent_id"]=>
string(1) "2" } [7]=> object(stdClass)#31 (4) { ["id"]=> string(1) "6"
["label"]=> string(13) "Forum Posting" ["link_url"]=> string(29)
"/php_web_development_jobs.php" ["parent_id"]=> string(1) "2" } [8]=>
object(stdClass)#32 (4) { ["id"]=> string(1) "8" ["label"]=> string(20)
"Blog Design Projects" ["link_url"]=> string(29)
"/php_web_development_jobs.php" ["parent_id"]=> string(1) "7" } [9]=>
object(stdClass)#33 (4) { ["id"]=> string(1) "9" ["label"]=> string(24)
"Freelance Website Design" ["link_url"]=> string(29)
"/php_web_development_jobs.php" ["parent_id"]=> string(1) "7" } [10]=>
object(stdClass)#34 (4) { ["id"]=> string(2) "11" ["label"]=> string(29)
"Internet Marketing Consulting" ["link_url"]=> string(29)
"/php_web_development_jobs.php" ["parent_id"]=> string(2) "10" } [11]=>
object(stdClass)#35 (4) { ["id"]=> string(2) "12" ["label"]=> string(25)
"Leads Generation Services" ["link_url"]=> string(29)
"/php_web_development_jobs.php" ["parent_id"]=> string(2) "10" } }
$this->db->order_by('parent_id','id','ASC'); $query =
$this->db->get('dyn_menu'); if ($query->num_rows() > 0) { $data =
$query->result_object(); return $data; }
how can i get the result as i want?
No comments:
Post a Comment