Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

PHP id problems

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

PHP id problems

Postby mylesbettermedia » Thu Jun 27, 2013 7:08 am

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
Code: Select all
 <?php if ($id != 1) : ?>

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

&nbsp; &nbsp;

<?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.

~Myles

EDIT: a video can be viewed here: http://youtu.be/F8LU1jei3E4
mylesbettermedia
New php-forum User
New php-forum User
 
Posts: 2
Joined: Thu Jun 27, 2013 7:00 am

Re: PHP id problems

Postby mylesbettermedia » Thu Jun 27, 2013 12:30 pm

It's all right - I figured it ^^

Did it by querying id:

Code: Select all
SELECT * FROM articles WHERE id < ? ORDER BY id DESC LIMIT 1

SELECT * FROM articles WHERE id > ? ORDER BY id LIMIT 1
mylesbettermedia
New php-forum User
New php-forum User
 
Posts: 2
Joined: Thu Jun 27, 2013 7:00 am


Return to PHP coding => General

Who is online

Users browsing this forum: mweingand and 3 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron