Php query data access database jobs

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    6,343 php query data access database jobs found, pricing in INR

    I would like someone to improve the performance of a MySQL Query I have written that is running very slow.

    ₹1777 (Avg Bid)
    ₹1777 Avg Bid
    8 bids
    SQL Query - complex? - MySql 5 days left
    VERIFIED

    I'm need a query to update a table based on another table. I have two tables – SwitchPorts & SlaveSwitchPorts. When the SwitchPorts .ClientID changes the associated ‘salve’ SwitchPorts (listed in the SlaveSwitchPorts table) are updated with the new ClientID also. For example see the screen captures. When the query is executed the ClientID for three

    ₹1633 (Avg Bid)
    ₹1633 Avg Bid
    30 bids
    apollo server graphql query 5 days left
    VERIFIED

    see user-owned device with apollo-server-graphql, I want to see which user belongs to the device. I would like to find the following query by username field. query { user(username: "fatih") { username password userDevices { deviceName username } } }

    ₹1919 (Avg Bid)
    ₹1919 Avg Bid
    4 bids

    Have two tables T_products ProductID Name T_products_used ProductID CustomerID Description The first...CustomerID Description The first table is showing all different products, the next table is showing all products selected by a customer with description added. I want to make a query who shows ONLY products not selected/used by CustomerID = 25

    ₹1616 (Avg Bid)
    ₹1616 Avg Bid
    70 bids

    I need someone who has real experience with SOLR accessing it using C#. D...not apply unless you can explain the attached C# code file. I need someone who can help with SOLR Search. It would involve the application SOLR code to search the indexed data. The schema is already defined. The person will need to modify the schema based on requirements.

    ₹37450 (Avg Bid)
    ₹37450 Avg Bid
    2 bids

    Hi need help with a ms sql query, need top select top 1, in a inner join. start comment with "SQL1" i will send you the query

    ₹1634 (Avg Bid)
    ₹1634 Avg Bid
    16 bids
    Mysql query 4 days left
    VERIFIED

    I moved my website from Opencart to Magento, and i have some queries used on Excel for get information on Opencart Db that i have to use for the same extraction for Magento. I'm looking for someone able to send me back a tested queries for Magento for get the same informations In atthacmente the queries, i will give you db structure when you will accept my job

    ₹4508 (Avg Bid)
    ₹4508 Avg Bid
    16 bids
    Firestore Query 3 days left

    I want to be able to create a quert which will show all posts order by timestamp from a user friends. How can I do this in Firestore in Android Studio?

    ₹9594 (Avg Bid)
    ₹9594 Avg Bid
    11 bids

    I want to create an Android app, a social one. I am hiring someone to create the database model. Firestore is a NoSQL database so you can't use foreign keys. How can I achieve what I want? Please help me.

    ₹1990 (Avg Bid)
    ₹1990 Avg Bid
    3 bids

    ...please do not apply for the project If you do understand Toolset, here is the scenario: Views for a custom taxonomy allows specific query filters, however it is limited so you can not have multiple operators in a query like WHERE ( $something = $something ) AND ( ( $something = $something ) OR ( $something = $something ) ) I require a custom

    ₹1341 (Avg Bid)
    ₹1341 Avg Bid
    3 bids

    Please read a file called "[login to view URL]" in the zip file

    ₹13573 (Avg Bid)
    ₹13573 Avg Bid
    36 bids

    ...problems with SQL queries (remove duplicate queries, reduce requests, etc), locate/fix plugin conflicts, and (ideally) be able to adjust MySQL server config settings. Some PHP/JavaScript customization could be needed if plugin conflicts exist. The main issue we're experiencing is when customers add products to the cart. If they are not logged in

    ₹16771 (Avg Bid)
    ₹16771 Avg Bid
    22 bids

    I have a database system project for my university. I have created a database design and I have 4 query to be solved. 1. Function that takes as parameter month and year and product and returns the amount of money 2. Employee name, customer name, number of orders 3. Customer name, distinct product name 4. Procedure that takes as parameter customer name

    ₹2649 (Avg Bid)
    ₹2649 Avg Bid
    18 bids

    i need a function to display a table after running a mysqli query $result = mysqli_query($link, $query) or die(mysqli_error($link)); display_datatable($result);

    ₹1042 (Avg Bid)
    ₹1042 Avg Bid
    28 bids

    I need to run a query in mysql that give me a count but not count some of the records fld1 is a date fld2 is a customer# fdl3-10 i only want to count a customer once per day.

    ₹1350 (Avg Bid)
    ₹1350 Avg Bid
    20 bids

    Hi, I am looking to create a table in MySQL that calculates the balance (with fixed interest rate) for each user. there are expected to be more than 1 million customers and they will be allowed to withdraw and deposit continuously. 1. Users will have to keep the deposit untouched (no withdrawer) for 90 days (balance_nowithdraw) - interest rate (say 10%) and days (90 days)fixed so the final number ...

    ₹11228 (Avg Bid)
    ₹11228 Avg Bid
    25 bids

    I work for a small charity in the UK. Our sql database holds a lot of financial information such as how much each event we run needs to be invoiced. As we are moving over the Xero we want to be able to transfer this data into Xero to create invoices. I have a query in Access, with data in that i need to export into a Xero csv template. i need some

    ₹2700 (Avg Bid)
    ₹2700 Avg Bid
    17 bids

    Want to built a hana query for BOM

    SAP
    ₹1634 (Avg Bid)
    ₹1634 Avg Bid
    7 bids

    Hi, I am a developer and I need a more experienced backend developer to make my API production ready. There are several tasks to complete but for now, I'm looking for someone to refactor my backend queries for speed and stability. Also I'm having trouble indexing from a new DB (similar to this: [login to view URL]). Please put the word Mongo as the first word in your reply so I know y...

    ₹14710 (Avg Bid)
    ₹14710 Avg Bid
    14 bids

    Hello, I have following query: SELECT * FROM WWW_Stock_Cpnr_Winkel WHERE ArtikelKode = 'MKN198A005107M/659' I either want to select all products that start with same data before the backslash /. Any idea to make this? Thanks. Keep in mind the Artikelkode change each time. This query is just one example

    ₹1421 (Avg Bid)
    ₹1421 Avg Bid
    52 bids

    here is the detail of my project: [login to view URL]

    ₹1498 (Avg Bid)
    ₹1498 Avg Bid
    1 bids

    Need help with the sql query for the following: Need to add a subquery to the Supplier table script - select supplier ID (d1_fornece) and invoice date (d1_emissao) from table SD1330, join to SF1330 (as in the Invoice query) and then from that table to SE4330 where payment terms are in the field E4_DESCRI. Select only the most recent record, by invoice

    ₹1563 (Avg Bid)
    ₹1563 Avg Bid
    30 bids

    ...Below is the flow. 1. visitor enters site, location is generic 2. visitor is prompted to allow access to their browser location (will query existing geoip seearch) 3. while the visitor is entering their zip/post code data, they are greated with an ajax query to a db that returns location. 4. they have an option of selecting their location and the browser

    ₹10517 (Avg Bid)
    ₹10517 Avg Bid
    20 bids

    Hello, I need a programmer with experience in: 1. Python - jupyter notebooks 2. lxml library to parse xml file I will send you a large XML ~1.2Gb with a reasonable schema (large list of relatively simple and flat xml tags) The result should by a single jupyter notebook that parse this file and then executes 5 simple queries on it (simple queries such as search for all elements that has a sub-eleme...

    ₹3837 (Avg Bid)
    ₹3837 Avg Bid
    5 bids

    Need some one to work on multi-level complex SQL Query

    ₹1421 (Avg Bid)
    ₹1421 Avg Bid
    2 bids

    We are looking for a front end UI/UX developer with the ability to design and connect. We are a big data company that is looking for a fresh look. The problem we are solving is bringing great AI based recommendations to our users. We love the ease of use of a "Slack" like platform with individual channels and chat bots telling our users what's new

    ₹95153 (Avg Bid)
    ₹95153 Avg Bid
    19 bids

    I have 10 excel workbooks with indentical excel sheets (same structure). I want a query (in power BI - DAX) to retrieve the information in these sheets in a single data sheet.

    ₹1279 / hr (Avg Bid)
    ₹1279 / hr Avg Bid
    12 bids

    I have an Oracle Database File I would like to pull a simple query out and export to excel.

    ₹924 / hr (Avg Bid)
    ₹924 / hr Avg Bid
    11 bids

    Develop small app based on Python or Google Go to bulk query rest api, with 3000 database entry and store all response in same database

    ₹1421 / hr (Avg Bid)
    ₹1421 / hr Avg Bid
    15 bids

    Hello We built an application using code codeigniter and MySQL database (MariaDB), we are facing server issue to getting few record results takes 1-5 min to execute the result. We need DBA to consult us on the solution and fix it.

    ₹6964 (Avg Bid)
    ₹6964 Avg Bid
    18 bids

    I have created a Microsoft Access database that consists of 2 tables. I need someone to create queries, and reports for me. This is a basic project but I am finding myself very short on time.

    ₹3553 (Avg Bid)
    ₹3553 Avg Bid
    11 bids

    Goal: #1: Using "Report" Sheet when a user types in the Start Date and End Date of data they need, the query will search the "Returns" sheet and display all the rows that fall between those two dates. #2: On "Report" Sheet in Cell B5, total Column G (Price) *Returns sheet will have an infinite amount of rows

    ₹1990 (Avg Bid)
    ₹1990 Avg Bid
    15 bids

    Hello i have a database of millions of records of lat & lon I wish to find the center where most points are concentrated Example: if 30% of the data is around Location A (within 20m radius), 20% at random Locations, and 50% around Location B (within 20m radius), the final result should tell me the center of Location B (since most points are around

    ₹32192 (Avg Bid)
    ₹32192 Avg Bid
    15 bids

    ...automate the following search process that returns the number of results found for a search. For example, for EHS management system, the query: site:[login to view URL] "EHS management system" returns 40 results while the same query for another website returns no results: site:[login to view URL] "EHS management system" Screenshots are attached. For eac...

    ₹2416 (Avg Bid)
    ₹2416 Avg Bid
    6 bids

    ...NodeJs to display the data from Mysql database onto the html site.( database is also done) BUDGET:$80 to 100 need the following functions: *3 color scheme. *Display games on homepage from database. *Display game information from database, after clicking into game details. *Categorize games based on genre. *Log in based on database. *Register/Sig...

    ₹8101 (Avg Bid)
    ₹8101 Avg Bid
    17 bids

    ...monetize and quantify their brand value by giving fans real time access to purchase items they see their favorite teams and athletes using. Backend GMDY has relationships with ecommerce retailers that allows for all product data to be imported into the GMDY database. GMDY also has sports data (Team, Roster, Game Schedules - Events). As a process, the Chrome

    ₹1634 / hr (Avg Bid)
    ₹1634 / hr Avg Bid
    5 bids

    Given the sample tables below, write a SQL query to show the combined Account MRR by Region for active contracts of at least 6 months with at least one Success engagement. See attached image for the tables. Accounts Example ID 100005 Name Acme MRR $1,500 Region EMEA Subscription Example ID 80003 AccountID 100005 ContractLength (mo) 3 MRR $1,000

    SQL
    ₹1634 (Avg Bid)
    ₹1634 Avg Bid
    9 bids

    Hello, I want someone that will build a PHP search query form based on start and end dates. This is how the form will work: 1. Select start and end dates and click the search box 2. The system will populate the form with the names, payment months and years based on the selected dates I already have a working system but its not working online on

    ₹8670 (Avg Bid)
    ₹8670 Avg Bid
    51 bids

    I have data on employees that I export on a weekly basis and have to sort csv in excel. I want to be able to upload the CSV into my website, then be able to run a query on one employee and have it output/display the items associated with that employee (Licenses/CPR, expiring items) in an easy to see list.

    ₹8030 (Avg Bid)
    ₹8030 Avg Bid
    34 bids

    I have a script that is rather long. In one section I need the below portion to be executed only if a specific table is not empty. ...just need someone to help with making this happen. If the table has records, then the below snippet will run and then the rest of the script will continue. if the table does not have records, then the below snippet will not run and then the rest of the script will c...

    ₹1350 (Avg Bid)
    ₹1350 Avg Bid
    22 bids

    ...advance PHP based CRUD application, for small medical office(record work, finance, expense). It is for local use(not online system) and access only by employees. We want from you to use Bootstrap 4, PHP 7, FontAwesome, MySQL, Ajax and little Java. We need responsive app(grid system base in our needs), multiusers and clean code. We prefer core PHP and lightweight

    ₹23806 (Avg Bid)
    ₹23806 Avg Bid
    30 bids

    Hi, I am a developer and I need a more experienced backend developer to make my API production ready. There are several tasks to complete but for now, I'm looking for someone to refactor my backend queries for speed and stability. Also I'm having trouble indexing from a new DB (similar to this: [login to view URL]). Please put the word Mongo as the first word in your reply so I know y...

    ₹12578 (Avg Bid)
    ₹12578 Avg Bid
    22 bids

    Please see video to see how application is to work. Applicant must work remotely on my test workstation, use linq to access the SQL database.

    ₹4193 (Avg Bid)
    ₹4193 Avg Bid
    5 bids

    Please see video to see how application is to work. Applicant must work remotely on my test workstation, use linq to access the SQL database.

    ₹11015 (Avg Bid)
    ₹11015 Avg Bid
    1 bids

    ...built in any front end framework so creating a complete new css file based on media Query is probably the quickest way to implement. I would do it myself if I had the time. Structure for implementation should be 1 x [login to view URL] file which will be called based on media query and 1 x [login to view URL] file which will be called based on change in element in the mobile

    ₹32689 (Avg Bid)
    ₹32689 Avg Bid
    85 bids

    Hi Everyone, I have a requirement to update a bunch of query when you click on a button in an excel sheet. The query is based on a Odata feed from D365FO(dynamics AX).

    ₹1706 (Avg Bid)
    ₹1706 Avg Bid
    11 bids

    Hi - I need an optimized, fast query that lets me display collections of images - three per collection (See attached image that shows one collection. In reality I'd be displaying bunches of these sets of three, each its own collection.) There are three tables: collections, which has a title and unique ID for each collection; collection_items, which

    ₹1634 (Avg Bid)
    ₹1634 Avg Bid
    11 bids

    I would like a 5 option query result function in excel where you select the query using dropdown options and the function looks into data tab and gives you the matching result. (See attached excel)

    ₹1350 (Avg Bid)
    ₹1350 Avg Bid
    11 bids

    - Web scrape website to create own database OR can use existing database on the website - Web scrape daily to keep database updated - Convert existing query parameters / code to an easy to use filter tool - Existing Query Page: *message for link* - New Query Tool Features - Filter Buttons (1 or more selections) - Searchable

    ₹39866 (Avg Bid)
    ₹39866 Avg Bid
    43 bids