Using asterisk query mysqlงาน

I'm on a tight deadline to develop a new application using Laravel. There are some minor bugs that need to be resolved before we can move forward. Ideal Skills & Experience: - Expertise in Laravel and PHP - Proficient in resolving minor bugs - Able to work efficiently under a tight deadline - Strong communication skills, as we'll need to discuss bug resolution progress and application development milestones regularly

Optimizar una página web de comercio electrónico Wordpress / Woocomerce / Divi y añadir algunas funcionalidades de uso interno, que implican incorporar nuevas tablas MySQL, CRUD y consultas. A. Cambiar la organización y visualización de los productos en la web B. Incorporar algunas tablas relacionadas, su CRUD correspondiente y algunos informes sólo para uso interno.

I'm looking for someone experienced in cleaning ou...will only respond to offers that have confirmed they have watched the video. I will not answer bot responses. Key responsibilities include: - Utilizing SemRush to identify toxic backlinks - Compiling the list of toxic backlinks in a notepad for Google Disavow backlinks tool - Ensuring that the backlinks are safely removed from our website The ideal candidate should have: - Prior experience in using SemRush for backlink analysis - Proficiency in compiling and managing backlink lists for Google Disavow tool - A solid understanding of SEO best practices and the impact of toxic backlinks on website ranking Access to the website's Google Search Console is crucial for this task. You should have full access to efficiently c...

...six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience programmers - Knowledge in Google Mapping - Knowledge with AWS and setting up Linux servers and MySql databases Your team will be replica...

...experienced in Apache NiFi to create a workflow pipeline. This will involve converting and integrating data into MySQL. Key Requirements: - Proficiency in Apache NiFi: You must have a solid understanding of the platform to develop efficient and reliable data conversion workflows. - MySQL Integration: Experience in integrating data with MySQL is essential. - Data Conversion: You will be responsible for converting the data - previous experience in this area is highly desirable. Please note the following: - The type and source of data to be converted is not yet defined. - The triggering mechanism and frequency of workflow runs are also pending. Ideal Skills: - Proficient in Apache NiFi - Strong MySQL Integration skills - Previous experience in data conversion...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complex...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

...make a quite smilar a product page. like this Specifically, I'd like this new page to be built using 'Pagefly' or similar tools. this is the product page that we desire to similar While the page should be an imitation of the reference site, I'd like some minor modifications to the design and layout. Key requirements: - Replicating Product Descriptions and Details: This is the core aspect of the project. You'll need to ensure the descriptions and details are accurately transferred to the new page. - 'Pagefly' Experience: Proficiency in using 'Pagefly' or similar tools is a must. This will ensure that the modifications to the design and layout can be achieved without compromising the overall

I need assistance to effectively integrate a post form into my project. The form should be skillfully designed to send data to a MySQL database, and to handle CRUD operations. Key Requirements: - Collaborate with me to understand the form's workflow and user interaction. - Skillfully implement the form to effectively send user data to a MySQL database. - Ensure the form is able to perform Create, Read, Update and Delete operations, where necessary. Ideal Skills: - Proficiency in form implementation. - Strong experience with MySQL databases. - Good understanding of web project workflows. Your bid should demonstrate your understanding of the requirements and provide a clear strategy for how you intend to approach this project.

Crea un sistema en Java, usando el IDE NetBeans y Xampp para la simulación de un sistema de control de empleados. En este proyecto desarrollarás las funcionalidades básicas del uso de Java e interacción con gestor de base de datos (MySQL) el uso de la biblioteca Swing de Java. Puntos para evaluar Uso de Variables Uso de Operadores Uso de Sentencias Uso de Instrucciones Uso de Arreglos Uso de Programación orientada a objetos Uso de Variables de texto Uso del controlador JDBC

...pushing the boundaries of the platform. Here's what we need: Shopify Expertise: In-depth understanding of Shopify's file structure, directories, and templating system (Liquid). Experience manipulating orders, grabbing data from the database, and crafting custom views using Liquid shortcodes. Proven ability to develop custom Shopify plugins to achieve complex functionalities. Technical Skills: Proficiency in Shopify development languages (Liquid, JavaScript, HTML, CSS). Experience with database manipulation (likely MySQL). Communication & Collaboration: Excellent written and verbal communication skills in English. Ability to clearly explain technical concepts to non-technical stakeholders. Comfortable participating in regular video calls to discuss projec...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds...primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database ...

...mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR. The data is sorted using the “Mode of delivery” information...

I'm searching for a skilled JavaScript developer who also has solid experience using Chrome Developer Tools for debugging. The main responsibility of this project will be to analyse and understand functionality of a web application and website. To succeed in this project, you need to: - Be an expert in JavaScript. - Have advanced proficiency in Chrome Developer Tools. - Have a solid understanding and previous experience with web platforms. - API integration experience.

Estoy buscando un experto que me ayude a migrar una aplicación web PHP y Ruby on Rails desde Node JS a un servidor con Cpanel. Detalles clave del proyecto: - La aplicación web actual está construida utilizando una combinación de PHP y Ruby on Rails. - La aplicación interactúa principalmente con una base de datos MySQL. Habilidades y experiencia ideales: - Competente en Node JS, PHP - Fuerte conocimiento de MySQL. - Experiencia previa con tecnologías del lado del servidor y migraciones. - Familiaridad con Cpanel. El candidato seleccionado debe poder garantizar que el proceso de migración sea fluido, sin pérdida de funcionalidad o datos. Este proyecto es urgente, por lo que estoy buscando a alguien que pueda real...

...skilled Core PHP Developer to build a custom web application with database management capabilities, using MySQL as the preferred database management system. The application should be well-structured and efficient with an emphasis on data handling. Key Requirements: - Extensive experience working with Core PHP. - Proven track record of developing dynamic, secure, and efficient web applications. - Strong understanding and experience with MySQL database management. - Ability to ensure the application is well-structured and follows best practices for data handling. - Strong problem-solving skills and the ability to work independently. ?️ Key Responsibilities: Design and develop the backend system using Core PHP, ensuring high performance and reliability. Impl...

I require to verify a basic Energy Compliance report using Comcheck program for a 750 sq. feet single story modular building.

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience ...Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other r...

I'm looking for an experienced PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving ...

Objetivo El proyecto implica el desarrollo de un MiniCRM con las siguientes características principales: Autenticación y Gestión de Perfiles Implementación de un sistema de inicio de sesión seguro. Gestión de perfiles y roles de usuario para garantizar accesos independientes a cada módulo del sistema. Diseño ...Mantenimiento de un historial detallado de cada transacción de entrada y salida de stock, incluyendo observaciones para el seguimiento del movimiento de inventario y el usuario que realizó cada transacción. Consideraciones Adicionales El sistema se desarrollará utilizando PHP sin el uso de frameworks, asegurando una solución personalizada y optimizada para las necesidades específicas d...

..."International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabetically for user search. -Search function: enter the name of the c...

...like PHP or Python. • Database management system (e.g., MySQL, PostgreSQL) for storing user data and job listings. • Integration with third-party APIs for features like job search, location services, and social media. • The recruitment website will incorporate AI-powered features such as natural language processing (NLP), machine learning (ML), and data analytics to deliver advanced functionalities including intelligent job recommendations, resume parsing, sentiment analysis, and automated candidate screening. 6. System Architecture: • Frontend: Modern web development frameworks like React.js or Angular for building responsive and interactive user interfaces. • Backend: Microservices architecture with scalable backend services using technologies l...

I'm in need of a talented data scientist with a strong background in natural language processing and deep learning. The goal of this project is to develop an efficient and accurate ML model that will estimate the temperature of the Electric Motor dataset from Kaggle. Key requirements include: - Utilizing natural language processing techniques to analyze the time series data provided - Employing deep learning methodologies to ensure the model is robust and performs well - Ensuring the model is able to accurately estimate temperature from the Electric Motor dataset Your expertise in natural language processing, deep learning, and time series data analysis will be crucial for the project's success. Please only apply if you have a proven track record in these areas.

We are seeking an experienced custom web developer to create a unique web application tailored to our specific needs. The ideal candidate will have expertise in the following areas: Recommended applications and Technology: HTML, CSS, JavaScript, React/Vue/Angular) Laravel, CodeIgniter, Node.js, Python, Ruby on Rails, PHP, or similar - Database management (MySQL, PostgreSQL, MongoDB, etc.) - API integration - Responsive design **Responsibilities:** - Develop and maintain the web application according to the project specifications. - Collaborate with our team to refine and improve features. - Ensure the application is secure, efficient, and scalable. **Requirements:** - Proven experience in custom web development. - Strong portfolio showcasing relevant projects. - Excellent proble...

Current project is built on Laravel for both front and backend. Need to build React frontend to replace Laravel frontend side. All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel fronten...All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel frontend back end Login this saas/superadmin version (include All modules) USE THIS Admin TEMPLATE FOR Frontend Current system making this stacks - Laravel, MySQL, VueJS, JQuery & Bootstrap, DOCUMENTATION API DOC

...each agent individually: - Other agents cannot see each other's campaigns. 4. Ability for the main agent to assign one campaign to all of their agents. 5. Exporting statistics by agents: - Export a text (or any other) file with answered/unanswered numbers specifically for that agent. - Export statistics for a specific campaign or overall for the day. 6. Integration with Magnus Billing based on Asterisk 13: - Login credentials for the auto-dialing module correspond to Magnus Billing users. 7. It will be web-based. 8. Easy connection to another Magnus Billing server and transferring the module to another server. 9. Ability to manage AutoDialer users Create a new user, delete an old one, disable a user Please provide a brief overview of your relevant experience and how you...

...Function to an Azure MySQL database. The function is being used as a Web API, and I need it to be able to both read and write data to the MySQL database. Key Requirements: - Development: You will need to establish a secure, reliable connection between the Azure Function and the Azure MySQL database. - Data Handling: The API should be able to retrieve data from the database as well as input new data into it. - Security and Optimization: Ensure proper security measures are in place to protect the data, and optimize the API for performance. Skills and Experience: - Proficient in C#: You should have strong experience working with C# and Azure Functions. - Azure Services: A solid understanding of Azure services and how they interact. - MySQL Database: Previous e...

Hello, I need a reliable, fast, and affordable installation of the Stripe payment processor for my website, from someone who keeps their commitments. This person must have knowledge of HTML, PHP, and MySQL. Regards

bjective: To create a website where parents can enter their child’s name, and the name will be automatically integrated into a pre-recorded audio story. The child’s name will be generated using Text-to-Speech (TTS) technology and merged with the main audio file. Scope of Work: Setup and Configuration: Install and configure WordPress on a suitable hosting platform. Ensure the environment is secure and optimized for performance. Frontend Development: Create a user-friendly form for parents to input their child’s name and provide consent. Ensure the form is responsive and works seamlessly across different devices and browsers. Backend Development: Develop a custom WordPress plugin to handle form submissions, generate TTS audio, and merge it with the...

...need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MySQL...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

...developer with experience in creating automation tools. We're looking to build a sophisticated website and dashboard, which will be later integrated with API and MySQL. The final product should be a robust, blockchain-based automation platform. Key responsibilities include: - Building a website and dashboard from scratch - Implementing blockchain technology for automation - Ensuring seamless integration with API and MySQL The ideal freelancer should have: - Extensive experience in web development, particularly in creating automation tools - Proven track record in implementing blockchain technology - Strong understanding of API and MySQL integration - Ability to deliver high-quality work within a short timeframe This is an urgent project, and we need someone ...

I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

I'm looking for a skilled professional who can convert a provided design into a PDF document using HTML format. The attached format should be replicated in the PDF. I will supply all the necessary content and images for the document. Key Requirements: - The PDF should include a header and footer as per the design. - Proper formatting and tables should be implemented. - Images and logos within the document should be accurately included. Skills and Experience: - Proficiency in HTML and experience in creating PDF documents. - Knowledge of would be advantageous. - Ability to replicate a design accurately in a PDF format. - Attention to detail to ensure all elements are correctly positioned. Budget: The fixed budget for this project is 500 INR. Please bid accordingly.

Key Requirements: - Create corporate video with voice over for an engineering factory - Inputs will be provided in the form of images and short videos - Time span of the video will be around 3 minutes - Voice over is required Ideal Freelancer: - Experience in creating corporate videos, ideally with a technological or engineering focus. - Proficiency in video editing and animation software....for an engineering factory - Inputs will be provided in the form of images and short videos - Time span of the video will be around 3 minutes - Voice over is required Ideal Freelancer: - Experience in creating corporate videos, ideally with a technological or engineering focus. - Proficiency in video editing and animation software. - Strong skills in voice over and script writing. - Make videos us...

...Tailored Solutions: We create custom web applications that meet your specific business needs, enhancing productivity and operational efficiency. ● Versatile Applications: Our solutions range from customer portals to complex inventory management systems, each built to address unique business challenges. ● Technology Stack: Node.js, , Ruby on Rails, Django, Laravel, MongoDB, PostgreSQL, MySQL, AWS, Docker....

Project Description: I am seeking an experienced freelancer to develop a directory listing website, similar in design and functionality to the following template: The design will be provided by me. Requirements: 1. Technical Specifications: - Framework/Technology: Please suggest suitable technologies. - Database: MySQL, PostgreSQL, or another relational database. - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly and

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL format...recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project are crucial for our lon...

I'm in need of a skilled individual or team to help me with a machine learning project focusing on image classification. The purpose of the models is primarily for classification, not any other form of analysis. Key Requirements: - The models will be working with image data, so experience in deep learning and image processing is a must. - The processing needs to happen in real-time. It's a critical aspect of the project. Ideal Skills: - Proficient in image processing and deep learning techniques. - Experienced in developing and deploying real-time machine learning models. - Strong background in image classification and neural networks. If you have a portfolio or past project that demonstrates your abilities in these areas, I'd be very interested in taking a look. Looking...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

Is it possible to create a video using Artificial Intelligence? If yes, I will provide the texts (around 300 words each) and you will do it Voices need to be male and female This is for a business website If you can do the voiceovers as well, let me know I need around 100 of them; 3 to 5 minutes each

Is it possible to do voiceover using Artificial Intelligence? If yes, I will provide the texts (around 300 words each) and you will do the voiceover Voices need to be male and female This is for a business website If you can create the videos themselves, let me know I need around 100 of them

Seeking an SEP expert using Yoast Premium SEO with a good command over the English language to optimize my WordPress hosted websites. Here are the links to the websites