Skip to content

Instantly share code, notes, and snippets.

View jlamim's full-sized avatar
👨‍💻
Working and having fun

Jonathan Lamim jlamim

👨‍💻
Working and having fun
View GitHub Profile
@jlamim
jlamim / uris.php
Created April 27, 2016 13:58
Reforçando a segurança com CSRF - URIs
<?php
$config['csrf_exclude_uris'] = array('pessoas/add');
$config['csrf_exclude_uris'] = array(
'pessoa/[0-9]+',
'registro/[a-z]+'
);
?>
@jlamim
jlamim / database.sql
Last active April 28, 2016 03:38
Importando dados CSV com CodeIgniter - SQL
CREATE TABLE IF NOT EXISTS `contatos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nome` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
# Cria alguns registros na tabela 'contatos'
INSERT INTO `contatos` (`nome`,`email`) VALUES ("Hayes","commodo.tincidunt@aliquamadipiscinglacus.org"),("Avram","sem.Pellentesque.ut@molestietellusAenean.org"),("Mufutau","in.sodales.elit@nunc.org"),("Malachi","sagittis.felis@Ut.co.uk"),("Victor","orci.luctus.et@Phasellusdolor.net"),("Geoffrey","Cras.interdum@ligula.ca"),("Chaney","mi@Cumsociis.net"),("Emerson","Curae@semutdolor.co.uk"),("Xanthus","dolor.sit.amet@nasceturridiculus.co.uk"),("Elvis","dis@ipsumnuncid.com");
@jlamim
jlamim / autoload.php
Created April 28, 2016 03:40
Importando dados CSV com CodeIgniter - Autoload
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
$autoload['packages'] = array();
$autoload['libraries'] = array('database', 'session');
$autoload['drivers'] = array();
$autoload['helper'] = array('url');
$autoload['config'] = array();
$autoload['language'] = array();
$autoload['model'] = array();
@jlamim
jlamim / routes.php
Created April 28, 2016 03:42
Importando dados CSV com CodeIgniter - Rotas
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
$route['default_controller'] = 'Base';
$route['404_override'] = '';
$route['translate_uri_dashes'] = FALSE;
$route['importar'] = "Base/ImportCsv";
@jlamim
jlamim / database.php
Created April 28, 2016 03:44
Importando dados CSV com CodeIgniter - Conexão com banco de dados
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
$active_group = 'default';
$query_builder = TRUE;
$db['default'] = array(
'dsn' => '',
'hostname' => 'host',
'username' => 'usuario',
@jlamim
jlamim / home.php
Last active April 28, 2016 03:51
Importando dados CSV com CodeIgniter - View Home
<div>
<?php if (isset($error)): ?>
<div><?php echo $error; ?></div>
<?php endif; ?>
<?php if ($this->session->flashdata('success') == TRUE): ?>
<div><?php echo $this->session->flashdata('success'); ?></div>
<?php endif; ?>
<form method="post" action="<?=base_url('importar')?>" enctype="multipart/form-data">
<div>
@jlamim
jlamim / csvimport.php
Last active April 28, 2016 04:17
Importando dados CSV com CodeIgniter - Library CSV Import
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Csvimport {
private $handle = "";
private $filepath = FALSE;
private $column_headers = FALSE;
private $initial_line = 0;
private $delimiter = ",";
private $detect_line_endings = FALSE;
@jlamim
jlamim / Base.php
Created April 28, 2016 04:25
Importando dados CSV com CodeIgniter - Controller
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Base extends CI_Controller {
/**
* Método construtor
*
* @access public
* @return void
@jlamim
jlamim / Csv_model.php
Last active April 28, 2016 04:34
Importando dados CSV com CodeIgniter - Model
<?php
class Csv_model extends CI_Model {
/**
* Método construtor
*
* @access public
* @return void
*/
@jlamim
jlamim / database.sql
Created April 28, 2016 15:34
Autenticação de usuário com controle de acesso - SQL
# Tabela que armazenará os métodos
CREATE TABLE `metodos` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`classe` varchar(50) DEFAULT NULL,
`metodo` varchar(50) DEFAULT NULL,
`identificacao` varchar(100) DEFAULT NULL,
`privado` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;