www.webdeveloper.com
Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21

Thread: JS Spot The Ball

  1. #16
    Join Date
    Aug 2009
    Posts
    593
    Ok, this is really getting back to basics for me without my precious framework

    Updated the game to include name, email, phone fields (all required).
    The game will also check if you have used all your guesses.
    On success the data is posted back to the server and stored away in the database (also supplied, restore it as spottheball). Just edit the results.php file and change the username and password for your MySQL server.

    There are two tables, the entries table to store the actual entry with names and email addresses, and the entry_positions table that holds each individual guess position. The are linked together by entry_positions.entry_id -> entries.id

    I can pretty much see what I'm going to be asked for next.
    Attached Files Attached Files
    Last edited by thraddash; 08-11-2009 at 04:09 PM.

  2. #17
    Join Date
    Aug 2009
    Posts
    10
    You, my friend, are most certainly a genious!

    Many thanks once again for your continued help and support!

    I will more than likely be in touch if I get a bit stuck again lol. Thank you though very very much! Webdeveloper.com for the win!

  3. #18
    Join Date
    Aug 2009
    Posts
    10
    Thraddash, little confused with your last version. I need to be able to edit the games and put backgrounds on etc but there's no html file and we don't have a MYSQL server sorted just yet.

    I'm a bit baffled lol!

  4. #19
    Join Date
    Aug 2009
    Posts
    593
    I'm sorry, I forgot to mention that the index.php (previously the html page) file contains the initial page with the games code etc. and the results.php file has the code to manupulate the database.

    I did it this was so it would be the default page on my local machine.

    You will need to have MySQL working before you can have the results captured, and with the files the way they are you will also need to place them in a PHP enabled host. (or you can just rename the index.php to something like index.htm for testing purposes).

  5. #20
    Join Date
    Aug 2009
    Posts
    10
    Right an update...

    The website design is built there are 3 different games available with 3 different amounts of how many times the user can place a guess on the page.

    Now I'm at a total loose end with how the database works. I've changed the variables as mentioned but nothing is getting logged. I also can't seem to upload the spottheball.sql file to the database as it says invalid user login but won't let me change the user login.

    We have a MYSQL database and logins all set in place and everything's where it should be but I'm totally confused as to how we go further.

    Please help as we're days away from going live and we really need this game to work

    Thanks guys!

  6. #21
    Join Date
    May 2009
    Posts
    9

    spot the ball

    Hi Guys,

    I'm hoping you can help me?

    I have seen what you put together in your spottheball3.zip file and it looks grat! What I need to be able to do is put a similar point on a picture/image which would mark the centre of a football - maybe a flag instead of a cricket ball?

    I then need to submit the location (x-Y coords) to a database to store an email address, name, department and company. and a facility to run a report on the database.

    Can you guys help me with this?
    It would be much appreciated.

    Kind Regards,
    John R.

    john1r@aol.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles