Find Jobs
Hire Freelancers

php file who gets mysql table data and send to mysql table

$10-30 USD

Closed
Posted over 5 years ago

$10-30 USD

Paid on delivery
i have a website where people sends information all the day based in tables, so i have a php table where i show as ranking ordered by date each report sended per user. The problem what i am having is how to send the report in a table to another table in order to show an "score" per each report. So i am planning to use "cron job" to execute a file who will do this task. the task consists in: execute a query who gets the latest report per each user, because the table "report" is like RAW DATA, where the same person can send his report many times, with this you get only the latest (i have done the query so you dont need to create a query, you use that query to create a new array and send to my new table) so bassically the phpfile will execute a query and the info recovered need to be saved in a new database. it will do the two things: insert into database if user does not exists. add values into database if user already exists. I will execute the cron every day at 23:55pm in order to save data every day.
Project ID: 18055009

About the project

19 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $39 USD for this job
User Avatar
Hi, After seeing your images, I can assure that I can create the script as you mentioned in your mysql tables and run it on every 23:55 on cron.
$77 USD in 2 days
4.9 (1209 reviews)
9.0
9.0
User Avatar
Php Pro - hourly rate: 25$ - Masters degree in Computer Science - more than 10 years experience in Development on IT jobs. - Flexible working time (possible on weekend, night, day) - like to work in the team. Experiences: Blockchain and cryptocurrency expert, OS Administrator, Developed a lot of Applications(web and mobile, desktop) Hope to hear messages from you! Thanks!
$25 USD in 1 day
4.9 (95 reviews)
7.6
7.6
User Avatar
Hello Sir I can write code to copy the data to new table and to check if the user exist or not. If not then insert in the database. I am willing to start right away. Please check my profile for work and experience. Regards Ashwin
$40 USD in 0 day
5.0 (280 reviews)
6.8
6.8
User Avatar
I read your project description …php file who gets mysql table data and send to mysql table ……..and we are very exited to work on it We are an group and we have an expert & qualified to accomplish your project in professional & unique We are working all section of integrated solution And for project ……………………. There are an specialist expert that can make your project like you want and more! We are looking for delivering unique services and add all feature that make your project is complete and professional You can check our sample and previous work before we start in work We provide for you the best services with the lowest prices
$25 USD in 1 day
4.9 (78 reviews)
6.7
6.7
User Avatar
I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 2016 Amazon Linux, Debian, RHEL, CentOS, Ubuntu. Web servers and servlets containers: IIS, APACHE, NGINX, DOCKER Mail servers: POSTFIX, EXIM, MS Exchange 2000-to-2013, MS Exchange 2016, QMAIL Database servers: MySQL, MS SQL Virtualization: MS Hyper-V, VMware Server(ESXI), VirtualBox. Directory service: Active Directory, OpenLDAP. File servers: IIS FTP, proftpd, FileZilla FTP Server, SAMBA. Firewalls: Windows firewall,ISA/Forefront TMG, MikroTik,PFSense Zywall and other Routers; Data Storage Systems: Netapp, FAS, EMC, VNX; Hosting Panels: PLESK,cPanel,Website Panel
$30 USD in 1 day
4.8 (150 reviews)
5.9
5.9
User Avatar
Hi, I have understood your task requirement which you are expecting to your selected freelancer to be done so please ping me here to discuss further . My Skills:- PHP HTML CSS Wordpress Bootstrap Regards, Shivansh
$61 USD in 4 days
5.0 (38 reviews)
5.5
5.5
User Avatar
Good day! I have all the necessary knowledge and experience to help you with this task. Fast, cheap and high quality. I always finish the work and provide support.
$30 USD in 1 day
5.0 (32 reviews)
5.2
5.2
User Avatar
Hello there, Hope you are doing well !! It's straight to your referenced post I am an expert in PHP/Mysql and having good experience over it.I can do it very well. I'm interested in your project. Please send me a message so that we can discuss more. Looking forward to hear more from you for any query. Sincerely, Ashish Sr. WP Developer
$15 USD in 1 day
5.0 (55 reviews)
5.0
5.0
User Avatar
Hola, Puedo ayudarte a hacer la lógica para insertar la información en tu nueva tabla. Entiendo que hay que insertar un registros si es que el nickname no existe en la tabla new y en caso que exista se deben actualizar los valores sumando el valor actual de la tabla new con el valor que venga en el query se insert. Saludos. Alfredo Mendiola Loyola Lima, Peru
$30 USD in 5 days
5.0 (16 reviews)
3.7
3.7
User Avatar
Hello, I am master in Php, I am confident to do this task, also love playing with PHP array.
$35 USD in 1 day
4.9 (6 reviews)
3.5
3.5
User Avatar
I am interested in this project. I have experience in these types of CRON and automatic jobs. My work strategy is to give regular status updates and intermediate version whenever required. I will give the tentative schedule and intermediate release details . Let me know if you are OK with my bid.
$25 USD in 3 days
4.9 (25 reviews)
3.2
3.2
User Avatar
Hi i have two year experience in web and app development field. i am new to freelancer but not in technology So please give me a chance to work with your project Thanks.
$25 USD in 1 day
5.0 (7 reviews)
2.6
2.6
User Avatar
Hola me gustaria tener mas informacion sobre su proyecto, tengo bastante experiencia en proyectos similares y puedo ayudarle con su desarrollo.
$111 USD in 10 days
5.0 (1 review)
1.6
1.6
User Avatar
Howdy! Best of my luck to work with you sir. As you know sir, life is a harsh struggle in the dark. Everyone is burning the breeze as hard as they can in the circle of life linking the chain one by one which covers the whole universe. I am one of those, climbing, falling, failing, searching, perspiring, fearing, encouraging,,,,! Being muscled in the tough course of life cycle, I am always fully loaded to go on alerts in what I am for. You are guaranteed the 100%possible benefit by my full skill and perfect creative ability in the corporation with me. I will help you to cross the Rubicon. Just name me,,, will be at your service.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Easy job, can be done in less than a day with me.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! I have experienced in php, mysql and running php script using crontab. I can help to your project :D
$30 USD in 1 day
5.0 (1 review)
0.0
0.0

About the client

Flag of PERU
lima, Peru
4.9
22
Payment method verified
Member since Mar 3, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.