Stored procedure in mysql 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'm looking for an experienced Python Developer to assist with web development tasks using Django and Flask frameworks. Key Responsibilities: - Implementing web development tasks usin...Django and Flask frameworks. Key Responsibilities: - Implementing web development tasks using Django and Flask frameworks. - Ensuring the code is of high quality and meets our standards. - Collaborating with the team to deliver project requirements on time. Ideal Candidate: - Proficiency in Django and Flask is a must, with experience in building scalable web applications. - Previous experience with Python for web development is highly desired. - Knowledge of databases and data storage systems like MySQL, PostgreSQL, and MongoDB is a plus. - Strong communication skills and abilit...

I need help hosting my PHP Laravel project on an...hosting my PHP Laravel project on an AWS EC2 instance with a MySQL database. The primary aim is to ensure high availability of the service. Key requirements: - Set up the PHP Laravel project on an AWS EC2 instance - Configure a MySQL database within the AWS environment - Assistance in setting up a load balancer to ensure high availability The application will mainly be handling API requests, so it's important to set up the infrastructure in a way that can handle these effectively. The project has been designed to be scalable, but I need a professional who has extensive experience in setting up and managing Laravel applications on AWS to ensure the best performance and availability possible. Please ...

I'm in need of a skilled developer who can build a .NET middle layer for me. This layer will be responsible for calling an external API and handling the responses in a JSON format. The requirement is to design the system in a way that the output is stored in a JSON file. Key Requirements: - Build a .NET middle layer for API calls - Handle API responses in JSON format - Save the output in a JSON file I need this layer to be manually triggered on-demand. This is a crucial aspect of the project, so reliability is key. Ideal Skills: - Proficiency in .NET development - Experience with APIs, especially handling JSON data - Ability to design systems for manual triggers Experience in similar projects is a big plus, so please...

...have experienced in cs-cart ( ) PHP software Built using open source technologies, PHP/MySQL, Smarty, CS-Cart is flexible and highly customizable software making it easy to modify the program and extend its functionality according to your needs. Key requirements include: - Developing a brand new Cs-cart site from scratch. - Experience with online stores, especially those dealing with physical goods. - Implementing top-notch e-commerce features, including but not limited to product listings, categorization, and secure checkout. - Designing a user-friendly and visually appealing interface that aligns with our brand identity. - Ensuring a seamless shopping experience for potential customers. Ideal candidates for this project should have prior experience in Cs-c...

...specialist to assist with a record keeping project. The task involves transcribing handwritten notes into digital format. Key Responsibilities: - Transcribing handwritten text notes into digital format while maintaining accuracy and attention to detail. - Ensuring the data is organized and stored appropriately for efficient record keeping purposes. Ideal Skills and Experience: - Proficient in data entry with a preference for experience in transcribing handwritten text. - Attention to detail and accuracy in transcribing to ensure the data is correctly entered. - Familiarity with record keeping practices is a plus. The role needs someone who is detail-oriented, reliable, and able to work efficiently. The goal is to smoothly transition handwritten notes into...

I'm looking for a skilled web developer who can help me deploy my e-commerce application on FastComet's shared hosting using cPanel. Here are the sp...of Node.js should be installed to support the application - File Management: The application files will need to be uploaded via the File Manager - Database: You will need to create and configure a MySQL database - Dependencies: I need you to install Laravel and Node.js dependencies The ideal candidate should have experience with Laravel, React, Node.js, and deployment on FastComet's shared hosting. Experience with cPanel is a plus. Your understanding of e-commerce application functionalities will be highly appreciated as well. Please include your relevant experience and your proposed approach in your bid. Look...

I need to convert a conceptual ERD to a logical ERD (See attached image below). The logical ERD should only include primary and foreign keys. I need the prpject ready by 25th/26th Skills and experience needed: - Proficient in database design, specifically with MySQL - Understanding of primary and foreign keys - Familiarity with normalization forms - Ability to convert conceptual ERD to a logical ERD

I'm in need of an experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this databa...

Hi, I need to extract data from some sites and compare them in a unique database. In few words i need a scraping code in python that extract data from some sites and the data have to saved in a mysql database.

I need an in-depth analysis of Woonsocket's justice system and the Department of Children, Youth, and Families (DCYF). Specifically, it should cover: - Law enforcement practices - Court procedures - Child protective services - The observance or violation of the Supreme Court Rules of Criminal procedure - Any cases that reveal policing based on personal bias, perception, and beliefs rather than law - Instances where the power and trust Rhode Island placed in these systems have been abused without consequence. Freelancers indicating interest should demonstrate: - An understanding of the depth and breadth this project demands - Ability to proficiently navigate the legal and justice system landscapes The ideal freelancer would have a background in legal stu...

The registration page of our website is encountering issues, where after submission, unidentified errors arise. I am seeking a professional who can: - Investigate the root of these errors and find a resolution - Optimize the registration process, ensuring a smooth user experience post submission And Also add option to add balance to ...is encountering issues, where after submission, unidentified errors arise. I am seeking a professional who can: - Investigate the root of these errors and find a resolution - Optimize the registration process, ensuring a smooth user experience post submission And Also add option to add balance to user Your expertise will be pivotal in ensuring our users can effectively register on our platform. Ideal skills for this project include: - CPANEL -...

I'm looking for an experienced Python and Flask and Mysql developer to construct a multitenant REST API project with three key components: an admin module, a customer module, and SMS integration using Twilio. The project will require the following: Admin Module: - CRUD Operations: I'll need a solid set of operations for creating, reading, updating, and deleting entries. - User Management: The admin module should have a user management system. - Reporting and Analytics: The ability to generate reports and analyze data will be critical. Customer Module: - Multiple roles under Customer - Registration and Login: The customer module should allow users to register and log in securely. - Account Management: There should be a functionality for account management for cust...

i need a web scraper for get the info of , i need some spepecific info (payments transactions) and put this info in a table in mysql. please fell free to ask

I'm working on a PWA application and require a developer to help integrate the following features: - Taking a photo using the phone camera - Saving the photo to a MySQL database - Capturing the GEO Location of the phone and associating it with the photo The PWA will be optimized for both Android and iOS platforms, so experience with development for these platforms is essential. Most of the pages in the PWA is PHP In your application, please provide examples of your past work that are relevant to this project. It will help me evaluate your experience and capabilities.

...genre's essence, laced with a streak of dark humor. The EMBRACE novels explore various "viruses," both literal and figurative, that plague society: Key Requirements: - Experienced in book cover design, preferably in political satire and dystopian genre. - Skilled in graphic design software, especially Photoshop and Illustrator. - Must be able to work swiftly, as the project completion is needed ASAP. - Creativity and the ability to weave subtle humor into the design is paramount. - This will be a minimum of a 3-book series, so factor that in the design. - Main character is Noah Philter: A Dictator in Waiting? (Guess who?). Books beta titles ,b1 - EMBRACE THE LIES; B2 - EMBRACE THE VIRUSES Publisher is Tanagers Envision ...

About Us Rentis is an online platform that facilitates the rental of objects between users. We connect people interested in saving money by renting objects instead of buying, with people who have unused objects and who want to earn extra money. We are a Brazilian startup starting an online platform. Perhaps the scope of the project and all the information are not in the best shape, but we have done our best so far to help anyone developing it. What we need Pages developed in ReactJs according to the Figma project and documentation in Notion, using the best practices in the development market. We accept suggestions for adjustments and improvements to the project. Maybe the Figma project doesn't have the best structure because we're beginners,...

I'm looking for a developer who is proficient with Google Cloud Platform and...website. Key Requirements: - Google Cloud Platform: You should have experience with GCP, including setting up and configuring services. - PHP 5.6: You will need to work with PHP 5.6 to ensure the website's functionality. - MySQL 5.0.96: Proficiency with MySQL 5.0.96 is essential for database integration. - FTP: You should be able to set up FTP to allow for the uploading of files. - Cloudflare: You will also be responsible for making necessary configuration changes in Cloudflare. Ideal Skills: - Experience with Google Cloud Platform - Proficiency in PHP 5.6 and MySQL 5.0.96 - Knowledge of setting up FTP - Familiarity with Cloudflare configurations - Ability to ensur...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

I'm in need of a skilled computer expert to help me develop a database. This database will essentially serve as an accounting tool for food. It's crucial for me to keep track of various aspects of my food-related transactions, including purchases, sales, and expenses. I require a professional who can translate these needs into a well-structured database. Key requirements include: - Data on food purchases, sales, and expenses should be efficiently stored and easily accessible - The database should be designed to facilitate clear accounting procedures - The system should be user-friendly and reliable, making it easy for me to input data and generate reports as needed Ideal skills and experience for this project are: - Proficient in database design, particula...

...Consistently slow loading times on the front end - High server CPU usage, which I suspect is leading to the slow loading times - Database connection errors - Posts in the backend are taking a considerable amount of time to load I haven't made any recent changes to the site, such as installing new plugins or updating the theme, which could have caused these issues. I need a skilled professional who can dig into these issues and improve the overall performance of my site. Ideal skills and experience for this job include: - Extensive experience with WordPress - Proficiency in optimizing site performance - Knowledge of Apache and MySQL/Mariadb - Experience working with Virtual Private Servers - Ability to diagnose and resolve database connection errors - Unders...

As a business owner with an existing website, I'm searching for an expert in Amazon Web Services (AWS), PHP, MySQL, and server administration. My core objective is to seamlessly migrate my website to AWS. Your role would involve: - Setting up and managing EC2 instances. - Assisting with RDS database and S3 storage. - Implementing Elastic Beanstalk. Necessary Skills include: - Extensive experience with AWS (EC2, S3, RDS, Elastic Beanstalk) - Website migration expertise - Strong background in PHP programming - Familiarity with MySQL - Proven Server administration skills Please bid with relevant credentials and explain how you would ensure a smooth migration.

I'm in need of an experienced Flutter Web App developer to develop a one page sample app that uses Firebase as back end. The app should be able to list Excel files from the server and allow the user to select a file and email the file as an attachment. The function must work on Android devices including Chromebook. The development environment must be on a MacBook with Android Studio IDE. Sending URLs instead of attachments is not acceptable. Key Requirements: - Utilize Flutter for the front-end development. - Incorporate Firebase for back-end data management. - Implement support for Excel files specifically. - Provide means to list the documents stored in the Firebase account. - Include functionality to email these files as an attachment. Ideal Skills: - Profici...

We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in ...

I am looking for an experienced and reliable PHP developer to integrate a new payment provider (CCBill) into our existing ecosystem. This system includes various APIs built with PHP 7.4, Symfony and MySQL. Requirements: - Extensive experience with PHP, specifically PHP 7.4 - Familiarity with integrating payment providers - Experience working with Symfony framework - Experience with MySQL databases - Familiarity with complex API ecosystems - Reliability and professionalism Project Details: - Scope: Integrate a new payment provider into our existing system, ensuring seamless functionality - Timeline: Expected duration and deadline can be discussed - Communication: Regular updates via preferred communication channels (email, zoom or skype) Budget: To be discussed ba...

I'm looking for someone skilled in both data science and natural language processing (NLP). The tasks at hand involve sentiment analysis, text classification, and named entity recognition. Key Requirements: - Your experience with sentiment analysis should be strong. - You should have a solid background in text classification and be able to manage a medium-sized dataset. - Experience in named entity recognition is essential for this project. Dataset Details: - The dataset you'll be working with is stored in text files. This is a medium-sized dataset, containing between 1,000 and 10,000 data points. The successful completion of this project will require deep expertise in NLP techniques, a keen eye for detail, and the ability to deliv...

...Establishing a data analytics feature. This data should be accessible to admins and will be used to gauge user preferences and activity. * Incorporating real-time notifications. This functionality should alert users of new content, primarily new music uploads. An essential part of this project is the local storage and streaming of music files. These files need to be stored on our server and not sourced from external resources. They should be stored on a local sqlite database. Ideal candidates should have experience working with ASP.NET MVC, building user registration systems, implementing real-time notifications, and most importantly, handling local storage and streaming of multimedia files, preferably music. A robust understanding of data analytics and how to track user...

...If you are familiar with AWS programming, this should be a simple task for you. I have included an example C# solution using AWS Transcribe that I need to be working. Example Program: AWS Transcribe documentation: Requirements: • I will create a new AWS free account and will supply credentials. • In my AWS account, configure any IAM role/policy/user/credentials needed to run the example program. • Change the example program to accept credentials (accessKey/secretKey) as arguments passed to the executable. • Ensure that the corrected code successfully converts the speech in the audio file to text using the AWS Transcribe service. Deliverables: • All source code • Instructions

"I am actively seeking a designer who possesses a profound understanding of branding. Proficiency in Maya, Adobe Suite, 3D Studio Max, and general image editing skills are prerequisites for this role. The brand in question is already well-established; however, it requires a sophisticated refinement while maintaining its appeal. Specifically, this project involves the design of a spirit label. If you lack the aforementioned skills, I kindly request that you refrain from applying or if you are trying to give the work to someone else. When I'm available online, I can provide further clarification. Please understand and NDA will be required to sign.

...integrity and security. Main Integrations 1. User Registration and Authentication: • Enable users to create accounts and securely log in. 2. Payment Gateway Integration: • Allow users to make payments online using a secure payment gateway. • Track payment statuses and link them to user accounts. 3. Data Submission with Unique Tracking Number Generation: • Allow users to upload documents and generate a unique tracking number for each submission. 4. Status Tracking Interface for Clients: • Provide a page where users can enter their tracking number and view the current status of their submission. 5. Admin Dashboard for Managing Data Statuses: • Enable administrators to log in, view submissions, update their statuses, and manage payments. 6. What...

I'm seeking a skilled programmer with experience in Moodle and JavaScript to develop a simple yet crucial feature for our Moodle platform. The task involves writing JavaScript code to enable audio file submissions within a Moodle 'ASSIGNMENT' that will be transcribed by the ChatGPT API. Key Responsibilities: - Write JavaScript code to facilitate audio file submissions. - Implement the integration of the ChatGPT API for audio transcription. - Ensure the transcript is displayed within the Moodle assignment. Key Requirements: - Proficiency in JavaScript programming. - Prior experience with Moodle, understanding of its architecture, including the ability to create Javascript for Moodle. - Familiarity with API integrations, preferably ChatGPT or similar. - Strong ...

...handle large data processing in a timely manner - Implementing efficient resource utilization strategies - Validating the performance of the cluster with real-world workloads The ideal candidate for this role should have: - Proven experience in configuring Cyclecloud HPC clusters - A strong understanding of machine learning and simulation requirements - The ability to optimize resource utilization and improve scalability - Excellent communication and problem-solving skills read the specs: What I would like to do is to set up a Cyclecloud cluster with four partitions to begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. ...

If you are familiar with AWS programming, this should be a simple task for you. I have included an example C# solution using AWS Transcribe that I need to be working. Example Program: AWS Transcribe documentation: Requirements: • I will create a new AWS free account and will supply credentials. • In my AWS account, configure any IAM role/policy/user/credentials needed to run the example program. • Change the example program to accept credentials (accessKey/secretKey) as arguments passed to the executable. • Ensure that the corrected code successfully converts the speech in the audio file to text using the AWS Transcribe service. Deliverables: • All source code • Instructions

I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven track record ...

...WebSQL database to MySQL and ensure smooth data storage and retrieval. New Features to Add: - User Authentication System: Incorporate a new authentication system to enhance user privacy and security. - Game Timer: Implement a game timer to bring an additional level of challenge and excitement to the gameplay. - Animations & Interactivity: Enhance user experience with engaging animations and interactive elements. Ideal skills for this project: - Proficiency in React Native development - Experience with database management and migration - Strong knowledge of implementing user authentication systems - Expertise in creating interactive UI elements and animations - knowledge of Node.js and This is a relatively straightforward existing project for someone well-ver...

...QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience working with PHP, particularly in customizing and enhancing applications. - A ...

I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in 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.

Olá, tenho um sistema simples de gestão feito em PHP com BD em MySQL, gostaria de converter esse BD para trabalhar de forma Multi Tenant (varias empresas no mesmo banco de dados em uma unica instalação), e tambem criar um painel administrativo para ativar e desativar essas empresas.

I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface an...

... Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides for the system architecture, API interfaces, and operational procedures. Provide ongoing support and troubleshooting to ensure system stability and user satisfaction. Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps fo...

I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and React - on the server. Additionally, you'll need to install Flutter and React Native apps. The ideal candidate should have advanced understanding and practical experience in Linux system administration, server administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. --------------------------------------------------------------------------------------...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

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.