Encerrado

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

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.

Habilidades: HTML, Javascript, MySQL, PHP, Arquitetura de software

Veja mais: php script save checkbox status mysql table, send mail loop mysql table php, php transfer csv file mysql table, send mysql data table php mailer, php mysql xml save contents file, export data mysql table word document php, xml file mysql table php, create excel file mysql table php, view data mysql table via php ajax, write txt file mysql table php, excel file data mysql table java, mysql table save rss, php file manager open source mysql, import data xlsx mysql table, input data send mysql database android, import data to mysql table and make some calculations + post the values to database, import data to mysql table and make some calculations post the values to database, load data into mysql table from text file, load data into mysql table from csv, export data from mysql table to pdf file using php

Acerca do Empregador:
( 16 comentários ) lima, Peru

ID do Projeto: #18055009

22 freelancers estão ofertando em média $37 para esse trabalho

rinsadsl

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 dias
(1130 Comentários)
8.9
$100 USD in 2 dias
(331 Comentários)
7.7
BigCityInstitute

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. E Mais

$25 USD em 1 dia
(76 Comentários)
7.4
an1566706

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 Mais

$25 USD em 1 dia
(52 Comentários)
6.0
Alka700

Hello Sir, I am the same freelancer for which you are looking and i am feeling happy to say that i am having 5+ exp in website design/development so pls have a look of my past work done and ping me for further proces Mais

$15 USD em 1 dia
(53 Comentários)
6.2
nixtech

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 ex Mais

$40 USD in 0 dias
(106 Comentários)
5.9
talhamq

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 Mais

$30 USD em 1 dia
(88 Comentários)
5.4
anj180190

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 Mais

$15 USD em 1 dia
(36 Comentários)
4.7
bhanderirakesh

i can done your job very quickly and easily sir. Let me more discuss into chat sir. I have 3 year experience in wordpress and php platform. I had been completed many projects into this platform. It is my poftfolio : Mais

$25 USD em 1 dia
(47 Comentários)
4.4
shivansh121

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 dias
(18 Comentários)
4.1
digitalfog

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 em 1 dia
(13 Comentários)
3.6
mendiola

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 act Mais

$30 USD in 5 dias
(15 Comentários)
3.6
nithyarajeshg

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 tenta Mais

$25 USD in 3 dias
(25 Comentários)
3.3
savshit

Hello, I am master in Php, I am confident to do this task, also love playing with PHP array.

$35 USD em 1 dia
(5 Comentários)
3.4
uzairabdullah786

Hi, I'm an experienced developer and I'll develop your PHP file easily without any errors. Feel free to contact me. Regards Uzair

$15 USD em 1 dia
(10 Comentários)
2.6
krostan9

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 dias
(1 Comentário)
1.7
indianitdevelopm

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 em 1 dia
(1 Comentário)
1.0
mikerson

Easy job, can be done in less than a day with me.

$25 USD em 1 dia
(0 Comentários)
0.0
malikumair94

Hey I'm Muhammad Umair I can write php script for you and cron job that will save user data into new database. Are you interested ? Thanks looking forward to your response.

$30 USD em 1 dia
(0 Comentários)
0.0
SonsaYT

Hi! I have experienced in php, mysql and running php script using crontab. I can help to your project :D

$30 USD em 1 dia
(0 Comentários)
0.0