Count number of rows in sql query result php jobs

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are highly appreciated.

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm in need of a skilled individual who is proficient in both PHP and Google Gemini. The primary task is to integrate this platform with my PHP website. Key requirements include: - Basic data syncing: The main goal is to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The ideal candidate must have: - Demonstrated expertise in PHP and Google Gemini. - Prior experience in integrating Google Gemini with websites. - Strong communication skills to understand my requirements and provide updates on the integration process.

I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to cl...

...Notification System (In-App, Push) Other Key Features: - Secure Admin Authentication - User Management (Roles, Permissions) - Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing admin dashboards - Expertise in Flutter, Firebase, PHP - Strong design sense for clean UI/UX - Knowledge of user management, data viz, content systems - Ability to ensure security, performance, compliance Your role will be to implement these features using PHP (or else) and Firebase. I'm open to suggestions and improvements on the features list. Please prov...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

As a lifestyle content creator, my main focus is to increase the number of subscribers on my YouTube channel. Key Requirements: - Goal: The primary aim is to develop a strategy to organically increase the channel’s subscriber count. - Skill: You are expected to have experience in growing YouTube channels, particularly in the lifestyle niche. - Strategy: A well-thought-out plan to boost subscriber numbers is crucial. Your Expertise: - Experience: Prior experience in driving subscriber growth is essential. - Knowledge: An understanding of lifestyle content and its audience would be a significant advantage. - Creativity: Innovative solutions to engage viewers and attract new subscribers are highly desired. Please come forward with ...

...the datasets I possess. The main objective of the system is to predict the next location that a user may visit. The datasets available for this project contain timestamps. Key Responsibilities: - Develop Python code for a location recommendation system - Utilize the provided datasets to predict user's next location - Ensure the system is efficient and accurate in its recommendations Ideal Skills and Experience: - Strong proficiency in Python programming - Experience in developing recommendation systems - Understanding of working with timestamp data - Ability to analyze and leverage data for prediction - Familiarity with location-based services or recommendation algorithms would be a plus The successful completion of this project should ...

I'm looking for a skilled professional who can successfully convert 2D images to 3D. The specifics are: - The images I provide will be in JPEG format. - The 3D conversion should be in STL format. - The final 3D result will be used for designing human images. Ideally, you should have proficient knowledge and solid experience in 3D modeling and image processing. A good hand in tools like 3D Studio Max, Blender or similar is needed. Experience in designing human figures in 3D is a massive plus.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I need a professional who can analyze the logs of my Apache PHP-FPM server and help me troubleshoot errors. The main focus of this task is to identify and resolve any issues that might be impacting the performance of the server. Key Requirements: - The ideal candidate should have a solid understanding of Apache PHP-FPM logs and their structure. - Good troubleshooting skills are necessary to pinpoint the root causes of the errors. - Ability to present the analysis results in a detailed report is crucial. The main goal is to ensure the server is running smoothly and efficiently. The server use Centos 7, Apache and PHP 5.6

I will pay no more than 30 dollars for this work. Please do not send a bid if you are going to offer a higher price. I'm seeking a skilled PHP programmer proficient with Cora. The goal is to automate the sharing of articles from my website to my business Facebook page. Key requirements: - Automate sharing: I want the programmer to ensure that whenever a new article is uploaded to my website, it's automatically shared to my business Facebook page. - Cora PHP programming: The ideal candidate should have experience with Cora PHP programming, specifically related to integrating website content with Facebook. - Facebook page sharing: The articles should be shared only on my business page, ensuring they reach my target audience. Your duties will include: ...

I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sendin...responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an effic...

One of our clients is looking for a literature search with a view to searching the Pubmed database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - ...

I'm seeking a talented designer to create a logo and branding for my personal use. The main inspiration for the logo should be nature, though you've full creative freedom. Key Points: - This is ...personalized logo and branding that reflects my love for nature. - The design needs to be distinctive and memorable, setting it apart from common logo themes. - There are no specific color preferences, so you can utilize your creativity in the color selection process. Ideal Skills and Experience: - Proven experience in logo and branding design, particularly with nature-inspired concepts. - Strong portfolio showcasing innovative and unique designs. - Ability to translate abstract ideas into visually appealing concepts. - Good communication skills to ensure the final ...

I'm seeking an expert in dynamic routing of capsules networks with a focus on accuracy. This project involves: - Enhancing the dynamic routing algorithm to achieve higher accuracy in image data analysis, primarily for healthcare applications. - Applying the improved algorithm to four distinct datasets for thorough evaluation. Key skills and experience for this project include: - Proven expertise in dynamic routing of capsules networks. - Strong background in medical image analysis. - Familiarity with the healthcare domain and the unique challenges it presents. The goal is to push the boundaries of current dynamic routing techniques to deliver a more precise and reliable method for medical imaging. A successful project will not onl...

I'm in a situation where I need assistance in creating an XML file and validating it with an XSD file. I am trying to work with and XSD files but hitting roadblocks. The result I'm seeking is an XML file which encapsulates transaction data. This specific data will be gathered from a database, making database management skills essential for this project. Key things I require guidance on include: - XML element creation for transactional data pieces - Using a database for XML data source - Validating the XML with an XSD file The successful freelancer for this project will need a high degree of proficiency with XML and XSD files. They will need the ability to explain complex concepts in an easy-to-understand manner as this project is about learn...

I'm looking for a skilled photo editor who can completely remove sun rays from an outdoor photo featuring a motorcycle and a person. Your expertise in professional photo editing and manipulation will be crucial to achieving a flawless end result. Here are my requirements: - Complete removal of sun rays from the image. - Retain the overall quality and integrity of the image while executing the task. - Experience working with outdoor photography and dealing with lighting elements. - Excellent attention to detail to ensure a natural look after removal. - The ability to work efficiently to deliver the project within the agreed timeframes.

I am seeking a PHP developer to bring my interactive website vision to life. Key Project Requirements: - The website will require interactive features, enhancing user engagement and experience. - The project demands a high level of proficiency in PHP, as this language will be the backbone of the site. - Skills in HTML, CSS, and potentially JavaScript will also be required to ensure a seamless and visually appealing interface. Ideal Candidate: - Proven experience in developing interactive websites using PHP. - Strong knowledge of front-end technologies to ensure a responsive and visually appealing design. - Excellent communication skills and the ability to understand and translate my vision into a functional website.

I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.

...proficient in Angular and PHP, with previous experience in integrating new features. This is for a project that involves: - Frontend Development: Enhancements and integration of Angular components into an existing website/application. - Backend Development: Implementation of necessary PHP functionalities to support the new features and ensure smooth operation of the site/application. - Database Integration: Synchronization of the updated features with the database, and ensuring consistent data flow and storage. The primary goal is to integrate CMS features into the existing system. Your role will include planning, execution, and testing to ensure that the new features are successfully integrated. Ideal candidates should have: -...

I need a PHP expert to help me fix a translation bug in my system. - The issue specifically affects the English language version of my website, disrupting various interface labels. - It's essential the freelancer is proficient in identifying and rectifying translation bugs in PHP. Your expertise will be invaluable in ensuring my platform is user-friendly and accessible to all English speakers.

I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel fi...

Please Sign Up or Login to see details.

I need an AI website that shows daily stock picks, weekly stock picks and monthly stock picks but there must be limited number of picks and there must be a paid version that shows special picks. For example, AI picks 10 stocks daily but shows only 7 of them, does not show the best first 3 stocks to buy and users need to pay monthly fee to see first 3 stocks.

...templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigate for non-technical users. It is essential that this application runs efficiently on a Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Devel...

...12' x 40' billboard to effectively promote our B2B Virtual Assistant service. This design should turn heads, deliver a clear message, and drive results! Use the below information to craft the best billboard you can do! You may utilize some of the copy provided or create your own copy based on the information provided. Company/Service Information: • We are a US-based staffing agency that provides Virtual Assistant Services to micro-, small-, and medium-sized enterprises worldwide. • Our Virtual Assistants come from all over the world. • We have been in business for more than a decade. Our services: • Admin Support • Business Support • Marketing Support • Technical Support Industries we serve: • Construction • eComm...

I'm in urgent need of a writer with a solid understanding of nursing. Please place your bid if you are capable of starting immediately. Ideal Skills & Experience: - Strong background in nursing - Ability to work with academic references - Quick turnaround time Please note that I've skipped specifying the word count and references for now. If we proceed further, we can discuss these details.

I'm in need of a simple Android application that's centered around offline data storage. Consider it an offline simplified Instagram app: Dashboard gallery - has a + button that creates a post (see screenshot) - displays rows of 5 thumbnails (similar to Instagram) (see screenshot) Post A post can take 3 forms: - static weight text (ie. 71.3, ^0.5 - where the latter is the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before addi...

...score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookmarks+ Authentication is done through twitter, I will connect my twitter account and run the script myself Deliverables: - Format: Script that I can run to export the required data in a CSV file. Ideal Candidate: - Proficient in web scraping tools and techniques. - Experience working with online marketplaces and eCommerce data. - A...

I finished your project successfully. Please check and let me know the result. I want you to give me 5 stars review after release a milestone. I will give you 5 stars review.

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

Please Sign Up or Login to see details.

I need a developer who send me the php code to contruct a php proyy to embed a m3u8 file with CORS restriction. I can provide you some url examples with m3u8 file which initially you can't embed in other domains, but i've seen that some website with some php code avoid this restriction. Send "I HAVE READ IT" in you bid. I only will pay if you send me the code and it works fine. Note: I need the code in php

I have this proyect and I am looking for a developer that has time available to work on the proyect. It is a long term proyect. I need someone with experience in PHP, Laravel, HTML I need to create a copy of a product page. Here is the info needed on the page;

I am in need of a skilled developer to create a group chat application that can be used on both Android and iOS platforms. The primary feature that is required for the app is text messaging. All users must be authenticated using phone number OTP. This project will require the following skills and experience: - Extensive experience with Flutter and mobile app development - Knowledge of implementing and customizing chat features - Proficiency in creating secure authentication systems, specifically phone number OTP - Past experience in developing cross-platform applications Ideal candidates will also have excellent communication skills, be able to work independently, and provide regular updates on progress. The successful candidate will not o...

...Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governan...

I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independ...

Help me with existing project to optimize the performance of core functionality and add some basic new functionalities. If you're genuine bidder then please write "php&python" in starting of your bid. This is kind of urgent and need to do it in around 1-2 weeks.

I'm in need of a Python application that can connect around 200 Android and iPhone devices to a PC via USB cables, allowing me to perform various automated tasks and workflows on them. Key Requirements: - **Bulk Control**: The app should be able to interact with all connected phones simultaneously. I should be able to create and assign tasks to each phone individually, or define tasks that apply to all devices. - **Task Automation**: I need the app to automate several types of tasks, which include: - Web browsing or searches: The app should be able to instruct the phones to browse certain websites or perform specific searches. - App testing or usage: The app should be capable of launching and interacting with various applications on the phones. - Con...

I'm looking for an experienced freelancer to assist in optical design and simulation using Ansys Lumerical software specifically aimed at communication hardware, more specifically, transmitters. Key Responsibilities: - Design effective and efficient optical layouts for transmitters. - Execute and analyze optical simulations. - Ensure that the optical design aligns with communication hardware requirements. Skills And Experience: - Proficient with Ansys Lumerical for Optical Design. - Comprehensive knowledge of communication hardware, especially transmitters. - Proven experience in optical design and simulation. - Must pay attention to detail and be result-oriented. I'm open to discussions if there are clarifications nee...

...a client, I need assistance in recovering a due refund from an immigration company in Dubai. This refund is a result of a cancellation request that has been approved by the company. Key Project Details: - The main reason for this collection is a refund due to a cancellation. - The cancellation request has already been approved by the immigration company in Dubai, making the collection process straightforward. Key Deliverables: - Making phone calls to the company to ensure a smooth and prompt refund process. - Expertise in negotiation to handle any potential hitches or obstacles that may arise. The ideal freelancer for this project should have: - Excellent communication skills, as phone calls are the primary method of communication ...

I have a PHP site hosted, but it's unfortunately not going live as intended. I need a skilled PHP developer to troubleshoot the site, identify the issue, and implement the necessary fixes to ensure it functions correctly. Key Deliverables: - Diagnose the issue causing the site to not go live - Implement the necessary fixes to ensure the site functions as intended - Provide me with the corrected file for future installation I'm experiencing error messages when I attempt to access the site. So it's crucial to not only fix the issue but also ensure it doesn't reoccur, making the site deployment-ready. Ideal Freelancer: - Experienced PHP developer with a proven track record of troubleshooting and fixing website issues - Strong problem-solvin...

I'm in need of a Google AdWords expert to help me generate leads and boost conversions at an affordable price. Key Project Details: - The campaign is aimed at both local and national customers. It's important that the specialist can tailor the ads to these specific audience segments. - The overall goal is to increase the number of leads the campaign brings in and to ensure a high conversion rate. Ideal Freelancer: - Proficient in Google AdWords and has a proven track record of generating leads and boosting conversions. - Experience in managing campaigns for both local and national customers. - Ability to work within a tight budget and still deliver effective results. - Strong analytical skills to constantly optimize the ...

I am in need of a skilled animator to create a 3D promotional animation for my locker product. The target audience for this video is adults, so the animation should be informative and visually appealing to a mature audience. Key requirements and responsibilities include: - Creating a 3D animation styled video - Crafting the video with a primary focus on promoting the benefits and features of the locker product - Ensuring the video is engaging and attractive to adults Ideal skills and experience for this project: - Proficiency in 3D animation - Prior experience in creating promotional content - Understanding of adult audience preferences and visual aesthetics - Ability to deliver high-quality work within a specified timeframe If you have a portfo...

I am in need of an experienced Japanese to English translator. The project will consist of translating a number of documents from Japanese to English. The documents to be translated will vary in field, including legal, business, and technical documents. The ideal candidate should be well-versed in translating such material, and be able to deliver accurate and high-quality translations.

I'm in need of a talented designer to craft a classic and elegant booklet for my project. Here are the specifics: - Size: A4 (8.3 x 11.7 inches) - Page Count: 20 to 50 pages The design should reflect a timeless and sophisticated aesthetic, incorporating classic elements while still appearing fresh. I want the design to be simple and uncluttered, evoking a sense of refinement and simplicity. Ideal Skills: - Proficiency in graphic design software (e.g., Adobe InDesign, Illustrator) - Strong understanding of classic design principles - Experience in booklet design - Ability to create engaging layouts for a multi-page document. Please include samples of your previous work in a similar style when applying. Your design will...

...pricing, preferred locations, etc. User Dashboard: • Users can submit trip details including location, and passenger count. • Users receive quotes from multiple operators. • Users can view and manage their trip requests, quotes, bookings, and messages. • Chat functionality to communicate with operators. Operator Dashboard: • Operators can view available trip requests. • Operators can send quotes to users. • Operators can manage their accepted bookings, quotes, and messages. • Chat functionality to communicate with users. Quote and Booking System: • Users receive quotes from multiple operators based on their trip details. • Users can accept quotes, leading to the creation of bookings. • Operators are notif...

...to provide a comprehensive analysis of the potential market for a school discovery platform in the UAE. Project Title: Comprehensive Market Research for School Discovery Platform in UAE Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. ...

Hello All, We are an established IT services provider with 13 years of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeking a long-term partnership and are willing to provide 20-30 hours of work per week. We welcome both experienced freelancers and those new to this platform who have significant prior experience, such as working in a company before starting their freelance career. This job post is open to all qualified candidates. Now, let's discuss the job requirements, which are urgently needed: We require an expert Laravel Developer who is well-versed in third-party APIs. T...