I’ve 2 tables named preacher & Sermons
\nFields of Preacher<\/p>\n
preacher_id \n first_name \n last_name \n preacher_image \n preacher_logo \n preacher_bio_brief \n category\n<\/code><\/pre>\nfields of sermons<\/p>\n
sermon_id\n preacher_id \n sermon_title \n sermon_image \n audio_file \n sermon_description \n sort_order\n<\/code><\/pre>\nI want to display all the sermons of each preacher by the order of preacher first_name.I got it properly but also got the below error<\/p>\n
A PHP Error was encountered\n\nSeverity: Notice\n\nMessage: Undefined index: 1\n\nFilename: home\/sermons_view.php\n\nLine Number: 27\n<\/code><\/pre>\nmethod in controller<\/p>\n
function index() {\n $res = $this->sermon_model->viewAllpreachers();\n $this->data['preachers'] = $res;\n $this->data['page'] = $this->config->item('APP_template_dir') . 'site\/home\/ sermons_view';\n $this->load->vars($this->data);\n $this->load->view($this->_container);\n}\n<\/code><\/pre>\nMethod in model<\/p>\n
function viewAllpreachers() {\n\n $preacher = array();\n $this->db->select('*');\n $this->db->from('preacher');\n $this->db->order_by('first_name');\n $query = $this->db->get();\n if ($query->num_rows() > 0) {\n foreach ($query->result() as $row) {\n $preacher[$row->preacher_id]['preacher_id'] = $row->preacher_id;\n $preacher[$row->preacher_id]['preacher_name'] = $row->first_name . ' ' . $row->last_name;\n $preacher[$row->preacher_id]['preacher_image'] = $row->preacher_image;\n $preacher[$row->preacher_id]['preacher_bio_brief'] = $row->preacher_bio_brief;\n\n $this->db->select('*');\n $this->db->from('sermons');\n $this->db->where('preacher_id',$row->preacher_id);\n $query = $this->db->get();\n if ($query->num_rows() > 0) {\n foreach ($query->result() as $row1) {\n $preacher[$row1->preacher_id][$row1->sermon_id]['sermon_id'] = $row1->sermon_id;\n $preacher[$row1->preacher_id][$row1->sermon_id]['preacher_id'] = $row1->preacher_id;\n $preacher[$row1->preacher_id][$row1->sermon_id]['sermon_image'] = $row1->sermon_image;\n $preacher[$row1->preacher_id][$row1->sermon_id]['sermon_title'] = $row1->sermon_title;\n $preacher[$row1->preacher_id][$row1->sermon_id]['audio_file'] = $row1->audio_file;\n $preacher[$row1->preacher_id][$row1->sermon_id]['sermon_description'] = $row1->sermon_description;\n }\n }\n }\n return $preacher;\n }\n return false;\n }\n<\/code><\/pre>\ncode in View<\/p>\n
\n <\/code><\/pre>\n\n<\/td>\n <\/td>\n<\/tr>\n \n<\/td>\n <\/td>\n <\/td>\n <\/td>\n<\/tr>\nI think its the problem with the resultant array I got that like<\/p>\n
Array\n(\n [21] => Array\n (\n [preacher_id] => 21\n [preacher_name] => Vance Havner\n [preacher_image] => profile_image\/havner.jpeg\n [preacher_bio_brief] => this is for testing \n [42] => Array\n (\n [sermon_id] => 42\n [preacher_id] => 21\n [sermon_image] => sermon_image\/image_81322797345.jpg\n [sermon_title] => 3 notes of the devil's tales\n [audio_file] => audio_file\/Niranja_Mizhiyum1.mp3\n [sermon_description] => 3 notes of the devil's tales \n )\n\n [41] => Array\n (\n [sermon_id] => 41\n [preacher_id] => 21\n [sermon_image] => \n [sermon_title] => The Lordship of Christs\n [audio_file] => audio_file\/Naladhamayanthi_Kadhayile.mp3\n [sermon_description] => the lordship of christ \n )\n\n )\n\n)\n<\/code><\/pre>\n\n- \n
there is no $res<\/code> in your model<\/code><\/p>\nfirst debug what is $res<\/code> with print_r($res)<\/code> and<\/p>\nAFAIK there must be $val1['sermon_title']<\/code> instead of $res['1']<\/code><\/p>\n<\/li>\n<\/ol>\nOriginally posted 2013-11-09 21:07:27. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
I’ve 2 tables named preacher & Sermons Fields of Preacher preacher_id first_name last_name preacher_image preacher_logo preacher_bio_brief category fields of sermons sermon_id preacher_id sermon_title sermon_image audio_file sermon_description sort_order I want to display all the sermons of each preacher by the order of preacher first_name.I got it properly but also got the below error A PHP Error […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-609","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=609"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/609\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}