I have a sports website a http://www.scoutsystem.com. My site is all PHP/JQuery with MySQL backend. (No wordpress, cms, etc)
On this site, I have athlete profiles, where each athlete as a unique ID in my MySQL DB.
I'm looking for someone to do the following:
Step 1: Create an "Add" button on the player profile page, allowing the person logged in ($UID) to add the player ID ($PID) to an array, stored in the mysql DB.
Table: "Lists" Fields/Value: Owner ($UID), Group ID ($GID), and Description (Watchlist) and the Array.
Note #1 - Because each Owner ($UID) can have more than one "list", we use the "Description" field to pull the correct list (array).
Note #2 - The default list, for which this button will work, will be called "Watchlist". While there may be many other lists, using the "Add" button only adds the athlete profile to the main list, "Watchlist".
Note #3 - Before adding players to table, you must check first to see if the $UID even has a master list (Watchlist) first, and if so, then read the existing array to make sure the player ($PID) already isn't added.
Step 2 : Make a PHP page that shows the existing array, allow it to be sorted, and for additional lists to be created (and have their list names customized/edited).
I'm after a drag-n-drop system that kind of looks like these : [login to view URL]
[login to view URL]
.... the difference being is that my boxes will have words and graphics in them (pulled info from the Database) - but only need to be stored as the $PID of course.
Hope this makes sense.
Hello,
So i hope i understood the description, bit fuzzy on part using Description field as identifier for multiple list rather then Group ID ($GID).
I have 4 years experience working with php, all sorts of frameworks, OOP PHP, built few MVC platforms. Worked with mysqli, pdo db connections.
Good knowledge of JQuery and few other javascript libraries.
If you have any questions or want to discuss more contact me.
Regards,
Kristijan
Hello. I have read your project description and I think I can perform the steps you have mentioned in description. Before I accept the project I just want to look at the code. If you can share the FTP details or create a user account
Please feel free to ping me anytime so we can have a detailed discussion.
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
Hi, ok I got it
What about to set list types, that can be swapped easily
Of course there will be validation to add only one player to list.
Are there any players list existing, there could be autocomplete search within existing records or within shared by other users?
Need to have a look a your system code, to discus further