2 Simple PHP Scripts required
$30-250 USD
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");
------------------------------------------------------------------------------------------------------------------------------------
ID dự án: #16083266
Về dự án
Được trao cho:
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
24 freelancer chào giá trung bình$109 cho công việc này
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
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
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
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
Hey there? I can code 2 PHP scripts which you explained in description. Let's talk over in chat and discuss there
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
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
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.
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
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
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
i have many, many experience working with php and databases. using ADO, MySQL, MySQLi and PDO. Delivery fasta abnd clean code