library cli-db-iterator
Interface for iterating through a SQL selection
leocolomb/cli-db-iterator
Interface for iterating through a SQL selection
- Monday, February 19, 2018
- by LeoColomb
- Repository
- 1 Watchers
- 0 Stars
- 0 Installations
- PHP
- 0 Dependents
- 0 Suggesters
- 0 Forks
- 0 Open issues
- 2 Versions
- 0 % Grown
CLI Database Iterator
Interface for iterating through a SQL selection, (*1)
Usage
$ composer require leocolomb/cli-db-iterator
Example
require_once __DIR__ . '/vendor/autoload.php';
use CLIDatabaseIterator\Iterator;
$bridge = new Iterator("SELECT `ID`, `content` FROM `data`;");
while ($row = $bridge->fetch()) {
$bridge->query("UPDATE `data` SET `content`='new content' WHERE `ID`={$row['ID']};", true);
$bridge->alert("Updated!", $row['ID']);
}
$bridge->finish();
See wordpress-thumbnails for a real example., (*2)
License
ISC © Léo Colombaro, (*3)