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
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
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
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 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'));
}