Posts

SQL queries in Cdeigniter

  Query for data insertion :      public function insert_department($data)     {         $this->db->insert('departments', $data);          //echo $this->db->last_query();exit;                     return true;     } Query for data updation : public function update_department($data, $id)     {         $this->db->where('id', $id);         $this->db->update('departments', $data);                      return true;     } Query for data updation : public function DeleteColors()     {         $this->db->where('id', $this->uri->segment(4));         $query = $this->db->delete('color_codes');                  ...
Post a Comment
Read more

Set Base URL in config file in Codeigniter

  $config['base_url'] = "https://".$_SERVER['HTTP_HOST']; $config['base_url'] .= preg_replace('@/+$@', '', dirname($_SERVER['SCRIPT_NAME'])).'/'; $config['index_page'] = ''; //Wirite below code in .htaccess file RewriteEngine on RewriteCond $1 !^(index\.php|public|\.txt) RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ index.php?$1 RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]
Post a Comment
Read more

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...
Post a Comment
Read more

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();
Post a Comment
Read more

Form Validation Using Javascript

<!DOCTYPE html> <html> <head> <title></title> <script type="text/javascript"> function validates(tmp){ uid = document.getElementById("uid"); uiderr = document.getElementById("uiderr"); uname = document.getElementById("uname"); unameerr = document.getElementById("unameerr"); uphone = document.getElementById("uphone"); uphoneerr = document.getElementById("uphoneerr"); uemail = document.getElementById("uemail"); uemailerr = document.getElementById("uemailerr"); upass = document.getElementById("upass"); upasserr = document.getElementById("upasserr"); uconpass = document.getElementById("uconpass"); uconpasserr = document.getElementById("uconpasserr"); if(tmp == "uid"){ if(uid.value == ""){ uid.style.border = "1px s...
Post a Comment
Read more

Form Validation Using jQuery

<!DOCTYPE html> <html> <head> <title></title> <script type="text/javascript" src="https://cdn.jsdelivr.net/jquery/1.12.4/jquery.min.js"></script> <script type="text/javascript" src="https://cdn.jsdelivr.net/jquery.validation/1.15.1/jquery.validate.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $("#signupForm").validate({ rules:{ firstname:{ required:true, minlength:5 }, lastname:{ required:true }, username:{ required:true, minlength:5 }, email:{ required:true, email:true }, password:{ required:true, minlength: 8 }, confirm_password:{ required:true } }, messages:{ firstname:{ required:"Please Enter First Name", minlength:"E...
Post a Comment
Read more

Hooks in Codeigniter

$config['enable_hooks'] = TRUE;                   in application/config/config.php application/config/hooks.php $hook['display_override'] = array(         'class'    => 'MySiteName',         'function' => 'Mysitetitle',         'filename' => 'Mysite.php',         'filepath' => 'hooks' ); application/hooks/Mysite.php <?php class MySiteName {     Public function Mysitetitle()     {       $this->CI =& get_instance();       $mysitename = $this->CI->output->get_output();       $mysitename = str_replace("CodeIgniter", "My Epploo123", $mysitename);       echo $mysitename;       return;  } }
Post a Comment
Read more