Custom Wordpress/Buddypress installation needs PHP + SQL work

This project received 18 bids from talented freelancers with an average bid price of $223 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

Directions to the backend of the site and more photos + description will be given to the chosen candidate. It is important that you comprehend this project draft and be able to repeat back to us what it is we're looking for before hire.

Photos are included to demonstrate where in the SQL database we need new tables, and where our new "profile tabs" have been created in our buddypress installation. "[url removed, login to view]".

Our project is created on a Wordpress platform, with the Buddypress plugin, and a slightly modified theme. Certain information must be stored within each members profile that required the custom creation of new tabs within the profile (we can demonstrate this upon hiring), for instance each employee's profile has a chronological tab among others which were not in the original buddypress installation but had to be created.

We will need this new profile tab to contain a modifiable table of data loaded from the database. For instance if the default 'profile' tab which is pulling it's data from 'bp_xprofile' table in the database displayed it's information in a table that was editable by clicking any field changing the value and saving - this would be ideal. We could then replicate this across multiple tabs for the rest of our needs.

We can provide the data needed for our new MySQL tables and to be displayed in each tab, but require a programmer to first devise a method of importing this data into the MySQL database and tying it to the appropriate profile tabs on each users profile. Some of this info will be in an orderly CSV file, other information can be given in different text formats (will demonstrate upon hire).

And of course, we need a programmer to then tie the info from this new table to the appropriate new profile tab (which we've already created) - displaying it like the "profile" information, but editable from the front-end.

- Custom information on user profiles: Necessary for each establishment to store a variety of information on each employee, custom user profile tabs have been programmed into the site which must be coded to display information from the database. The function to display that information in these tabs is already existing with certain default buddypress functions, for instance that which displays a users basic profile information (name, address etc). We would like a programmer to replicate this function, modifying it to instead display info from new custom tables in the database.

By default, the Buddypress installation assigns each user account a "wp_bp_xprofile_data" table in the SQL database, (screenshot attached) which contains second and tertiary tables ; "wp_bp_xprofile_fields" which governs the information fields on each profile, namely those that a member would fill in upon registration and " wp_bp_xprofile_groups" which would tie a members profile to any groups they may have joined. Likewise there is a table somewhere to tie "friends" to user profiles, which would then show up in that users' "friends" tab.

- Displaying custom information on our newly created profile tabs: There is a pre-existing PHP function displaying the bp_xprofile data in the users profile tab, and we would like a programmer to target this code, modify it and use it, if possible to accomplish what has been explained above.

As you can see, "wp_bp_xprofile_data" serves as an example of an SQL table responsible for storing information entered by the user upon registration, "wp_bp_xprofile_fields" are the data fields which the user filled in the registration form, and the PHP function to display that information in the users profile tab does already exist in a default buddypress installation. Again, we need a programmer to replicate and modify this function to display information from newly created SQL tables.

More info upon hire.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online