Correct / Resolve SQL Lookup in PHP Web Application

Hi! All questions would have been pertinent to the new database schema on teh CRM side, but you said that would be unavailable at this time, at least not for everybody bidding. In any event, I don't think it would require more than couple hours - to get familiar with those database functions in [login to view URL] and [login to view URL], just to make sure not to break anything, and with the new schema and what you'd be wanting pulled from there(you said teh output would change too), and to plan and do the actual modding. And then the 3rd hour is for testing and debugging/problem rectifying etc. on the modded code(because we don't have neither side of this communication and data to test locally, and it's not even worthed to set it up locally only so it can be tested anyway. Kind Regards, Dobri

Hello, I'll need CPanel and admin access to the CRM. I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1150 projects from a period of 12 years. Thanks. I look forward to hearing from you Best Regards, Rajesh Soni.

Hello Sir/ Mam, My name is Neha from “Hire Wordpress Experts”. We are the team of 18+ employees and over past 10 years. We read through the project details extremely carefully and absolutely sure that we can do the project very well. We build your small, local php web application that lookups phone numbers in your CRM and return them to your phone system and according to your need attached SQL query to reflect the output changes. Thank you to share the txt file. We can achieve the results that you are asking for. Kindly review our profile and past work here: https://www.freelancer.com/u/OutsourceMan We would appreciate working with you. We are “waiting humbly and patiently”. Thank you Neha

Hello, Full Stack Expert development team is ready to serve you. Please check my profile and message me for more details. Thanks

Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you as PHP/MySQL programmer to research new CRM database structure and rewrite old code to Lookup phone properly. Yes, 6 hours is enough. 2000+ successfully completed projects speak for me. Links and reviews from my past clients available in my profile. I am an individual, I am not a company in any meaning. I need FTP access to start right now. I can communicate via Freelancer.com. -- Sergey aka Takereal

Hello there, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Codeigniter/ Laravel/ Prestashop/ Drupal/ Jquery / Wordpress/ Joomla / OSC / Magento /OpenCart / Android / Mobile development / Responsive. Ready to start the work immediately. I am confident to handle your business projects with dedication and good quality. Thanks and regards, Harpreet Singh

HI its possible it could be fixed in 6 hours or less, but where is the code hosted? is there remote access? how easy would be to test? We specialize on co-located teams in South America with constant training and we aim for indefinite long term business relationships, we work by providing full time programmers, but this is project is small enough that we can quote it. Sincerely Pablo V Atlanticsoft

Hi there Here is one of CRM database management experienced developer including Query optimization If you give me this project, I will complete it in a short time Please contact me with your project access. Thanks Will look forward to hearing from you soon. Best regards.

Dear, client. I am Yukai, from China, a senior web developer. I have read your project description carefully and checked attached sql. In this file, there are some including files so I need to see these files, as well. I can provide you the correct result. I want to discuss via PM. Thanks.

Hi, there! I am very interested in your job. I have been working as a full stack web developer for over 5 years. I am highly skilled in PHP, Mysql so I feel confident that I can do your job without fail. I can start working right now and I will guarantee the quality of code and keep the timeline as well. If you are willing to work with me, please contact me. Regards.

Hi Sir, If you are looking for a PHP expert, please consider my proposal. As an expertise in PHP with more than 15 years of experience related to databases like MYSQL / ORACLE /DB2 . Past experience related to different major technology methodologies . Focus on front-end development based on AngularJS and VueJS, using Codeigniter as back-ends. I am confident that I can fix the issue successfully within the time frame. Looking forward to discuss the further details over freelancer chat. Message me to getting touch. I will wait for a positive response. Thank You

Hello there i can do the fix you want please contact me im available now

Hi, I am full stack web developer working more than 2.5+ years on commercial projects. I have skills in php, mysql, postgresql, sqlite. I looked to your code, but for fixing an error it will be good to look what error your server returns in apache/nginx log files on your server that understand what exactly is wrong after CRM changes.

I am interested to apply for the Remote Full Stack Web Developer position. My background as a Full Stack Web Developer, along with my engineering education degree in Information Technology has made me attain some excellent technical skills. Following are my skills in which I am expertise * PHP 7, Advanced PHP (OOPs) * Laravel 5.5 REST API * AngularJS * HTML5 * CSS3 * JavaScript/Jquery, JSON, AJAX * Payment gateways Integration In addition to my Web Development skills, I also have a great eye for design. I have 6 years of experience with these technologies. I am always happy to learn even more new concepts in these technologies to sharpen my skillets whenever I get the chance. Besides, I do have a passion for mobile technologies as well. I also worked on a few responsive websites with the usage of Bootstrap and Media Queries. You'd also be delighted to know that I have acquired the Information Technology extensive education, that's why I'm confident that I can be a great asset to your organization. I am willing to work for 40 hours per week to help you with your project.

hi, I have 20+ years experience on java,web,db tech. Your specs are quite clear, and it should be quite easy. Can do it for 20$. regards, manoj

Hi. I have 6 +years of experience in IT Sector working with Database especially writing Sql queries. I have seen your project requirements and I am sure I would be able to complete this project as required in the given time frame with maximum efficiency.

This should be an easy task to complete. I have 12+ years experience in sql. This is my first freelancer job, so I really hope I can get this one.

Buenas tardes, para este proyecto entiendo que lo que necesitan es adaptar el script de la consulta para que retorne los datos que se requieren. Puedo colaborarles con esto.

I do have knowledge of Front End and Back End using PHP and database SQL. I ca rewrite the query as per your requirement.

UPD: today i am able to run your SQL queries $crm_customer_sql and $crm_vendor_sql on MySQL DB, with only minor modifications to the original SQL code to achive this i create Tables simulating the tables of your CRM including links between tables via ForeignKeys, for example Contacts.Company_ID is a foreign key points to Company.Company_ID. And fill each table with several rows of dummy data now i am ready to receive the Information about new CRM table(s) and fields structure ------ day before: I am looking thru your PHP code, especially SQL statements and now i have a draft of tables and table fields in your CRM database the script has been designed to work with i prefer one-time payment, not per hour

I am a good listener, who succeeds in learning new things. A very sociable colleague who can easily help, skills acquired in volunteering. Due to the intuition and the spirit of observation, I can troubleshoot and overcome most of the problems encountered.