PHPize Online / SQLize Online  /  SQLtest Online

<?php use Carbon\Carbon; $table = 'unicodetest' . rand(1, 99999); $setup1 = " CREATE TABLE $table( [name] [nvarchar](max) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ;"; $setup2 = " CREATE PROCEDURE guest.spTestUnicode ( @action nvarchar(256) = 'ADD' , @name NVARCHAR(max), @title NVARCHAR(max), @table NVARCHAR(max) ) AS BEGIN INSERT INTO $table (name) VALUES (@name) END; "; $stmt = $pdo->prepare($setup1); $stmt->execute(); $stmt = $pdo->prepare($setup2); $stmt->execute(); printf("\nCurrent PHP version: %s \n\n", phpversion()); $query = "SET NOCOUNT ON; EXEC guest.spTestUnicode @action = N:action, @name = :name, @title = :title, @table = :table;"; $action = 'test😃'; $name = 'test😃'; $title = 'test😃'; $tables = 'test😃'; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->bindParam('action', $action, PDO::PARAM_STR, mb_strlen($action), PDO::SQLSRV_ENCODING_UTF8); $stmt->bindValue('name', $test, PDO::PARAM_STR); $stmt->bindValue('title', $title, PDO::PARAM_STR); $stmt->bindValue('table', $tables, PDO::PARAM_STR); $stmt->execute(); var_dump($stmt->debugDumpParams()); // $row = $stmt->fetch(PDO::FETCH_ASSOC); echo "<pre>"; $stmt = $pdo->prepare("SELECT * from $table;"); $row = $stmt->fetchAll(PDO::FETCH_ASSOC); print_r($row); // // Select using Laravel // $version = $db::select($query); // printf('DB version (Laravel Query Builder): %s ' . PHP_EOL, $version[0]->version);