Skip to content

Instantly share code, notes, and snippets.

View koffisani's full-sized avatar

Koffi SANI koffisani

67 followers · 21 following
View GitHub Profile
@koffisani
koffisani / drop-constraint-and-create-again-sql-server.sql
Created December 28, 2016 09:23
Drop and Create constraints in SQL Server
CREATE TABLE #x -- feel free to use a permanent table
(
drop_script NVARCHAR(MAX),
create_script NVARCHAR(MAX)
);
DECLARE @drop NVARCHAR(MAX) = N'',
@create NVARCHAR(MAX) = N'';
-- drop is easy, just build a simple concatenated list from sys.foreign_keys:
SELECT @drop += N'
ALTER TABLE ' + QUOTENAME(cs.name) + '.' + QUOTENAME(ct.name)
@koffisani
koffisani / sending-mail-in-PHP-with-mail-function.php
Created December 27, 2016 22:16
Sending mail in PHP with native mail function
<?php if(isset($_POST['submit'])){
if(isset($_POST['email']) && !empty($_POST['email']) && isset($_POST['name']) && !empty($_POST['name']) && isset($_POST['subject']) && !empty($_POST['subject']) && isset($_POST['message']) && !empty($_POST['message'])){
$to = "contact@micronium.net";
$subject = $_POST['subject'];
$message = $_POST['message'];
//$header = "Name= " .
$header = "From:" . $_POST['name'] . " <" . $_POST['email'] . "> \r\n";
$header .= "MIME-Version: 1.0\r\n";
$header .= "Content-type: text/html\r\n";
$header .= "X-Mailer: PHP/" . phpversion();
@koffisani
koffisani / enable-constraint-sql-server.sql
Created December 26, 2016 11:17
Enable Constraints in SQL Server
USE <nom_database>;
Exec sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all";
@koffisani
koffisani / disable-constraint-sql-server.sql
Created December 26, 2016 10:58
Deactivate all constraints on tables in an SQL Server database.
USE <nom_database> ;
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all";
@koffisani
koffisani / correct-way-to-include-excerpt-in-gh-pages
Created December 24, 2016 10:09
{{ post.content| split: '<!--more-->' | first }} <br/><a href="{{ post.url }}">Lire plus ...</a>
@koffisani
koffisani / wrong-way-to-include-excerpt
Created December 24, 2016 10:07
{{ page.content | truncate(500)}} </br> <a href="{{ post.url }}">Lire plus ... </a>
@koffisani
koffisani / .htaccess
Created October 12, 2016 11:05
.htaccess for CakePhp3 root folder
# .htaccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ index.php?url=$1 [QSA,L]
</IfModule>
@koffisani
koffisani / .htaccess
Created October 12, 2016 11:04
.htaccess file for CakePHP 3 webroot/ folder
# webroot/.htaccess
<IfModule mod_rewrite.c>
RewriteEngine on
RewriteRule ^$ webroot/ [L]
RewriteRule (.*) webroot/$1 [L]
</IfModule>
@koffisani
koffisani / force-https-in-htaccess
Created March 18, 2016 11:45
Pour forcer l'utilisation d'une connexion SSL sur votre site web
###############################################
#Pour forcer l'utilisation d'une connexion SSL sur votre site web, veuillez placer le contenu suivant dans un fichier .htaccess
###############################################
RewriteEngine On
RewriteCond %{HTTPS} !=on
RewriteRule ^(.*)$ https://%{SERVER_NAME}/$1 [R=301,L]
@koffisani
koffisani / open-frame-after-closing-first.cs
Created March 15, 2016 10:56
A brief code for openning a window after closing the first one in C#
private void OnButton1Click(object sender, EventArgs e)
{
this.Hide(); //On cache la fenêtre courante
var form2 = new Form2(); //On instancie la seconde
form2.Closed += (s, args) => this.Close(); //On notifie à la première de se fermer au moment où la seconde se ferme
form2.Show(); //On affiche la seconde
}