2 Simple PHP Scripts required

Đã hoàn thành Đã đăng vào 6 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

DATABASE NAME = 'MYDATABASE'

TABLE NAME - 'DB_transactions'

FIELD NAMES:

transaction_id

reference_id

network_id

program_id

user_id

payment_type

payment_method

payment_details

transaction_amount

transaction_commision

amount

status

reason

created

updated

process_date

1)

I need a PHP Script that saves the following into a csv file:

Calculate currency total for each 'user_id' where 'status' is 'confirmed' and 'process_date' is between 2012-01-01 - 2012-12-31

I would like to be able to change the variables so I can re-use in the future

eg.

$host="";

$username="";

$password="";

$database="MYDATABASE";

$table="DB_transactions";

$date_from="2012-01-01";

$date_to="2012-12-31";

$connection = mysql_connect("$host", "$username", "$password") or die ("Unable to connect to server");

mysql_select_db("$database") or die ("Unable to select database");

-----------------------------------------------------------------------------------------------------------------------------------

2)

I need another PHP Script that will:

Delete the records for each 'user_id' where 'status' is 'confirmed' and 'process_date' is between 2012-01-01 - 2012-12-30

eg.

$host="";

$username="";

$password="";

$database="MYDATABASE";

$table="DB_transactions";

$date_from="2012-01-01";

$date_to="2012-12-30";

$connection = mysql_connect("$host", "$username", "$password") or die ("Unable to connect to server");

mysql_select_db("$database") or die ("Unable to select database");

------------------------------------------------------------------------------------------------------------------------------------

JavaScript MySQL PHP Kiến trúc phần mềm SQL

ID dự án: #16083266

Về dự án

24 đề xuất Dự án từ xa 6 năm trước đang mở

Được trao cho:

AbubakarHashmi

Hello, i have read your job description and fully understand your requirements. It looks like I’ll be the perfect candidate for this job because I have hands on experience in this field. Could you provide us more Thêm

$66 USD trong 3 ngày
(25 Đánh Giá)
5.0

24 freelancer chào giá trung bình$109 cho công việc này

rajeshsonisl

Hi there, Quick and easy. I can create both scripts right now. Just need CPanel access to your server. I have a 99% project completion rate and a 4.99 reputation (out of 5.0 from over a thousand projects. Thank Thêm

$83 USD trong 1 ngày
(1033 Nhận xét)
8.8
superwanchiu

Hello , how are you? I have just checked your project description carefully. I am very interested in your project. I have rich experience in PHP & MySQL. Please send your message so that i can check your requiremen Thêm

$155 USD trong 3 ngày
(233 Nhận xét)
7.8
vano101

Hello Despite PHP is not primary language but I see this is easy project and even my PHP experience is enough to complete it in short time

$38 USD trong 2 ngày
(1002 Nhận xét)
7.5
rohitagarberg

Hi, I would like to create the 2 php script to save the result to csv and for delete. I have good proficiency in PHP, mysql,. please get in touch to discuss more. Regards, Manish

$88 USD trong 4 ngày
(527 Nhận xét)
7.0
ahsansaleemnaz

Hey there? I can code 2 PHP scripts which you explained in description. Let's talk over in chat and discuss there

$250 USD trong 2 ngày
(216 Nhận xét)
6.7
webxtechin

Hi! I I am Expert in PHP,MYSQL,HTML5-HTML,JAVASCRIPT,CSS,AJAX etc..... I have 6+yr experience in developing as well as designing field... I can do this work easily and quickly..... Thankyou waiting for your Thêm

$66 USD trong 1 ngày
(112 Nhận xét)
5.5
testotorko

2 Simple PHP Scripts required 2 Simple PHP Scripts required 2 Simple PHP Scripts required 2 Simple PHP Scripts required 2 Simple PHP Scripts required

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

Hello, I am a seasoned php and mysql dev. I could perform your task for 2-3 hours. I'm ready to start working on your project right now. Please contact me if interested. Thank you. Regards.

$60 USD trong 1 ngày
(31 Nhận xét)
5.3
IgorSkyFlyer93

Hello, my name is Igor and I am an IT expert with 9 years of experience in Web development, PHP, MySQL, MSSQL, HTML, CSS and JavaScript. I am a full stack developer meaning that I create the user interface and more imp Thêm

$177 USD trong 1 ngày
(10 Nhận xét)
4.2
priyabagus

Hi Instinctiv, My name's Bagus, an expert in Web Dev & Database. Thank you for posting the project. I understand that you need 2 scripts for calculating currency then saving to CSV & deleting records. Yes, I c Thêm

$72 USD trong 1 ngày
(9 Nhận xét)
3.7
digitalads786

hi i can make code for i am working on core php sinse last six years and code w ill so Profesinonal and clean please award me project so can furthure discuss

$166 USD trong 3 ngày
(10 Nhận xét)
2.1
epapgu

i have many, many experience working with php and databases. using ADO, MySQL, MySQLi and PDO. Delivery fasta abnd clean code

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

A proposal has not yet been provided

$133 USD trong 5 ngày
(0 Nhận xét)
0.0