Php script xml parse load mysql database jobs
I am in need of a skilled Linux and Bash Script expert to help me with my current project. Although I haven't specified exact tasks or goals, I am seeking assistance in the following areas: - Linux installation and configuration - Bash scripting and automation - Troubleshooting and debugging I expect the successful freelancer to have a deep understanding of Linux systems and be proficient in Bash scripting. Your past work and experience in similar projects will be valuable. Please detail how you can assist and your approach in your application. Thank you.
I need of an experienced PHP Laravel developer to create an ecommerce website for multiple products. Though the specific features are not defined, I am looking for products to be organized by category. Successful freelancers should include past work in their application. The ideal candidate should have: - Proven experience in ecommerce website development - Expertise in PHP and Laravel - Strong understanding of product categorization - A good understanding of UX/UI for ecommerce applications Please send references and previous work for review. I need below features.
Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...
...General System Requirements - **Security** - Implement secure authentication and authorization mechanisms. - Sensitive data such as user emails and phone numbers should be encrypted. - **Performance** - The system should handle multiple users simultaneously without significant performance degradation. - **Scalability** - The system should be scalable, capable of handling an increased load of users and data entries as the platform grows. - **Usability** - The interface should be user-friendly and accessible on multiple devices, including smartphones and tablets. This structured list of requirements should be used as a foundation for the development process, ensuring all critical features are included and clearly defined for both the user and admin functionalities of...
This project is open only to individuals. Agencies need not apply. Freelanc...responsibilities and skills: - Experience in web scraping, specifically from news websites. - Knowledge of creating Python or PHP scraping scripts or using API. - Ability to deliver results fast, as the project needs to be completed ASAP. Please note that the sole requirement is to extract the body of the news articles with no need for the title, date or author. Let me know your approach and estimated timeframe for completion and budget. I give you (English only) - Google News search keywords, (possibly 500K-1M news articles) You give me - excel file with two columns (possibly split excel file based on year/month) A- URL to the news article B- article body (no photo, video or XML tags, ONLY ...
FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The ...
I'm seeking a skilled PHP Laravel developer from India to collaborate with on an hourly basis, with a rate of $5USD/hour. Key Responsibilities: - Develop robust and user-friendly applications using PHP Laravel - Ensure efficient back-end development - Manage and optimize databases Ideal Candidate: - Proven PHP Laravel development experience - Proficient in both front-end and back-end development - Strong understanding and practical experience in database management Please submit your bid with the hourly rate you are looking for and examples of your previous work.
We are looking for an experienced Word Press designer to build a one page corporate website. You can see our existing website at Key Skills Required: - Image Design and optimization capabilities – Photoshop or similar - Experience in WordPress, HTML, CSS, JavaScript, PHP, (MySQL also helpful) - Experience with major WordPress themes and plugins - Strong understanding of SEO, website performance optimization, and security best practices - Familiar with WPEngine. Once confirmed we’ll create a WPEngine account - Strong English communication with ability to jump on Zoom calls if required Ideal Candidate: - The freelancer should have previous experience in creating minimalist corporate websites and integrating a product showcase with some animation. - Knowledge in...
...for users to input their trip details and receive real-time fare estimates from both platforms. Once users have compared the fares, they should be able to seamlessly redirect to the Uber or Lyft app to book their ride. Additionally, we want to incorporate a blog and forum section to foster discussions and provide valuable information for both drivers and riders. Skills Required: Proficiency in PHP, Laravel framework, HTML, CSS, and JavaScript Experience with API integration (Uber and Lyft APIs) Strong understanding of web development and design principles Ability to create secure, scalable, and responsive web applications Excellent problem-solving and analytical skills Good communication and project management skills Responsibilities: Design and develop a user-friendly fare com...
Read first - NO auto bidding, please I am hiring a Full Stack WordPress Developer who has an intermediate experience level. in >> Full time job << I anticipate that this developer will use a variety of programming languages and technologies, including: - HTML - CSS - JavaScript - PHP - MySQL - WordPress - jQuery - Laravel The candidate should be comfortable with carrying out a range of tasks, but these will most frequently include: - Creating new and custom features from scratch - Improving or updating existing features - Debugging and fixing issues You should have a thorough understanding of each of these tasks and be committed to providing high-quality results on a consistent basis. Please only apply if you possess a strong competency in all mentioned langua...
I am in need of an editor to craft an engaging visual narrative for a true crime documentary I am working on. I already have the voice overs and script prepared, and the video is approximately 10 minutes in length. Looking for longterm relationship. Key responsibilities: - Prioritize visual storytelling above all else, ensuring each edited scene fits the narrative arc outlined in the provided script and suspense thrilling background music Ideal candidate: Prior experience.
I am pleased to present my proposal outlining information on the cost of renting an industrial area in Abu Dhabi ranging from 500sqm to 1000sqm suitable for your Crypto mining facility and the cost of electrical consumption of a 250KVA load when running 24/7 for a year. My proposal includes different real references for plot prices, and all the hidden rent fees allowing for a comprehensive comparison of prices, in addition to detailed electrical calculation to give you clear picture of the cost of the yearly electrical consumption. I am confident that this proposal meets your requirements, and I am fully prepared to address any clarifications or additional needs you may have. Thank you for considering my proposal. I eagerly anticipate the opportunity to collaborate with you. Be...
I'm looking for a skilled developer to integrate a database for our congregation into my Squarespace website. I manage a Hindu temple. Requirements: - The primary purpose of this database will be to store our congregation's contact information. This includes details such as name, email address, and phone number. - The integration should be seamless, with the database easily accessible and manageable through the Squarespace platform (maybe, more like contact information collected from our website). - Prior experience with Squarespace and developing client databases is a huge plus. - We should be able to easily send an email to targeted groups within our database. Please provide your portfolio or examples of similar projects you have completed.
...create a Roblox script for my new simulation game. Key Requirements: - The script should primarily focus on implementing engaging game mechanics for a simulation genre. - The game is designed for Player versus Environment (PvE) interactions. Ideal Skills & Experience: - Prior experience with Roblox game development is essential. - Proficiency in Lua, the scripting language used in Roblox. - Understanding of game mechanics for simulation genre. - Experience with Player versus Environment (PvE) gameplay. I'm looking for someone who can deliver a script that not only meets these requirements but can also bring innovative ideas to enhance the gameplay experience. Looking for someone to make me an Updated and improved Miners Haven Script on roblo...
...following issues: - **MySQL Configuration**: I'm encountering error messages related to MySQL. The freelancer must be able to diagnose the issue and provide an effective solution. - **SSH Troubleshooting**: There are connection issues with SSH. The hired professional should be able to identify the root cause and resolve it promptly. - **cPanel Account Missing**: Currently, some cPanel accounts are not showing. The task involves investigating and rectifying the issue. - **Service Stoppage**: Some important services have stopped working. The ideal candidate should have experience with Linux administration and be able to troubleshoot and restart these services effectively. Ideal skills and experience include: - Proficient in Linux server administration, particularl...
This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):
This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):
...payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you w...
I am looking for a skilled PHP developer to create a website that can check the validity of RDP login credentials. The website should: - Allow users to input RDP username and password - Perform a check on this data - Display the results directly on the website Key Requirements: - Create a user-friendly interface - Implement a robust RDP username & password checking system - Ensure that results are displayed accurately Ideal Skills: - Proficient in PHP - Experience working with RDP protocols - Strong understanding of web development and user interface design Please let me know your related experience and how you plan to approach this task.
I'm in need of a skilled Nginx expert to help me configure a server for my application. Some key details about the project are as follows: - I'm looking to implement Load Balancing and SSL termination for my TCP traffic. - On the UDP side, I would like to have the server configured for Streaming Media and DNS Resolving. In addition, the Nginx should be set up on a Linux-based operating system. Ideal skills for this project include: - Proficiency in Nginx configuration and management - Strong understanding of TCP and UDP protocols - Experience with Load Balancing, SSL, Streaming Media and DNS - Linux server administration I'm open to suggestions for the best approach in setting up these features, so good communication and problem-solving skills are a...
I'm seeking a skilled freelancer to create an engaging explainer video regarding my software. The primary purposes are to provide its introduction and explain its key features & benefits to our potential customers on a my given script. The ideal candidate for this project should possess: - Proficiency in animation or any suitable format for explainer videos with audio. - Previous experience in creating software or tech related explainer videos with audio. - Capacity to distill technical and complex software information into a user-friendly and easily digestible format. - Excellent storytelling skills for narrating the software benefits effectively. - Understanding of software marketing and how to appeal potential customers. The successful freelancer would turn my softwa...
I need a custom code component created for my PowerApps Canvas App. Key Requirements: - The component should decrypt static text encrypted with AES or any other simple algorithm Deadline: - I need this project completed ASAP. Ideal Skills and Experience for the Job: - Strong experience with C# programming, Java script or any language that we will use to achieve the goal - Prior experience with creating code components for PowerApps Canvas Apps. - Proficiency in encryption/decryption methods
Hi we have small web application on PHP we have face issue to save or publish some data and some table shorting please bid if you can fix this quickly
I'm on the lookout for a well-versed WordPress developer, proficient in WooCommerce and Google's PageSpeed Insights. The fundamental objective of my project is to optimize the performance of my e-commerce site selling digital products. Key Tasks Include: - Ameliorating overall performance and loading speed of Home Page - Opti...understanding of e-commerce web development. Good afternoon everyone, I have aweb page in my c panel; I have 2 themes that I want to install. to each one independently by wordpress. In addition to this, I want WooComerce to be able to be used and linked to all payment methods, in different currencies. Please take into consideration we have our added products must also be. Installed plugins. high load level by PageSpeed ​​​​Insights
convert coordinates into url using webscraping python
I'm looking for a skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the proposed so...
I need a talented scriptwriter and PowerPoint designer to create a persuasive present...presentation should: - Highlight our project's key aspects: teamwork, goal achievement, engineering skills, design abilities, strategic planning, and our efforts in marketing and securing sponsorships. - Effectively showcase our project to impress judges and potential sponsors. Given the urgency, someone available to complete the task ASAP would be ideal. Skills and experience required: - Proficiency in script writing, particularly in creating persuasive narratives. - Expert knowledge in PowerPoint, including the ability to visually represent information and data effectively. - Experience in creating presentations aimed at persuasion and promotion. - Quick turnaround time without compromis...
I'm in search of a MailWizz expert Key responsibilities: - Customizing the user interface design to improve the overall user experience and branding. - Devising a mechanism to manage debits of email credits efficiently. We simply want to add emailing credits to our customers mailbox account and we will add emaili...the account based upon the amount paid. We then simply like to debit the credits for each email sent. Very simple. If we give the mailbox user 10,000 credits and they emails 3,000 emails the 3,000 is debited from the 10,000 balance and 7,000 credits are left. We have already configured Mail Wizz with Postfix MTA We own our servers and we wish to integrate the emailing server with our MySQL database. This is the first of many jobs that we will requ...
...improve my website, KEEP IN MIND THAT THE IDEA IS TO IMPROVE THE MOBILE WEBSITE (NOT THE DESK) Our primary goal is to optimize the site's core vitals in 5 out of 6 Core Vitals test. Key Requirements: - Page load speed optimization - Mobile responsiveness enhancement - Core Vitals performance improvement The ideal candidate for this project will have: - Prior experience in website optimization - A strong understanding of Core Web Vitals metrics - Proven ability to enhance mobile responsiveness - Experience in page load speed optimization Your role will be to thoroughly analyze the website and provide a detailed optimization plan. You should then implement the necessary changes to meet the core vitals requirements. A successful outcome will not only improve
I am looking for a skilled developer to create a Windows-based ...developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL...
I need a skilled full-stack PHP developer with expertise in core PHP. The project is of a small scale, consisting of a few pages and features. Key requirements for the role include: - Proficient knowledge in core PHP - Experience in Database Management and APIs is crucial - Attention to detail and commitment to deadline - Good communication skills The candidate should demonstrate enthusiasm, initiative, and a hard-working approach to any challenge given. I look forward to working with you.
I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.
Description: The objective of this project is to develop a PHP application that enables sending messages to customers via the WhatsApp platform using the official WhatsApp Business API. This application will be useful for effective communication with customers, sending notifications, order confirmations, appointment reminders, among other relevant messages for the business. Key Features: Authentication and Authorization: Implement a secure authentication system to protect access to the application and ensure that only authorized users can send messages via the WhatsApp API. Integration with WhatsApp API: Utilize the official WhatsApp Business API to send text messages, images, files, and other supported content types. Contact Management: Develop a system to manage the list of cus...
I'm in need of a skilled PHP/MySQL programmer to help me resolve issues with my legacy application. While the data in the current database isn't critical and can be easily recreated, the system is currently not allowing the addition or update of database records, although deletion is possible. Key requirements and responsibilities: - The main issue is resolving the problem of not being able to add or update database records. - There are no error messages displayed, so a deep understanding of PHP and MySQL is needed to identify and solve the root problem. - Once the issue is resolved, the next step would be to optimize the application to prevent similar issues in the future. Ideal skills: - Proficient in PHP and MySQL...
I need a PHP expert to integrate PayPal into my website for one-time payments. The system should ideally support multiple international currencies. Key requirements: - Integration with PayPal: The freelancer should have extensive experience with integrating PayPal into websites. - PHP expertise: The project requires a solid understanding of PHP to ensure the integration is smooth and effective. - International currency support: The ideal candidate will have experience in configuring PayPal to support multiple international currencies, as this is a key requirement for the project. Please share your relevant experience and a clear plan on how you intend to approach this project.
I need a script that can bypass security measures on my website which uses Cloudflare. This is not for any malicious intent, but for testing and troubleshooting purposes. Key Points: - The script should be specifically designed for websites - The main purpose is to bypass Cloudflare security measures - I didn't specify the customization level, as I'm open to options that might suit my needs better Ideal Skills: - Familiarity with Cloudflare security measures and how to bypass them - Ability to create a script that can seamlessly integrate with any website - Experience working with security testing tools or scripts Please provide a proposal that outlines your experience in this area and how you plan to approach this particular project.
I'm seeking a competent web developer to create a personal blog site specifically designed to host video content. You will be responsible for enabling the site to host videos, ensuring optimal...developer to create a personal blog site specifically designed to host video content. You will be responsible for enabling the site to host videos, ensuring optimal playback, and creating an appealing yet user-friendly interface. Ideal skills include: - Proven experience in HTML/CSS - Understanding of video hosting and embedding - Experience in designing user-friendly websites - Knowledge of website load optimization strategies, particularly relating to video content. Looking forward to work with freelancers who are committed to creating a high-quality, functional, and visually appea...
**Project Description: Laravel Developer for E-commerce Website** We are seeking a skilled Laravel developer to collaborate on a project to build a single e-commerce website for a bags shop. The primary responsibilities include database management, backend development, API integration, and connecting the frontend to the backend. The project requires connecting Razorpay as the payment gateway and Shiprocket as the delivery partner. The frontend design will be provided as custom HTML, CSS, and JavaScript. **Responsibilities:** 1. Implement database architecture and management using Laravel's ORM. 2. Develop backend functionality to support the e-commerce website's operations, including user authentication, product management, order processing, and more. 3. Integrate...
I'm seeking a talented script writer to develop a script for a desktop application focused on content management. Key Points: - The script should be engaging and compelling. It has to be tailored for desktop applications, keeping in mind the medium's characteristics and audience. - The target software is a Content Management System (CMS), hence the script should be easy to understand and navigate for users who are managing content. - The script has to be designed for software, not a movie or a play. This means it needs to be technically detailed and efficient for users. Ideal Skills and Experience: - Prior experience in script writing in the software industry, especially for desktop applications. - Understanding of Content Management S...
I am currently looking to significantly boost the speed of my website, primarily focusing on the home page and product pages, which at prese...rankings. Your task would be to identify, prioritize, and optimize the slowest elements of the specified website pages to improve the overall performance. Relevant experience in website speed diagnostics and relevant tools and techniques for speed optimization will be considered a plus. My website is earphoneguy.com. I am looking for specific tasks that can be verified and completed to increase the load times of my site. I have no problem doing work, I just need a little help and guidance. I am looking for someone who speaks fluent English. When placing your bid, auto-bids will be deleted. The more personal your bid is, the better chance...
...perspective correction script which is currently struggling with shapes that have more than 4 points. I have a Python script that does perspective correction of the images. It works in cases where the shape has 4 corners. If a shape has more than 4 corners, the script will not work. Please see attached and The script obviously fails on the "L" shapes. The has the expected result simulated. Attached is a zipped folder with everything you need to start. To run a script, use this command {filename} Example The "source" folder has various source images that have working and non-working cases. I need a solution that will work in most "non-working" cases. This script also has a function that
I'm looking for a skilled web developer to revamp my current website, which is built on WordPress and Elementor free versio...first about 8 fields. - File upload capability: Users should be able to upload documents, images, and videos Skills and Experience: - Proficiency in WordPress and Elementor - Strong knowledge of web design and user interface principles - Experience in implementing user registration and form functions - Familiarity with secure data handling and processing Would like custom script work so I"m not paying monthly/annual script fees. This project would suit a developer with a strong background in web design, user registration, and file upload capabilities, who can deliver a secure and user-friendly solution that also include good seo skills. Cu...
I'm in need of a skilled freelancer to integrate a custom payment gateway into our Farmart Cart softw...cc_allowed and the answer would be y or n. Upon the options in the checkout if cc not allowed then this option won’t be available to the customer. You will do the above mentioned functionality and pages and popups if need be. There will also need to be a way to test this functionality before it goes live to the public. This project is only for one individual (no agencies) that currently has no work load and can complete this project within 48 hours of starting. All funds will be released once verified code is working on our server. Download the code and MAKE SURE you are able to complete this project before you send a message. Thank you for looking, please message ...
I'm looking for an experienced developer to enhance the functionality of my website/game which is built on the Nginx platform. Key requirements include: - Scripting: I need new features integrated into the current setup to make it more engaging and useful for users. - Platform Expertise: You should be well-versed in Nginx and skilled in enhancing the functionality of websites or games built on this platform. Ideal skills and experience for this job include: - Proficiency in Nginx and server-side scripting - Prior experience in integrating new features into websites/games - Strong problem-solving skills to suggest and implement improvements for the existing setup - Ability to work with the existing codebase and not disrupt the current functionality while enhancing it - Excel...
Specification: Facebook-Web-Scraping and Web-Crawling Write Swift Code that prompts the user to give username and password This information is used to login to facebook and scrape facebook for facebook friends and extract the following information: - Name - Birthday and month and if available year - Gender This information should be made available in a JSON or XML format. The code will be embedded in an app. It is important that this web-scraping activity can run in the background of the app invisible to the user.
I'm in need of an experienced PHP and Wordpress developer to assist with ecommerce website, theme customization, plugin development, and additional tasks relating to Inventory management and Sales tracking. We are embarking on an exciting project to develop an ecommerce website for health products using WordPress, and we need a proficient PHP and WordPress developer who can take on a range of tasks for our ecommerce project. Responsibilities will include: Mastering PHP Coding: Proficiency in PHP coding is essential for customizing and extending WordPress functionality to meet our specific requirements. Customizing WordPress Themes: We require expertise in customizing WordPress themes to ensure they align with our branding and design preferences while m...
I'm seeking a skilled developer who ...main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowledge of the latest design trends and how to selectively prune menus for user-frie...
I'm in need of a highly creative, humorous writer to draft a script for my YouTube video focusing on video games. We're aiming particularly at the teen audience and our video will embrace facets of comedy and fun edits. Key aspects to consider: - Excellent understanding of video games, especially those popular among teens. - Ability to effectively incorporate humor and create engaging content. - Experience with video editing could also be advantageous to understand the intended fun edits. - Proficiency in English language and script writing. I look forward to your imaginative, amusing and youth-focused pitches.
I need an experienced PowerShell developer to create a script that logs me into , downloads today's menu, and displays it on a window. Requirements: - The script should log in to bosch.aramark.cz. - After logging in, it should download today's menu. - The menu should be displayed in a window. - The menu display should be in the format: "Number of menu : Text of menu" with each number on a separate line and menu text following it. - The menu number should be displayed before the text. Ideal Skillset: - Proficient in PowerShell scripting. - Familiarity with web scraping is preferred. - Good understanding of GUI development. - Experience in parsing and displaying structured data is a plus. Please ensure the script is user-friendly and efficient. A ...
I need a new PHP coder I need some easy projects coding at low budget I need work for long term