Đã hoàn thành

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.

Kĩ năng: MySQL, PHP

Xem nhiều hơn: set of pairs, row 44, read find and write, mysql documentation, mysql data access, look find and write, generic data access, creating php table, php mysql project, simple php mysql project, mysql mean, write php and mysql, write a simple php script, 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

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

ID dự án: #1652130

Được trao cho:


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

$30 USD trong 0 ngày
(31 Đánh Giá)

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


Ready to deliver the project

$80 USD trong 2 ngày
(80 Nhận xét)

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

$50 USD trong 0 ngày
(145 Nhận xét)

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

$30 USD trong 0 ngày
(110 Nhận xét)

Ready to help you.

$40 USD trong 2 ngày
(15 Nhận xét)

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. Thêm

$30 USD trong 1 ngày
(4 Nhận xét)

Hello, please check your inbox.

$30 USD trong 2 ngày
(4 Nhận xét)

Been working on big projects like [url removed, login to view] and [url removed, login to view] Great knowledge of CDN,payment gateways, handling large volume of data, designing structure of database

$30 USD trong 2 ngày
(0 Nhận xét)

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 Thêm

$50 USD trong 14 ngày
(0 Nhận xét)

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 trong 0 ngày
(0 Nhận xét)

Ready to work with you!

$40 USD trong 3 ngày
(0 Nhận xét)

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 Thêm

$40 USD trong 1 ngày
(0 Nhận xét)