Below is an example of the data that needs to be uploaded.
INSERT IGNORE INTO wp_descp (`sweeps_link`,`link_val`,`link_detail`,`en_freq`,'prize','exp_date`) VALUES
('[login to view URL]','Old Dutch Foods - Quality Lives Here Sweepstakes','Grand Prizes (1 per month): iPad 16 GB with Wi-Fi and Skinit cover (ARV $534).
Second Prizes (4 per month): Old Dutch Sweatshirt Blanket (ARV $30).
Third Prizes (15 per month): Old Dutch Clock ARV $10).
Fourth Prizes (35 per month): Old Dutch Reusable Shopping Bag (ARV $5).','6','Monday, December 31, 2012 @ 11:59pm CT'),
If you look at the date at the end "Monday, December 31, 2012 @ 11:59pm CT" must be converted to "2012-12-31" format automatically.
Not only the date but must look at the table in database to not enter duplicates.
Please give quote for writing a php file to upload large sql file as above with a confirmation page with statistic results.
I know this is a simple project but may have more for the right person.
I understand you need a PHP file that uploads files to a folder in the server and at the same time it inserts the file information to the database, checking for duplicate entries before inserting. Of course if you select me, I'll need some more details about the type of "file" you need to upload, and where is the data coming from?, a Form?, or from the file?
Best!
$30 USD in 1 day
5.0 (2 reviews)
3.1
3.1
20 freelancers are bidding on average $76 USD for this job
Greetings, I understood what you want so tell me about following questions.
QUESTIONS:
==========
1- Will you require php file to allow you to "select" a .sql file and then process its upload into wordpress database?
2- By what field do you want to prevent duplication in database?
3- Beside DATE FORMAT, any other specific requirement for any other field?
4- What STATIC result do you want to see after confirmation?
=========
I will further discuss after your reply.
Cheers,
- Zeeshan
Hi sir,i am interested but i want to know that you want me to code a php script to upload a mysql file to mysql database or you want me to build a script that will insert entries using file of another format ?
i can write the php upload file to mysql database for you. please pass me more details information.
i can write the php upload file to mysql database for you. please pass me more details information.
Hi I'm a 12 year experienced PHP developer I will deliver a professional and high quality solution to your project.. thnaks in advance for considering my proposal.
Hello !
(The Amount we ll discuss to reduce and free updates)
I am an experience programmer in php, java, c#, jquery, ajax, android(java), html, css... i have done more than 150 application under those platform... you can check some few task that i have done in freelancer.. you can check my feeds and comments too... i can complete your work within few hours... i can complete your work successfully with your satisfaction if your not satisfy you dont need to make me the payment...... you can trust my service 100%....please provide me the details....
Thank you very much !!!
hi,,
what the data will come from when inserting into database,
how to know that record is duplicated ?check all field to the database field from duplication."Not only the date but must look at the table in database to not enter duplicates."
kindly open chat window to discuss it further.
Thanks
Hello,
I am interested to implement the upload script. I have experience on Uploading large mysql database dump files.
According to your requirements:
1. Date will be converted tinto mysql format datetime format.
2. No duplicate entry.
3. Will be large database to upload
I am experienced on PHP, MySQL, CodeIgniter, Zend, MAgento, Wordpress, JQuery etc.
Looking foreword for your kind response.
Regards
I can use php date format to convert from the input format to the required format. Then I can use mysql query options to avoid duplicates.
I have more than 6 years experience on php,mysql including several php projects in freelancer.com.
Also I have experience in java scripts, Ajax, Jquery,.. other web technologies for more than 5 years.
Continuous projects from same client is guaranteeing our work and service.
Thanks
Hi I am a software developer with more than 10 years of experience. I can write that script for you quickly and without any problems, if you are interested - I need to talk with you about few more details, just to clarify my bid.