Mysql transpose rows to columns exampleроботи

Front: Vuejs3 (routing, vuetify) Back-API: flask( SQLAlchemy, flask-restful, uwsgi), jwt, mysql Нужно реализовать SPA. Два типа пользователей (юзер, админ), доступ к SPA только после авторизации (пара логин/пароль). Для юзера: (страница №1) - реализовать поиск по базе данных, поиск по всех полях (отдельно по дате, фио, заказу), предусмотреть последующую фильтрацию результатов пользователем (фильтрация: пользователь вводит текстовую строку и если она может быть включением любой ячейки своей колонки результата поиска то отображается, остальные прячем), предусмотреть пагинацию. (страница №2) - как и страницы №1, но база другая, поля базы совпадают. Для админа: добавление новых юзеров админом, и доступ к функционалу описанному у юзера. База данных: ФИО (текстовое), ДатаРожд...

Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)

Будь ласка, вкажіть 1-3 проекти, де Ви працювали із таксономіями (WordPress) та як Ви їх застосовували, де робили кастомну адмінку PHP+MySQL. Очікую на оцінку вартості та термінів, або уточнювальних запитань. Посилання на ТЗ:

Потрібно розгорнути на віртуальному сервері 1. веб сервер (apache/nginx/ +PHP) 2. СУБД (mysql/postgresql) 3. сам сайт

1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Привіт chnazar, бачив твоє резюме на рахунок пошуку роботи якщо тебі цікавий довготривалий проект (PHP,JS,HTML,CSS,MySQL) можемо обговорити деталі

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.

...process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understanding of data analysis and automation. If you have prior experience in similar projects or can demonstrate your ability to deliver q...

See attached detailed description of project. Ideal Skills: - Proficient in pHp 8 - Extensive experience in database integration, particularly with MySQL® - Strong problem-solving skills - Attention to detail and thorough testing - Previous experience with file processing in pHp I'm looking for a professional who can work efficiently and deliver high-quality results. If you believe you possess the necessary skills and experience for this project, I look forward to reviewing your bid.

I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can add and upgrades modules into our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.

I...a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-party Google map API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery -> REST API -&...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 a...

I am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.

We have two sites on windows server that we would like to move to linux, without having to rewrite code for both sites. The current code is ASP and ASPX (vbscript) with Acess dbase. I am looking for someone that can make our ASP and ASPX pages to work on linux server with mysql dbase. We have a VPS on godaddy server, that we can host the two sites on. You are only qualified if you have done this many times before. You may not use our sites to "try" to do this after doing research, we only want experienced individuals on this.

i need my aws rds mysql connceted with retool. it gives error and i am unable to link it. i need help fast so only if you can help in this moment not in 1 h

I'm in need of an experienced PHP MySQL developer to handle data management and manipulation, database design and optimization, as well as web application development for my project. The goal is to create a robust e-commerce website with the following features: - Product listing and details - Payment gateway integration Ideal candidates should have a rich background in PHP MySQL, web application development, particularly in e-commerce platforms, and database design and optimization. Your skills in crafting systems that are user-friendly, secure, and streamlined will be essential. Emphasizing on data management and security is also paramount in this project. Let's connect if you possess these skills.

I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.

...looking for a talented Android developer to build a secure and feature-rich mobile application along with a Laravel-based admin panel for remote management. Responsibilities: Develop an Android application (minimum Android 8) with the following functionalities: Read incoming SMS and identify target keywords. Send identified keywords to a designated remote server. Receive and display SMS messages triggered from the admin panel. Implement a sync button to synchronize SMS data and send details to the remote server. Design and develop a secure admin panel using Laravel 10, MySQL 8, and PHP 8: User registration and management. Device registration with approval workflow. Device blocking functionality. SMS panel to send SMS commands to registe...

...creating our own high quality games and IP via global free-to-play mobile games. Our mission is to championing social good and the sustainability of our ecosystems through games. Want to join a small but experienced and passionate game dev team as a full stack developer? Develop and manage code and infrastructure such as cloud server, backend databases, APIs, and automation scripts. Help build powerful game ops tools with simple frontend UI. - - - Job Specs: - Create backend solutions and integrate with cloud platforms like AWS and Digital Ocean. - Design and deploy modern frontend user interfaces using the latest UI technologies. - Build secure and scalable mobile app REST APIs. - Manage databases using MySQL and NoSQL. - Use DevOps tools to monit...

It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences

We are seeking an experienced WordPress Developer to join our team. As a WordPress Developer, you will be responsible for both the frontend and backend development of our WordPress websites. Your main tasks will include creating and editing custom themes and plugins, optimizing website performance, and implementing new features (such as translating plugin language, or overwriting some existing AI features). The ideal candidate should have strong knowledge of WordPress, PHP, MySQL, and frontend technologies such as HTML, CSS, and JavaScript. Responsibilities: - Develop and maintain WordPress websites - Create custom themes and plugins - Optimize website performance - Implement new features and functionalities Requirements: - Proven work experience as a WordPres...

I'm seeking an expert in Excel w...expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data managemen...

Busco desarrollador web para realizar una página exclusivamente con Java, Javascript, HTML, CSS (puede usar Bootstrap) con base de datos MySQL utilizando XAMPP (phpmyadmin) y Apache NetBeans/Eclipse como entorno. La pagina tiene que tener un inicio de sesión/registro de 2 tipos de usuario (usuario cliente y administrador). La pagina tendrá un menú de navegación en la parte superior con varias pestañas: inicio (introduccion a la web, ultimas noticias, etc), videojuegos (aqui estaran todos los videojuegos de la web con un filtro de busqueda por genero y plataforma sacado de la base de datos donde se ve el nombre de cada uno, foto de su portada, genero, plataforma, fecha de lanzamiento, etc. y alguna opcion para ponerles nota, opinar, añ...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...frameworks, MySQL database, and E-commerce development to build a website. The developer should also have experience with Wordpress and integrating various platforms and APIs. Key project details: - The ideal candidate should have strong knowledge and experience in PHP frameworks like Laravel or Symfony, as well as Wordpress. - E-commerce development experience is essential, especially in designing and building secure and user-friendly online stores. - Proficiency in MySQL database is required. - The website will require integrating payment gateways, social media, and email marketing platforms. Hence, the developer should have experience in these areas. Ideal skills and experience: - PHP frameworks (Laravel, Symfony, CodeIgniter) - Wordpress - E-commerce site dev...

...and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collection, waiting on parts, not started, completed. - Ability to search by customer, PO number, job status, date, part on both active jobs and completed archived jobs in t...

...experienced Java Full Stack Developer to build a comprehensive application with the following features and requirements: - **Features and Functionalities** I need the application to have the following features: - User registration and login: A secure and user-friendly way for users to create accounts and log in. - Payment processing: A seamless payment processing system. - Data encryption: Robust data encryption measures to ensure user data is safe and secure. - **Design and UI/UX Requirements** I'm looking for a modern and clean design that is responsive and mobile-friendly. The interface should be intuitive and user-friendly, making it easy for users to navigate and interact with the application. - **Integration and Third-Party...

...developer, well-versed in Core PHP and Wordpress Development. The ideal candidate must be able to work on various projects with the following requirements: - User Authentication and Authorization: The developer will need to create secure login and registration systems for our websites. - Database Integration and Management: Proficiency in MySQL is a must. The developer will be responsible for managing and integrating databases effectively into our sites. - Payment Gateway Integration: The developer will have to implement payment gateways, ensuring a smooth and secure payment process for our users. Ideal Skills: - Proficiency in Core PHP and Wordpress Development - Strong understanding and experience with MySQL - Previous experience in User Authentica...

...proficient PHP programmer to handle a variety of tasks on my project. These tasks will include: - Website development: The core of this project involves visualization of the key concepts, hence proficiency in creating efficient and visually appealing websites is a must. - Database integration: The website functionality will be backed by a responsive and robust database. Expertise in MySQL or similar database is critical. - Custom script development: You will need to develop tailored scripts to meet the specific needs of my project. Familiarity with CodeIgniter is essential for this project since we will be using this framework for our site. Given the complexity of the work, I prefer a mid-level developer who has substantial experience in the aforementioned ...

...users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design

...e-commerce platform development - Strong understanding of front-end technologies, such as jQuery, JavaScript, HTML5, and CSS3 - Knowledge of MySQL and other relational databases - Familiarity with RESTful APIs and Web Services - Ability to work with version control systems like Git The primary goal of the project is to create a robust, scalable, and user-friendly e-commerce platform. The platform should be able to handle a large number of products, facilitate smooth transactions, provide a secure payment gateway, and have a user-friendly interface. A key part of the role will be to ensure the system is built with scalability and maintainability in mind, to support future growth and modifications. If you have experience in CodeIgniter and e-co...

I'm looking for a PHP developer with substantial CodeIgniter framework expertise. The project at hand involves upgrading and optimizing an existing PHP application. Key Requirements: - Strong PHP skills and extensive experience with the CodeIgniter framework - Proficiency in MySQL database management for database optimization and management. - Familiarity with front-end development to be able to enhance the UI/UX as part of the upgrade. Your main responsibility will be to improve the existing codebase, making it more efficient and scalable. This will involve database optimizations, code refactoring, and possibly some UI/UX upgrades. An understanding of security best practices in web development will also be highly beneficial. If you have previous experi...

...the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, skin and hair products, and makeup. This system must: Collect content from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools ...

We are looking for a talented PHP Laravel Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the stability and rel...

I'm seeking a skilled professional to help me understand the basics of the Zig programming language, specifically in relation to MySQL/MariaDB. I would like assistance in the following areas: - Learning how to incorporate MySQL/MariaDB within Zig projects

I'm currently facing a Forbidden error in my Laravel project that's connected to a MySQL database. I'm looking for a skilled developer to troubleshoot and resolve this issue, and potentially optimize the database connections for a smoother performance. Key tasks: - Troubleshoot the Forbidden error in my Laravel project - Review and potentially modify the existing database connections - Ensure that the database connections are optimized for performance The ideal candidate will have: - Strong experience with Laravel framework - Proficient in MySQL database management - Proven track record in troubleshooting and resolving similar issues

We are a web development company looking to expand our team. We need someone highly skilled in PHP and MySQL. Our work primarily involves custom projects, and occasionally WordPress. Currently, we have a job ready to start using the BigCommerce platform. This project requires code customization, assistance with connecting to shipping, and more. Thank you.

I need help migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Migrate the entire website (including the Currency Converter feature) from the existing server to a new one. - Ensure that the Currency Converter functionality remains intact and fully operational post-migration. Ideal Skills and Experience: - Proficiency in Joomla, PHP, and MySQL. - Prior experience with migrating websites, particularly those with dynamic features like Currency Converters, would be beneficial. - Strong attention to detail to ensure all components of the website are correctly transferred and operational.

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I have a series of medical bills that need to be entered into a spreadsheet. The data is primarily textual, numeric Ideal Candidate: - Must have a keen eye for detail to ensure accurate transcription of the printed text into a digital format. - Proficiency in spreadsheet software for the efficient and organized entry of the data. I have attached an example bill and the expected excel format. I have 34 such pages of bill. Overall you will have ~200 rows to be entered.

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I have a substantial Exc...table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key t...

I'm in need of a professional who can convert both scanned documents and photos into simp...have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurately reflected in the Excel sheet based on the provided template. The quality and accuracy ...

...like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL d...

I'm looking for a skilled professional who ...setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommodate this added f...

Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.

I need a minimal working example of PPPOS in IDF framework v4.4.7. The requeriments are: - Minimal example with SIM800L modem. - Create and configure esp_netif for PPP (create the driver, and task to receive data from modem and send to esp_netif) - Configure the modem via AT commands (PPP conection ATD*99#) - After succesfull connection, make a http request for testing. The most important thing: DO NOT USE esp_modem component. The example must do not use any component, simply the esp_netif API.