1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Displaying Data from And Writing Data To MySQL Database

Discussion in 'Databases' started by joeelmore, Sep 25, 2015.

  1. #1
    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.
    SEMrush
    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.
     
    joeelmore, Sep 25, 2015 IP
    SEMrush
  2. mmerlinn

    mmerlinn Notable Member

    Messages:
    2,415
    Likes Received:
    353
    Best Answers:
    6
    Trophy Points:
    290
    #2
    Why did you post your question here? It looks to me that it should be in the sub-forum for MySQL.
     
    mmerlinn, Oct 4, 2015 IP
  3. neutralhatter

    neutralhatter Greenhorn

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    11
    #3
    You should first understand php and mysql seperately. Then you just need to connect the dots. Nobody will write out the code for your application:

    for php start here: http://www.w3schools.com/php/

    make sure you understand sql: http://www.w3schools.com/sql/

    then learn to connect to mysql from php: http://www.w3schools.com/php/php_mysql_connect.asp

    From this point on you should be able to figure out things by yourself.

    Hope this helps,
     
    neutralhatter, Nov 7, 2015 IP