Webmaster Forum

Go Back   Webmaster Forum > Web Development > Coding Forum

Coding Forum Problems with your code? Discuss coding issues, including JavaScript, PHP & MySQL, HTML & CSS, Flash & ActionScript, and more.


Reply
 
Thread Tools Display Modes
Share |
  #1  
Old 09-25-2015, 06:55 PM
joeelmore joeelmore is offline
Junior Member
 
Join Date: 09-25-15
Posts: 1
iTrader: 0 / 0%
Displaying Data from And Writing Data To MySQL Database

Hello everyone. I just registered and I've got a bit of a problem. I have a database already created. I will be manually adding more of the records to the database but one of my fields for each record is rank and I want to place a buttons on my website so the visitors can like songs and I want that rank field to increment by 1 every time the button is pressed. I also have a tab box on the home page where I want to query the database and display the top 10 songs by rank. Finally I want to display a random song name every 10 seconds.

Now I'm comfortable with html and css but totally clueless when it comes to php and javascript. I thought it would be easy enough to find a tutorial or website that would walk me through doing this. Unfortunately every site I've looked at assumes the user has some understanding of php. It's all a bunch of letters and symbols to me. I was wondering if anyone knows of a site that would show me how to do this. I mean I need to be told the exact code and where to put it on my page. everything from how to connect to the database to updating it and pulling data from it to display on my site. I'm sorry for the wall of text. Thanks for taking time to read this.
 
Reply With Quote

Advertisement

Advertisement

  #2  
Old 09-30-2015, 06:31 PM
Dan Williamson Dan Williamson is offline
The Controversial Coder
 
Join Date: 05-01-06
Location: Manchester; UK
Posts: 2,710
iTrader: 0 / 0%
It's difficult to help without you posting a link and/or code to work with, but to display the top 10 songs by rank it is fairly simple depending on your database structure - hopefully you will have something like an amount_played column in the database, so then you can just attach a SQL query into PHP such as:

PHP Code:
SELECT FROM database ORDER BY amount_played 
You could work with the query to get it to do what you wanted, such as LIMIT/TOP arguments etc.

Quote:
Originally Posted by joeelmore View Post
I mean I need to be told the exact code and where to put it on my page. everything from how to connect to the database to updating it and pulling data from it to display on my site. I'm sorry for the wall of text. Thanks for taking time to read this.
Unfortunately you're not going to get many people who tell you how to develop your entire database driven website, as that's a good chunk of work for someone over the internet to do for free.
 
Reply With Quote
  #3  
Old 10-01-2015, 04:53 AM
ScriptMan's Avatar
ScriptMan ScriptMan is online now
Super Moderator
 
Join Date: 02-10-07
Location: Central Kentucky
Posts: 14,023
iTrader: 4 / 100%
I know nothing about HTML5. Prior to that there was no way for HTML to be used to push or pull info from a MySQL database. The pages had to be code pages like php or asp.

HTML can exist on a php page. An HTML form can be used to post data to a php page.

I guess I'm saying you have a lot of studying ahead of you.
 
Reply With Quote
Go Back   Webmaster Forum > Web Development > Coding Forum

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Export data from PHP to Excel my database is in MYSQL stephen001 Coding Forum 3 06-27-2013 11:43 AM
Mysql database all data not show colling25 Coding Forum 1 08-07-2012 06:17 PM
retrieving data from mysql Midwifery Online Coding Forum 16 08-14-2011 11:49 PM
MySQL Data Partitioning Question addedworth Coding Forum 0 12-21-2010 05:51 AM
Asp site database to mysql data conversion simi Web Hosting Forum 3 03-23-2009 07:53 AM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 03:43 PM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC