PHP Airship\Engine Database::insert Examples

insert() public method

Insert a new row to a table in a database.

public insert ( string $table, array $map = [] ) : mixed
$table	string	- table name
$map	array	- associative array of which values should be assigned to each field
return	mixed

Example #1

File: Keyggdrasil.php Project: paragonie/airship

 /**
  * We're storing metadata about a package in the database.
  *
  * @param TreeUpdate $update
  * @param int $treeUpdateID
  */
 protected function updatePackageQueue(TreeUpdate $update, int $treeUpdateID)
 {
     $packageId = $this->db->cell('SELECT
               packageid 
          FROM
               airship_package_cache
          WHERE 
              packagetype = ?
              AND supplier = ?
              AND name = ? 
         ', $update->getPackageType(), $update->getSupplierName(), $update->getPackageName());
     if (empty($packageId)) {
         $packageId = $this->db->insertGet('airship_package_cache', ['packagetype' => $update->getPackageType(), 'supplier' => $update->getSupplierName(), 'name' => $update->getPackageName()], 'packageid');
     }
     $data = $update->getNodeData();
     $this->db->insert('airship_package_versions', ['package' => $packageId, 'version' => $data['version'], 'checksum' => $data['checksum'], 'commithash' => $data['commit'] ?? null, 'date_released' => $data['date_released'], 'treeupdateid' => $treeUpdateID]);
 }