codeigniter Help

[isurutmv]

මචන් මේ පහල තියෙන code එක code repeat නොකර ඔයිටවඩා අඩු line ගානකින් ලියන්න බැරිද බන්?

public function insertbooking($data)
    {
       $this->db->where('vehical_number',$data['vehical_number']);
        
        $respond = $this->db->get('ongoing_booking');

        if($respond->num_rows()==1){

          foreach ($respond->result() as $row)
                {
                        $enddate= $row->end_date;
                        $bookingtime= $row->booking_time;
                        $bookingdate=$row->booking_date;
                }
                if(($enddate>$data['booking_date']) && ($bookingdate<$data['booking_date'])) 
                {
                    redirect(base_url()."admin/insertbooking");
                    
                }
                else if (($enddate==$data['booking_date'])){

                    if($bookingtime>$data['booking_time']){

                        redirect(base_url()."admin/insertbooking");
                    }
                    else{
                        $this->db->insert("ongoing_booking",$data);

                    }
                }
                else{

                    $this->db->insert("ongoing_booking",$data);

                }

        }
        else{

            $this->db->insert("ongoing_booking",$data);
        }

        

                
    }

 

[rajith123]

$respond->num_rows()==1

නම් ඇයි loop කරන්නේ

 

[STU26015]

බම්ප්

 

[Unclesam]

You dont need to loop. Since you need to get one result, you can use like this

$query = $this->db->query('SELECT name FROM my_table LIMIT 1');
$row = $query->row();
echo $row->name;

Meke sure to read the document first.
https://www.codeigniter.com/userguide3/database/examples.html

 

[isurutmv]

You dont need to loop. Since you need to get one result, you can use like this

$query = $this->db->query('SELECT name FROM my_table LIMIT 1');
$row = $query->row();
echo $row->name;

Meke sure to read the document first.
https://www.codeigniter.com/userguide3/database/examples.html

Thanks Bro I changed it

 

[isurutmv]

if($respond->num_rows()==1)

if(($enddate>$data['booking_date']) && ($bookingdate<$data['booking_date'])) 

if($bookingtime>$data['booking_time'])

මට මේ if condition තුනම වෙන වෙනම නැතුව එකට ලියන්න බැරිද බන්

 

[Profile_01]

බම්ප්

 

[Hora_Nariya]

BUMP​