Posts

Showing posts from September, 2019

Image Display Inside Form

                                <div class="form-group"> <label>Profile Image</label> <input type="file" name="profile_image" id="profile_image" class="form-control" accept="image/*"> <?php if($row['profile_image'] != ''){?> <img src="<?=base_url('images/'.$row['profile_image']);?>"  class="img-thumbnail" width="150" > <input type="hidden" name="profile_image" value="<?=$row['profile_image']?>"> <?php } ?> </div> public function updateProfile(){ if($this->input->post('edit_profile')){ $file_name = $this->input->post('profile_image'); $password = $this->input->post('password'); $data = array( 'username' => $username,  'nam...

Codeigniter Joins Example

                $this->db->select('*'); $this->db->from('tbl_samples_post'); $this->db->join('tbl_twitter_user','tbl_twitter_user.user_id = tbl_samples_post.user_id','left'); $this->db->join('tbl_follow','tbl_follow.sender_id = tbl_samples_post.user_id','left'); $this->db->where('tbl_follow.receiver_id',$receiver_id); $this->db->or_where('tbl_samples_post.user_id',$receiver_id); $this->db->order_by('tbl_samples_post.user_id','DESC'); $query = $this->db->get(); return $query->result_array();