Skip to content

Instantly share code, notes, and snippets.

View raphaeldealmeida's full-sized avatar

Raphael de Almeida raphaeldealmeida

116 followers · 132 following
View GitHub Profile
@raphaeldealmeida
raphaeldealmeida / codeigniter_iis.md
Created September 13, 2024 00:22
Instalar codeigniter 4 no IIS

O CodeIgniter vem com um arquivo .htaccess para rodar diretamente no servidor web Apache. Porém isso não funciona no IIS.

1 - Configurar as permissões no IIS

Abra o Gerenciador do IIS (IIS Manager).

Adicione um novo Website:

  • Clique com o botão direito em Sites e escolha Adicionar site.
  • Preencha os detalhes como o nome do site, caminho físico da sua aplicação (onde você colocou o CodeIgniter no servidor) e configure a porta.
  • Certifique-se de que o pool de aplicativos esteja configurado para rodar com a versão correta do PHP.
@raphaeldealmeida
raphaeldealmeida / typescriptreact.json
Last active June 28, 2024 12:49
Mithril VS Code snippets
{
// Mithril snippets
// Paste in File > Preferences > Configure User Snippets > typescriptreact.json
// ref: https://code.visualstudio.com/docs/editor/userdefinedsnippets
"Mithril component": {
"prefix": ["mcomp"],
"body": [
"import m from \"mithril\"",
"",
@raphaeldealmeida
raphaeldealmeida / added-services.js
Created June 13, 2024 21:55
function initPayPalButton() {
var shipping = 0;
var orderDescription = 'Additional Services';
if(orderDescription === '') {
orderDescription = 'Item';
}
paypal.Buttons({
style: {
shape: 'rect',
@raphaeldealmeida
raphaeldealmeida / MyComponent.tsx
Created July 15, 2023 13:00
Generic mithril js component snippet
import m from "mithril"
type TProps = {}
const MyComponent: m.ClosureComponent<TProps> = () => {
return {
view: () =>
{
return <>
@raphaeldealmeida
raphaeldealmeida / wp-install.sh
Created June 14, 2021 18:21
Step-by-step wp install using wp-cli
mkdir blog
cd blog
wp core download
wp config create --dbname=wordpress_plugin --dbuser=root --dbpass=root
wp db create
wp core install --url=example.com --title=Example --admin_user=supervisor --admin_password=password [email protected]
wp server --port=8001
@raphaeldealmeida
raphaeldealmeida / interactive_maps.html
Created April 26, 2021 15:49
This file has been truncated, but you can view the full file.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<style>
@raphaeldealmeida
raphaeldealmeida / previsao.sql
Created August 19, 2019 23:13
select avg(valor) previsao_valor from (
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
where (EMPRESA_ID = 1)
and (VALOR > 0)
and (DAY_WEEK = 1)
UNION
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
@raphaeldealmeida
raphaeldealmeida / previsao.sql
Created August 19, 2019 23:13
select avg(valor) previsao_valor from (
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
where (EMPRESA_ID = 1)
and (VALOR > 0)
and (DAY_WEEK = 1)
UNION
SELECT TOP (1000) avg(VALOR) valor
FROM [onboard].[dbo].[RESUMO]
@raphaeldealmeida
raphaeldealmeida / testconn.php
Last active May 13, 2019 18:12
<?php
$host = "";
$db = 'onboard';
$user = 'inffel';
$pass = "";
$conn = new PDO("sqlsrv:server=$host,1433;Database=$db", $user, $pass);
$tsql = "select * from usuarios";
@raphaeldealmeida
raphaeldealmeida / docker_sqlsrv.sh
Last active April 3, 2019 23:31
sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' -p 1433:1433 --name sql1 -d -v /home/raphael/projects/freelas/OnBoard/Backup:/home/backup mcr.microsoft.com/mssql/server:2017-latest
sudo docker start sql1
sudo docker exec -it sql1 "bash"
## on container, it request pass
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE central FROM DISK = '/home/backup/Central.bak' WITH MOVE 'central' TO '/var/opt/mssql/data/central.mdf', MOVE 'central_log' TO '/var/opt/mssql/data/central.ldf'"
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q "RESTORE DATABASE onboard FROM DISK = '/home/backup/Onboard.bak' WITH MOVE 'onboard' TO '/var/opt/mssql/data/onboard.mdf', MOVE 'onboard_log' TO '/var/opt/mssql/data/onboard.ldf'"