StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POActive record and Joining with specific ID row
primarykey
Id
15849193
data
AcceptedAnswerId
15850506
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-04-06T09:26:49.653
FavoriteCount
1
LastActivityDate
2017-07-19T11:29:00.763
LastEditDate
2017-07-19T11:29:00.763
LastEditorUserId
4370109
OwnerUserId
2080328
ParentId
0
PostTypeId
1
Score
0
ViewCount
222
LastEditorDisplayName
text
Body
Here my problem : <ul> <li>I have one controller called : events </li> <li>I have one view called : inscrits_liste</li> <li>I have one model called : inscrits_model</li> </ul> I have for my query 2 tables to work on : Table 1 : inscrits Table 2 : etats And a third table called : events In my table "etats" I have 'etat_id' and 'etat_lib' I would like to have the details from 1 "inscrit" with the lib of the 'etat' for the event id specified. events.php <pre><code><?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Events extends MY_Controller { public function __construct() { parent::__construct(); $this->load->model('event_model', 'event_m'); // Modele des évènements $this->load->model('inscrits_model', 'inscrits_m'); // Modele des inscrits $this->template->title('Gestion des évènements'); $this->template->data('titre', 'EVENTS'); $this->is_validated(); } public function index() { // Preparation du template $this->template->data('heading', 'Liste des evènements'); $this->template->widgets('content', 'events_list'); try { // On recupère la liste des events $this->template->data('evt', $this->event_m->get_all(array(), array('evenement_title ASC'))); // On charge le template $this->template->load(); } catch (Exception $e) { echo $e->getCode() . " => " . $e->getMessage(); } } public function inscrits($event_id) { // Preparation du template $this->template->data('heading', 'Liste des inscrits'); $this->template->widgets('content', 'inscrits_liste'); try { // On recupère la liste des inscrits $this->template->data('inscrits', $this->inscrits_m->inscrits_event($event_id)); // On charge le template $this->template->load(); } catch (Exception $e) { echo $e->getCode() . " => " . $e->getMessage(); } } } </code></pre> The model : <pre><code><?php class inscrits_model extends MY_Model { protected $table = 'inscrits'; protected $primary = 'inscrits_id'; public function inscrits_event($event_id) { $this->db->select('inscrits_id,inscrits_pseudo,inscrits_nom,inscrits_prenom,inscrits_email,etat_lib'); $this->db->from('inscrits'); $this->db->join('etats', 'inscrits.inscrits_etat_id = etats.etat_id', 'inner'); $this->db->where('inscrits_evenement_id', $event_id); $joint = $this->db->get(); return $joint; } } /* End of file admin_model.php */ /* Location: ./application/models/admin_model.php */ </code></pre> The problem is to use the specific event_id to make the request on 1 inscrit for the current event. I can't find the mechanism :s I know the model do the query, the controller use the model to send datas to the view. But in my case , in the model I would like to use a data given from a row in the view (the current event_id). I'm lost!
Tags
<codeigniter><join>
Title
Active record and Joining with specific ID row
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USKliklipse
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POActive record and Joining with specific ID row
 UserUserId
 USKliklipse
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. COplease post error you receive :)
 singulars
 PostPostId
 POActive record and Joining with specific ID row
 UserUserId
 USsbaaaang

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.