Advertisement
mstranieri

PHP + CodeIgniter + Canvas // PARTE PHP

Nov 11th, 2015
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.11 KB | None | 0 0
  1. //Controller file
  2.     public function sketch($idWork = null) {
  3.         $this->load->helper('rocks');
  4.        
  5.         if ( ! file_exists(APPPATH.'/views/pages/sketch.php')) {
  6.             show_404();
  7.         }
  8.        
  9.         $session_data = $this->session->userdata('logged_in');
  10.        
  11.         if ( !$session_data) {
  12.             set_log("Accesso alla vista 'rocks' non consentito.");
  13.             show_403();
  14.         }
  15.        
  16.         $sketch = get_rock_sketch_by_work($this->uri->segment('3'));
  17.         $data['saved'] = get_saved_sketch($this->uri->segment('3'));
  18.        
  19.         $data['email'] = $session_data['email'];
  20.        
  21.         if(isset($sketch) && $sketch != "") {
  22.             $data['background'] = $sketch;
  23.         } else {
  24.             $data['background'] = "";
  25.         }
  26.        
  27.         $this->load->view('templates/header', $data);
  28.         $this->load->view('pages/sketch', $data);
  29.         $this->load->view('templates/footer', $data);
  30.     }
  31.    
  32.     function save_sketch() {
  33.         $this->load->helper('form');
  34.        
  35.         $data = array(
  36.             'canvas' => $this->input->post('sketch')
  37.         );
  38.        
  39.         $this->db->where('id', $this->input->post('segment'));
  40.         $this->db->update('manager_works', $data);
  41.        
  42.         $this->session->set_flashdata('msg', '<div class="alert alert-success text-center">Sketch aggiornato correttamente!</div>');
  43.         redirect('pages/sketch/' . $this->input->post('segment'));
  44.     }
  45.  
  46.  
  47.  
  48. // --------------------------------------------------
  49. // Helper
  50.  
  51. function get_rock_sketch_by_work($idWork) {
  52.     $CI = &get_instance();
  53.     $CI->db->select('rock');
  54.     $CI->db->from('manager_works');
  55.     $CI->db->where('id', $idWork);
  56.     $query = $CI->db->get();
  57.  
  58.     if($query->num_rows() > 0) {
  59.         $idRock = $query->result();
  60.        
  61.         $CI->db->select('sketch');
  62.         $CI->db->from('manager_rocks');
  63.         $CI->db->where('id', $idRock[0]->rock);
  64.         $query = $CI->db->get();
  65.         $sketch = $query->result();
  66.         return "/uploads/" . $sketch[0]->sketch;
  67.     } else {
  68.         return null;
  69.     }
  70. }
  71.  
  72. function get_saved_sketch($idWork) {
  73.     $CI = &get_instance();
  74.     $CI->db->select('canvas');
  75.     $CI->db->from('manager_works');
  76.     $CI->db->where('id', $idWork);
  77.     $query = $CI->db->get();
  78.    
  79.     if($query->num_rows() > 0) {
  80.         $saved = $query->result();
  81.  
  82.         return $saved[0]->canvas;
  83.     } else {
  84.         return null;
  85.     }
  86. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement