Create tables MySQL, and JS, PHP Conections (READ)

Job ID: 36596370

Budget: $30 – $250 USD

I need a freelancer who can help me create tables in MySQL for data. Although I have a rough idea of the database structure, I am open to suggestions from the freelancer. The PHP and JS connections that I need are of an intermediate level of complexity. The ideal candidate for this project should have experience in MySQL, PHP, and JS. They should also be familiar with database structures.

My MAX BUDGET is $50 USD. Details:

Looking for a developer who can assist with creating and implementing various features for the investment web application. Here is a breakdown of the tasks:

Database Setup:
Create the necessary tables in MySQL to store the required data.

User Registration and Login:
User registration and login functionality is already implemented.

Referral System:
Implement a referral system that allows users to refer others to the platform.
Track referrals and provide appropriate bonuses to both the referrer and referee.

Sing Up Bonus:
Connect a signup bonus to new users who register on the platform.
Ensure the bonus is added to their account upon successful signup.

Deposit Functionality:
Create a deposit function that allows users to deposit funds using BNB BEP20 wallets.
Implement web3 wallet integration for seamless deposits.
Save the private key associated with each user's wallet securely in the database.
Display the wallet address to the user for making deposits.

Balance and Collect Button:
Connect a "Collect" button to the user's account balance.
Allow users to collect their earned bonuses and investment returns.
Investment Integration:

Connect user deposits to their respective investment accounts.
Ensure investments are linked to the user's profile in the profile.php page.

Shortlink Ads:
Develop functionality for users to create and manage shortlink advertisements.
Allow users to define target URLs and track click statistics.

PTC Ads:
Implement Pay-to-Click (PTC) advertisements for users to view and earn rewards.

Quests:
Create a quest system that provides users with specific tasks or goals to complete.
Reward users upon successful completion of quests.

Leaderboard Tables:
Design and implement leaderboard tables to showcase top performers based on various metrics.

To accomplish these tasks, you will need to create the required tables in MySQL, write JavaScript (JS) and PHP files, integrate web3 wallets for deposit functionality, and establish the necessary connections between different components of the application
Related categories: PHP JavaScript SQL Software Architecture MySQL