StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcodeigniter pass data from view to model and retrieve info
primarykey
Id
4509118
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2010-12-22T12:23:26.407
FavoriteCount
0
LastActivityDate
2016-05-18T13:03:37.907
LastEditDate
2016-05-18T13:03:37.907
LastEditorUserId
-1
OwnerUserId
544764
ParentId
0
PostTypeId
1
Score
0
ViewCount
976
LastEditorDisplayName
text
Body
Here is the thing: I have controller that retrieve data from database and pass info to view. In the view I have a loop like this: <pre><code>foreach ($myphotos->result() as $myphoto){ echo $myphoto->p_id } </code></pre> But in that loop I need to pick up $myphoto->p_id and ask database to retrieve me users with this p_id. <pre><code>SELECT * FROM users WHERE u_id IN (SELECT u_id FROM p_votes WHERE p_id = 268); </code></pre> and in: <pre><code>foreach ($myphotos->result() as $myphoto){ echo $myphoto->p_id $this->load->model('m_member'); $users_voted = $this->m_member->getUsersVotedOnImage($myphoto->p_id); foreach ($users_voted->result() as $users){ echo '<div id="voterfooter">voted:<a href="$users->i_id">'.$users->name.</a> } } </code></pre> Ok that was one option that I come up, but there is also another option, but select statement is so complicated! here is how: I already have this one: <pre><code>SELECT * FROM photos WHERE p_id NOT IN (SELECT distinct p_id FROM p_votes where u_id = ".$this->session->userdata('u_id').") LIMIT ".$segment_url.", ".$config['per_page']; </code></pre> But how to pick up also from users people that voted on that picture and print it in view? Here is database scheme: <pre><code>CREATE TABLE IF NOT EXISTS `users` ( `u_id` int(10) unsigned NOT NULL auto_increment, `fb_id` varchar(255), `fb_url` varchar(255), `email` varchar(100), `username` varchar(100), `name` varchar(100), `lastname` varchar(100), `mini_pic_fb` varchar(255), `mini_pic` varchar(255), `country` varchar(100), `place` varchar(100), `address` varchar(100), `nr` int(10), `postcode` varchar(10), `pass` varchar(35), `active` varchar(35), `activation_code` varchar(42), PRIMARY KEY (`u_id`), UNIQUE KEY `email` (`email`), UNIQUE KEY `username` (`username`), UNIQUE KEY `fb_id` (`fb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=229 ; CREATE TABLE IF NOT EXISTS `photos` ( `p_id` bigint(20) unsigned NOT NULL auto_increment, `u_id` bigint(20) unsigned NOT NULL default '0', `p_date` datetime NOT NULL default '0000-00-00 00:00:00', `p_content` longtext NOT NULL, `p_title` text NOT NULL, `p_photo` text NOT NULL, `p_small` text NOT NULL, `p_thumb` text NOT NULL, `p_up` bigint(20), `p_down` bigint(20), PRIMARY KEY (`p_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=229 ; CREATE TABLE IF NOT EXISTS `p_votes` ( `pv_id` bigint(20) unsigned NOT NULL auto_increment, `u_id` bigint(20) unsigned NOT NULL, `p_id` bigint(20) unsigned NOT NULL, `pv_date` datetime NOT NULL default '0000-00-00 00:00:00', `pv_ip` varchar(200) NOT NULL, PRIMARY KEY (`pv_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=229 ; </code></pre>
Tags
<mysql><codeigniter>
Title
codeigniter pass data from view to model and retrieve info
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USDakadaka
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

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.