odan

Installing Xdebug for XAMPP with PHP 7.x

• New: XAMPP - XDebug Setup for PHP 8

Requirements

• XAMPP for Windows: https://www.apachefriends.org/download.html
• Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017 and 2019

Setup

odan

Nginx and PHP Setup on Windows

For local development you could also use Nginx with PHP as an replacement for XAMPP.

Install Nginx

• Download Nginx for Windows: http://nginx.org/en/download.html | Direct: nginx-1.19.7.zip
• Extract the ZIP file to c:\nginx
• Open the file c:/nginx/config/nginx.conf and replace the server { ... } section with this configuration:

odan

Free PHP Webhosting

• https://www.infinityfree.com/
• https://x10hosting.com/

Inexpensive Webhosting

• https://www.nearlyfreespeech.net/ ($0.25)
• https://www.netcup.eu/ (~ $30 / year)
• https://www.manitu.de/webhosting/

odan

Exporting SQL Server database structure into SQL script files

Scripting your SQL Server database schema is one such task that can benefit significantly from automation. Using C# and SQL Server Management Objects (SMO), you can easily generate scripts for your database schema and data.

Automating database scripting ensures that your schema and data scripts are always up-to-date and reduces the risk of human error. It is particularly useful for version control, backups, and migration tasks.

By integrating it into your workflow, you can significantly enhance your database management processes.

odan

XAMPP - Oracle Driver Setup (v12)

The url has changed: https://odan.github.io/2017/03/21/xampp-oracle-driver-setup-v12.html

odan

@echo off

winget list

winget uninstall "Solitaire & Casual Games"
winget uninstall "Microsoft Kontakte"
winget uninstall "Movies & TV"
winget uninstall "News"
winget uninstall "Get Help"
winget uninstall "Microsoft People"

odan

Generating UUID v4 in MySQL

SELECT
  LOWER(
    CONCAT(
      # 1th and 2nd block are made of 6 random bytes
      HEX(RANDOM_BYTES(4)),
      '-',
 HEX(RANDOM_BYTES(2)),

odan

<?php

$dom = new DOMDocument();
$dom->preserveWhiteSpace = false;
$dom->formatOutput = true;
$dom->loadXML(file_get_contents(__DIR__ . '/demo.xml'));

$dom = removeAllNamespaces($dom);

$dom->save('demo-out.xml');

odan

using System;
using System.Collections.Generic;
using System.Globalization;

// CultureInfo culture = new CultureInfo("en-US");

// Full-date notation as defined by RFC 3339, section 5.6, for example, 2024-03-28
string date1 = string.Format("{0:yyyy}-{0:MM}-{0:dd}", DateTime.Now);
Console.WriteLine(date1);

odan

Sign SOAP messages with xmlseclibs

Requirements

• PHP 7.4+
• OpenSSL

Generating Public and Private Keys

First we have to create a private key for signature creation, and a public key for verification.