3v4l.org

run code in 300+ PHP versions simultaneously

@ 2018-07-14T03:32:24Z

<?php
// SELECT `link_id`, `link_name`, `alias` FROM `m5cob_mt_links` WHERE `alias` = ''
// indexed resultset...
$resultset = [
    [6, 'Convivio Bar & Restaurant Chester Cheshire UK', ''],
    [7, 'Slug and Lettuce Chester Cheshire UK', ''],
    [8, 'Da Rosa Restaurant 1 & Wine Bar Torrevieja Costa Blanca Spain', ''],
    [9, 'Bar Lounge Chester Cheshire UK', ''],
    [10, 'Telfords Warehouse Chester Cheshire UK', ''],
    [11, 'The Botanist Chester Cheshire UK', ''],
    [12, 'Missoula Chester Cheshire UK', ''],
    [13, 'Fiesta Havana Chester Cheshire UK', ''],
    [14, 'El Oceano\'s Hotel Restaurant, Torrenueva, Marbella, Malaga', ''],
    [15, 'La Plaza Restaurant Riviera del Sol Mijas Costa Malaga Spain', '']
];

foreach ($resultset as $row) {
    $purged = preg_replace('~[^a-z ]+~', '', strtolower($row[1]));  // lowercase, then remove unwanted chars
    $split = preg_split('~ +~', $purged, 6, PREG_SPLIT_NO_EMPTY);   // explode on 1 or more spaces, max of 6 elements, no empty elements
    $new_alias = implode('-', array_slice($split, 0, 5));           // remove 6th element if it exists, re-glue with hyphens
    echo "{$row[0]}: $new_alias\t\t(from: {$row[1]}\n";

    // UPDATE `m5cob_mt_links` SET `alias` = '$new_alias' WHERE `link_id` = $row[0]
}

Output for git.master_jit, git.master, rfc.property-hooks: 6: convivio-bar-restaurant-chester-cheshire (from: Convivio Bar & Restaurant Chester Cheshire UK 7: slug-and-lettuce-chester-cheshire (from: Slug and Lettuce Chester Cheshire UK 8: da-rosa-restaurant-wine-bar (from: Da Rosa Restaurant 1 & Wine Bar Torrevieja Costa Blanca Spain 9: bar-lounge-chester-cheshire-uk (from: Bar Lounge Chester Cheshire UK 10: telfords-warehouse-chester-cheshire-uk (from: Telfords Warehouse Chester Cheshire UK 11: the-botanist-chester-cheshire-uk (from: The Botanist Chester Cheshire UK 12: missoula-chester-cheshire-uk (from: Missoula Chester Cheshire UK 13: fiesta-havana-chester-cheshire-uk (from: Fiesta Havana Chester Cheshire UK 14: el-oceanos-hotel-restaurant-torrenueva (from: El Oceano's Hotel Restaurant, Torrenueva, Marbella, Malaga 15: la-plaza-restaurant-riviera-del (from: La Plaza Restaurant Riviera del Sol Mijas Costa Malaga Spain

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

66.52 ms | 403 KiB | 8 Q