Wikizone - Benutzerbeiträge [de]

PHP - String Snippets

2019-03-07T07:04:31Z

84.157.30.153: /* Zeilenumbruch einfügen */

== Siehe auch ==
[[PHP - Zahlen formatieren]]

== Überflüssige Whitespace entfernen ==
<syntaxhighlight lang="php">
<?php
$str = 'foo o';
$str = preg_replace('/\s\s+/', ' ', $str);
// This will be 'foo o' now
echo $str;
?>
</syntaxhighlight>
== Zeilenumbruch einfügen ==
string wordwrap ( string $str [, int $width = 75 [, string $break = "\n" [, bool $cut = false ]]] )
== Zeilenenden normalisieren ==
<syntaxhighlight lang="php">
function normalize($s) {
// Normalize line endings using Global
// Convert all line-endings to UNIX format
$s = str_replace(CRLF, LF, $s);
$s = str_replace(CR, LF, $s);
// Don't allow out-of-control blank lines
$s = preg_replace("/\n{2,}/", LF . LF, $s);
return $s;
}
</syntaxhighlight>

== Text kürzen ==
=== Text kürzen / HTML entfernen ===
<syntaxhighlight lang="php">
function truncateText($text,$characters=500){
$summary = strip_tags($text);
if(strlen($summary) > $characters) {
$summary = substr($summary, 0, $characters); // display no more than 500 chars
$trimToSentence = substr($summary, 0, strrpos($summary, ". ")+1); // and truncate to last sentence
if( strlen( $trimToSentence) > intval($characters/3) ) $summary = $trimToSentence; // use it if not too short
}
$summary = trim($summary);
return $summary;
}

// Beispiel 2
function truncateText($text, $maxlength = 200) {
// truncate to max length
$text = substr(strip_tags($text), 0, $maxlength);
// check if we've truncated to a spot that needs further truncation
if(strlen(rtrim($text, ' .!?,;')) == $maxlength) {
// truncate to last word
$text = substr($text, 0, strrpos($text, ' '));
}
return trim($text);
}
</syntaxhighlight>
Einsatz in Processwire:
<syntaxhighlight lang="php">
$summary = truncateText($page->body);
echo "
<a href='$page->url'>$page->title</a>
<p class='summary'>$summary</p>
";
</syntaxhighlight>

=== Text kürzen HTML belassen ===
<syntaxhighlight lang="php">
function truncateHtml($text, $length = 100) {
$current_size = strlen($text);
$diff = strlen($text);
$remainder = $current_size - $length;
while($diff > 0 AND $remainder > 0) {
$pattern = "/(.*)[^<>](?=<)/s";
$text = preg_replace($pattern, "$1", $text);
$diff = $current_size - strlen($text);
$current_size = strlen($text);
$remainder = $current_size - $length;
}
// iff $diff == 0 there are no more characters to remove
// iff $remainder == 0 there should removed no more characters
return $text;
}

</syntaxhighlight>

=== Auf Wortende kürzen ===
<syntaxhighlight lang="php">
function limit_words($words, $limit, $append = ' …') {
$limit = $limit+1;
$words = explode(' ', $words, $limit+1);
array_pop($words); // Shorten the array by 1 because that final element will be the sum of all the words after the limit
$words = implode(' ', $words) . $append;
return $words;
}
</syntaxhighlight>
=== Auf Satzende kürzen ===
<syntaxhighlight lang="php">
<?php

function substr_sentence($string, $start=0, $limit=10, $max_char = 600)
{
/* This functions cuts a long string in sentences.
*
* substr_sentence($string, $start, $limit);
* $string = 'A example. By someone that loves PHP. Do you? We do!';
* $start = 0; // we would start at the beginning
* $limit = 10; // so, we get 10 sentences (not 10 words or characters!)
*
* It's not as substr()) in single characters.
* It's not as substr_words() in single words.
*
* No more broken lines in a story. The story/article must go on!
*
* Written by Eddy Erkelens "Zunflappie"
* Published on www.mastercode.nl
* May be free used and adapted
*
*/

// list of sentences-ends. All sentences ends with one of these. For PHP, add the ;
$end_characters = array(
'. ',
'? ',
'! '
);

// put $string in array $parts, necessary evil
$parts = array($string);

// foreach interpunctation-mark we will do this loop
foreach($end_characters as $end_character)
{
// go thru each part of the sentences we already have
foreach($parts as $part)
{
// make array with the new sentences
$sentences[] = explode($end_character, $part);
}

// unfortunately explode() removes the end character itself. So, place it back
foreach($sentences as $sentence)
{
// some strange stuff
foreach($sentence as $real_sentence)
{
// empty sentence we do not want
if($real_sentence != '')
{
// if there is already an end-character, dont place another one
if(in_array(substr($real_sentence, -1, 1), $end_characters))
{
// store for next round
$next[] = trim($real_sentence);
}
else
{
// store for next round and add the removed character
$next[] = trim($real_sentence).$end_character;
}
}
}
}

// store for next round
$parts = $next;

// unset the remaining and useless stuff
unset($sentences, $sentence, $next);
}

// check for max-char-length
$total_chars = 0;
$sentence_nr = 0;
$sentences = array();

// walk thru each member of $part
foreach($parts as $part)
{
// count the string-lenght and add this to $total_chars
$total_chars += strlen($part);

// if $total-chars not already higher then max-char, add this sentences!
if($total_chars < $max_char)
{
$sentences[] = $part;
}
}

// return the shortened story as a string
return implode(" ", array_slice($sentences, $start, $limit));
}
?>
</syntaxhighlight>

== String als Variablenname ==
Manchmal möchte man einen String als Variable nutzen, damit PHP den Namen des Strings als Variable Nutzt kann man so arbeiten:
$string = 'meineVariable';
${$string} = Hallo;
echo($meineVariable) // Hallo

PhpSpreadsheet

2019-03-05T15:09:57Z

84.157.30.153: /* Snippets */

== Excel, CSV, OpenOffice und mehr mit PHP verarbeiten ==
PhpSpreadsheet, ist eine PHP Library, mit der es möglich ist Verschiedenste Tabellenformate zu verarbeiten und zu erzeugen.

== Links ==
https://phpspreadsheet.readthedocs.io
== Snippets ==
=== XLS Datei erstellen (Hello World) ===
<syntaxhighlight lang="php">
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

$writer = new Xlsx($spreadsheet);
$writer->save('data/hello_world.xlsx');

echo('<div>hello_world.xlsx created</div>');
?>

</syntaxhighlight>
=== XLS Datei lesen ===
<syntaxhighlight lang="php">
<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;

$inputFileType = 'Xls';
$inputFileName = __DIR__ . '/data/sampleData/example1.xls';

$reader = IOFactory::createReader($inputFileType);
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($inputFileName);

$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
var_dump($sheetData);

</syntaxhighlight>
=== XLS 2 HTML ===
<syntaxhighlight lang="php">
<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;

$inputFileType = 'Xls';
$inputFileName = __DIR__ . '/data/sampleData/example1.xls';

$reader = IOFactory::createReader($inputFileType);
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($inputFileName);
$worksheet = $spreadsheet->getActiveSheet();
// Get the highest row number and column letter referenced in the worksheet
$highestRow = $worksheet->getHighestRow(); // e.g. 10
$highestColumn = $worksheet->getHighestColumn(); // e.g 'F'
// Increment the highest column letter (possible for chars in php)
$highestColumn++;
echo '<p>Highest Row: '.$highestRow.' | Highest Column: '.$highestColumn.'</p>';

echo '<table>' . "\n";
for ($row = 1; $row <= $highestRow; ++$row) {
echo '<tr>' . PHP_EOL;
for ($col = 'A'; $col != $highestColumn; ++$col) {
echo '<td>' .
$worksheet->getCell($col . $row)->getValue() .
'</td>' . PHP_EOL;
}
echo '</tr>' . PHP_EOL;
}
echo '</table>' . PHP_EOL;
</syntaxhighlight>
=== Create data and write CSV file ===
<syntaxhighlight lang="php">
<?php

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Csv;
$targetFile='data/writeCsvSample.csv';
// Create Spreadsheet...
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

// Set some date in sheet...
$arrayData = [
[NULL, 2010, 2011, 2012],
['Q1', 12, 15, 21],
['Q2', 56, 73, 86],
['Q3', 52, 61, 69],
['Q4', 30, 32, 0],
];
$sheet->fromArray(
$arrayData, // The data to set
NULL, // Array values with this value will not be set
'C3' // Top left coordinate of the worksheet range where
// we want to set these values (default is A1)
);

// Write as csv...
$writer = new Csv($spreadsheet);
$writer->save($targetFile);
$writer->setDelimiter(';');
$writer->setEnclosure('');
$writer->setLineEnding("\r\n");
$writer->setSheetIndex(0);
echo('<div><a href="'.$targetFile.'" target="_blank">'.$targetFile.'</a> created</div>');
?>
</syntaxhighlight>

<syntaxhighlight lang="php">
</syntaxhighlight>

PhpSpreadsheet

2019-03-05T14:49:43Z

84.157.30.153: /* Snippets */

== Excel, CSV, OpenOffice und mehr mit PHP verarbeiten ==
PhpSpreadsheet, ist eine PHP Library, mit der es möglich ist Verschiedenste Tabellenformate zu verarbeiten und zu erzeugen.

== Links ==
https://phpspreadsheet.readthedocs.io
== Snippets ==
=== XLS Datei erstellen (Hello World) ===
<syntaxhighlight lang="php">
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

$writer = new Xlsx($spreadsheet);
$writer->save('data/hello_world.xlsx');

echo('<div>hello_world.xlsx created</div>');
?>

</syntaxhighlight>
=== XLS Datei lesen ===
<syntaxhighlight lang="php">
<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;

$inputFileType = 'Xls';
$inputFileName = __DIR__ . '/data/sampleData/example1.xls';

$reader = IOFactory::createReader($inputFileType);
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($inputFileName);

$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
var_dump($sheetData);

</syntaxhighlight>
=== XLS 2 HTML ===
<syntaxhighlight lang="php">
<?php
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;

$inputFileType = 'Xls';
$inputFileName = __DIR__ . '/data/sampleData/example1.xls';

$reader = IOFactory::createReader($inputFileType);
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($inputFileName);
$worksheet = $spreadsheet->getActiveSheet();
// Get the highest row number and column letter referenced in the worksheet
$highestRow = $worksheet->getHighestRow(); // e.g. 10
$highestColumn = $worksheet->getHighestColumn(); // e.g 'F'
// Increment the highest column letter (possible for chars in php)
$highestColumn++;
echo '<p>Highest Row: '.$highestRow.' | Highest Column: '.$highestColumn.'</p>';

echo '<table>' . "\n";
for ($row = 1; $row <= $highestRow; ++$row) {
echo '<tr>' . PHP_EOL;
for ($col = 'A'; $col != $highestColumn; ++$col) {
echo '<td>' .
$worksheet->getCell($col . $row)->getValue() .
'</td>' . PHP_EOL;
}
echo '</tr>' . PHP_EOL;
}
echo '</table>' . PHP_EOL;
</syntaxhighlight>

<syntaxhighlight lang="php">
</syntaxhighlight>

<syntaxhighlight lang="php">
</syntaxhighlight>

PhpSpreadsheet

2019-03-05T13:39:58Z

84.157.30.153: Die Seite wurde neu angelegt: „== Excel, CSV, OpenOffice und mehr mit PHP verarbeiten == PhpSpreadsheet, ist eine PHP Library, mit der es möglich ist Verschiedenste Tabellenformate zu verar…“