This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
placa | modelo | ano | fabricante | |
---|---|---|---|---|
LQO-6674 | D250 Club | 1993 | Dodge | |
ADK-0804 | Landaulet | 1993 | Maybach | |
FJB-0338 | Explorer | 1993 | Ford | |
LJR-5297 | C70 | 1993 | Volvo | |
DJH-1485 | Astro | 1991 | Chevrolet | |
BSK-9052 | CLS-Class | 1993 | Mercedes-Benz | |
ZCJ-8701 | MX-5 | 1993 | Mazda | |
AVL-1411 | 4000s Quattro | 1992 | Audi | |
EOG-9618 | Xterra | 1991 | Nissan |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- PostgreSQL database dump | |
-- | |
-- Dumped from database version 11.3 | |
-- Dumped by pg_dump version 11.2 | |
-- Started on 2019-05-23 23:23:19 | |
SET statement_timeout = 0; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 4.8.4 | |
-- https://www.phpmyadmin.net/ | |
-- | |
-- Host: 127.0.0.1:3306 | |
-- Generation Time: 24-Maio-2019 às 01:49 | |
-- Versão do servidor: 5.7.24 | |
-- versão do PHP: 7.3.1 | |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
begin tran | |
DROP TABLE IF EXISTS [autor]; | |
CREATE TABLE autor ( | |
[id] int NOT NULL IDENTITY, | |
[nome] varchar(255) NOT NULL, | |
PRIMARY KEY ([id]) | |
) ; | |
-- |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- -------------------------------------------------------- | |
-- Servidor: 10.120.100.14 | |
-- Versão do servidor: 5.1.61 - Source distribution | |
-- OS do Servidor: redhat-linux-gnu | |
-- HeidiSQL Versão: 10.1.0.5464 | |
-- VERSÃO CORRIGIDA POR TARCÍSCIO FREITAS: https://www.linkedin.com/in/tarcisio-freitas-1484bb9/ | |
-- -------------------------------------------------------- | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$options = [ | |
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, | |
PDO::ATTR_EMULATE_PREPARES => false, | |
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC | |
]; | |
$server = "localhost"; | |
$user = "php"; | |
$senha = "admin"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
include '../conexao_postgres.php'; | |
$fotos = [ | |
1 => 'Lurdes Boça', | |
2 => 'Wallace Guilhermino', | |
3 => 'Edson Wander', | |
4 => 'Cláudio Ricardo', | |
5 => 'Neo Labaque', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP TABLE IF EXISTS `log`; | |
CREATE TABLE IF NOT EXISTS `log` ( | |
`id` int(11) NOT NULL AUTO_INCREMENT, | |
`dados` text NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; | |
-- | |
-- Extraindo dados da tabela `log` | |
-- |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
//table example: https://gist.github.com/celsowm/82cace3ae81fdaf653a3e944007892bc | |
include 'conexao.php'; | |
class Log implements \Serializable { | |
public $id; | |
public $dados; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP TABLE IF EXISTS teste; | |
CREATE SEQUENCE teste_seq; | |
CREATE TABLE IF NOT EXISTS teste ( | |
id bigint NOT NULL DEFAULT NEXTVAL ('teste_seq'), | |
datetime timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP, | |
channel int DEFAULT NULL, | |
value double precision DEFAULT NULL, | |
PRIMARY KEY (id) | |
) ; |
OlderNewer