Skip to content

Instantly share code, notes, and snippets.

View mvnp's full-sized avatar
🏠
Working from home

Marcos Pereira mvnp

🏠
Working from home
24 followers · 12 following
View GitHub Profile
@mvnp
mvnp / Selecionando a operadora quando for escolhido celular
Created June 15, 2017 00:00
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<style>
.esconde{display:none!important}
</style>
<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script>
@mvnp
mvnp / Conexão PDO, fazer require e chamar o $conn
Created June 15, 2017 14:31
<?php
$servername = "localhost";
$username = "username";
$password = "password";
try {
$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
@mvnp
mvnp / Erro
Last active June 18, 2017 01:50
<?php
class Carrinho {
private $pref = 'media_';
private function existe($id) {
if(!isset($_SESSION[$this->pref.'produto'])) {
$_SESSION[$this->pref.'produto']=array();
}
@mvnp
mvnp / Produção de resultados por tabela horizontal
Created June 23, 2017 19:09
foreach ($planilha as $info) : ?>
<?php $count = 0; $total = 0; $remove = 0; ?>
<?php if($count == 0 OR ($count % 13 == 0)) : $count++; ?>
<tr>
<?php for ($i = 0; $i < 13; $i++) : ?>
<?php $remove = $info[0]['ORCD_VLR']; ?>
<?php if($i == 0) : ?>
<td><?php echo $info[$i]['PCT_DESCRICAO'] ?></td>
<td><?php echo $info[$i]['NAT_DESCRICAO'] ?></td>
<?php else : ?>
@mvnp
mvnp / Código completo
Created June 30, 2017 12:22
<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Welcome4 extends CI_Controller {
/**
* Gera a tabela de valores sem os nomes das naturezas e
* foi inserido as colunas de PACOTE e NATUREZA no início
* e implementado a possível ordenação por orden alfabética
* de naturezas ou possível ordenação por ordem alfabética
* de pacotes ...
@mvnp
mvnp / SQL mais visual !!!
Created July 4, 2017 18:40
SELECT DISTINCT * from (agenda join TIPOAGENDA ON TIPOAGENDA.tipoagenda_id=AGENDA.tipoagenda)
where year(agenda_data)= year(now())
and ADDDATE(agenda_data, INTERVAL 1 MONTH)=ADDDATE(now(), INTERVAL 1 MONTH)
order by agenda_data ASC
@mvnp
mvnp / SQL
Created August 23, 2017 01:39
SELECT f.FUNC_NOME, p.PERG_PERG, r.RSPND_RESP_AVALO, e.PDOS_AVALR_ID,
(SELECT f.FUNC_NOME FROM funcionarios f WHERE f.ID = e.PDOS_AVALR_ID) AS NOME_AVALIADOR
FROM responder r
INNER JOIN perguntas p on r.RSPND_PERG_ID = p.ID
INNER JOIN funcionarios f on r.RSPND_AVALO_ID = f.ID
INNER JOIN pesquisados e on r.RSPND_PESQ_ID = e.ID
@mvnp
mvnp / htaccess
Created September 5, 2017 16:44
<IfModule mod_rewrite.c>
RewriteEngine On
# !IMPORTANT! Set your RewriteBase here and don't forget trailing and leading
# slashes.
# If your page resides at
# http://www.example.com/mypage/test1
# then use
# RewriteBase /mypage/test1/
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
@mvnp
mvnp / Confirm dispara infinito
Created November 4, 2017 11:23
$(document).on('blur', '.edit_descr > span', function(event){
event.preventDefault();
var descricao = $(this).text();
var metodo_id = $(this).data("metodo_id");
if(descricao && metodo_id){
if(confirm("Deseja realmente atualizar a descrição desta função no sistema?") == true){
@mvnp
mvnp / Exemplo de Javascript
Created December 18, 2017 13:29
(function(){
'use strict';
var empresas_id = "#ajax_empresa";
var local_id = "#ajax_local";
var servicos_id = "#ajax_servico";
var pesquisadores_id = "#ajax_persquisador";
var pesquisa_id = "#ajax_pesquisa";
var unidades_id = "#ajax_unidade";