best way for next/previous buttons for entries in yii -


I would like to know what is the best way to create next / previous buttons for entry into the database. Suppose we have images There is a table and the id and path of each image is. If the current image has an id equal to "9" then how can I get the next and previous ID?

I already found a solution for this right but it seems the latest option. If we have more than 10000 entries (images) in our database, then this server will be submerged first, it selects all the entries and then it tries to copy all the results in an array. After this, the array is searched for the current ID. It is very slow.

I was thinking about the limit set on the query, but after that how do I get the next and previous pictures?

Another (better, I think) solution will have to obtain the ID of the current photo and it will be reduced / increased unless another image is found with the new ID. I think it is faster than the given function in the link.

In addition to setting prev_id and next_id in the current picture model, there is one more idea in the same link but here we have only one problem, how do we find them? And even if we find them, then is it right to store data about the previous / next pictures in the current picture? It does not seem right, but I'm sure that when you want to access that data, it will be more convenient.

This query only returns the next / previous line, if found. Better? (Should be implemented in your model class). 

  public function getNextId () {$ record = self :: model () - & gt; Find (Arrays ('condition' = & gt; 'id'; current_id '', 'order' => 'id asc', 'limit' => 1, 'params' => array ( ': Current_id' => $ this-> ID),);); If ($ record! == empty) $ record-> id; Return tap; } Public event getPreviousId () {$ record = self :: model () - & gt; Find (Arrays ('condition' = & gt; 'id & lt ;: current_id', 'order' => ID idc, 'border' = & gt; 1, 'params' => array ( ': Current_id' => $ this-> ID),);); If ($ record! == empty) $ record-> id; Return tap; }

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more