Mysql + PHP to fix the script work
18 USD In BD we have links (contact users) to whom we send SMS. The SMS script is not working properly.
How the SMS script works now: The script is run by the crown every minute. The cycle starts a query in the database, from which it pulls n-e number of lines (cycle for), which have been added more than 5 minutes ago. Send a SMS on the last line. After that he again sends the request, again pulls n-e number of lines, etc. The script was written by me very long ago, there was no problem in small amounts, now I noticed it and I want to correct it qualityly.
Problems: Instead of one query and reviewing the result by a cycle, the n-e number of queries is formed.
The demand is wrong.
mysql_query('SELECT * FROM `table` WHERE `sms` = 0 AND `date_added`
Client's review of cooperation with Aleksandr Polischuk
Mysql + PHP to fix the script workAs always, quickly, quality, early and with great bonuses in the form of optimization of some of the elements that we have not discussed. A wonderful initiative!
Freelancer's review of cooperation with Sergey Lunev
Mysql + PHP to fix the script workGood, and most importantly adequate customer) Very detailed TZ, the payment is decent and timely.
I will be happy to continue to work together, I recommend!
-
3 days18 USD
3 days18 USD
Hello to you,
I’m a Full-Stack web developer, I’m engaged in web development since 2019. I have been working with PHP and Laravel for a long time. I also have experience in developing applications in Python. You can learn about some of my projects by looking at my portfolio. So when it comes to your project, I have read your description carefully and very interested in your project.
This project is in line with my experience.
If you are interested, please write to me and we will discuss further cooperation.
All of that, good luck!
P is :
… My Skills:
PHP (3 years of experience)
by JS
by Laravel
Tailwind CSS / Bootstrap
Wordpress
Docker
MySQL
by Ajax
by Wix
Software Architecture
Database Architecture
Web Security
Web Hosting
Web API
Web Development
Back-End / Front-End / Full-Stack Development
Website Design
Website Build
I take time with the stock for 2 days so that it doesn’t burn in case of CP, so in the course of 1 I think I can do it.
Andrei Wozniak
-
Winning proposal1 day18 USD
883 44 0 Winning proposal1 day18 USD
Good Morning .
Ready to solve the problem, 7 years experience. Go to)
-
1 day18 USD
10689 591 6 10 1 day18 USD
Ready to work, write, I’ll do everything well! Experience in work for over 12 years!
-
1 day22 USD
3351 101 4 3 1 day22 USD
I can do. It seems a typical mistake when the number of requests increases exponentially when the number of data increases.
-
1 day18 USD
2641 427 9 1 1 day18 USD
готов сделать
=-= =- =- = - =-= =- =- = - =-= =- =- = - =-= =- =- = - =-= =- =- = -
-
1 day18 USD
6474 229 4 7 1 day18 USD
Hello, you are ready to solve the question now. Write in the face. I will repair the script.
-
1 day18 USD
1830 70 1 1 day18 USD
Hello to you. You need to correct the query and, ideally, not to calculate the date in the query, to form the application a time mark minus 5 minus and to compare it. Write and help.
-
1 day18 USD
103 2 0 1 day18 USD
I welcome.
I’m going to call you on Monday, I’ll be happy to collaborate.
-
1 day18 USD
696 35 3 2 1 day18 USD
Hello, ready to do it. until Monday.
• • • • • •
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
607 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 22 hours 30 minutes back ∙ 45 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 23 hours 5 minutes back ∙ 10 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 1 day 11 hours back ∙ 9 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 1 day 17 hours back ∙ 10 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 2 days 15 hours back ∙ 23 proposals |
Chernigov