/**
* Determine whether the given value exists.
* @param DB\Table $table
* @param DB\Column $column
* @param mixed $value
*/
protected function value_exists($table, $column, $value)
{
$wpdb = $table->get_database()->get_wpdb();
$sql = 'SELECT 1 FROM `' . $table->get_name() . '` ' . 'WHERE `' . $column->get_name() . '` = %s ' . 'LIMIT 1';
$exists = $wpdb->get_row($wpdb->prepare($sql, array($value)));
return !is_null($exists);
}
/**
* Determine whether the given value exists.
* @param DB\Table $table
* @param DB\Column $column
* @param mixed $value
*/
protected function valueExists($table, $column, $value)
{
$sql = 'SELECT 1 FROM `' . $table->getName() . '` ' . 'WHERE `' . $column->getName() . '` = :value ' . 'LIMIT 1';
$exists = $table->getDatabase()->query($sql, ['value' => $value])->fetchColumn();
return $exists;
}
