StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUsing Associate Array to Pass Database Information with PHP and CodeIgniter
primarykey
Id
8588940
data
AcceptedAnswerId
8710131
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-12-21T11:16:36.030
FavoriteCount
0
LastActivityDate
2017-06-12T18:12:44.307
LastEditDate
2017-06-12T18:12:44.307
LastEditorUserId
236345
OwnerUserId
957549
ParentId
0
PostTypeId
1
Score
1
ViewCount
1301
LastEditorDisplayName
text
Body
Issue/Question: I'm using CodeIgniter to build an event calendar, and I have included a sharing option. This option works at a base level, but only displays the users' ID (primary key) in an <code><ul></code>. This isn't ideal, and I would like to show the users' first and last names in the <code><ul></code> instead. I thought creating an associative array would work, but I'm receiving funky results. The first and last name echo out as "Array Array" when the page loads, and the URL id comes up as "Array" when you select the "Array Array" link. I'm wondering what is wrong in my logic. Funky link generated in view: <pre><code>Array Array </code></pre> Funky URL that is linked to "Array Array": <pre><code>http://example.com/user/shared/view/Array </code></pre> Modified Controller: <pre><code><?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Shared extends Common_Auth_Controller { private $end_user; public function __construct() { parent::__construct(); $this->end_user = $this->ion_auth->user()->row(); $data['end_user'] = $this->end_user; $this->load->vars($data); $this->load->model('events_model', 'events'); } public function index() { $title['title'] = 'Shared'; $this->load->model('shared_model','shared'); $data['sharers'][] = array( 'shared_owner_id' => $this->shared->get($this->end_user->id), 'owner_first_name' => $this->shared->get($this->end_user->first_name), 'owner_last_name' => $this->shared->get($this->end_user->last_name), ); $this->load->view('public/head_view', $title); $this->load->view('user/header_view'); $this->load->view('user/shared_view', $data); $this->load->view('user/footer_view'); } </code></pre> Modified View: <pre><code><div class="hide-on-phones"> <ul> <?php foreach($sharers as $key => $value): ?> <li><a href="<?php echo base_url('user/shared/view/'.$value['shared_owner_id']) ?>"><?php echo $value['owner_first_name']." ".$value['owner_last_name'] ?></a></li> <?php endforeach; ?> </ul> </div> </code></pre> Model: <pre><code>class Shared_model extends crud_model { public function __construct() { parent::__construct(); $this->pk = 'id'; $this->table_name = 'shared'; } public function get($shared_to_user_id) { $this->db->where('shared_to_id', $shared_to_user_id); $ids = parent::get_all(); $users = array(); foreach ($ids as $id) { $users[] = $id->owner_id; } return $users; } } </code></pre> Thank you so much for your help, and let me know if there is any more information that may be required. Below are the original view and controllers that work, but are not preferable. Original Controller: <pre><code>public function index() { $title['title'] = 'Shared'; $this->load->model('shared_model','shared'); $data['sharers'] = $this->shared->get($this->end_user->id); $this->load->view('user/head_view', $title); $this->load->view('user/header_view'); $this->load->view('user/navigation_view'); $this->load->view('user/shared_view', $data); $this->load->view('user/footer_view'); } </code></pre> Original View: <pre><code><?php foreach($sharers as $s): ?> <li><a href="<?php echo base_url('user/shared/mobile/'.$s) ?>"><?php echo $s ?></a></li> <?php endforeach; ?> </code></pre> Disclaimer: I'm new to web development, and I suck at associative arrays (apparently).
Tags
<php><codeigniter><loops><foreach>
Title
Using Associate Array to Pass Database Information with PHP and CodeIgniter
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAlfabravo
UserOwnerUserId
1. USimlouisrussell
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
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.