StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7693529
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2011-10-07T22:40:02.827
FavoriteCount
0
LastActivityDate
2011-10-07T23:18:58.143
LastEditDate
2011-10-07T23:18:58.143
LastEditorUserId
979102
OwnerUserId
979102
ParentId
7692352
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
<p>I'm not sure if you're following MVC Architecture or not because your post is actually kind of confusing.</p> <p>However, this is what I would do -- in Codeigniter. I'll try and match your code style as best as possible. Also there are a ton of ways you can do this, some might be way more efficient than this, but this will get the job done. I never ran this script, so it might have errors or require a little debugging:</p> <pre><code><?php /* Controller *************************/ class Something extends CI_Controller { function coord_check() { //Form Validation -- if necessary $this->form_validation->set_rules('X', 'X', 'required|xss_clean'); $this->form_validation->set_rules('Xm', 'Y', 'require|xss_clean'); $this->form_validation->set_rules('Y', 'Y', 'require|xss_clean'); $this->form_validation->set_rules('Ym', 'Ym', 'require|xss_clean'); if ($this->form_validation->run() == FALSE) { $this->load->view('your_view'); } else { $this->load->model('num'); $X = $this->input->post('X'); $Xm = $this->input->post('Xm'); $Y = $this->input->post('Y'); $Ym = $this->input->post('Ym'); $X_result = $this->num->check_if_coord_thingy_exists('xone', $X); $Xm_result = $this->num->check_if_coord_thingy_exists('xtwo', $Xm); $Y_result = $this->num->check_if_coord_thingy_exists('yone', $Y); $Ym_result = $this->num->check_if_coord_thingy_exists('ytwo', $Ym); /* if ($X_result == TRUE && $Xm_result == TRUE && $Y_result == TRUE && $Ym_result == TRUE) { //all things inputed match database } else { //all values don't match database } if ($X_result == TRUE && $Xm_result == TRUE) : //all X things inputed match database endif; if ($Y_result == TRUE && $Ym_result == TRUE) : //all X things inputed match database endif; */ $data['X_repsonse'] = ($X_result == TRUE ? 'X exist' : 'X doesn\'t exist'; $data['Xm_repsonse'] = ($Xm_result == TRUE ? 'Xm exist' : 'Xm doesn\'t exist'; $data['Y_repsonse'] = ($Y_result == TRUE ? 'Y exist' : 'Y doesn\'t exist'; $data['Ym_repsonse'] = ($Ym_result == TRUE ? 'Ym exist' : 'Ym doesn\'t exist'; $this->load->view('your_view', $data); } } ?> <?php /* Model *************************/ class Num extends CI_Model { function check_if_coord_thingy_exists($value, $variable) { $this->db->select($value); $this->db->where($value, $variable); $query = $this->db->get('num'); if ($query->num_rows() > 0) { //Value exists in database return TRUE; } else { //Value doesn't exist in database return FALSE; } } } ?> <?php /* View -> your_view.php *************************/ echo validation_errors('<div class="message">', '</div>'); if (!empty($X_response)) echo '<div class="message">X: '.$X_response.'</div>'; if (!empty($X_response)) echo '<div class="message"Xm: >'.$Xm_response.'</div>'; if (!empty($X_response)) echo '<div class="message">Y: '.$Y_response.'</div>'; if (!empty($X_response)) echo '<div class="message">Ym: '.$Ym_response.'</div>'; ?> <?php echo form_open('something/coord_check'); ?> <?php echo form_label('First Coord', 'X'); ?><br> <?php $first_coord = array('name' => 'X', 'id' => 'X', 'value' => set_value('X')); ?> <?php echo form_input($first_coord); ?><br> <?php echo form_label('Second Coord', 'Xm'); ?><br> <?php $second_coord = array('name' => 'Xm', 'id' => 'Xm', 'value' => set_value('Xm')); ?> <?php echo form_input($second_coord); ?><br> <?php echo form_label('Third Coord', 'Y'); ?><br> <?php $third_coord = array('name' => 'Y', 'id' => 'Y', 'value' => set_value('Y')); ?> <?php echo form_input($third_coord); ?><br> <?php echo form_label('Fourth Coord', 'Ym'); ?><br> <?php $fourth_coord = array('name' => 'Ym', 'id' => 'Ym', 'value' => set_value('Ym')); ?> <?php echo form_input($fourth_coord); ?><br> <?php echo form_submit('submit', 'Coord Check or Whatever'); ?> <?php echo form_close(); ?> </code></pre> <p>Hopefully this helps. This is all assuming you autoload your database and form_validation libraries.</p> <p>Lastly, your database is strange. X and Y I feel should be different tables. I don't know the extent of your project though. Good luck!</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCodeigniter check if values exist with database
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USenvysea
UserOwnerUserId
1. USenvysea
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
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. CONice Answer. +1 for you.
  singulars
  PostPostId
  PO
  UserUserId
  USTareq
2. COThank you very much, the fields are not user inputted though. Sorry if i confused you with the way i asked the question. Thanks again, you seem to be very good with the CI interface, how long have you been using it lol?
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
3. CObtw sorry i didn't explain the question well enough, could you please take a look at this updated question right here http://stackoverflow.com/questions/7698553/codeigniter-database Many Thanks envysea.xx
  singulars
  PostPostId
  PO
  UserUserId
  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.