Skip to content

Instantly share code, notes, and snippets.

View JRGGRoberto's full-sized avatar

Roberto JRGGRoberto

20 followers · 45 following
View GitHub Profile
@JRGGRoberto
JRGGRoberto / showErros.php
Created August 12, 2024 12:35
Quickly Show All PHP Errors
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
@JRGGRoberto
JRGGRoberto / phpproj.bat
Created July 24, 2024 14:00
Criar estrutura de pasta de uma padrão de projeto PHP. Copie-o para a pasta do projeto, ou para o do Windows e execute no terminal do vscode para facilitar.
@echo off
cls
SETLOCAL ENABLEDELAYEDEXPANSION
:: the two blank lines are required!
set NLM=^
set NL=^^^%NLM%%NLM%^%NLM%%NLM%
:: Example Usage:
@JRGGRoberto
JRGGRoberto / lista.html
Created April 9, 2024 17:57
Lista com numeração dinâmica
<!DOCTYPE html>
<html>
<body>
<h1>Título</h1>
<ol id="menu">
<li><a href="#cafe">Café</a></li>
<li><a href="#verde">Limão</a></li>
<li><a href="#laran">Orange</a></li>
@JRGGRoberto
JRGGRoberto / VIEW_projetostb.sql
Created March 15, 2024 13:48
View que junta todos os projetos
CREATE OR REPLACE VIEW `projetostb` AS
select
n.id AS id,
n.coordenador AS coordenador,
n.titulo AS titulo,
n.campus AS campus,
n.ano AS ano,
n.arq_projeto AS arq_projeto,
n.arq_relatorio AS arq_relatorio,
n.versao AS versao
@JRGGRoberto
JRGGRoberto / TabelaDinamica.html
Last active March 30, 2023 19:33
Tabela dinamica. Dados inseridos via input. Javascript
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css">
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/jquery.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>
@JRGGRoberto
JRGGRoberto / Array PHP
Created March 20, 2023 19:12
<!DOCTYPE html>
<html>
<body>
<?php
$total = 6;
class Blocos {
public $pos;
public $cor;
@JRGGRoberto
JRGGRoberto / PKG_KAF24F.pck
Last active January 30, 2019 14:01
KAF
CREATE OR REPLACE PACKAGE PKG_KAF24F is
-- Author : Roberto Gomes
-- Created : 25/01/2019
-- Purpose : Package para exportar dados para envio a KAF24h
-- http://kaf24h.com.br/
Procedure Cria_Registros;
Procedure Apagar_Registros(V_Id in out number);
Procedure MarcarComoEnviado(idReg in out number);
@JRGGRoberto
JRGGRoberto / Classe.dart
Last active December 25, 2018 14:49
Dart Flutter
class Pessoa {
String nome;
int idade;
double altura;
void dormir(){
print("$nome está dormindo!");
}
void aniver(){
@JRGGRoberto
JRGGRoberto / Oracle_Qry_where_case.sql
Last active December 20, 2018 16:56
Oracle SQL -2
select
'.config' doc,
case when af.dtliberacao >= t.tp_prms then 1 else 0 end Imprime
from tb_prms_glob t,
assistfinanc af
where
t.nm_prms = 'KIT_IMPRESSAO'
and af.numcontratoemp = :NUMCONTRATO
union
@JRGGRoberto
JRGGRoberto / GetDadoMySQL.php
Created September 15, 2016 15:57
Google Grafs- https://google-developers.appspot.com/chart/interactive/docs/gallery/areachart#loading
<?php
$conn = new mysqli("localhost","root","20gmtel14","Dashboards");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql= "select DATE_FORMAT(dt, '%k:%i') as dt, n1, n2, n3, n4, n5, n6, n51, n52 from graf_log_trunks_sft order by id";
$result = $conn->query($sql);