PHP Database::like Examples

Example #1

File: url_identifier.php Project: vitrinephp/Vitrine-PHP

 public static function get_next_available_url_identifier(ORM $object, $url_identifier)
 {
     $database = new Database();
     $database->select('COUNT(*)');
     $database->from($object->table_name);
     $database->like('url_identifier', $url_identifier . '%', FALSE);
     $row = $database->get()->result_array(FALSE);
     $count = $row[0]['COUNT(*)'];
     if ($count > 0) {
         $url_identifier .= '-' . ($count + 1);
     }
     return $url_identifier;
 }