Hello,
Is their anyway to make MySQL Database results show up in a web browser? As in the MySQL database tabel results will be shown on any page I want it to? The only option I want is for each seperate result to be deleted with a simple delete button. Anyone know of a script that can do this?
Thanks in advance,
Joe
Clearly, you want this secure... so don't code it yourself.
The point of mysql is to use php (and other languages) to get the data then display, yes, as html.
however, in this case, you'd want to use a real manager for it, so it's secure, can do a bunch, etc.
I'd recomment myphpadmin, if you don't already have that. If you do, get used to it... it's a good way to navigate, once you get used to the controls.
Err... Dosen't need to be secure... I'm going to password protect it so its fine. And if its still not secure after the password than its not that big if a deal... Dosent matter to me if people can see it. I just want it to show on a page.
However you created the table in the first place. :)
Errrr... I'm pretty sure that won't work.
Idk I really want a simple code to have it show up in a table with a delete button. can you do that like without all the ID crap... Or teach me the ID CRAP?
All you need is a unique column, which your table must already have. Just change the 'id' to the name of your unique column, and surround the value with quotes where it's used in to delete a row if the value isn't numerical.
Ok I Get This error.
Warning: Invalid argument supplied for foreach() in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 14
del
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 12
Warning: Invalid argument supplied for foreach() in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 14
del
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 30
and lets say the Uneque colom is named ID would it be (ID)
???
and lets say the Uneque colom is named ID would it be (ID)Eh?
Paste the top bit of the script after you've configured it (without username and password, obviously).
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 12
Warning: Invalid argument supplied for foreach() in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 14
del
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 30
Usually means there were no results. What's the layout of your table?
why is there an additional table header before the ID, Habbo Name, Song Request, ShoutOut/Joke? :p and extra table data after the execution of the request.php
I think your PHP and MySQL versions are more important than your OS. Tell us those, and manually execute the command:
select * from `request`;... on your database. What is the output?
PHP Version 5.0.4
MySql Version 4.1.20
And HUH?????
:[
:[
can u make ur requests.php to requests.txt just to really see if we're on the page? :D tnx :p
I sourta dont know if i can. It has my passwords and stuff.
oic :D oh right :p i forgot :D
:[ :[ :[ :[ :[
that's all i could do to help :p i running out of ideas on how to help you solve the problem :D
God damn. I really need help.
Yay.
XD i played around w/ it and i got it like 1/2 working.
I still have like two little problems,
The table is poorly aligned.
And The delete function wont work.
You think. Lol... Got us a little closer.
The delete button is there... Just dosent work.
And theres doubles of each result.
http://smileyoureahabbo.freepgs.com/scripts/radiobox/requests.php
Please add another row to the database.
Ok...
I added one...
its still not working.
http://smileyoureahabbo.freepgs.com/scripts/radiobox/requests.php
hmmmmmmmmm..
hmmmmmmmm Twey. Have any idea?
Any ideassss?
I feel like i'm being ignored...
:[ :[ :[
Not ignored... just... well.. I dunno... did you say somehting? :p
I'm serious... Please Twey Help!
Twey??? Please Man!
I REALLY NEED HELP Twey! PLEASEEEE!
SO I Guess everyone in the fourms hates me now? Noone is paying attention to me... :(
SO I Guess everyone in the fourms hates me now?
not really :p i, for one, can't help you. m still learning all this myself :) sound like a signature of somebody... he he :cool:
I've bookmarked this thread, and I consider it daily :) When I spot an answer, I assure you I'll let you know.