How to join two tables in mysql using php with example jobs

...designer to help us seamlessly integrate our brand identity into a pre-existing website template we have purchased. This project involves implementing our brand colors, fonts, and visual elements to create a cohesive and compelling design. Project Overview: • Objective: To incorporate our brand identity into an existing website template with minimal changes, ensuring a simple and efficient development process. • Scope: The project will include updating page colors, fonts, and images to reflect our brand. The template will remain largely unchanged to maintain development simplicity. • Deliverables: A visually appealing website that aligns with our brand identity, using both vector and image overlays where appropriate...

We are seeking a talented and creative individual to join our team and work on our mobile app designed for medical professionals. We need someone who can think outside the box, develop innovative marketing strategies, and help build and enhance our brand.

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

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

I'm in need of an experienced Node.js backend developer who can build a robust REST API. The ideal candidate should be proficient in MySQL, and have experience in user authentication, data retrieval, and data modification. Key Requirements: - Develop User Authentication: The API should include secure user authentication functionality. - Implement Data Retrieval: The API must be able to retrieve data from MySQL database as needed. - Data Modification Capability: The API should also support updating and deleting data in the database. Additional Needs: - Third-Party Integrations: The API will need to integrate with a payment processing system and also be able to send WhatsApp messages. If you have a strong backgrou...

I am seeking an experienced engineer who can assist me in the design and analysis of a new project. Ideal skills and experience for the job: - Proficiency in AutoCAD for design and analysis - Strong background in engineering, particularly in the area of design and analysis - Excellent problem-solving skills - Ability to work closely with me to understand my vision for the project and bring it to life

I need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as w...

I'm looking for a talented freelancer to help me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly ...

I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a...

Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501

I am in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tracking: I require a system that will consistently track and update inventory in real-time to ensure accuracy. Other Details: - Products: As a small warehouse, I have less than 50 different types of products. - User Access: The app will not need to support multiple users accessing and updating the inventory simultaneously. Ideal Skills: - Proficient in AppSheet development - Experience in building inventory tracking systems Please respond with your relevant experience and sample work for further consideration.

Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PD...

Seeking a talented writer with a knack for penning engaging, informal biography-style content. What's Required: - Composition of a casual, yet captivating account of a detailed personal history. This biography should be comprehensive, drawing on key life moments to create a rich tapestry of the subject's life. Ideal Skills & Experience: - Previous experience writing memoirs or biographies - Ability to write informally while maintaining the depth and credibility inherent to the genre - Mastery in vividly depicting scenes to make the story more alive and engaging Join us in conducting an intriguing journey through the past, mapping out a detailed personal history in an easy-going informal style. It's no...

I'm in need of a skilled OpenCV programmer to help me with a bug in my WhatsApp automation script. Here's what you need to know: - The specific issue is that the automation isn't starting as expected. - The script is written in Node.js. - I haven't been able to locate any error messages or logs that might be related to the issue. You should ideally have experience with: - WhatsApp automation - Node.js - OpenCV Your task will be to identify the root cause of the automation failing to start and rectify it.

...Native Spanish Translator to join our dynamic remote team. The ideal candidate will possess an excellent command of both Spanish and English, with extensive experience in translation and document editing. **Responsibilities:** - Translate a variety of documents from English to Spanish and vice versa while maintaining the content, context, and style of the original material. - Convert PDF documents into editable Word formats, ensuring that the layout and formatting are preserved. - Edit and format Word documents to meet specific client requirements. - Ensure translated documents meet the quality standards and timelines set by clients. **Requirements:** - Must be a native speaker of Spanish with an excellent command of English. - Proven e...

I'm seeking a skilled individual to assist in increasing my Telegram member count. The main goal of this promotion is to attract Crypto Enthusiasts to my channel. Key Requirements: - Experience and success in increasing member counts for Telegram channels. - A good understanding of the crypto market and community. - Ability to personalize direct messages based on the recipient's interests. - Strategies for engaging with potential members in a non-intrusive way. Your main tasks will include: 1. Identifying and reaching out to potential members within the cryptocurrency community. 2. Engaging with these individuals through personalized direct messages. 3. Encouraging them to join our Telegram chan...

I have project developer and just installed but i need to configure a virtual machine in order to keep confidence to install and edit for the future the backend and frontend. I have just a guide to install but is very high level guide and I'm to able to install the system. The goal of this project is: - Install on virtual machine Backend php, Fronend php and create a guide step by step to allow me to install in the future myself.

I need a talented full-stack developer with experience in PHP and MySQL. You'll be designing and creating a platform that supports 360-degree videos, similar to YouTube. Deployment in the cloud will also be required. Key Responsibilities: - Develop the front-end and back-end of the platform. - Design the platform's layout (the design concept is yet to be decided). - Enable 360-degree video support. - Implement features for video uploading, sharing, and rating. - Enable user account and profile creation. - Include a commenting system. Ideal Skills and Experience: - Proficient in PHP and MySQL. - Experience with cloud-based deployment. - Good understanding of user-friendly design concepts. - Familiar ...

I'm in search of a skilled Python PHP developer with experience in backend development. If you have a good grasp of Python and backend systems, this project is for you. Essential skills and experience: - Proficiency in Python PHP - Proficiency in Firebase MySQL - Experience in developing real-time features like live chat and notifications Ideal candidates will have: - Strong communication skills - Experience in developing and maintaining a reliable backend system - A keen eye for detail and the ability to troubleshoot and solve problems quickly If you think you're a good fit for this project, please get in touch. I'm excited to see what you can bring to the table.

I'm looking for Shopify store owners to install and test two Shopify apps. This project entails the following: - Installing and testing two Shopify apps. - Providing comprehensive feedback on the apps based on usability, performance, features, and overall experience. - The chosen apps should heavily emphasize social media promotion features. The ideal freelancer for this project should: - Have a good understanding of Shopify and its app ecosystem. - Be experienced in using and evaluating marketing apps. - Be able to provide detailed and constructive feedback. - Have a keen eye for user experience and app performance.

...interior designer to bring my modern design concept to life through a high-quality rendering for linked bridge whose walls are approximately 400 meters long, approximately 8 meters wide and approximately 4 meters high. Its walls are glass and cladding, and it also has escalators. Key Requirements: - Visualize the Design: I need the freelancer to translate my design into a visually appealing and realistic 3D model. This will help me understand how the final space will look. - Client Presentation: The rendering should be of a quality that I can use it to present my design to clients. It should be professional, detailed, and showcase the key elements of the design concept. - Interior design rendering with pictures of the floors in...

...hosted and the site is complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connectio...

v2 - user can find merchant and register in their user account. after admin approve, Merchant can create shop and promotion. User will get 0.1% of their total sales, check v3. - shop field (brand name, address, website, whtasapp, facebook, description, category, City, how many brands, open for agency?(radio button)) - promotion field (title, normal price, now selling price, description, expire date, point weight - V4 user can follow shop to see their promotion in feed, also can apply to be their agent. - agent can share the promotion with uniqic referral link which will earn 2% v3 - point system- user purpose any thing will get point same as the price, usd 23.12, will get 23.12 points. if point weight is 2, then he will get 46.24 point. - when us...

Based in sketch dimensions and photos create 3 3D tables . Creations of 1 Scene and render the items inside. - singular renders items in scene - 3 Images each item - combo items in scene - 4 images

We are see...observant videographer to join our team in Pattaya, Bangkok, or Koh Samui. The ideal candidate will have a passion for creating authentic and engaging video content, and a smartphone with a good quality camera. Responsibilities: Shoot 10 short videos (55 seconds each) using your smartphone. Capture interesting people, restaurants, and attractions in the amusement parks. Ensure good image quality and stable shots. Videos should be shot in landscape format (9:16). Qualifications: Good smartphone camera skills and experience shooting short-form videos. An eye for detail and the ability to capture interesting and engaging footage. Ability to work independently and reliably. Good English language skills. We need Con...

I'm in need of a skilled freelancer to embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web development (specifically emb...

...Developer with a flair for mobile development and UI/UX design. You'll take charge of designing, coding, and modifying mobile applications to enhance user experience. This role requires collaboration with cross-functional teams to bring new features to life and ensure our applications are both robust and responsive. **Key Responsibilities:** - Design and build advanced applications for both iOS and Android using frameworks like Flutter. - Work alongside other teams to define, design, and deploy exciting new features. - Focus on application performance and user experience. - Maintain high standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related fiel...

I'm looking for a skilled PHP Laravel developer to quote a PHP Laravel based project. Please note that the scope of this task is to provide a quote for the project, not to complete the project itself. However, if the quote is good, there is a chance that you will get the your bid by answering the following question: What is your favorite Laravel template engine?You must have completed at least 10 Laravel projects and be available for discussions via Zoom. The ideal candidate should have: - Proficiency in PHP and Laravel

Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PD...

...experienced Android App Developer to join our team for the development of a puzzle game for the Android platform. As an Android App Developer, you will be responsible for translating game concepts and designs into high-quality, efficient, and engaging mobile experiences. Your primary focus will be on the development of the Android application and its integration with backend services. Responsibilities: 1. Collaborate with game designers and artists to understand game mechanics, features, and visual designs. 2. Develop clean, efficient, and maintainable code for the Android platform using Java or Kotlin. 3. Implement game mechanics, user interfaces, animations, and audio effects according to specifications. 4. Optimize game performance fo...

I'm in need of an experienced web developer proficient in Python or PHP, specifically with expertise in Magento. The project involves creating a customized e-commerce website, which requires several key features: - Product Catalog: The website must be able to showcase a wide range of products, organized in a user-friendly and visually appealing way. - Shopping Cart & Checkout Process: A seamless and secure shopping experience for users is paramount. This involves a smooth cart functionality and a secure checkout process. - User Registration & Login: The site should enable users to create accounts and log in, allowing for personalized shopping experiences and order tracking. - Super fast load time at least 93 score...

...app developer with expertise in integrating key functionalities such as user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode s...

...looking to create an appealing short video commercial for our English Summer School that will be shared across social media. The aim of this video is to increase enrollment and, while doing so, provide some information on the specific attributes of each of our five branches. The successful freelancer should ideally have: - Proven expertise in creating compelling live-action video content suitable for social media - Excellent storytelling skills and the ability to differentiate between the general and specific content provided for each branch - A high degree of adaptability to utilize the provided assets and similar video samples The video should be approximately 8 to 9 frames long; assets, including sample videos, will be provided to ...

I'm in need of an experienced PHP developer to create a comprehensive web-based portal. This platform will serve as a central hub for both my customers and employees, as well as allow administrators to manage and update the content effectively. Key Features: - User authentication: Implement a robust user authentication system to ensure only authorized personnel can access the portal. - Content Management System (CMS): Create a user-friendly CMS that allows the administrators to update, upload, and manage text and image content on the portal. User Roles: - Customers: The portal will be used by customers to interact with our services. Ensure seamless user experience and accessibility. - Employees: Employees should have access ...

I am seeking a skilled designer for a furniture project involving the creation of modern chairs and tables. Key Requirements: - Extensive experience in furniture design. - Proven track record in designing modern style furniture. - Proficiency in working with metal as the primary material. - Ability to share previous project samples as reference. Ideal Skills: - Sound knowledge of the latest trends in furniture design. - Excellent understanding of modern design principles. - Strong experience in working with metal. This is an incredible opportunity for furniture designers interested in modern design and metal work. Please share portfolios or examples of previous work that align closely with the requirements men...

I'm looking to create a compelling Instagram ad that promotes the sale of unique furniture pieces. The aesthetic needs to be urban and modern to resonate with the target audience: millennials, homeowners, and interior designers. The goal is not only to create strong brand awareness but to effectively generate sales leads. I refurbish second hand furniture and turn into modern functional furniture. Eg old pine wood tv cabinet into a unique modern functional one off desk for a teenager or dining with lots of storage and great to look at. Also refurbish pallets into potting tables, herb pot and tables for seniors, garage work benches. Also turn old tv cabinets into cat houses/averies. I sell everything for under ...

I am seeking a proficient freelancer to convert 1-5 Word documents to Overleaf Latex Journal Format. These documents include not only text but also graphics and tables, necessitating an eye for detail and good command of layout techniques. The ideal candidate will have extensive experience in Word-to-LaTeX conversions and dealing with documents that are graphically rich. The successful freelancer would demonstrate a deep understanding of LaTeX syntax and formatting, and the capacity to preserve the structure and aesthetics of the original Word documents in the process of conversion. Efficiency and accuracy will be key attributes for this task. I have 4 documents & Latex template. I want those documents to be converted int...

I am excited to apply for the part-time Software Developer position. As a third year computer engineering with solid background in both front-end and back-end development, I am confident in my ability to contribute effectively to your projects. Technical Skills and Expertise Front-end Development: Skilled in HTML, CSS, and JavaScript, with experience in and Tailwind CSS. I focus on creating responsive and visually appealing user interfaces. Back-end Development: Proficient in Python and Node.js, with a track record of building robust APIs and microservices. Database Management: Experienced with MySQL and MongoDB, capable of designing efficient database schemas and performing queries. Full-Stack Deve...

I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the page numbers.

...looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific ...

We are seeking an experienced PHP developer to assist in fixing existing and add new back-end functionality. Our platform allows parents to book their children's lunch boxes for selected schools, offering multiple choices for the boxes. Parents can select the school and timings through dropdown menus. We receive the details on our dashboard and print stickers to be pasted on the boxes. Currently, we are facing issues with obtaining accurate order details, leading to mismanagement and manual intervention. We also want to integrate a monthly subscription feature for parents. The ideal candidate should have a strong understanding of PHP and be able to create clean, efficient, and scalable code. As a PHP Develo...

I'm in need of a skilled programmer to create an automation code page for me. This code page will be focused on text processing, so a strong understanding of working with textual data is essential. Key Requirements: - Proficient in JavaScript: The automation code should be written in JavaScript to ensure compatibility with other platforms. - Automation Experience: The primary function of this code will be automating tasks. A proven track record in building automated processes is highly desirable. - Text Processing: The code must be able to accurately and efficiently process textual data. Experience in this field will be a huge advantage. If you have experience in JavaScript, a background in automati...

...professional operations team to tailor live broadcast content and character building for you. And, there's a lot of room for growth in our job. We are also recruiting for HR, operations managers and other positions. If you have the ability, we are willing to provide positions! What are you waiting for? Come to join us! Live broadcast job requirements: computer equipment and internet in English and Portuguese and cheerful the face live Live content:  casual games. During the live broadcast, introduce the game you are playing to the audience. We provide game accounts. You only need to play for two hours and tell the audience how to play the game. Live time: Live broadcast time: 7:00-10:00 ...

...skilled Flutter and PHP developer to create a three-platform application- Android, iOS, Web. The crux of the application is to serve a robust platform for job posting and searching. Its primary audience is families and domestic helpers. Key Features: - User authentication - Push notifications - Payment integration - Job posting and Employee Profile creation - In-app chat and Whatsapp integration - Bookmarking and job/profile sharing functionalities - Premium membership that enables additional contact features - MySQL database schema design - Integrated Google Admob Advertisement Backend Work: - You'll develop a RESTful API with PHP+MySQL to support app functionalities. The ideal candidate will have significant exp...

I'm seeking a skilled individual who ca...Communication: The chosen candidate should have a sound understanding of MQTT (Message Queuing Telemetry Transport) and how to use it to integrate various IoT devices. - Data Collection & Analytics: Proficiency in handling data streams from these devices, ensuring seamless collection, storage, and basic analytics. - User Interface & Experience: Creating a clear, intuitive UI to monitor and interact with the IoT data is essential. Ideal Skills: - Proficient in Java, MySQL, and Tomcat - Experience with MQTT and IoT SCADA is a plus - Strong background in designing user-friendly interfaces - Able to deliver quality work within a tight timeframe Go through the PD...

...communicator with a knack for scheduling appointments? Glimmer Grove Design is seeking freelance appointment setters to assist us in reaching potential clients and scheduling Zoom calls to showcase our beautifully crafted websites. Responsibilities: - Utilize provided dialer, script, and lead list to make outbound calls to businesses without websites. - Engage with business owners or decision-makers to discuss our website offerings. - Schedule Zoom calls to present our pre-built website demos. - Maintain accurate records of appointments scheduled. - Requirements: - Excellent communication skills, both verbal and written. - Comfortable making outbound calls and engaging with potential clients. - Ability to ef...

Description: We are seeking a skilled and experienced HR Recruiter to join our team on a freelance basis, specializing in recruiting for the BPO industry. The ideal candidate will have a strong background in talent acquisition for Customer Service Representatives (CSR), Relationship Managers (RM), and Telesales positions. This is a remote position with flexible hours. Responsibilities: Source and attract candidates using databases, social media, and other recruitment platforms. Conduct interviews and filter candidates for open positions. Collaborate with hiring managers to understand job requirements and candidate profiles. Create and post job descriptions on relevant job boards. Screen resumes and job applications. Perform referenc...

I am in need of a skilled developer to create a customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The succ...

I'm in need of a proficient PHP developer to take on a range of responsibilities for my project. You'll be handling both the front and back-end development, as well as maintaining the website. I'm looking for someone who has a strong background in PHP, not just with creating and managing dynamic and interactive web pages, but also maintaining them for optimised performance. Key Responsibilities: - Handling front-end and back-end development - Carrying out website maintenance You must provide examples of your past work in your application. We appreciate attention to detail and a deep understanding of PHP. Since I will provide all the content needed for the website, you can focus solely on the programming side o...

...cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system can automatically award to bidded products as admin can set