Jean-Philippe Léveillé webgraphe
webgraphe
/ php-soap-client-chameleon-design-bug.php
Last active
July 20, 2019 19:32
PHP SOAP Client issue with "chameleon design pattern"
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 | |
| function includedXsd($ns = null) | |
| { | |
| $ns = $ns ? " xmlns=\"{$ns}\"" : ''; | |
| return <<<XML | |
| <?xml version="1.0" encoding="UTF-8"?> | |
| <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"{$ns}> | |
| <xsd:attributeGroup name="CurrencyAmountGroup"> |
webgraphe
/ mysql-database-inspection.sql
Created
August 8, 2018 16:33
Quick inspection script for MySQL databases
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
| set @db = 'DATABASE-NAME'; | |
| SELECT | |
| TABLE_SCHEMA as `Database`, | |
| TABLE_NAME as `Table`, | |
| TABLE_ROWS as `Rows`, | |
| ROUND(AVG_ROW_LENGTH / 1024, 2) as `Average Row Length (KB)`, | |
| COLUMN_NAME as `Primary Key Column`, | |
| DATA_TYPE as `Data Type`, | |
| ROUND(DATA_LENGTH / (1024 * 1024), 2) as `Data Usage (MB)`, |
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
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset="utf-8"> | |
| <title>CSVu</title> | |
| <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> | |
| <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" | |
| integrity="sha384-WskhaSGFgHYWDcbwN70/dfYBj47jz9qbsMId/iRN3ewGhXQFZCSftd1LZCfmhktB" | |
| crossorigin="anonymous"> | |
| <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"> |
webgraphe
/ phollow.html
Last active
June 27, 2018 20:30
An HTML/JavaScript view on JSON messages delivered through WebSocket
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
| <!doctype html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> | |
| <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" | |
| integrity="sha384-WskhaSGFgHYWDcbwN70/dfYBj47jz9qbsMId/iRN3ewGhXQFZCSftd1LZCfmhktB" crossorigin="anonymous"> | |
| <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"> | |
| <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jquery-jsonview/1.2.3/jquery.jsonview.min.css"> | |
| <link id="favicon" rel="shortcut icon" type="image/png" href=""> |