Fermé

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.

Compétences : HTML, Javascript, MySQL, PHP, Architecture Logicielle

en voir plus : 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

Concernant l'employeur :
( 16 commentaires ) lima, Peru

Nº du projet : #18055009

22 freelance font une offre moyenne de $37 pour ce travail

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1130 Commentaires)
8.9
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(331 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(76 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(52 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(53 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(106 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(88 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(36 Commentaires)
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 : Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(47 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(18 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(15 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(25 Commentaires)
3.3
savshit

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
2.6
krostan9

Hola me gustaria tener mas informacion sobre su proyecto, tengo bastante experiencia en proyectos similares y puedo ayudarle con su desarrollo.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.0
mikerson

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
SonsaYT

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0