Select query in php with where clause jobs

I need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP,...

...upgrade my PHP-based website (CodeIgniter). The current website front end is outdated and the PHP version needs to upgraded too. Key Requirements: - Modernize the User Interface: I want the design to look fresh, modern, and appealing to visitors. We will provide the HTML design for all the pages. - Improve User Experience - Incorporate New Branding Elements - Upgrade the CI/ PHP version to the latest version - The site has a sub login area where the profiles of users are listed. - The users submit their listing info from the front end which creates the profiles. - There is a search function to filter profiles - Ensure the contact forms and all the functions of the site are functional Skills and Experience: - Proficient in PHP - Strong ba...

...3500 stocks 9 min => 350 stocks. Maybe we could do multiple queries of 350 stocks? Because what is in place stops after 1800 files out of 7000. And obviously it starts again each time at the beginning when we restart... so it is always the same stocks which are updated. It would be better if the already downloaded data was not deleted, but kept and downloaded only the missing delta. This would allow us to have large data If we downloaded 1 year of data 7 days ago and we select 1 year, then only the last 7 days are downloaded, which goes faster. The data is then aggregated and deduplicated if necessary. 2) In the "indicator" section, be able to add, modify, delete existing indicators. 3) In "Add an indicator" (to be moved to the "...

...nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the 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, ...

...for Jira Cloud. The script should modify the behavior of a select field within the platform. Key Features: - Dynamic Select Field: The select field should dynamically change based on the values chosen by other issues in the project. This means that as the field is selected, it should update to exclude values already in use by other issues. - Hide Values Already In Use: The script should ensure that the select field does not present options that have already been selected by other issues in the project. - Customize Form Behavior: The script should also allow for custom form behavior in Jira Cloud. This project requires a developer with experience in Jira Cloud and strong skills in Groovy, the required ...

I'm currently in need of a talented fiction writer who can craft captivating stories within the fantasy genre. Key Details: - Your primary task will be to develop a compelling narrative that keeps readers engaged and eager to follow the storyline. - While the narrative perspective is not predefined, I expect you to select a suitable viewpoint that aligns with the story's requirements. Ideal Candidate: - A passionate and experienced writer with a knack for immersive storytelling. - Prior experience in writing within the fantasy genre will be a significant plus. - Ability to adapt to different narrative perspectives and showcase versatility in your writing style.

I'm working on a project using Ignition 8.1.31 and need a feature implemented. The goal is to have a dropdown list in the perspective view that allows the user to select files from a specified directory. Key Points: - The dropdown should be populated with the file names upon the user clicking a perspective View button. - The Load button should be located on the perspective view. The ideal freelancer for this job should have experience with Ignition 8.1.31 and familiarity with creating dropdown lists that are dynamically populated based on user interactions.

Join us in building a cutting-edge slot booking engine from the ground up! This project aims to streamline the process of booking slots for various services, ranging from appointments at clinics to reservations at recreational facilities. Our goal is to create a flexible and scalable backend infrastructure that can handle high volumes of bookings while ensuring a smooth user experience. I need a 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 dynami...

We need a skilled PHP developer who can build a SaaS platform based on the functionality and features of and The project has a set deadline. Critical requirements include: - Expertise in PHP development - Experience in building a SaaS platforms - Google My Business API on the server to fetch review data. - API on the server to fetch review data from other platform like Trustpilot, Facebook, Yelp and Amazon review - Ability to replicate similar functionality and features from a reference website Main functionalities required: - Platform formation from scratch - Comprehensive platform construction - User Registration and Login - Product Rating and Review - API Integration We aim to replicate similar features and functionality from the reference

Before applying for the task, please read the following: - I will include a code word at the end of the text to ensure you have read it thoroughly. When you apply, please start with this code word; I will ignore everything else. - The price and time you provide will be considered fixed, so please adhere to them as I will not negotiate. - I will explain the task as precisely as possible and provide the necessary login credentials. Here is the task: My website is a multi-vendor platform where sellers list their products. When sellers upload products, they had to specify product images and gallery images separately for image uploads. I asked the previous freelancer to automate this so that the product image would automatically become a gallery image as well. Unfortunately, ...

I need help with fixing a project and adding new features in core PHP. - **Fixing:** The project needs to address some bugs and issues. - **New Features:** I'm looking to add a partners portal enhancement, scheduling options for cron jobs, and a mail campaign scheduling feature. - **Partners Portal Enhancement:** The focus of this project is on enhancing the partners' portal, such as: - Improving the user interface to make it more user-friendly. - Adding additional features for partner management that will make the portal more functional and useful for our partners. - Integrating with third-party systems to enhance the capability and reach of our portal. Your previous experience in core PHP projects and adding new feature...

I am looking for a PHP and WordPress Expert to fix a small issue with my current CAPTCHA, which is written in PHP. I also need to add another CAPTCHA to my wordpress website. If you think you can work on these tasks, please let me know. Ideal Skills and Experience: - Proficient in PHP and WordPress. - Expertise in CAPTCHA integration.

Note: Integration with Stripe and Swish payment is a must have. The current wordpress website is with Divi. I'm looking to create an online appointment booking system for an eye clinic. I need this system to have a range of features that will make it more convenient for our patients and staff. Key Features: - Online Payment: The system should support online payment through Stripe. This will allow patients to pay for their appointments in advance. - Swedish Payment Provider: Integration with the Swedish payment provider Swish is important, as many of our customers prefer to pay using this method. - Video Conferencing: The system should enable the setup of online meetings. These meetings should be conducted via video conferencing. This feature will be usefu...

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 a...

ALL PHP script of the configurations and parameters of the site /////CONFIG AND INSTALL SCRIPT //// I want a complete configuration of all parameters URL DEMO SCRIPT. 7437.Cj0KCQiA5rGuBhCnARIsAN11vgR0IAOeV3fZLehJ28mJeOVeC35qXrrXFJfbYhlUK8e9nraqPybSIxUaAic2EALw_wcB .................................................. ................ ......... I want a complete script setup with all systems working. CREATION OF ACCOUNTS AND EMAIL ADDRESSES TO MAKE THE WHOLE SCRIPT WORK example add: :add languages EUROPE AND ENGLISH : account creation, facebock, instagram, twitter X, (create an email address on the domain)

Looking for php laravel developer for small modification on home page of my movie website. 1. Latest movie section is not showing on Home page, show that section again. 2. Fix a small bugs on movies or series option clicking first time showing sometimes Loading only. 3. Lates data of series are not showing. Here is the website:

Google Search Ads Cold Traffic Analysis - Select best countries and why - budget requiremetns - KPIs to follow

I am looking to develop a web-based job extractor that's capable of aggregating job listing from various platforms across multiple countries with the following features: # Source Selection : The ability to select multiple sources for job scraping, including Google jobs. # Comprehensive Job Details: Extraction of all details included in the job listing, such as job title, company name, location, job description, requirements, etc. # Web Interface: A user-friendly web interface where users can enter the URL of the job listings page and initiate the scraping process. # Downloadable in .csv Format: The scraped job data should be downloadable in .csv format for easy analysis and storage. # Filtering Options: Ability to filter job listings bas...

Hi, I need a VPN application with V2Ray protocol. It should support VMESS and VLESS methods. The project can be developed in Swift or Objective-C or Flutter. UI Is attached to the project. Api is ready and all information and payloads related with api will provided by me. Main features: * User will connect to server using an activation code (Like: 23wsfio3592 (include digit and char)) * User can see the remain days and traffic (Like: 25 Days left, 55 GB remaining) * User can change the server to connect to different locations (Simple combo box to select server) * Server list can show the online percentage (Api will return percentage of total traffic on server) * Api will provided best server to connect (Auto connect) that will choose server aut...

In order to realize the scientific research project of "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 ...

...tools look compared to one we're building ourselves. Specifically we're interested in Davinci, After Effects and Runway. We'd like someone with access to/familiarity with all of them (at least the background removal function). This is how it would work: - We give you a single clip - You use each tool to remove the background best you can while screen recording each process and making note of how many clicks it took to select the whole object - For controlled conditions, you have 30 seconds to select the foreground in each tool - Export as is (no further clean up) - Then using whatever editing tool you like the most, take these outputs (and one we'll prvide) and create identical vertical videos for each where it sho...

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.

Hi, Nee one simple PhP,MySQL app which will prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of

More details: What specific coding issue are you experiencing on your website? Functionality not working as expected Which functionality on your website is not working as expected? Footer How soon do you need your project completed? ASAP

...This role involves creating a unique and consistent brand image that aligns with our vision and appeals to our target audience. You will work closely with our team to design a logo, select brand colors, create a slogan, develop social media posts, and compile comprehensive brand guidelines. Key Responsibilities: Logo Design: Create a distinctive and memorable logo that encapsulates the essence of our brand. Brand Colours: Develop a cohesive color palette that reflects the luxury and authenticity of our services. Slogan Creation: Craft a compelling and concise slogan that communicates our brand's mission and values. Social Media Posts: Design aesthetically pleasing and engaging social media content that aligns with our brand identity. Brand Guideline...

...secure and efficient. • Creating property listings, where landlords will be able to upload and manage their property details. • Designing a streamlined booking and reservation system, ensuring it's straightforward for customers to select their desired dates and reserve properties. • Incorporating a map feature, allowing users to visualize property locations. • Developing an interactive help system that can provide prompt assistance to users. If you have prior experience in developing booking platforms, specifically like Airbnb, that will be an added advantage. Essential skills include proficiency in website design and development, a solid understanding of booking systems, knowledge of user interface and user experience design, and ex...

...into my Opencart website. While I am not certain about the specific version of Opencart my website is built on, I am open to discussing this with you. Key Requirements: - Payment Integration: I need Grab Pay to be smoothly integrated into my website. Customers should be able to select Grab Pay as their payment option with ease. - Atome Integration: You should also be able to integrate Atome's installment plan functionality. This includes setting up the installment plan process on the website for customers. Ideal Skills: - Strong experience in Opencart development - Previous experience integrating third-party payment systems like Grab Pay - Familiarity with Atome's installment plan setup and integration - Good communication skills to discuss...

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?

...to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful c...

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

...is essential, allowing customers to easily select and store their desired food items prior to checkout. - User Registration and Login: It's vital that users can register and create accounts, making the process of repeat orders and order tracking seamless and efficient. - Payment Gateway Integration: A solid and secure payment gateway is crucial to accommodate a variety of payment methods and protect customer transactions. Target Audience: - This food ordering website is aimed directly at individual customers, so the design and features must be attuned to individual consumer preferences and behaviors. Ideal Skills and Experience: - Proficiency in e-commerce web development, with a strong portfolio of successful e-commerce projects. - Familiarity with fo...

...products. Key Features: - The app should be compatible with iOS only. - The form is meant to collect information like Name, RMA #, Order #, SKU, SKU quantity, a checkbox "Pass" and a checkbox for "Restocked" (with an option to add multiple SKUs). - The app should also have a drop-down list to select the store name, which will determine the email address the result is sent to. - It should have a section to upload up to 10 images using the phone camera. - Date and time fields need to be automatically populated with the current date and time as default. - There should be a drop-down list to select the person inspecting the returns. Ideal Skills: - Experience in iOS app development. - Proficiency in form creation wi...

Senior Developer wanted with skills in Woocommerce | Wordpress. Must have real coding knowledge not just a plugin expert. To build custom plugins and modify existing ones.

I am seeking an accomplished Interior Designer with experience in corporate settings to undertake an office design project. My aim is to impress my clients with a modern styled office that incorporates key elements. It must also be created to allow for podcast to happen within this office. Key requirements: - The vibe is similar to a gentleman's cigar bar/lounge with a modern twist. - Design should primarily be modern and sophisticated. However, don’t shy away from incorporating some trendy touches here and there. - Incorporation of luxury furniture and art pieces is a must, to enhance the luxurious feel of the office. The designer should have a keen eye for art and design aesthetics, with the ability to select pieces that complement t...

I am seeking an experienced Android developer to create a Forex live charting app that integrates seamlessly with our online CRM. The app will receive live Forex data along with indicators via web socket. Key Features: Real-time Forex charts with multiple timeframes Integration of specific indicators provided through the web socket Option to switch between different currency pairs Customizable interface: users can select which indicators to display Push notifications for significant market events Sample Menu: Home News Market Accounts The app should be both functional and visually appealing, with an intuitive user interface that accommodates traders of all levels. The design should prioritize ease of navigation and effective use of the app's featu...

...custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in 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 subtotal...

I'm looking for a skilled developer to upgrade my site from PHP 7 to PHP 8.2. The current site has: - User registration and login functionality The site is built on Custom PHP, without the use of any specific frameworks or CMS. The ideal freelancer would have: - Strong experience with PHP - Previous experience with upgrading codebases from PHP 7 to PHP 8.2 - Familiarity with Custom PHP coding Please note that the client did not specify custom plugins or modules that need updating. However, it's important to anticipate and address any issues that may arise during the upgrade process. The selected freelancer should be able to identify and resolve any potential conflicts with the existing site's f...

I have a document with the specifications of webservices. I need with php consume this webservices and get responses and save some information in my database

I'm looking for a skilled developer to update the 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 qui...

I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs & Building...

The task at hand is to upgrade the PHP version of my content management system from 7.2 to 8.1. I have been using a PHP without any frameworks, and I'd like to keep it this way. I'm seeking a skilled developer well-versed in PHP and experienced in operations without frameworks. Your responsibilities will include: - Studying the existing PHP code - Carrying out the necessary modification for smooth running on PHP 8.1 without any performance degradation. - Testing and debugging post upgrade to ensure seamless system operation Please note, I need this work completed within 7 - 15 days.

...so you can Chill”. I’m from Greek Cypriot heritage so would like to incorporate that in the logo but it’s not limited to that, something which represents Greek Cypriot culture, vine leaves, fig trees etc I'm looking for a skilled and creative designer to develop a logo that embodies our brand and conveys a sense of professionalism, creativity, and energy. Key Requirements: - Brand Recognition: The logo should establish our brand identity effectively. - Professional Appearance: It should reflect the seriousness and trustworthiness of our business. - Unique Design: We're looking for a design that stands out and is original. - Color Scheme: The logo should predominantly feature blue and green, to align with our brand color preferences. The ide...

...model, brand, year, and other factors. * Create a section for featured listings to highlight select cars, thereby giving sellers the opportunity for added visibility. * Develop a flawless and transparent user review system to allow communication between buyers and sellers regarding the performance, functionality, and reliability of the listed cars. Transaction Feature: * Integrate a secure and efficient payment system to enable direct transactions on the website, providing a seamless buying experience for users. Ideal freelancer for this project should have: * Proven experience in web development, particularly in creating and managing e-commerce platforms and/or car dealership websites. * Knowledge in implementing secure payment gateways. * A strong po...

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 formation, and more. The primary purpose of the proje...- 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 pro...

... Device Selection: Ability to select a device to load its statistics via API. Graphs and Data Tables: Around 10 different graphs and several data tables with pagination. Time Ranges and Filtering: Options to select time ranges and apply filters from the UI. API Integration: Fetch device statistics from a backend API. Modern UI: Clean, intuitive, and well-designed user interface. Key Features: Device List Display: A dashboard-like interface showing all IoT devices. Dynamic Graphs: Display statistics and data in a graphical format (around 10 different graphs). Data Tables: Tables with pagination to display detailed data. Filtering and Time Ranges: UI elements to filter data by different criteria, including time ranges. API Integration: Seamless integrat...

I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs & Building...

...organize stock data from my trading view strategy. The person must have experienced in strategy test option in tradingview. No pragramming language required, just manually check. Note that my strategy name is BRAMMA 1. Objective - Find every stocks in US exchange (Nasdaq and NYSE) that meet the BRAMMA strategy conditions Steps to do before everything. - Please gather all the names of US stocks market in both exchange (Nasdaq and Nyse), then please manually check every stock that meet condition and extract them to excel file. - Please select the trigger that match with the tradingview ticker -Please find list of company in Nasdaq exchange here: - Please find list in NYSE exchange here: - Total share number are: 3381

I'm in need of a PHP developer to assist with resolving a specific issue within my code, and also adjust some functionality related to user balances and payment processing. - The issue is isolated to a certain part of the codebase. I have a video that comprehensively explains the problem, saving you time on debugging and troubleshooting. - The main issue at hand involves the necessity of adjusting user balances and funds for payments. This requires a high level of precision and understanding of PHP functionality. Ideal candidates should have: - Proficient in PHP and associated technologies. - Strong problem-solving skills to address the issue quickly. - Experience in user balance management and payment systems is highly desirable.

...Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  Optimize database performance through indexing, query...