Đã Đóng

simple concept 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.

By the way, By lag I mean 1 period before. So if the lag is -1 then the data from table 1 that I want is one period before the current period (1 row prior to the current row in the table)

Kỹ năng: MySQL, PHP

Xem thêm: simple php project concept, concept php, php mysql project concept, simple project concept, set of pairs, read find and write, mysql documentation, mysql data access, look find and write, generic data access, creating php table, simple concept php mysql, mysql concept, concept project php mysql, simple mysql project, mysql mean, find current address, write php and mysql, tokyo, mysql test, myname, mean project, program test php, access project program, easy database project

Về Bên Thuê:
( 2 nhận xét ) Ev, Japan

Mã Dự Án: #1730571

3 freelancer đang chào giá trung bình $62 cho công việc này

waelfree

Hi, I can do that

$75 NZD trong 2 ngày
(50 Đánh Giá)
5.8
honeypotant

Hi, I am ready for you. Regards.

$75 NZD trong 1 ngày
(19 Đánh Giá)
4.8
KHs7oFJ60

Custom software development - <b><i>Removed by Admin</i></b>

$75 NZD trong 1 ngày
(0 Đánh Giá)
0.0
nevans77

Hello wekaman2011 I would like to tackle this project, even if somebody else has done it for you to gain some sort of an entry into freelancing, as this is my first post. I need to ask 3 or 4 questions regarding Thêm

$35 NZD trong 2 ngày
(0 Đánh Giá)
0.0