ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down.
Read our Farewell Blog Post for more details.
MySql Question
-
-
- LiVECrys
- Jr. Rocketeer
- Posts: 37
- Thanks: 0
-
I have a custom script I've written that will accept a post to update a db I'm creating everytime a new song is played on a station.
I have another script that displays the last played song.
How can I have this script update automatically without a browser refresh.
The way it is now, it will update everytime a new page is loaded it shows the latest song, but if a song changes while on the page, I want that one line to update. Every tut I find is on how to update it via a refresh, I dont want that, just want a simple way to have it update in the php.
Thoughts?
-
-
-
- Ben Lee
- Elite Rocketeer
- Posts: 4193
- Thanks: 42
-
If you're using a Gantry template, would something like this get you closer to what you want to do?
http://www.gantry-framework.org/documentation/joomla/advanced/built-in-ajax-system
I'm not sure of the full power of AJAX, but it might be a solution that avoids a full page refresh...even just clicking on a link for "Current Song" might be better than a full page refresh.
-
-
-
- Adamck
- Elite Rocketeer
- Posts: 546
- Thanks: 2
- Web Developer, IT Assistant, Graphics design, App Developer
-
Hmm i wonder if you could use RokNewsPager? (stay with me on this one...)
If you create a RokNewsPager module to grab a selected article (i.e latest song article) and leave AutoUpdate set on, this will grab the latest song article by itself via ajax.
If you get your custom form to update the Latest Song Article's body via SQL surely this will be grabbed by RokNewsPager and updated automatically?
Im taking a stab in the dark here but just might work without so much coding and a little more Joomla integration so you can control it.
Ad. - Kiss my RSS
-
Time to create page: 0.074 seconds