Jump to content
Sign in to follow this  
Mylez

php id

Recommended Posts

Hi, I've recently developed a CMS from scratch using PHP and MySQL running through Apache/phpmyadmin on a localhost.Everything has gone very smoothly so far, visitors may view articles and navigate through the page successfully.

 

Admins (created by an Admin on the CMS or in the MySQL schema) can log in, view articles, edit articles, view and edit users and delete articles.

 

 

My problem is that when articles are deleted, a next/previous button at the bottom (of any existing articles) with a function of

 

 <?php if ($id != 1) : ?>

<a href="article.php?id=<?php echo $id - 1; ?>">Previous Article</a>

   

<?php endif; ?> 

 

which looks for a previously existing article with x-id, however since this article was deleted it no longer exists.

 

Is there any way to remove the article id as the article is deleted, thus freeing up that article id again? I can manually reset the id to 0,1,2,3... etc. in the schema on phpmyadmin, but I'd like to apply some logic in order to make this system work flawlessly.

 

Many thanks for you help, if I get time I'll upload the CMS to my web server so that it can be viewed freely.

 

~MYLZ

 

EDIT: a video can be viewed here:

 

http://youtu.be/F8LU1jei3E4

Share this post


Link to post
Share on other sites

You could add the id to a list and then check the list for available ids before generating a new id.

Share this post


Link to post
Share on other sites

It's all right - I figured it ^^

 

Did it by querying id:

 

SELECT * FROM articles WHERE id < ? ORDER BY id DESC LIMIT 1

SELECT * FROM articles WHERE id > ? ORDER BY id LIMIT 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.