PHP

unpack JSON blobs in CSV and store as JSON

<?php
ini_set('memory_limit', '200M');

$rows = [];
$separator = ",";

if (($file = fopen($argv[1], "r")) !== FALSE) {
  if (fgets($file, 4) !== "\xef\xbb\xbf") rewind($file); //Skip BOM if present
  $header = fgetcsv($file, 0, $separator, "\"", "\\"); // read and skip header

  while (($data = fgetcsv($file, 0, $separator, "\"" , "\\")) !== FALSE) {
    $row = array_combine($header, $data);
    $row["answers"] = json_decode($row["answers"]);
    $row["merged"] = json_decode($row["merged"]);
    $rows[] = $row;
  }
  fclose($file);
}

echo(json_encode($rows,JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES));
?>

PHP Fatal error: Allowed memory size of bytes

ini_set('memory_limit', '200M');

pass through jpg

see also htaccess

$guid = pathinfo(basename($_SERVER["REDIRECT_URL"]), PATHINFO_FILENAME);

if (strlen($guid)==32) {
  header("Content-type: image/jpeg");
  readfile("https://SERVER/$guid");
};

PHP Fatal error: Uncaught Error: Class "Normalizer" not found in /usr/share/php/Symfony/Component/Console/Helper/Helper.php:65

sudo apt install php8.1-intl  # with version number!

always cast numbers to string in CSV

$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
//...
fputcsv($fp, $header);
foreach ($results as $row) {
    $row = array_map(function($value) { return '"' . $value . '"'; }, $row); //cast to strings
    fputcsv($fp, $row, ',', "'");
}
fclose($fp);

echo mysql query as CSV

<?php
require "query_to_csv.php";
query_to_csv(<<<SQL
  select 
      locatie.nid "ID", 
      locatie.title "Naam",
      link.field_link_url "Link_URL",
      (replace(file_managed.uri,"public:/","xxxxxxxxx")) "Logo_URL"
  from node locatie
  join field_data_field_link link on link.entity_id=locatie.nid and link.bundle='logo'
  left join file_usage on file_usage.id=locatie.nid
  left join file_managed on file_managed.fid=file_usage.fid    
  where locatie.type='logo'
  and file_usage.type='node'
SQL);
?>

#query_to_csv.php
function query_to_csv($query) {
  ini_set('display_errors', 'On');
  // error_reporting(0);
  error_reporting(E_ALL & ~E_NOTICE);
  $r = array();

  require('../../sites/default/settings.php');

  if(isset($databases)) {
    $db = $databases['default']['default'];

    $dsn = 'mysql:host=localhost;charset=utf8mb4;dbname='.$db['database'];
    $username = $db['username'];
    $password = $db['password'];

    try {
        $db = new PDO($dsn, $username, $password);
    } catch (PDOException $e) {
        echo 'Connection failed: ' . $e->getMessage();
    }

    $stmt = $db->prepare($query);
    $stmt->execute();
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);

    header('Content-Type: text/plain; charset=utf-8');
    $fp = fopen('php://output', 'w');
    $header = array_keys($results[0]);
    fputcsv($fp, $header);
    foreach ($results as $row) {
        fputcsv($fp, $row);
    }
    fclose($fp);
  }
}

Query MS Access database with PHP using PDO+ODBC

On windows 11 with IIS 8 I first needed to install AccessDatabaseEngine_x64.exe from Microsoft to get rid of the following Error: "Data source name not found and no default driver specified"

$mdbFile='C:\db6.mdb';
$pdo = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=".$mdbFile);

$sql="select top 10 * from afbeelding";
$stm = $pdo->query($sql);
$rows = $stm->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_CLASSTYPE);

header("Content-type: application/json");
echo json_encode($rows);

strip footer using regex

$html = preg_replace('/<footer.*<\/footer>/s', "", $html);

permanent redirect

header("Location: https://NEWSITE", true, 301);

disable buffering (realtime output of executed script)

ini_set('output_buffering', 'off');        // Turn off output buffering
ini_set('zlib.output_compression', false); // Turn off PHP output compression
ini_set('implicit_flush', true);           // Implicitly flush the buffer(s)
ob_implicit_flush(true); 
while (ob_get_level() > 0) {               // Clear, and turn off output buffering
    $level = ob_get_level();               // Get the curent level
    ob_end_clean();                        // End the buffering
    if (ob_get_level() == $level) break;   // If the current level has not changed, abort
}
if (function_exists('apache_setenv')) {
    apache_setenv('no-gzip', '1');         //disable apache compression
    apache_setenv('dont-vary', '1');       //disable apache output buffering
}

//....

$process = proc_open($cmd, 
    array(
      0 => array("pipe", "r"), 
      1 => array("pipe", "w"), 
      2 => array("pipe", "w")
    ),
    $pipes, realpath('./'), array());

if (is_resource($process)) {
    while ($s = fgets($pipes[1])) {
        print "<p>".$s."</p>";
        flush();
    }
}

generate Excel Spreadsheet

fierst install PhpSpreadsheet by:

composer require phpoffice/phpspreadsheet

...

require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
//...
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->fromArray(["a","b","c"],NULL,'A1'); //header
//...
//foreach col
  $sheet->getCellByColumnAndRow($col, $row)->setValue("value");
//
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="result.xlsx"');
$writer = new Xlsx($spreadsheet);
$writer->save('php://output');
die();

restart PHP FPM after changing php.ini file

sudo /etc/init.d/php7.3-fpm restart

SQLite

$db = new SQLite3('kadaster.db');
$sql = "SELECT * FROM Kadaster";
$results = $db->query($sql);
  $data = array();
  while ($row = $results->fetchArray(SQLITE3_ASSOC)) {
    array_push($data, $row);
  }
  echo json_encode($data);

HTTP POST base64 encoded image and wait for processing

$img = file_get_contents('x.jpg');
$b64 = base64_encode($img);

$header = "accept: */*\r\n".
  //...
  "content-type: application/json\r\n";

$data = array(
  "x" => array(
    "y" => array(
      "z" => 123
    ),
  ),
  "a" => array(
    "base64" => $b64
  )
);

$options = array(
  'http' => array( // use key 'http' even if you send the request to https://...
    'header'  => $header,
    'method'  => 'POST',
    'content' => json_encode($data) //http_build_query($data)    
  ),
);

$context  = stream_context_create($options);
$result = file_get_contents($url, false, $context);
if ($result === FALSE) die("Error");

$json = json_decode($result);
$status = $json->status;
$id = $json->id;

ODBC

ini_set('display_errors', 'On');

$mdbFilename="db6.mdb";
$driver="MDBTools";
//$connection = odbc_connect("odbc:Driver=MDBTools;Dbq=$mdbFilename;", "", "");

$dataSourceName = "odbc:Driver=$driver;DBQ=$mdbFilename;";
$connection = new \PDO($dataSourceName);

$query="select * from afbeelding";
$result = $connection->query($query)->fetchAll(\PDO::FETCH_ASSOC);
print_r($result);

get objects in json

function loadData() {
  return json_decode(file_get_contents("data.json"));
}

function sendData($data) {
  header("Content-type: application/json");
  echo json_encode($data);
}

function getPersons() {
  return loadData()->persons;
}

function getPerson($personId) { //main info of a person
  $p = array_values(array_filter(getPersons(), function($item) use ($personId) { return $item->id == $personId; }));
  if ($p) return $p[0];
}

function getEvents($personId) { //the events of a person
  $events = loadData()->events;
  return array_values(array_filter($events, function($item) use ($personId) { return $item->personId == $personId; }));
}

flight

require 'vendor/autoload.php';

//....

Flight::route('/', function(){
  echo '';
});

Flight::route('/persons', function(){
  sendData(getPersons());
});

Flight::route('/persons/@personId', function($personId){
  sendData(getPerson($personId));
});

Flight::route('/persons/@personId/events', function($personId){
  sendData(getEvents($personId));
});

Flight::start();

php frameworks

• https://flightphp.com/
• https://www.slimframework.com/
• https://docs.guzzlephp.org/en/stable/

php.ini

php --ini

thumbnail from video using ffmpeg

$time = $_GET["time"];
$tmp = tempnam("/tmp", "thumb").".jpg";
$id = $_GET["id"];

if (!is_numeric($id)) die("id");
if (!preg_match('/\\d{2}\\:\\d{2}\\:\\d{2}/', $time)) die("time");

shell_exec("ffmpeg -i thumbs/$id.mp4 -ss $time -vframes 1 $tmp 2>&1");

header("Content-type: image/jpeg");
imagejpeg(imagecreatefromjpeg($tmp));

force download

header("Content-disposition: attachment; filename='$filename'");
header("Content-type: application/json");
$json = file_get_contents($db . $id . "/sketch");
die($json);

make safe filename

$filename = preg_replace( '/[^a-z0-9]+/', '-', strtolower($json->name . " by " . $json->author)) . ".ext";

get querystring

if ($_SERVER['QUERY_STRING']=='123') {

receive JSON from P5.js

p5js:

var data = { from: 'Rick', msg: 'Hello' }
httpPost('loopback.php', data, function(res) {
  console.log("response: ",res);
});

php:

header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Headers: Content-Type,Accept");
header('Content-Type: application/json');
$data = json_decode(file_get_contents("php://input"));
echo json_encode($data);

PHP glob files by date

https://pp19dd.com/2010/12/php-glob-files-by-date/

$files = glob( "../../../feed21/*.xml" );
// Sort files by modified time, latest to earliest
// Use SORT_ASC in place of SORT_DESC for earliest to latest
array_multisort(
  array_map( 'filemtime', $files ),
  SORT_NUMERIC,
  SORT_DESC,
  $files
);

anonymous function instead of create_function (php7)

the old way:

usort($files, create_function('$a,$b', 'return filemtime($b) - filemtime($a);'));

the new way:

usort($files, function($a, $b) {
  return filemtime($b) - filemtime($a);
});

string replace for each item in array

$out = str_replace('a', 'b', $array);

list files ordered (newest first) as json

header('Content-type: application/json');
$files = glob("*.png");
usort($files, create_function('$a,$b', 'return filemtime($b) - filemtime($a);'));
echo json_encode($files);

list files as json

header('Content-type: application/json');
echo json_encode(glob("*.png"));

log

$log = date('Y-m-d-H-i-s') . "\t" . $_GET["localip"] . "\t" . $_GET["wifiboxid"] . "\t" . getenv('REMOTE_ADDR') . "\t\n";
file_put_contents("log/log.txt", $log, FILE_APPEND);

bare bone upload script

if (isset($_FILES["file"])) {
  move_uploaded_file($_FILES["file"]["tmp_name"], "files/" . date('Y-m-d-H-i-s') . ".d3sketch");
}

php serve

php -S localhost:8000

parse cloudant json through template

<?
$db = "https://.....cloudant.com/....";

//check requested URL for doc_id of 32 chars
preg_match('/^\/(.*)/',$_SERVER["REDIRECT_URL"], $matches, PREG_OFFSET_CAPTURE);
if (count($matches)!=2 || strlen($matches[1][0])!=32) all($db);
else single($db,$matches[1][0]);

function single($db,$id) {
  $status = get_headers("$db/$id")[0];
  if ($status!="HTTP/1.0 200 OK") die ("ERR:db");

  $obj = json_decode(file_get_contents("$db/$id"));

  $template = file_get_contents("single.html");
  $template = str_replace("{db}", $db, $template);
  $template = str_replace("{id}", $id, $template);
  $template = str_replace("{url}", "https://share.doode3d.com/$id", $template);
  $template = str_replace("{image}", "$db/$id/img", $template);
  $template = str_replace("{title}", $obj->name, $template);
  $template = str_replace("{author}", $obj->author, $template);

  echo $template . "
";
}

function all($db) {
  $json = file_get_contents('https://......cloudant.com/......?limit=25&reduce=false&descending=true');
  $obj = json_decode($json);
  foreach  ($obj->rows as $row) {
    $id = $row->id;
    $thumb = $row->value->thumb;
    echo "<a href='https://......./$id'><img src='$thumb'></a>
";
  } 
}

?>

composer

https://getcomposer.org/doc/00-intro.md

  curl -sS https://getcomposer.org/installer | php
  php composer.phar install

list images in folders as JSON

<?php
header('Content-type: application/json');
$rootfolder = "photos/*";
$albums = [];

foreach (glob($rootfolder) as $folder) {
  $album = [];
  $album["folder"] = basename($folder);
  $album["title"] = basename($folder);

  $items = [];
  foreach (glob($folder."/*.jpg") as $filename) {
    list($width, $height, $type, $attr) = getimagesize($filename);
    $item = [];
    $item["filename"] = basename($filename);
    $item["src"] = $filename;
    $item["w"] = $width;
    $item["h"] = $height;
    $items[] = $item;
  }
  $album["photos"] = $items;
  $albums[] = $album;
}

echo json_encode($albums);
?>

json header

header('Content-type: application/json');

array_map & str_getcsv

//"07","Week 3","54.jpg"
$a = array_map('str_getcsv', file('info.txt'));

glob

foreach (glob("fotos/$folder/*.jpg") as $filename) {
  list($width, $height, $type, $attr) = getimagesize($filename);
  $items[] = "{ src: '$filename', w:$width, h:$height }";
}

youmagine missing API call: get image preview for document

header("Access-Control-Allow-Origin: *");
header("Content-type: text/plain");
if (empty($_GET['id'])) die("id is undefined");
if (!is_numeric($_GET['id'])) die("id should be a valid number");
$id = $_GET["id"];

$json = json_decode(file_get_contents("https://www.youmagine.com/documents/$id.json"));
$documentable_id = $json->documentable_id;
$url = getDesignURLById($documentable_id);
$html = file_get_contents($url);

preg_match("/<article data-id=\"".$id."\" .+?id=\"(\d+)\"/", $html, $matches);

echo $matches[1];

function getDesignURLById($designId) {
  $url = "https://www.youmagine.com/designs/$designId";
  $ch = curl_init($url);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
  curl_setopt($ch, CURLOPT_HEADER, TRUE); // We'll parse redirect url from header.
  curl_setopt($ch, CURLOPT_FOLLOWLOCATION, FALSE); // We want to just get redirect url but not to fo$
  $response = curl_exec($ch);
  preg_match_all('/^Location:(.*)$/mi', $response, $matches);
  curl_close($ch);
  return !empty($matches[1]) ? trim($matches[1][0]) : 'No redirect found';
}

PHP.INI on OpenPanel

/etc/php5/apache2/php.ini

Use PHPMailer for sending email with attachment

require 'PHPMailerAutoload.php';
$bodytext = "Testing...";
$email = new PHPMailer();
$email->From      = 'from@email.com';
$email->FromName  = 'YOU';
$email->Subject   = 'Message Subject';
$email->Body      = $bodytext;
$email->AddAddress('to@email.com');
$file_to_attach = 'test.png';
$email->AddAttachment( $file_to_attach , 'test.png' );
return $email->Send();

Save Base64 encoded raw data from post as image

header("Access-Control-Allow-Origin: *");
$img = $GLOBALS["HTTP_RAW_POST_DATA"];
$img = str_replace('data:image/png;base64,', '', $img);
$img = str_replace(' ', '+', $img);
$data = base64_decode($img);
$file = 'test.png';
$success = file_put_contents($file, $data);

Install GD

  apt-get install php5-gd

online code testen

http://runnable.com/

socket server with php

http://devzone.zend.com/209/writing-socket-servers-in-php/

upload script

based on: http://www.w3schools.com/php/php_file_upload.asp permissions: 755

<?php
if ($_FILES["file"]["error"] > 0)
  {
  echo "Error: " . $_FILES["file"]["error"] . "<br>";
  }
else
  {
  echo "Upload: " . $_FILES["file"]["name"] . "<br>";
  echo "Type: " . $_FILES["file"]["type"] . "<br>";
  echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB<br>";
  echo "Stored in: " . $_FILES["file"]["tmp_name"] . "<br>";

  move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . $_FILES["file"]["name"]);
  echo "Stored in: " . "upload/" . $_FILES["file"]["name"];

  }
?>

Solve the following problem om CentOS

'''PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/module.so' - /usr/lib64/php/modules/module.so: cannot open shared object file: No such file or directory in Unknown on line 0'''

edit /etc/php.d/mcrypt.ini and change

extension=module.so

to

extension=mcrypt.so

AMPPS

• http://www.ampps.com/

last item from array

$item = end($array);

strip illegal characters from string

$location = preg_replace('/[^( -)]*/','', $location);

append or create if not exists

file_put_contents($path, $data, FILE_APPEND);

get random string

function getRandomKey($count) { 
  $chars = "abcdefghijklmopqrstuvwxyz1234567890";
  for ($a=0; $a<$count; $a++) $str.=$chars[rand(0,strlen($chars)-1)];
  return $str;
}
echo getRandomKey(6);

or shorter and with no duplicate characters per string:

echo substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyz"), 0, 6);

or if you only need a hex string:

echo substr(md5(rand()), 0, 6);

get url info ie. in 404.php

echo $_SERVER["REDIRECT_URL"];

remove links with regexp

$result = preg_replace('/(https?|ftp|file):\/\/[-A-Z0-9+&@#\/%?=~_|$!:,.;]*[A-Z0-9+&@#\/%=~_|$]/i', '', $input);

auto include

function __autoload($class_name) {
    include $class_name . '.php';
}

extract, stripslashes & sqlite escape

if (get_magic_quotes_gpc() ) {
  $_GET = array_map('stripslashes', $_GET);
}
$_GET = array_map('sqlite_escape_string', $_GET);
extract($_GET);

json header

  header("Content-type: application/json");```

#file_get_contents_utf8
```php
function file_get_contents_utf8($fn) {
    $content = file_get_contents($fn);
    return mb_convert_encoding($content, 'UTF-8', mb_detect_encoding($content, 'UTF-8, ISO-8859-1', true));
}

encoding of non utf-8 content to json

http://www.php.net/manual/en/function.json-encode.php#99837

Convert PHP Object to array

$eventArray = (array)$event;

Encoding

als je last van rare tekens hebt (zoals ë wordt ë) dan staat misschien de encoding van je pagina verkeerd.

header("Content-Type: text/plain; charset=utf-8"); //iso-8859-1

Bij het inserten van UTF-8 tekst in een MySQL datebase dien je eerst een utf8_decode te gebruiken zoals het er nu naar uitziet.

  $event->description = utf8_decode($tweet->text);

Als de tijd niet goed staat in PHP staat misschien je timezone verkeerd

setlocale(LC_ALL, "nl_NL");
date_default_timezone_set("Europe/Amsterdam");

ssl disabled

if ssl seems to be disabled in php just enable it like this in your php.ini:

extension=php_openssl.dll

short open tags

in php.ini

short_open_tag = On

http://www.php.net/manual/en/ini.core.php#ini.short-open-tag

connect to mysql through console/command line PHP but without Apache

if you get this error:

PHP Warning:  mysql_connect(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) 

try to connect to 127.0.0.1 instead of localhost

twitter

twitter uitlezen met PHP? zie [[Twitter]]

php versie opvragen

php -v

if else endif

<?php if( condition ): ?>
...  
<?php else: ?>
...
<?php endif; ?>

PEAR

Ik moet me nog steeds eens verdiepen in PEAR: http://pear.php.net/manual/en/package.database.db.intro-fetch.php

while / list / each

while (list($k, $v) = each($_GET)) {
  echo $k . '=' . $v . ', ';
}

mysql transactions in php

$this->db->startTransaction();
foreach($userIds as $id) {
  $this->db->update("INSERT INTO ......");
}
$this->db->commit();

Internal Server Error 500 door PHP in Apache

Als Apache error 500 geeft kan dat liggen aan een fout in de syntax van een PHP script. Door het aanzetten van display_errors in php.ini of door het gebruiken van de ini_set functie in php kun je de exacte foutmelding achterhalen.

ini_set('display_errors', 'On');

Als dat niet helpt kun je ook je php.ini aanpassen. In mijn geval stond die hier (het pad kun je opvragen mbv ''phpinfo()'':

/Applications/MAMP/bin/php/php5.3.6/conf/php.ini
of hier (op OpenPanel):
/etc/php5/apache2/php.ini

php error log

/Applications/MAMP/logs/php_error.log  

import_request_variables icm sqlite vs extract

Problemen met quotes in sqlite zelfs na SQLite3::escapeString of sqlite_escape_string?

• zie post van brian at enchanter in de [[http://php.net/manual/en/function.import-request-variables.php|php reference]]
• maar vooral ook: [[http://www.dirac.org/linux/databases/sql_quoting/|sql quoting]]

  import_request_variables("g","_"); //kijkt niet naar $_GET dus negeert magic quotes.

  ik gebruik nu ipv daarvan extract (ik weet niet of dat veilig genoeg is maar het werkt wel):

  if (get_magic_quotes_gpc() ) {
  $_GET = array_map('stripslashes', $_GET);
  }
  $_GET = array_map('sqlite_escape_string', $_GET);
  extract($_GET);

Content-type voor json

header("Content-type: application/json");

Scraper

require 'scraperwiki/simple_html_dom.php';

$html_content = scraperwiki::scrape("http://ofxaddons.com/");
$html = str_get_html($html_content);

foreach ($html->find("div.category") as $categories) {
    foreach ($categories->find("div.repo") as $addons) {
        //if ($ttl++>20) exit();

        $link = $addons->find("a.github_link");
        $link = $link[0]->href;

        $name = explode("/",$link);
        $name = $name[count($name)-1];

        $author = explode("/",$link);
        $author = $author[3];

        $category = $categories->find("h2 a");
        $category = $category[0]->plaintext;

        //print $category . " - " . $name . " - " . $author . " - " . $link . "
";

        $records[] = array("link"=>$link, "name"=>$name, "author"=>$author, "category"=>$category);
    }
}

print "saving...
";
$unique_keys = array("link");
$table_name = "repos";
scraperwiki::save_sqlite($unique_keys, $records, $table_name);
print "done
";

mini api

<?
header("Content-type: text/plain");

extract($_GET);

if (isset($pinguin)) {
  $html = file_get_contents("http://www.pinguinradio.nl/");
  $parts = explode("Nu op PinguinRadio.nl:</strong> <I>", $html);
  $parts = explode("</I>",$parts[1]);
  $artist = $parts[0];
  $parts = explode("</h2>", substr($parts[1],3));
  $title = $parts[0];
  die("$artist
$title");
}

if (isset($time)) {
  die(date('Y-m-d h:i:s'));
}