En cours

simple php and mysql project

Need a script to read from one table called , do some calculations, and write the resulting fields to a second table.

I need to have this run on 30 pairs of tables. My idea for the design of the program is that there will be a constant declared at the top of the script which will point to the proper table. The constant will have a value of xxx and the table name wil be tbl_xxx. Each row in Table1 will be data for a day. The script should read the most recent row and make sure that the day is the “right” day. The right day is defined as today as measured by either NYC time or Tokyo time. There will be a constant at the top of the script which is set to either NYC or Tokyo and based on that value the script should use either NYC time or Tokyo time.

If the script cannot complete or if it cannot find today’s data it will send an alert mail to the address . myName will be another constant defined at the top of the script.

The script should be written so that it will be easy for me to add additional fields to write to.

I cannot give you access to the database. You will have to send me the code using a generic database and I will test it.

More detail is below

Table2 will obtain all of its data from Table1 but will perform calculations like adding and subtracting fields from table1 to obtain a new value for table2. Also some of the values from table2 will be lagged values from table1. By lagged I mean that values for today in Table2 will come from k days prior values of Table1.

I suggest creating a function which will look like this

fieldWriter(string writeTo, int Lagfield1, double field1, int Lagfield2, double field2, int Lagfield2, double field3, …, int LagfieldN, double fieldN)

where writeTo is the name of the field in Table2 to be written to, lagFieldJ is the number of periods back to find the value of fieldJ.

using fieldWriter() will allow me to change the calculations later on if I want to. At the moment I want fieldWriter() to have 70 different default values. I will give you these calculations. Many of them are just lags of a single variable.

I cannot give you access to the database. You will have to send me the code using a generic database and I will test it.

The completion of this project requires documentation although it should be pretty simple since this is a simple script.

Compétences : MySQL, PHP

Voir plus : set pairs, row 44, read find write, mysql data access, look find write, generic data access, creating php table, php mysql project, simple php mysql project, mysql mean, write php mysql, tokyo, mysql test, myname, mean project, database calculations, program test php, access project program, easy database project, mysql add fields, mysql pretty, php look pretty, write simple php database, time today php, php mail test script

Concernant l'employeur :
( 2 commentaires ) Ev, Japan

N° du projet : #1652130

Décerné à :

SevenStarInfo

Ready to start right now! Let me do this. Thanks in advance!

30 $ USD en 0 jours
(31 Commentaires)
6.3

11 freelance ont fait une offre moyenne de 41 $ pour ce travail

srinichal

Ready to deliver the project

80 $ USD en 2 jours
(80 Commentaires)
6.9
zeke

I have lots of experience with similar projects. Available to start immediately and finish within less than a hour. Best Regards, Zeke

50 $ USD en 0 jours
(145 Commentaires)
6.8
gangabass

I can do this for you. See PM for details.

30 $ USD en 0 jours
(110 Commentaires)
5.7
Alkobazik

Ready to help you.

40 $ USD en 2 jours
(15 Commentaires)
4.6
parthk

Hello, I am a certified IT professional. I have read your requirements for the DB script, and I am confident that I can create it within just couple of hours. Kindly contact me via PMB for further discussion. Plus

30 $ USD en 1 jour
(4 Commentaires)
3.9
softune

Hello, please check your inbox.

30 $ USD en 2 jours
(4 Commentaires)
3.3
dipens

Been working on big projects like http://www.lawcrossing.com and http://www.employmentcrossing.com Great knowledge of CDN,payment gateways, handling large volume of data, designing structure of database

30 $ USD en 2 jours
(0 Commentaires)
0.0
hexabinary

As per our understanding the project is all about calculations and algebric operations. I have a experience of buiding such project in php an example which i have recently done for the company is Parallel processing in Plus

50 $ USD en 14 jours
(0 Commentaires)
0.0
gngn

I have done many projects like this several times even for my personal usage i needed to code same kind of scripts. im ready to start .

30 $ USD en 0 jours
(0 Commentaires)
0.0
Pradeepmakone07

Ready to work with you!

40 $ USD en 3 jours
(0 Commentaires)
0.0
rmartignoni

Hello, I have 4+ years of experience with PHP /MySQL development having built several systems/web applications from CMS to corporate management software. I believe I have the skills to deliver a high quality product w Plus

40 $ USD en 1 jour
(0 Commentaires)
0.0