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

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

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

Nº du projet : #1652130

Décerné à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(31 Commentaires)

11 freelance font une offre moyenne de $41 pour ce travail


Ready to deliver the project

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(80 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(145 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(110 Commentaires)

Ready to help you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(15 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)

Hello, please check your inbox.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(0 Commentaires)

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 .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)

Ready to work with you!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

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

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