Online PHP editor | rfc for lZVXm

@ 2019-02-09T22:19:23Z

<?php
function fillSheet($sheet, $fields, $data) {
    // headers 
    $colLetter = "A";
    $rowNumber = 1;

    // A1...Z1 for header
    foreach ($fields as $fieldname){
        $sheet->setCellValue($colLetter.$rowNumber, $fieldname);
        $colLetter++;
    }
    
    // A2..Z999 for the rest
    foreach ($data as $row) {
        $rowNumber++;
        $colLetter = "A";
        foreach ($fields as $i => $fieldname) {
            $sheet->setCellValue($colLetter.$rowNumber, $row[$i]);
            $colLetter++;
        }
    }
}

// mock
class Sheet { public function setCellValue($a, $b) { echo "$a : $b\n"; } };
$sheet = new Sheet();

$ids = ["1", "2", "3"];
$fields = ["firstname", "lastname", "phonenumber"];

$data = [
    ['Mary', 'Stuart', '555-555-0001'],
    ['John', 'Doe', '555-555-5555']
];
// end mock

/*
$ids = $_POST["id"];
$values = $_POST["values"];

$sqlIds = implode(",", $ids);
$sqlFields = implode(",", $fields);

$sql="SELECT $sqlFields FROM database WHERE id IN ($sqlIds)";
$result = mysqli_query($connect, $sql);
$data = [];
while ($row = mysqli_fetch_array($result)) {
   $data[] = $row;
}
*/

fillSheet($sheet, $fields, $data);

Output for git.master, git.master_jit, rfc.property-hooks: A1 : firstname B1 : lastname C1 : phonenumber A2 : Mary B2 : Stuart C2 : 555-555-0001 A3 : John B3 : Doe C3 : 555-555-5555

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive preview