| public isUniqueValue ( string $strTable, string $strField, mixed $varValue, integer $intId = null ) : boolean | ||
| $strTable | string | The table name |
| $strField | string | The field name |
| $varValue | mixed | The field value |
| $intId | integer | The ID of a record to exempt |
| Результат | boolean | True if the field value is unique |
public function isUniqueValue($strTable, $strField, $varValue, $intId = null)
{
$strQuery = "SELECT * FROM {$strTable} WHERE {$strField}=?";
if ($intId !== null) {
$strQuery .= " AND id!=?";
}
$objUnique = $this->prepare($strQuery)->limit(1)->execute($varValue, $intId);
return $objUnique->numRows ? false : true;
}