zualex/SqlCvs

SqlCvs

PHP class for working SQL and CVS.

Exmaple

require_once __DIR__ . '/vendor/autoload.php';

use \SqlCvs\SqlCvs;

$sqlCvs = new SqlCvs('mysql:dbname=test_db;host=127.0.0.1', 'root', '');
$table = 'my_table2';

if (!$sqlCvs->isExistTable($table)) {
    $sqlCvs->import($table, 'tests/example.cvs');
}

$sqlCvs->setTable($table);
$row = $sqlCvs->getRandomRow();
if (count($row)) {
    $sqlCvs->update($row['id'], ['status' => 1]);
    echo $row['value'];
}