• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Issue with joining tables.

#1
Hey guys,
I know it might be a silly question but i can't make it work and it drives me crazy.

I have a view.php for displaying single item details. In model file i'm trying to join some tables (in which some columns are INT and have 0 value).

When I'm trying to get a single entry where the INT column is 0, i can't get any info shown in the "view.php" file (if i also place the show_404 if data are empty i get redirected. Which means that it does not get any data).
When i erase the db join it works fine. My guess is something i made wrong with the db or the model.

Any ideas?!
Controller
Code:
 public function view($pet_entry_id = NULL, $pet_entry_slug = NULL){
   //Data
   $data['pet'] = $this->pet_model->get_pets($pet_entry_id);
   $data['images'] = $this->pet_model->get_images($pet_entry_id);

   //Same page redir with entry-id given
   if (!$pet_entry_slug) {
     redirect(site_url('pets/' . $data['pet']['pet_entry_id'] . '/' . $data['pet']['pet_entry_slug']), 301);
   }

   if( empty($data['pet']) ){
     redirect('pets');
   }

   //Meta data
   $seo_data['title'] = $data['pet']['pet_entry_title'] . ' - Petgee.gr';
   $seo_data['meta_descr'] = $data['pet']['meta_descr'];
   $seo_data['meta_keywords'] = $data['pet']['meta_keywords'];

   // View files
   $this->load->view('templates/header', $seo_data);
   $this->load->view('pets/view', $data);
   $this->load->view('templates/footer');
 }



Model file
Code:
 public function get_pets($pet_entry_id = 0, $pet_entry_slug = FALSE){
   $this->db->join('users', 'users.user_id = pets.pet_user_id');
   $this->db->join('pet_categories', 'pet_categories.pet_category_id = pets.category_id');
   $this->db->join('pet_breeds', 'pet_breeds.pet_breed_id = pets.pet_breed');

   if($pet_entry_id === 0 && $pet_entry_slug === FALSE ){
     $this->db->order_by('pet_id', 'DESC');

     $query = $this->db->get('pets');
     return $query->result_array();
   }

   $query = $this->db->get_where('pets', array('pet_entry_id' => $pet_entry_id, 'pet_entry_slug' => $pet_entry_slug));
   return $query->row_array();
 } //Get pets (end)



Thank you in advance!

//Life motto
if (sad() == true) {
     sad().stop();
     develop();
}
Reply

#2
I can't see that you are converting $pet_entry_id into an integer. It will be a string of '0' so the following will not be true.
PHP Code:
if($pet_entry_id === && $pet_entry_slug === FALSE ){ 
Reply

#3
(08-25-2018, 05:31 AM)jreklund Wrote: I can't see that you are converting $pet_entry_id into an integer. It will be a string of '0' so the following will not be true.
PHP Code:
  if($pet_entry_id === && $pet_entry_slug === FALSE ){ 

The problem is not the Pet_entry_id.. The problem is when the breed (which is optional) gets a zero value. If the value is different and not 0 them it works fine. I dont want that though, since as i mentioned is optional

//Life motto
if (sad() == true) {
     sad().stop();
     develop();
}
Reply

#4
I solved it by creating a value in the db of id number 1 (for no value) since the problem was that the 0 value i was joining with the other table could not be found.

If anyone has any other solution to this feel free to explain!

Thank you!

//Life motto
if (sad() == true) {
     sad().stop();
     develop();
}
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.