Mysql php database website jobber

My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with ...

need Simple live chat system between 2 users, no designing needed. 1. login using php 2. show list of users fetched from db 3. on clicking a user, initiate chat (if the other user not blocked the requested user) 4. the chat should be live, realtime. and the data to be stored in mysql db 5. option to block user should use php as backend and bootstrap as front end . you can use firebase budget AUD 50 and should be done today please don't bid and ask for more time and money

Looking to implement an Elasticsearch Cluster primarily for improved data management and search ability for my app. The system must cater to handling and analyzing large amounts of structured data. Ideal Skills and Experience: - Strong Elasticsearch expertise - The system should integrate efficiently with both Logstash and MySQL. - Previous experience in cluster management - Proficient in tweaking and optimizing performance of cluster and data management

...customer service aspect of my business and to take charge of a small database (containing up to 1,000 records). Key responsibilities will include: - Customer Service: Responding to client enquiries, resolving user issues, and maintaining high customer satisfaction levels. - Database Management: Handling information pertinent to the customer service role, conducting regular updates, ensuring record accuracy, managing data privacy, and maintaining overall data integrity. The ideal candidate would have: - Prior experience in a customer service position, demonstrating excellent communication and problem-solving skills. - Proficiency in database management, more specifically with small scale databases. Knowledge of database software will be an added advantage....

I am seeking a Java expert to build a simple and efficient Java Servlet application that will seamlessly connect to my Oracle 19c database via JDBC. Key requirements for the project: - A Java Servlet application tailored to connect to Oracle 19c database - The application should be able to execute both read and write operations on the database. - The solution should be robust, secure, and optimized for performance Ideal candidate for this project should have: - Proven experience with developing Java Servlet applications - Strong background in working with Oracle databases - Proficiency in JDBC and database management - Familiarity with database read and write operations - Ability to deliver a high quality, efficient and well-documented solution

We have an internal database with about 2000 European investor profiles from the last 20 years. I'm looking for a skilled developer to integrate OpenAI GPT to allow users to search for suitable investors in our database without needing to input a specific format, but normal text. the GPT then translates this text into a format of our database and based on a matching / scoring algorithm will select the best 10 investors for our set of 2000. The user should be able to go on our website. ask a question leave an email and get an answer with the top 10 list as an email attachment. That person needs to leave his contact details which will be automatically added to our Zoho CRM with a trigger action to setup a call for one of our sales people. Key Project Deta...

I'm seeking a professional PHP expert to assist with my current project. Key Responsibilities: - Hands-on PHP web development - PHP script optimization - Integration of PHP frameworks - Debug and troubleshoot code I'm looking for an individual with a solid understanding of PHP, who can help take my project to the next level. Your ability to optimize scripts, integrate PHP frameworks, and tackle web development issues will be crucial. Please provide examples of your past projects, particularly those related to PHP development. Experience and knowledge of PHP frameworks are a bonus. If you're a skilled PHP developer and you're ready to tackle new challenges, I'd love to hear from you.

Error establishing a database connection This either means that the username and password information in your file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down. Are you sure you have the correct username and password? Are you sure you have typed the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.

...expert to assist in configuring a Linux VPS. The main purpose of this server is for database management specifically using MySQL. Key Tasks: - Configure a Linux (Ubuntu) VPS with optimal settings for database management. - Install MySQL and ensure it's fully functional. - Implement necessary security measures to safeguard the server and database. - Documentation of the process and any configurations made. The ideal freelancer for this project should have: - Proficiency in Linux (Ubuntu) server configuration. - Advanced knowledge of MySQL and its management. - Proven experience in setting up servers for database management. - Capable of implementing robust security measures to safeguard the server and database. - Ability ...

Seeking an expert to restore my website stored on an AWS server. The main goal is to recover lost data; specifically, substantial MySQL database information which unfortunately went missing. Key Skills and Experience: - Experience with AWS and MySQL is critical. - Proven track record of effective database recovery. - Proficient in database management and data retrieval. If you are adept in these areas and can ensure a successful recovery of my data, I would be interested in discussing further.

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

I'm in need of a professional PHP developer to manage back-end services and ensure interchangeability between server and users. Key responsibilities will include the development of all server-side logic, definition, and maintenance of the MYSQL database. This role also requires the optimization of the system for speed and scalability, as well as the integration of user-facing elements developed by front-end developers. The ideal candidate would have: - Solid PHP development experience. - Proficiency in MySQL databases and related operations. - Experience with User Management functionalities. - Expertise in Content Management operations. - Prior experience with Real-Time Data Processing. Your primary focus will be on: - Creating database sc...

...support to create an online post-secondary institute website. The website is scalable and easily deployable. Choose the best domain registrar with the best hosting package, if the domain registrar and host offers website development and designs...or if registrars/host offer integration with LMS or SIS (I would use an open source LMS or SIS with the ability to custom and integrate... Current priorities are: - advertising on the institute website for job seekers, partners,... (provide solutions) - autoreply for submitted job seekers application, inquiries,... Website will look fully functional. All pages connected and linked. There are AI powered solutions with no code web builders, I know some. Do you know them if so write me. All website file...

I need new features integrated into the existing PHP code. It's vital to note that your proficiency in PHP will be instrumental. I expect the freelancer to provide suggestions and potential improvements in creating a robust application.

I want a script that allows me to export a Zencart catalog () to CSV in real-time with the following fields: Title Short description Category (x, y, z) Description Image URLs (URL1, URL2, URL3) Price Stock

I am in search of a skilled backend developer with proficiency in Python, for a project that necessitates a relational database system for user authentication and authorization. Key Requirements: - Proficiency in Python: The project is built on Python, so the ideal candidate should have a strong command of this language. - Experience with Relational Databases: I am looking for someone with a background in working with relational database systems such as MySQL or PostgreSQL. - Security Conscious: Given the focus on user authentication and authorization, a strong understanding of security principles and best practices is essential. Additional Skills (preferred but not mandatory): - Experience with NoSQL or Cloud-based databases could be a plus, as these might be integr...

II'm in need of a skilled developer to build a PHP, HTML, and CSS based public grievance web-based project for me. This project will include: - Complaint Handling System: This system should be capable of receiving, processing, and resolving complaints from users. It should categorize complaints based on their types and departments. - Sentiments Analysis Graph: An integral part of this project is the sentiments analysis graph. The graph should be designed as a bar chart, displaying the overall sentiment of the received complaints. - Department Categorization: Complaints should be automatically routed to the relevant department based on their nature. Ideal candidates for this project should have: - Proficiency in PHP, HTML, and CSS - Experience in building web-based comp...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

Hi, I'm looking somone to edit my websoftware developped in php/mysql : Add : - field to attach a file per client - add account expiration date - Email notification - Link vehicles by API with our geolocation system

I'm in need of assistance for setting up a PostgreSQL database on my backend GitHub website. The primary purpose of this database is to store user data. Given the nature of my website, it's essential that the database supports concurrent access efficiently. The ideal professional will have: - Proficiency in setting up PostgreSQL databases. - Experience with integrating databases into backend GitHub projects. - Knowledge of concurrent access management in databases.

I need a proficient PHP coder who can write a script for me that will print images (in JPEG format) and QR codes on a thermal printer. The images are our company logo and the QR codes are meant for conducting reviews. This PHP script will be used online on a cloud platform. Ideal skills for this job are: • Strong expertise in PHP • Familiarity with JPEG images and QR codes • Experience in creating scripts for printing needs, specifically on thermal printers • Understanding of cloud platform workings. Your primary task will be the creation of a script that can accurately print images and QR codes on our thermal printer, effectively facilitating bill printing for our operations. Deliver a clean, efficient code that can be effortlessly integrated a...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I am in need of a MySQL expert to develop advanced queries for my database management tasks. Key Responsibilities: - Writing new queries: You'll be responsible for designing and implementing new, advanced MySQL queries. - Query Optimization: While the focus is on writing new queries, any optimization suggestions to existing queries are welcome. Ideal Skills: - Proficiency in MySQL: You should have advanced knowledge of MySQL language and its various functions. - Query Optimization: Experience in query optimization will be beneficial. This project is suitable for a MySQL developer with a proven track record in creating complex, high-performance database queries. It's important that you're able to work efficiently and effecti...

I'm currently experiencing some technical problems with my PHP website. Though it functions smoothly on localhost via XAMPP, errors arise upon moving it to our server on HostGator. The desired candidate for this job has the following abilities: - Extensive knowledge in PHP and server-handling, preferably with HostGator - Experience with troubleshooting and resolving website issues - Capable of fixing server-related issues Typical problems we're facing include: - Site not functioning correctly on the server despite proper local host operation - Error messages - Performance issues This troubleshooting requires someone who can detect and fix issues from server-end to user interface. Prior experience with cases similar to ours will be a plus. Applican...

I'm seeking a proficient Full Stack Java Developer to create a web application. Even though I haven't specified the use of certain frameworks, familiarity with Spring Boot, Hibernate, and Angular will be useful. Your primary role will focus on: - Developing a highly responsive web application from scratch. - Implementing MySQL as the preferred database management system. Candidates who have prior experience in full-stack development and database management using MySQL are highly desirable. This is a project that demands robust technical skills, so a sound understanding of various Java frameworks and web application development is essential.

Looking for a very expereinced php devleoepr for multiple bug fixes

I need a skilled Java developer specializing in back-end development who can use MySQL as their database technology. The main task for the developer is to work on API development, ensuring the smooth transaction of data between the server and our end users. Ideal Skills and Experience: - Proficient in Java and backend development - Extensive experience with MySQL database technologies - Experience in API development and management

I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - ...

As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.

I acquired a PHP script from Codecanyon and seek a skilled developer to enhance its capabilities. The primary tasks involve implementing robust data validation mechanisms and integrating a specific condition for the calculator functionality. Project Requirements: Data Validation: Strengthen the script's data validation process to ensure accuracy and security in handling user inputs. Calculator Functionality Enhancement: Customize the existing calculator feature to include a specific condition, optimizing its performance and usability.

I will be choosing someone one hour from now. Answer me this questions: Are you available immediately? We have a demo tomorrow 9am EST What is your experience with PHP? What AI tools do you use to make your devleopment faster? Are you comfortable working hourly?

As a PHP and MySQL expert, your task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to ...

I am in need of an experienced Laravel expert who can upgrade a food delivery PHP script, consisting of Laravel + React PWA Apps, from Laravel 5.8 to 6.20.44. This is a Codecanyon PHP Script that I have already purchased. - No feature changes are needed within the upgrade process. - Skills needed include Laravel, PHP, React and PWA Apps knowledge. - Hands-on experience in upgrading Laravel projects would be an added advantage. It is essential that you understand the intricacies of both versions to ensure the upgrade is seamless, with no bugs or errors. Prior experience with food delivery scripts will be highly regarded.

...Sistema de Pujas Consideraciones Adicionales: Ya contamos con logotipo, colores, tipografia. Los pagos de los estudiantes seran cobrados en una cuenta comun por transferencia bancaria, por lo tanto no se requeire un sistema de pagos aun. Tecnologías Recomendadas: Al ser el primer proyecto que envio a cotizar no conosco de tecnologias pero si quisiera que se realize en HTML,CSS, JAVASCRIPT MySQL y PHP para el Chat interno. abierto a recomendaciones No estoy considerando el hosting y otras asuntos por lo tanto espero sugerencias. Deseo que el sistema sea inspirado en aqui comparto una grabacion breve que hize para que entiedan mejor de lo que deseo cotizar: Video demostrativo?: ?

I'm looking for a proficient PHP developer who can help me with parameterizing a MySQLi query in my project. Specifically, I need assistance with data retrieval operations. Key requirements: - Proficiency in PHP: You should have a strong grasp of PHP programming. - MySQLi Query Parameterization: The ideal candidate should be experienced in properly parameterizing MySQLi queries. - Data Retrieval: The primary task will be focused on data retrieval operations. The project may include: - Handling multiple parameters: You should be comfortable working with queries that handle multiple parameters at once. - Optimization: Ensuring the queries are optimized and secure. It's a relatively straightforward task for a skilled PHP developer with MySQLi experien...

I'm in need of a versatile software that can record video from endoscope cameras and facilitate the creation of a database from each video. Key requirements: - It should be compatible with Windows and Mac operating systems. - I prefer storing the database locally on the same device. - The software must support video formats AVI and MP4, which are the formats the endoscope cameras I use record in. The ideal freelancer for this project should have experience with: - Developing video recording software - Implementing database management systems - Proficiency in working across Windows and Mac operating systems - Knowledge of AVI and MP4 video formats Please submit your proposal with relevant experience and a clear explanation of how you plan to approach this proj...

The code stuck when xml is wrong or long or when the close tagID is not found. I want to correct it in order to manage more connection. Consider that the XML is a camera that send more or less 1 xml every 2sec. Here my code: $listen_port = $this->cameraPort; $sock = socket_create_listen($listen_port); if ($sock === false) { $errorcode = socket_last_error(); $errormsg = socket_strerror($errorcode); $this->logger->error($this->logPrefix . "Couldn't create socket: [$errorcode] $errormsg"); return Command::FAILURE; } socket_getsockname($sock, $addr, $port); $this->logger->warning($this->logPrefix . "Server Listening on $addr:$port"); while ($c =...

WordPress & Database Speed Optimization required : 1- Database optimization as one of my plugins is sending queries to DB - some time causing connection Error - or unreachable host Error. 2- Without CDN if possible 3- Including Premium plugin - I have 10 web booster Pro subscription. - If required. 4- Automatic Photo Optimization 5- Permanent solution. 6-Minification - if required. Urgent start up required, who is free and can finish asap.

~10 php files in stock Rework everything - rewrite texts - change graphics and make it modern corporate. the design requirement is a modern corporate style, one of the main requirements for the landing page is trust the same requirements as for landing pages for affiliate marketers - PPC google ads companies The user must trust the design - the content - aif-usa com a couple of links as an example for additional content The theme of the design must correspond to the direction of the company’s activities: The company is globally engaged in transportation and logistics - WAREHOUSING SERVICES - Import Export operations The company is globally engaged in transportation and logistics - WAREHOUSING SERVICES - Import Export operations One of the company’s projects is the...

I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this o...

I'm seeking a top-notch freelancers with expertise in Laravel PHP to design my business-oriented payment gateway website. Ideal candidates should have a deep understanding of e-commerce platforms and a proven track record of delivering reliable and secure payment solutions. The final product should enable hassle-free transactions for businesses and ensure a seamless user experience. Key Requirements: - High proficiency in PHP, particularly Laravel - Familiarity with business-oriented platforms - Experience in integrating multi-currency support - Mobile wallet integration expertise - Proven ability in creating detailed transaction reporting systems - Deep understanding of security protocols - Excellence in UI/UX for a seamless user experience By evidenced past w...

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

Please fix my task that we spoke about

I require a freelancer skilled in MacOS and command line operations to assist me with the installation of a Foodomaa extended license script on my localhost. The purpose of this installation is to allow for extension development. The selected freelancer must have: - Proficiency in MacOS - Fam...command line interface operations - Previous experience in handling Foodomaa scripts This task will involve installation and ensuring that the script functions as required on my MacOS localhost environment. Your responsibility will not only be limited to the installation but includes providing documentation on the process to help other team members understand any modifications made. Skill in PHP, MySQL, admin panel setup, and understanding of web server would be a bonus. Looking forw...

...a PERL, HTMX, MYSQL programmer who can help me with an intermediate level project. The ideal candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML interface, based on Perl, HTML, HTMX to this table. I need to be able to search, add, edit and delete entries as well as combine two entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and commented. Per...

...help upgrade a state-of-the art startup MEMBERSHIP PLATFORM; website, iOS & Android apps, and admin panel. **OVERVIEW** The framework is built in versions that are several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, Node, Express, React Native Frontend: React (website), Node + ...

READ FIRST: ONLY HOURLY CONTRACTS, no fixed rate because I have multiple bug fixes on trello and I need someone to start immedaitely. We have demo tomorrow. I want someone to work the next 8-10 hours on time tracker (no manual hours). Important, I need someone immediately

...development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experience in creating forms in MS Access - Ability to understan...

** FAVOR DE VER Y LEER EL PDF ADJUNTO CUENTA DEMO WEB ACTUALMENTE EL REPORTE SE PUEDE CREAR PERO EN 2 FORMAS DIFERENTES NECESITO UNIFICARLO Y QUE ME MUESTRE LA DIFERENCIA QUE HAY ENTRE CARGA Y DESCARGA Se requiere un reporte con la siguiente información: Reporte en donde marca el máximo valor de nivel de combustible (carga) en este caso es 20,000lts El reporte deberá tener la condición para tomar el punto de carga de si se conservo en un nivel alto por más de 10 minutos, no se ha movido y no cambio el valor digamos 5000,10000,15000,20000lts lo marcará como carga, cuando este detenido por 10 minutos y empiece a detectar movimiento de descarga de más de 2000 litros lo tomará como descarga el ultimo valor más grande. • ...