
Informative Method of checking link validity from MySQL
- or -
Post a project like this1295
£30(approx. $40)
- Posted:
- Proposals: 9
- Remote
- #3526773
- Completed
Quick Graphic Designer + Animator + Video Editor + Photo Editor + Logo Designer + Autocad Designer

Professional Digital Marketer | Web Development | IOS and Android Developer | WordPress | React Native | Video Editor | Graphic Designing

371264722748046476906638476754553945041591691165966789906865491





Description
Experience Level: Entry
I have a rather simply web-page currently which connects to my MySQL server and simply runs;
"SELECT * FROM Firmware ORDER BY idFirmware ASC"
The script then checks the URL's it gets back and populates them in a table with a simple Tick if they're online and a Cross if they're not. Whilst this works, with almost 800 (and growing) links to check, it can take quite a while when all i care about in most instances are the latest additions to the table.
What i would like is for the page to dynamically update. Start at the end of the table, lets say Row 800 and then work backwards, displaying more results as they come in without having to reload the page.
I believe this can be done with Ajax, but this isnt my area of expertise.
I have uploaded the full code (with SQL connection details removed). Whoever takes the project on would need to supply me with code to verify as i cannot give out the SQL server connection details.
The supplied code was a .php page, but PPH does not allow those so i altered the extension to .txt
"SELECT * FROM Firmware ORDER BY idFirmware ASC"
The script then checks the URL's it gets back and populates them in a table with a simple Tick if they're online and a Cross if they're not. Whilst this works, with almost 800 (and growing) links to check, it can take quite a while when all i care about in most instances are the latest additions to the table.
What i would like is for the page to dynamically update. Start at the end of the table, lets say Row 800 and then work backwards, displaying more results as they come in without having to reload the page.
I believe this can be done with Ajax, but this isnt my area of expertise.
I have uploaded the full code (with SQL connection details removed). Whoever takes the project on would need to supply me with code to verify as i cannot give out the SQL server connection details.
The supplied code was a .php page, but PPH does not allow those so i altered the extension to .txt

Chris H.
100% (15)Projects Completed
13
Freelancers worked with
11
Projects awarded
67%
Last project
7 May 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies