StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7211023
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-08-26T22:07:27.427
FavoriteCount
0
LastActivityDate
2011-08-26T22:07:27.427
LastEditDate
LastEditorUserId
0
OwnerUserId
903904
ParentId
1944800
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>Here's some elaboration on zombat's solution with code examples.</p> <p>I usually have the form post to the same controller/method. Then I let $this->form_validation->run() handle all the dirty work. If $_POST data is present, the validator checks the rules. If it passes I redirect them to a success page, otherwise the same page is presented with validation errors displayed in the repopulated form.</p> <pre><code>class Contact extends CI_Controller { function __construct() { parent::__construct(); } function index() { /* the foreach() line makes each field visible to form_validation so we can reliably repopulate (using set_value, set_checkbox, etc) fields that have no validation rules example: since 'phone' has no rules, we would not be able to repopulate that field if validation failed */ foreach ($_POST as $key => $value) $this->form_validation->set_rules($key, '', ''); $this->form_validation->set_rules('first_name', 'First Name', 'required|min_length[2]'); $this->form_validation->set_rules('last_name', 'Last Name', 'required|min_length[2]'); $this->form_validation->set_rules('email', 'Email Address', 'required|strtolower|valid_email'); if ($this->form_validation->run() == FALSE) { $this->load->view('contact_form'); } else { /* save form data, email it, etc then redirect the user so they cannot re-submit the same data */ redirect('contact/success'); } } function success() { $this->load->view('contact_success'); } } </code></pre> <p>Example HTML for application/views/contact_form.php</p> <pre><code><form method="post" action="<?php echo current_url(); ?>"> <table> <tr> <td>First Name</td> <td><?php echo form_input('first_name', set_value('first_name')); ?> <?php echo form_error('first_name'); ?></td> </tr> <tr> <td>Last Name</td> <td><?php echo form_input('last_name', set_value('last_name')); ?> <?php echo form_error('last_name'); ?></td> </tr> <tr> <td>Email Address</td> <td><?php echo form_input('email', set_value('email')); ?> <?php echo form_error('email'); ?></td> </tr> <tr> <td>Phone Number</td> <td><?php echo form_input('phone', set_value('phone')); ?> <?php echo form_error('phone'); ?></td> </tr> <tr> <td>&nbsp;</td> <td><button type="submit">Send Message</button></td> </tr> </table> </form> </code></pre> <p>I have absolutely no worries about CSFR or XSS doing it this way.</p> <p><sub>Note: As with any publicly accessible form, there are always going to be junk submissions (from bots AND real people trying to solicit business). If you encounter a lot of them, fine-tune your validation rules accordingly.</sub></p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCodeIgniter URLs
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMavelo
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
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.