Closed

MySQL Database implementation for [login to view URL]

We have a website [login to view URL] hosted by [login to view URL]

Target : We need somebody to create and implement a mySQL database to manage a new interface that we are implementing. This interface should enable our machines to communicate with clients through a mobile application.

All work and database creation should not interfere in any way with our existing wordpress website. Database access and admin panel are completely independent from the existing website.

All work to be done directly on [login to view URL] -> not on your server. We provide credential to access our provider ([login to view URL]).

We need our freelancer to create our own database interface to

- Manage data contained in 3 linked tables (to be created): MACHINES, CLIENTS, TRANSACTIONS. (See attached expected display in pictures)

- Receive inputs 1/ from us (manual input), 2/ input from client’s mobile application 3/ Input from payment gateway (PayPal or another).

- Record new clients (through the online application)

- Record new machines (manual input by us)

- Validate transactions (from the payment gateway)

- Record all transactions

- Enable or refuse to give a green light for use of a machine based on the balance available.

- Add credit by the administrator (e.g. reimbursement in case of failure)

- Issue reports : by groups, by client, by amount, by date, by week, by month, by year, by level of use in .pdf and .csv format

- Setup automatic issuance and dispatch of reports by email at a certain time and for certain email address(es)

Database through the admin panel should be able to :

- Display online an admin panel accessible by password + google authenticator

- All admin panel display in English language, database content may be in different languages that includes accent and special signs/caracters (öèéàäèü’)

- Backup or clone the entire database and enable an easy restoration system and full setup (daily,weekly,monthly, destination local or online, type of data saved etc)

- Have a user friendly interface, see attached images

Planning:

- We expect the project to be available for testing online within 3-4 days maximum.

As you need at least 60 seconds to read the above and to check the pictures any offer received within this timeframe will be automatically deleted.

We are on budget, please make sure you check your bid as it is a commitment. All unrealistic prices will be removed immediately. Should you have any question please ask before placing an offer.

Skills: PHP, WordPress, MySQL, HTML, Website Design

See more: run multiple mysql database queries php send xml, collecting information mysql database, building front end mysql database, query mysql database information, php script updates mysql database, php script read pop3 email message mysql database, create pdf mysql database, javascript mysql database update click, xml parser mysql database, vbulletin mysql database move, mysql database splitter, creating mysql database contact form, create mysql database iis, simple php mysql database, mysql database restore different instances, can search different fields mysql database php scripts, mysql database iphone implementation, https://www.freelancer.com/projects/mysql/database-developer-13616809, store mysql database different location, copy mysql database to another database on different server

About the Employer:
( 13 reviews ) Guatemala, Guatemala

Project ID: #22320129

36 freelancers are bidding on average $184 for this job

phpdeveloper100

we will do implementation. Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress - Zen-cart - X-Cart - Website Desig More

$186 USD in 7 days
(85 Reviews)
7.4
einnovention

Hello Sir/Madam!! I’m “Master Expert in HTML PHP Js Query & WordPress” and immediately available to discuss and start working on your project. I have developed/completed 350+ websites and Mobile Applications relevant More

$140 USD in 4 days
(167 Reviews)
7.1
Jeet81

Hi, It took me more than 60 SECONDS to read and view the three images of Control Panel with details asking for machine output, payment client ID etc. Just writing this to inform you that I am a serious bidder. I can h More

$230 USD in 7 days
(221 Reviews)
7.1
amitpandeyposin

Hi There, Greetings for the day.I have gone through your project requirements for creating your Wordpress websites. I am a specialist Wordpress developer having 8+ years of work experience in website design and develop More

$450 USD in 20 days
(127 Reviews)
7.0
maamekal

Hi there, I have checked your attachment Client [login to view URL] Machines [login to view URL] Transactions [login to view URL] I don't have a question about the requirement, I exactly got your point, Also I can start right away. Got you More

$200 USD in 5 days
(176 Reviews)
7.2
baniksubir1

Dear , Today your job posting (MySQL Database implementation for [login to view URL]) has caught my attention, and I wish to have a conversation about the project http://subirbanik.com- You can check my a few past projec More

$155 USD in 7 days
(122 Reviews)
6.6
rexjeramey

I have more than 12 years of experience.I have checked attached images. I have gone thoroughly your project specification. The requirement is best match with my expertise. See my portfolio of recently developed sites: More

$185 USD in 7 days
(47 Reviews)
6.2
webgenius0322

Hello I read all about your project. As a web development expert, especially WordPress expert who have enough experience, I can do your job enough as you want. Being responsible is my Virtue, communication is the most More

$140 USD in 7 days
(92 Reviews)
6.3
manjeet2017

Hey there! Read your project description and can do your task. Lets discuss more over chat.. Clients themselves expressing our excellence of work, Here you can check. https://www.freelancer.com/u/manjeet2017?w=f Belo More

$140 USD in 7 days
(105 Reviews)
5.9
codetechservices

Validcode is a dynamic and fast-moving company in Web/Mobile designing and development world-wide and has proven itself to be one of the best in markets. Validcode have served customers from USA , Canada , Germany , More

$140 USD in 7 days
(41 Reviews)
6.1
hawkscodeau

Hello, I can start work on your project immediately once you confirm me and I am also open for further discussion if you want. I have 8+ years in web design & development with good experience in following skills ... More

$200 USD in 3 days
(13 Reviews)
6.2
jindongdev

Hello. I'm advanced Full-Time WP/WooCommerce developer. (https://www.freelancer.com/u/jindongdev). I checked project description carefully. Your project fit perfectly with my core skills. Also I had enough exp More

$190 USD in 3 days
(71 Reviews)
5.9
aadips

Hi sir, i understated you need MySQL SB integrated in your website "[login to view URL]" for your project..... sharing few projects done so far by me.... 1. [login to view URL] 2. [login to view URL] 3. http://brossardd More

$200 USD in 7 days
(74 Reviews)
5.6
jyotivmsoftsolut

Hello I'm an expert Web Designer/Developer >> WordPress, Woo-commerce, Shopify, HTML/CSS, Bootstrap, UI/UX , complex websites, graphic design,web design, logo design, landing pages, building custom themes based on P More

$200 USD in 2 days
(45 Reviews)
5.6
sky19130

Hello sir. High-quality & Fast-delivery is promised! As a highly skilled full stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My cli More

$300 USD in 3 days
(13 Reviews)
5.7
lokeshsaurav

Hello, I have read your description and understand your requirement . I can complete your project. Please discuss with me for more clarification. Thanks

$160 USD in 4 days
(51 Reviews)
5.5
aswebsmart

Hi, I have huge experience working with WordPress. I have been working on WordPress since last 8+ years & also developed 500+ WP projects successfully. I will design & develop your website in WordPress as per your re More

$220 USD in 4 days
(42 Reviews)
5.1
zeeshan411

Hi, I have read your project description. I am full stack developer having 10 years working experience and I am very confident to build your website in PHP, WordPress, Laravel, Codignator and Reactjs. I am an exp More

$104 USD in 3 days
(23 Reviews)
4.6
monikadevm

Hello, ==== Ready for an Immediate start === I am an expert web designer/developer and have extensive experience in orchestrating the development of simple and complex websites, Wordpress, Elementor, Graphic design,Web More

$150 USD in 2 days
(30 Reviews)
5.0
eliaa

Hello, I have gone through your requirements and understand what you need. I am a Web developer with 7 years experience I have used a lot of technology to implement my clients solutions. List of Services that i can hel More

$200 USD in 6 days
(15 Reviews)
4.2