Hello. I need an experienced PHP developer to help make my website (and several others afterwards) work. The website was in perfect working shape, last time I had it online (some 2 years ago). Most probably it needs some minor tweaks here and there, due to syntax deprecation that happens over time. I uploaded the website source files on my hosting account, where I will give you FTP access.
After some mysql-to-mysqli fixes (which I thought to be all that it took for my website to work), I've been told, by another programmer I've hired through Freelancer, that my server MIGHT not be able to handle this query :
SELECT SQL_CALC_FOUND_ROWS [login to view URL] FROM pictures INNER JOIN tags_pictures_map ON tags_pictures_map.picture_id = [login to view URL] INNER JOIN tags ON tags_pictures_map.tag_id = [login to view URL] INNER JOIN authors ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND [login to view URL] > 0 GROUP BY [login to view URL] ORDER BY [login to view URL] DESC
While this could be true, I somehow doubt it, since my database only contains 4 rows and a max of 2,500 records. This is where I need a professional opinion, since I don't want to upgrade my hosting unless I have to.
Please apply for this project ONLY if you are an expert programmer. I am looking for someone I can rely on in terms of programming skills, since my focus is on Project Management / Web Design (I only know some basic programming). If you prove yourself, I will work exclusively with you, for all my future programming needs.
Thank you for your time.
hi there, i am ready to start now.
I have checked your sql query. We can increase performance of that query easily by rewriting it using simple join. Besides this SQL_CALC_FOUND_ROWS makes query slow due to versions. we can omit it using LIMIT.
let me know when available so we can discuss.
looking forward to your response.
thank you
$170 USD 2 napon belül
4,8 (220 értékelés)
6,9
6,9
12 szabadúszó adott átlagosan $36 USD összegű árajánlatot erre a munkára
Thanks for providing me opportunity to place bid over the project and communicate with you.
i have a lots of experience in PHP MVC,MySQL, Wordpress, Codeigniter, laravel and Web Designing. my aim to deliver quality products to our customers within specified deadline.
If hired by you I will put in my best work. I am ready to be hired by you and start
you can check my previous work here.
Waiting for your positive response
with best Regards.
-- Chirag Jagani
Hello Sir,
I will help you in this scenario. I have resolved many such issues without server/hardware changes.
Please ping me for further discussion.
Thanks & Regards,
Anshulika Bansal
- 12 years of CORE PHP and 5+ years codeigniter web development experience.
- I have developed many complex back end applications
You can discuss further to me and ask questions.
Hello there,
I have read the post and I'm ready to work immediately.
I have 8 years of experience in developing websites and mobile application.
ping to check my work.
Thank you
Hi
Hope you are doing well. I have 7 years of working experience on website developement with various assignment completed successfully and looking forward for many more. I have done many projects using php mysql javascript html java spring hibernate oracle.
I am Tarek from Alger, Amgeria, serving for more than 5+ Years all across the globe in the Industry of Web Development and graphic design. It will be my pleasure to work for. We are too sure about the quality and services too. We hope we will do something great over here and will be able to keep the long term relationship too.
Dear employer, I have 10 yr of experience in php and angular and mysql. I am new on freelancing and looking for small project to built up my portfolio. I would really happy to help you on this task. Give me a try i hope i will deliver it as you want.
Please share more details, about the code like in which php version it was developed and now which php version you want to migrate and is it built on any frame framework like codeigniter or yii or laravel.
I hope we will have good relationship in future as well.