Browse Some URL's from mysql table

PHP
1

Hello,

I have a question and i will be glad if you someone help me :slight_smile:

i have 50 websites URL’s in mysql table how i can browse this websites by php page just to verify this sites by Next Button.


CREATE TABLE webistes (
         id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
         url VARCHAR(100)
       );

INSERT INTO websites (url) VALUES ('http://www.domain1.com');
INSERT INTO websites (url) VALUES ('http://www.domain2.com');
INSERT INTO websites (url) VALUES ('http://www.domain3.com');
INSERT INTO websites (url) VALUES ('http://www.domain4.com');
INSERT INTO websites (url) VALUES ('http://www.domain5.com');

Thank you

2

Please any help in this case :shifty:

3

So you want to run a php page that cycles through the urls and checks if they return status 200? if not then delete them?
You could use curl for this quite nicely!

4

@smftre unfortunately i want to browse the websites by something like HTML frames and Next Button not for status 200 only.

5

you can use an iframe and make it’s source one of the records in your database, then when you click next it takes it’s id and increments it and then gets the next item in the database, which then replaces the source of the iframe to the new website.

you could even use sessions for this to store the current website id so when you click next it knows what the next item will be!