It is necessary from 2 Small MySQL requests to make 1 request.

I'm looking for a developer who can create a program (Windows or Web) designed for automatically sending messages on WhatsApp. Sending messages to a list of phone numbers, no spam, no complicated software needed. I need a script that runs through the API and sends messages.

It is necessary to perform the update, transfer, and configuration of Laravel projects to a new server, ensuring stable operation, security, protection against exploits, and correct functioning of all services after migration. 1. Main tasks Prepare the new server for operation. Transfer project files, databases, configurations, and cron jobs. Update server software. Configure a secure environment for Laravel. Check compatibility of PHP, Laravel, Composer packages, and dependencies. Ensure protection against known exploits, malicious requests, and unauthorized access. Set up SSL certificates. Check the functionality of the websites after the transfer. 2. Transfer of Laravel projects For each project, it is necessary to: Transfer project files. Transfer the database. Transfer the .env configuration. Set directory access permissions: storage bootstrap/cache Check functionality: homepage; admin panel; authorization; forms; API; file uploads; email sending; cron jobs; queue workers.3. Security and protection It is necessary to implement basic and application-level protection: close root access via SSH; configure SSH access only via keys; change the default SSH port if necessary; configure the firewall; allow only necessary ports; install Fail2Ban; hide service versions of Nginx/Apache/PHP; restrict access to .env, .git, backup files, log files; set correct file permissions; check projects for malicious files; check Composer packages for known vulnerabilities; update dependencies if it does not break functionality; configure protection against SQL injection, XSS, CSRF, and path traversal; check the correctness of Laravel APP_ENV and APP_DEBUG; set APP_DEBUG=false in production; configure rate limiting for critical endpoints; check access to storage/uploads; configure protection against PHP execution in upload directories; check access rights to admin panels. 4. SSL and domains It is necessary to: Install SSL certificates. Configure automatic SSL renewal. Enable redirect from HTTP to HTTPS. Check the correct operation of websites via HTTPS. 5. Backup It is necessary to configure backup: project files; databases; .env files; uploaded media; cron configurations; Nginx/Apache configurations. Backup should be performed automatically on a schedule. It is preferable to store copies separately from the main server. 6. Post-transfer verification After migration, it is necessary to check: absence of 500/403/404 errors; absence of critical errors in Laravel logs. 9. Result of execution After the work is completed, there should be: Laravel projects successfully transferred to the new server; websites are functioning stably; SSL is configured; the server is protected with basic security settings; access to critical files is restricted; backup is configured; cron and queues are operational; the old server can be turned off after final verification.

I am looking for a developer for a project consisting of 4 related tasks for the website best-matchmaking.com to be completed sequentially:Integration of a ready-made premium Blade template for blog articles + auto-generation of Schema/SEO markup (Article, FAQPage, Open Graph, canonical) for all current and future articlesRefinement of the blog structure: changing URLs with 301 redirects, renaming in the footer/menu/breadcrumbs, cleaning hidden code, removing categoriesNew block (photo + quote from a review) in the existing constructor for the main and landing pages = the ability to independently add text blocks between sectionsUnification of fonts, sizes, and colors across the entire site (except for the blog) — a single standard for headings and regular text, including header and footerDetailed technical specifications for each item — I am attaching them below via Google link.https://docs.google.com/document/d/1E5oQO2E-xmKJ3C0jW0ZsSPDBjaiELq0ETxfdivW6yIs/edit?tab=0 HTML samples and code will be sent in private messages after the response IMPORTANT! Please review all 4 tasks in detail before making an offer, especially the last one about fonts. There is quite a lot of work involved.Experience RequiredLaravel + Blade — confident, not beginner levelFrontend (CSS/JS) at the same level as backendExperience working with existing, not your own codeWork FormatBackup and test server before starting, transfer to production is MANDATORY — after agreement and testingMandatory self-check on all devices before submission — sending "ready, check" without your own testing is not acceptable. Bugs found after submission will be fixed within the same task. Bugs that arise during the transfer must also be fixed in production.Report with "before/after" screenshots for each itemDeadline and budget — after assessing the volume based on the detailed technical specifications. I look forward to your offers. Thank you

Optimization of the website jdgreta.co.uk on Shopify. SEO audit attached to the project. Main tasks - - Fix all meta data - Complete the technical specifications for the programmer (since this project combines tasks for both the programmer and SEO, if you are not a company - you can use assistance) - Fix minor noticeable flaws - you can visit the pages and add your observations to the bid - this is more than welcome. - Fix reviews as they are duplicated in the cards (screenshots added) we use Judge.me plugin - Fix text color in some places, for example in filters for better readability - Update the Next template

Need a specialist who can correctly set up the product Feed. Problem: Currently, over 13,000 products are being uploaded with the same type value (e.g., "everything for manicure and pedicure"). Because of this, it is impossible to segment products in Google Ads and set different advertising budgets. Task: Pass only the final subcategory (the name of the folder) where the product physically resides on the site into the tag, instead of the general root category. Condition: A flat list is needed — without "breadcrumbs" and parent categories through >. Only one, the last phrase (the name of the final section) should go into the tag. ❌ Currently (incorrect): everything for manicure and pedicure ✅ How it should be: Base: Bases Color polish: Gel polishes Router: Routers Starter kit: Starter kits Wax heater: Wax heaters