Find Jobs
Hire Freelancers

175735 MySQL DB Query Script

N/A

Completed
Posted over 16 years ago

N/A

Paid on delivery
Looking to have a script written in Perl or PHP that will query a MySQL database and be able to do a FIND and REPLACE (update) my data. Basically, I need a form that will find dates (currently stored in Unix timestamp format) that I enter, and replace them with new dates. So, I want to have a pull-down menu that looks like the following: Find: MONTH | DAY | YEAR <== pull-down menus (01/01/2007) Replace with: MONTH | DAY | YEAR <== pull-down menus (01/01/2007) -- For example, if I search for Jan 28 2005, and replace it with Jan 28 2007. The script should find all instances of Jan 28, 2005 and replace the MySQL data with Jan 28 2007 (in its original Unix timestamp format). This is the current date format stored in our DB ==> 1106933160 for Jan 28, 2005 at 09:26 AM Must also do the following: 1. Retain the original time (from example above “09:26 AM”) 2. The find MONTH, DAY, and YEAR pull-downs must also have a wildcard. So, if I search for Jan 28 "*" from pull-down menu, the query would search for Jan 28 of any year. Likewise, If I search for June * 2005, and I set the replace date to June 24 2007, the all dates found in June 2005 would be changed to June 24 2007. 3. Must be able to change the “database name”, “table name”, and field name” as I will use this script to update dates in different tables. A working DEMO will go a long way with my selection.
Project ID: 1921936

About the project

1 proposal
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Please see pmb.
$50 USD in 1 day
5.0 (188 reviews)
6.7
6.7

About the client

Flag of UNITED STATES
Henderson, United States
5.0
15
Payment method verified
Member since Dec 9, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.