Php loop thru mysql field jobs
I'm looking for an expert who can migrate my existing WordPress website to PHP. The reasons for this migration are multifaceted: - **SEO Performance**: I want the new PHP site to be more SEO-friendly than the WordPress version. - **Speed and Performance**: The PHP site should load faster and handle traffic better than its predecessor. - **Customization and Control**: PHP offers more flexibility, so I want to leverage that for a more tailored website. While I do not have specific SEO goals at this moment, the new site should be built with the potential for higher search engine rankings, better keyword targeting, and improved mobile optimization in mind. Please note that I want to keep the core design and layout of the WordPress site, but with some minor d...
In ASTPP version 6.0, after fail and restart of MySQL, sip profile does not start. From fs_cli, it shows the following error: [ERR] switch_core_db.c:106 SQL ERR [database disk image is malformed] [ERR] switch_core_db.c:246 SQL ERR [database disk image is malformed] [CRIT] switch_core_sqldb.c:645 Failure to connect to CORE_DB sofia_reg_default! [CRIT] sofia.c:3165 Cannot Open SQL Database [default]! The project is to correct the error, so that when the sip profile is started or reloaded from https interface, customers can connect using phone number and password and server name. Freelancer must document each step done from the command line of the server to correct the error with small description for each step, so that anyone can take the doc and follow the procedure in case of the...
...Implementation: This is the most crucial aspect of the project. The ideal candidate should have extensive experience in implementing automation in web applications. - DevOps Pipeline: Experience with setting up a seamless DevOps pipeline is a must. The candidate should be able to integrate the application into a well-functioning DevOps pipeline. - Database Integration: The application will require MySQL for its database. Tasks will involve application development, so proficiency in schema design, data migration, and performance optimization is key. - Ansible Playbook & GitHub: The candidate should be adept in using Ansible playbook for automation and GitHub for version control. The ideal freelancer for this project will be skilled in Perl and Python, with a strong backgro...
I'm looking for an expert in chemical engineering or a PhD in bio pesticides to help me create a concentrated liquid bio organic fertilizer specifically for my chilli crop. This formula should also help to combat various fungal, viral, and bacterial diseases that typically afflict chilli plants. Key Responsibi...Phytophthora leaf blight, Choanephora blight - Viral: Chilli veinal mottle virus (ChiVMV), Tobacco mosaic virus (TMV), Pepper mild mottle virus (PMMoV), Leaf curl virus, Begomovirus, Potyvirus, Tospovirus - Design a liquid soil conditioner formula The ideal candidate for this project should have a strong background in chemical engineering with a specialization in bio pesticides. A PhD in the field would be highly advantageous. Please provide samples of previous wor...
I'm seeking a proficient developer to create a comprehensive visitor management system using PHP and MySQL. The system should encapsulate the following key functionalities: - Visitor Check-in/Check-out: The system should efficiently track the check-in and check-out processes of each visitor. - Pre-registration of Visitors: Visitors should have the ability to pre-register. Upon doing so, an appointment ID should be generated for them. - Email Reporting: An automatic email report detailing the day's visitors should be sent to the admin department's email. - Appointment Booking: The system should facilitate appointment bookings for visitors. - Dashboard Creation: A user-friendly dashboard needs to be created which highlights total visitings for the day, and promi...
I'm looking to develop a Flutter field app integrated with a Laravel backend. The app's primary functionality will be GPS tracking, so it needs to be able to monitor locations in real-time and optimize routes. Key Features: - GPS Tracking: The core functionality of the app. - Real-Time Location Updates: The app should be able to provide live updates on the location. - Route Optimization: The app needs to have the ability to optimize routes based on the real-time data. Ideal Skills and Experience: - Proficient in Flutter for app development. - Extensive experience with Laravel for backend development. - Previous experience developing GPS tracking apps will be a plus. - Strong understanding of route optimization algorithms.
...professionals familiar with the Saudi legal and regulatory framework, preferably those with experience handling business registration for foreign investors. Candidates should be well-versed in Ministry of Investment (MISA) and Ministry of Commerce procedures. Please provide a quote for trade name reservation first, followed by estimates for the remaining steps. If you have experience in this field and can offer practical, step-by-step guidance, please submit your proposal detailing your expertise, past work, and estimated timeline for completion....
I'm looking for an experienced backend developer specializing in Node.js to build a RESTful API for my project. The scope of the project includes: - Implementing both authentication and authorization mechanisms to secure the API. - Utilizing a SQL database, preferably MySQL or PostgreSQL, to store and manage data. Ideal candidates should have a robust understanding of Node.js, RESTful API development, and SQL databases. Experience with implementing security measures in API development is a must. Please include relevant samples of your work in your proposal.
I need my ReactJS, NodeJS and MySQL project deployed on Railway.app. The deployment should also provide a test URL for live testing. Ideal skills for the job: - Proficient in ReactJS, NodeJS, and MySQL - Experienced with - Able to set up and configure necessary settings for deployment
I'm looking for a skilled web developer to create a modern, minimalistic portfolio website for me using PHP and React. Key Features: - The site should include a contact form for inquiries. - A section for client testimonials. Design Preferences: - The overall aesthetic should be clean and simple, in line with a modern and minimalistic theme. Ideal Skills: - Proficient in PHP and React. - Experience in designing modern, minimalistic websites. - Ability to implement interactive features like contact forms and testimonial sections. Needs to design admin dashboard and client's dashboard
We need a developers for React Projects with Complete API Implementations on Project with Backend of PHP or Node Js. Have experiance to Upload website on AWS and Have expertise in problem solving , data base should be Mongo DB or My SQL . Experiance required - 3+ Years Project time -Limited Proposal required on Hourly Basis or Project Basis or monthly Basis More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? Within a month
...background in financial consolidation, reporting, and planning, along with expertise in these platforms, we want to hear from you! **What We’re Looking For:** - **Expertise:** Proven experience working with OneStream, Hyperion, or Essbase, with a deep understanding of their functionalities and applications in financial processes. - **Education:** A degree in Finance, Accounting, or a related field. - **Skills:** Strong analytical and problem-solving abilities, with a focus on delivering accurate and efficient financial solutions. - **Experience:** A solid track record of implementing, maintaining, or optimizing financial consolidation, reporting, and planning systems. **Key Responsibilities:** - Design, develop, and maintain financial models and reports usin...
...enhancement by achieving a 20% scalability boost with innovative features in Iot tool. • Applied agile principles, enhancing decision-making in IoT solutions, boosting satisfaction ,streamlining operations. • Fortified Atoll Kinesis with innovative security measures, ensuring data integrity,thwarting potential vulnerabilities Data scientist | AntWalk • Maintained client's e-commerce site using HTML, MySQL, CSS, and JavaScript in backend support • Accomplished significant 14% reduction in operational costs by conducting a analysis of transportation data • Conducted QA tests, proposing 5 fixes under team supervision, ultimately enhancing overall software quality. [Jun 22 – july22] PROJECTS Railway Management System [Aug 21 - Dec 21] • Develo...
Good for beginers. low budget : 15$ for whole project. PHP based, to be hosted on : Key Features: - Multiple quiz formats: The app needs to support various types of questions: multiple choice, true/false, short answer, and blanks. - User-friendly interface: As the main audience is students, the design should be intuitive and engaging to cater to this demographic. - Students and Tutor profiles. - Google login - progress monitor (each student compared to overall as well as, progerss monitor for the course ) -progress monitor should include time and scores. - Selection : course, subject, chapters, topic - Selection :free & premium quizz, where the later is based on approvals. -Practice vs Test mode: Practice should have Hint , Revison, mark as imp, mark as wrong
I need a skilled Java Spring Boot developer for creating a REST API service. This application will primarily manage product data. Bangalore or Hyderabad based are preferred Key Features: - Implementing Authentication to secure the API - Conducting Data validation to ensure data integrity - Enabling CRUD operations for full data management - MySql data base handling from Java and respond to Web and Mobile applications using APIs Ideal Skills: - Extensive experience with Java Spring Boot - Proficient in designing and developing REST API services - Strong understanding of implementing Authentication and Data Validation - Skilled in CRUD operations - Experience working with product data
I'm seeking a skilled PHP developer to create a modern, sleek portfolio website for me. Key Requirements: - Extensive experience in PHP and web development. - Strong understanding of modern web design principles. - Ability to create a clean, user-friendly interface. - Prior experience developing portfolio websites would be a plus. Please include examples of your previous work, particularly any portfolio sites you've developed, in your proposal. I'm excited to see what you can create!
I'm looking for a skilled PHP developer to create a comprehensive online portfolio website for me. The site will feature a variety of content types, including: - Images and videos - Text and articles - Code repositories and demos In addition to showcasing my work, the site will need to facilitate user interaction. This will primarily be through comments or contact forms, so experience with implementing user interfaces and handling backend requests is essential. Ideal skills for the job include: - Proficiency in PHP and web development - Experience with interactive website development - Ability to integrate diverse content types - Knowledge of handling user inputs and comments The primary focus of this project is to create an engaging, interactive platform that effec...
I need someone with expertise in accounting and finance to create a portfolio in this field. Creating example projects and all.
We are seeking a skilled developer to create an application that manages audio playback across multiple AirPlay speakers on a network. T...to: - Create groups of airplay speakers - Send different audio streams to each group (it may be that multiple groups have the same source, and all should be synchronised playout) - Control volume and mute of each speaker and also the volume of each group. - start/stop the stream to each group - integration with bitfocus companion - The different audio streams source could be a specific mp3 file in loop, or a web browser page (for example), but all in the same pc/mac The ideal candidate should have experience with audio streaming technologies and a solid understanding of network protocols. Your expertise will help us enhance our audio systems ef...
I'm looking to hire a CodeIgniter developer with a minimum of 2 years of experience to work on our project. The ideal candidate should have strong expertise in PHP, MySQL, and CodeIgniter framework, along with a good understanding of front-end technologies. Skills & Experience: - Minimum 2 years working with CodeIgniter - Strong PHP and MySQL skills - Good understanding of front-end technologies - Experience in web application development - Familiarity with content management systems
...you should know that my keycloak is on private key not public and the authentication should be done via back end. this has to be done last part of the project. note: if you dont have active directory you can work on my local server but you will work via remote you will work on my test server after completion of the project you have to deploy this on production. Im using nginx and db has to be mysql...
I'm seeking a proficient C# programmer with robust audio programming experience to develop a beat player (see image) as part of an app (Windows and Mac) for songwriters. The beat player will play back sampled drum sounds in a loop, with the rhythm chosen by the user. It will have 12 different beats. Key Requirements: - A deep understanding of C# with a focus on audio programming. - Experience in cross-platform application development specifically for Windows and Mac. - Prior experience in audio application development is a significant plus. The application will not include user accounts, real-time notifications, or data synchronization features. However, the ideal candidate will be able to deliver a seamless, efficient and user-friendly audio sample application. Please includ...
Title: Expert Academic Writer Needed for Research Paper on cybersecurity Project Description: I am seeking a professional academic writer with expertise in field, e.g., cybersecurity, to assist with writing/editing/reviewing a research paper. The ideal candidate should have experience in academic research, strong writing skills, and proficiency in [APA/IEEE/MLA] citation styles. Scope of Work: Conduct a thorough literature review . Ensure clarity, structure, and logical flow of arguments. Edit and refine the paper for grammar, coherence, and academic rigor. Properly format citations and references according to APA/IEEE/MLA guidelines. Provide feedback and incorporate necessary revisions. Requirements: Proven experience in academic writing and research. Strong background in cybers...
I'm looking for a proficient Tableau expert to help me create a Coxcomb chart for an internal report. The data is sourced from a CSV file and the primary focus is to highlight the percentage of areas corresponding to specific results. I want it to resemble a baseball field Key Requirements: - Proficiency in Tableau and experience with Coxcomb charts - Ability to work with CSV data files - Understanding of how to visually represent data for internal reporting purposes The ideal freelancer for this project should be able to translate complex data into a clear, concise, and visually appealing Coxcomb chart.
...up, and they exchange a few competitive glares. It's clear they both think they’ve got the best tractor. But instead of a typical showdown, the two farmers break into an unexpected dance-off—and yes, it's the tractors themselves doing the dancing. Each tractor comes to life with a clever animation: one tractor starts "twerking" its back wheels, the other performs a smooth "moonwalk" across the field. Tagline: "When you’ve got the right tractor, the competition doesn’t stand a chance." #TractorDanceOff Why It Works: 1. Humor: It’s light-hearted and humorous, showing that farming doesn’t always have to be so serious. The animation adds a fun and unexpected twist. 2. Relatability: Queensland farmers will lik...
I need a professional web developer to help me convert my current .aspx project website to PHP. The new site must be fully functional on a Linux Debian system. Key Requirements: - Extensive experience with both .aspx and PHP - Deep understanding of standard .NET frameworks, as the current site uses these - Proficient in MySQL, as this is the database system currently in use - Familiar with Linux Debian systems Please note that the functionalities of the current .aspx website were not specified, so the developer may need to reverse engineer some elements. A keen eye for detail and problem-solving skills will be essential to ensure a seamless transition.
I'm seeking a skilled developer to finalize my trading system. The project is built with Node.js, React, and MySQL, and requires expertise in these technologies. Key tasks include: - User interface development: The UI needs to be completed with a focus on real-time data display, user authentication and profiles, and a trade execution interface. - Backend integration: Connect the frontend to the backend seamlessly. - Database setup and management: Ensure the MySQL database is properly configured and managed. The user interface will need to incorporate: - Real-time data display: The UI should be able to showcase live market data. - User authentication and profiles: Implement a secure and efficient user login and profile system. - Trade execution interface: A clear and f...
I need a professional who can configure an AWS MSK Connector to capture both Insert and Update data from my MySQL RDS 8.0 and write it into a single MSK topic per table using Debezium. Key requirements: - Set up an effective data capture system that captures both Inserts and Updates from the MySQL RDS. - Utilize a single MSK topic for each table. - Provide assistance to fully set up my partially configured MSK. - Implement the Debezium connector to facilitate the data transfer. Ideal skills and experience: - Proven experience with AWS MSK and MySQL RDS. - Hands-on experience with Debezium connector. - Previous project work with configuring MSK and data capture systems. - Excellent troubleshooting skills to assist with the partial setup.
...deleted WhatsApp chats from my iPhone. The chats I need to recover are specific conversations, not all chats. My phone is regularly backed up on iCloud, and WhatsApp is synced on my laptop. I haven't attempted any recovery methods yet, so you're free to explore all possible options, including: - iCloud - Local backups - Forensic tools - Third-party software Please share your experience in this field and your assessment of the likelihood of a successful recovery. The ideal candidate for this project would have extensive experience with data recovery, particularly with WhatsApp and iPhone devices, and possess the right tools and software for the task. Your skills should include: - Proficiency with iCloud and local backup systems - Expertise in using forensic tools for ...
Hi, I am faving an issue in my iOS App. There is also AR/VR, so developer must have good skills in Mobile App, iOS, Swift. AR/VR. You have to resolve a bug in my iOS App developed using Swift language. I would be happy to share more details thru' chat but I want direct developer, who can be available online and check the code, run the App, fix the issue and work with me. Revise as many times as i want till the issue is resolved. Please no beginner, as it is time sensitive project, so i have to get this issue resolved immediately.
I'm seeking an expert editor with medical knowledge. Your primary task will be refining journal articles for non-English speaking authors in the medical field. Key Responsibilities: - Edit and proofread medical journal articles - Enhance language, structure and content Skills & Experience Required: - Strong background in all medical specialties - Proven experience in language editing, substantive editing, and copyediting - Excellent understanding of academic publishing standards - Prior work with medical research papers is a plus Your role will be crucial in helping authors publish their research in international academic journals.
I need a PHP script that will read a JPG from a filename on disk, and upload it to various Amazon APIs - Use Amazon Rekognition to detect any adult content, and return a structure of detected objects and rating - Use Amazon Textract to identify and return any text present on the image. - Use Amazon S3 to store the image for public access, and return a public URL (with no expiration). - Add feature to PHP class to remove the image from Amazon S3 Deliverables: - PHP script to do all of the above (probably using cURL) requests, must be robust with error checking, and return a JSON structure with all relevant results from each API - Basic documentation to setup and secure the various Amazon services being used Ideal Skills: - Proficiency in PHP (no comopser b...
I need a PHP Freshdesk script modified to send bulk emails that align with Spiceworks'. Key requirements: - Edit the script to ensure the bulk emails match the format used by Spiceworks. Skills and experience: - Extensive experience with PHP and Freshdesk. - Ability to understand and replicate email formats. - Previous experience with bulk email scripts preferred.
...without page reloads. Integration with TradingView or custom charting solutions for interactive charts. Mobile-first responsive design with CSS Flexbox/Grid for layout management. Backend: Built with Node.js (Express) or Python (Django/Flask) to handle API requests, user authentication, and integration with Binance (or other CEXs) for liquidity, MoonPay, and blockchain networks. PostgreSQL/MySQL database for storing user data, transactions, and account details. Redis for session management and caching real-time market data. Security: TLS encryption for all sensitive communication. Database encryption for sensitive data at rest. Deliverables Fully functional trading platform with integrated Binance API and MoonPay for fiat purchases. Source Code in GitHub/Bitbucket with...
...full-text screening of selected articles to assess their eligibility against defined inclusion and exclusion criteria. • Collaborate with the lead researcher to resolve discrepancies in article selection. • Maintain meticulous records of decisions using the provided research management software (Covidence). Requirements • Background in health sciences, public health, social science, or a related field. • Experience in conducting or contributing to systematic/scoping reviews is highly desirable. • Familiarity with literature databases such as MEDLINE, CINAHL, PsycINFO, and Scopus. • Strong analytical skills and attention to detail. • Ability to work independently and collaboratively. • Proficiency in using reference management software and ...
I'm seeking a PHP expert to enhance the functionality of my existing payment form. The goal is to improve its overall performance and user experience. Your modifications will contribute to a more seamless transaction process. Ideal Skills: - Proficient in PHP - Experience with payment form modifications - Strong web development and UX/UI skills - Problem-solving skills for improving existing functionality
...to modify my existing CAD file for a medical device accessory that I have prototype on. This accessory is intended to more efficiently deliver oxygen. The modifications will involve: - Changing a fixed part to be interchangeable - A few adjustments involving standard shelf items The ideal freelancer for this project should have a strong background in CAD design, preferably within the medical field. Experience with 3D printing is also essential as the modified design will need to be printed. I require a professional who can pay meticulous attention to detail and deliver high-quality work. Key requirements: - CAD design - Medical device design experience - 3D printing knowledge - Detail-oriented The modifications will involve: - Changing a part to be interchangeable - A few adj...
Project Title: Economist Expert Opinion Letter for EB-2 NIW Petition Description: I am seeking a qualified economist to provide an expert opinion letter in support of my EB-2 NIW (National Interest Waiver) petition. The letter should meet the following criteria: Purpose: The letter will serve as a key document to demonstrate my qualifications and contributions in my field, supporting my EB-2 NIW petition. Content Requirements: Comprehensive and well-researched. Directly related to my expertise in Apparel and Textile Industry Demonstrates my significant contributions and their national importance. Includes references to relevant published material or data to strengthen the case. Expert Credentials: The writer must hold a degree in economics and have experience drafting expert opinion...
...environments. Monitoring Requirements Host-Level Metrics Ping and availability CPU usage (load averages, per-core utilization) Memory usage (RAM, swap) Disk activity (IOPS, free space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Service uptime Service-Level Metrics Web services (HTTP/HTTPS status, performance, visitor statistics) Database performance (MySQL/MariaDB with query statistics) Mail servers (queues, processed/deferred emails, etc.) DNS server health FTP server status cPanel/DirectAdmin-specific service metrics Backup monitoring (jetbackup) Website monitoring Security and Logs User login activity Firewall rule statistics System and error log monitoring Mail log monitoring Apache log analysis Deliverables A fully configure...
...Interface: Clear navigation and instructions for both admin and users. 8. Security: Secure link generation to prevent unauthorized access. Optional: Add password protection for specific files. Technical Requirements: Use Python (preferred) with Telegram Bot API or a suitable framework like Pyrogram or Telethon. Database for storing file data, links, and user information (e.g., PostgreSQL, MySQL, or MongoDB). Hosting recommendation (e.g., VPS, Heroku, or AWS) to ensure scalability and reliability. Deliverables: 1. Fully functional bot with all features implemented. 2. Clear documentation for setting up, managing, and maintaining the bot. 3. Source code and database structure. If you have additional ideas or suggestions to improve the bot, feel free to includ...
I need a systematic review focusing on the CARDIOLOGY field, specifically assessing health intervention outcomes. Your primary task will be to include and analyze qualitative studies. Ideal Skills and Experience: - Expertise in healthcare research - Proficient in conducting systematic reviews - Experienced in analyzing qualitative studies - Strong understanding of health intervention assessments
ALERT: I am looking for who can be futuristic and flexible with pay. If you are looking for money in end of this month this is not YOURS PLEASE DON'T BET. I WANT TEAM WHO ARE OKAY WITH NO PAY AT END OF THIS MONTH BUT I CAN ASSURE YOU GREAT PAY AT END. I need courageous talentful persons who can be my bros and sisters. I'm looking for a group of professionals with expertise in marketing...Capability in business analysis - Specific Responsibilities: - Implement data-driven marketing strategies - Conduct comprehensive market trend analyses - Develop brand strategies that resonate with target audiences Your expertise will be instrumental in driving growth and success for these startups. Please, only apply if you have a passion for startups and a proven track record in the mar...
I'm looking for an experienced Roblox game developer to create a simulator game for me. This game will be set in a fantasy environment, with new worlds that unlock as the player progresses. Key Features of the Game: - Repetitive Gameplay: The game is designed to be repetitive, with the core loop being fighting monsters to earn coins. - Unlocking Characters: Players will use in-game coins to purchase different and better characters in each new world. - Fantasy Combat: All characters will use magic in combat, so the game will require a creative and engaging approach to magical combat mechanics. Ideal Skills and Experience: - Extensive experience in Roblox game development - Strong understanding of game design principles, especially for simulator games - Creative thinking to des...
...membership plans with exclusive content and features. • Easy in-app purchases for subscriptions. Technology Requirements: • Mobile Development: Native iOS (Swift) and Android (Kotlin) apps or cross-platform frameworks like Flutter/React Native. • API Integration: Ensure seamless communication between the app and the web backend. • Database Management: Use a scalable database (e.g., Firebase, MySQL) to handle real-time data sync. • Push Notifications: Integration of Firebase Cloud Messaging (FCM) or other push services. • Wearables Integration: Apple HealthKit, Google Fit API, and third-party wearable SDKs. Deliverables: 1. Fully functioning iOS and Android apps (ready for submission to App Store and Google Play). 2. Documentation for the we...
I'm seeking a professional clothing designer to create 5 variations of an existing T-shirt design. The variations should incorporate different graphics or logos, all of which I will provide. I'm looking for someone with experience in this field who can offer a competitive price. Your expertise will be invaluable in transforming these designs into unique and appealing variations.
...to meet program deadlines. To Apply: Please submit the following: • Your current CV, highlighting relevant experience. • A sample of your grant writing, preferably an SBIR-related document or similar technical writing in the biomedical field. Preferred Qualifications: • Knowledge of innovative wearable health technologies, or wellness products. • Familiar with signal processing of autonomic variables especially extracting ‘neural’ components embedded in heart rate variability. Have a general understanding of the autonomic nervous system as a feedback loop regulating autonomic state. • Experience working with startups or small businesses in the MedTech or health-tech sectors. If you have the expertise and drive to contribute to a...
...should effectively showcase our cyber security services in a clear and engaging manner. - Logo Design: The logo should be modern and sleek, reflecting the contemporary and cutting-edge nature of our services. - Presentation: This should cover our service offerings, include customer testimonials to build trust and credibility, and feature case studies to demonstrate our success and expertise in the field. The ideal freelancer for this project should have experience in service catalog creation, logo design, and presentation development. They should have a strong understanding of the cyber security industry and be able to translate our service offerings into engaging and accessible content. A modern and sleek design aesthetic is crucial, and experience with creating compelling cust...
I'm in need of a skilled PHP Laravel developer to help me with some design issues on my website. There are certain things I want to remove and some new functionalities I need to add on the homepage.
...should effectively showcase our cyber security services in a clear and engaging manner. - Logo Design: The logo should be modern and sleek, reflecting the contemporary and cutting-edge nature of our services. - Presentation: This should cover our service offerings, include customer testimonials to build trust and credibility, and feature case studies to demonstrate our success and expertise in the field. The ideal freelancer for this project should have experience in service catalog creation, logo design, and presentation development. They should have a strong understanding of the cyber security industry and be able to translate our service offerings into engaging and accessible content. A modern and sleek design aesthetic is crucial, and experience with creating compelling cust...