Using SQL to (i) create and manipulate database tables, and (ii) extract information from a database. 1. List the complete Tasks table. [11 points] Answer: 2. List the number and name of all clients that are represented by consultant 22 or that have credit limits of $10,000. [11 points] Answer: 3. For each work order, list the order number, order
I need to loop through a very simple payments table and apply the payments to a simple invoice table. The sample is m...and apply the payments to a simple invoice table. The sample is mostly written but has a mysqli_fetch_assoc() error. Also I would like this to be re-written using PDO. The php and sql are attached as text files so you can review.
*URGENT PROJECT* I need a simple php to query on mysql database selecting by ID and display full resulting record. This will be for a club elections to let members know where to vote. Where to vote is on its own database record too. Attached database with sample records ... I need to make a select where "cedula" is $variable (please strip a...
I have a government web site that needs to have database table fields mapped to it. This is to allow an MS Access database to fill out the web page(s) from the data a user has entered. There is no API. So it needs to be created to allow the connection from the Access DB to the SHTML web pages. The government agency has provided all the necessary information
...JavaFX to develop a Graphical User Interface (GUI) and a database for the vehicle management program. 1. Enhance your ability to build a Graphical User Interface using JavaFX 2. Practise implementation of various GUI event handlers and handling exceptions 3. Read from and write to a database using Java JDBC technology 4. Incorporate text file handling
...and its underlying database architecture. - Have strong experienced with both SQLITE and MYSQL server. - Understand SQLITE & MYSQL are NOT the same and the challenges involved. The requirements: (1) At Osclass installation steps, database username/password shall be ignored. The database field is to specify path to sqlite database file. (2) After cu...
Currently, my Shopify store ( [login to view URL] ) is a bit slow and this is increasing my bounce rate. First I would like to improve the overall speed of the website since I presume it is mainly a theme issue since I don't use many apps. All items to be completed: 1. Improve google page speed to around 90 [login to view URL] 2. On the product page the thumbs below the main image need to ...
The project is about a mobile application which is relating to healthcare. The company name is Healixir Wellness Services. We need someone to create a database for the application and create the API (services) to call the data from the database. The UI for the application is being built simultaneously. Also after building the database there will be
We have a project which is almost ready for production. We are looking for a freelancer to complete the pending tasks on the project. It includes 1. Modifying and improving the current UI/UX designs. (10-12 Pages) 2. Add a few functionalities 3. Integrating Payment Gateway The project is developed on PHP CodeIgniter Framework. This is a complete
have a series of names in the following format, and need a function to seperate them into first and last names, examples: johnson, dave & sue rose johnson,dave&sue dav...johnson dave henry johnson dave + sue johnson johnson dave h & johnson sue johnson, dave; johnson, sue johnson dave & johnsone sue johson dave h sue r Needs to work on mysql database
Hi there. I have an old website that we are building all new. I need to export the database from the old website and import into the new. Can you help?
I would like to build an inventory "database" to a shop grocery shop. I do not have access to a list and i am thinking to video record the item in one of the shops to be able to transfer them into an inventory. dose that sound like something doable or do you have access to an inventory? Please let me know . if you can do that bid and lets talk.
I need someone to help design a database for my business. I have 2 custom forms I will need and I want to have app capabilities. I know what I need but need someone to help me walk thru how to get to the end point
Hi, I am facing an issue on my website when a member registers his data is not adding in the database i need database expert to fix this
[This is a dummy project]. URGENT TO BE COMPLETED BY 2ND OF MAY 2019. PLEASE PROPERLY READ ALL THE DOCUMENTS THOROUGHLY (ESPECIALLY THE "EXTREMELY IMPORTANT" DOCUMENT) IN ORDER TO UNDERSTAND ABOUT THIS PROJECT BEFORE GOING AHEAD WITH FURTHER DISCUSSION. ALSO CANNOT DISCLOSE ORGANIZATION OR PERSONAL DETAILS.
I have a Google Chrome extension that sends a POST request to my website with JSON data. I need someone to help set this up so all of the JSON data is saved.
...this has been stored on paper, which has proven problematic, with personalised programs going missing along with Members details being misplaced. They want to create a single database to consolidate all these details into one single source. The logical data model must be designed to meet 3NF (Third Normal Form) requirements. They want it to record all Member
I need you to develop some software for me. I would like this software to be developed . I have a Microsoft Access Database. I need to create 4 Lables (banners) that will become visible only if certain values are selected in a field. Like a message banner. Of the banner is visible it should be recorded to the record. And of i look for the record later
...he is doing. You can read more about the solution here [login to view URL] You should have the following skills: Docker / Kubernetes Ruby 2.5.0 Rails 4.2+ Redis 2.0+ MySQL 5.7 RabbitMQ Blockchain/Cryptography knowledge is a plus At the first stage, I´m looking for the solution deployment on the cluster and then we will create more tasks with
Django Website using a database with login and resistor
I have an old wordpress site [login to view URL] I need to download all the portfolio post types into a csv from MYSQL. I need a column for name, description, and image url.
We are looking for a React Native Developer. To be successful with our project you will need to have... 3 years of industry experience Develop for Android using React Native Ensure the consistent performance, quality and responsiveness application Troubleshoot and debug technical issues Use best coding practices and document well Implement security
Our company is called Don Maslow Coffee, and we require some help in building a customer database. We would like 200 contacts entered into our database. Please see attached the Project Brief and Business Development Database template the we require to be filled. Thank you in advance for your help.
Must read attached pdf specification.
...using MongoDB hosted on AWS. Now we have changed the backend and its running on MySQL on the same server, not gone live yet. Changes: In order to continue supporting the seller users we would like to transfer their login details and Item information details. The new database/tables has all the existing fields so its a case of matching the columns and
I need a backhand design including database tables queries , which should be used in a freelancing system, it's an urgent term project!!
I need a freelancer to work long-term for projects in backend and frontend, the requirements are the following: - Backend developer (Codeigniter, PHP, MySQL). - Frontend developer (HTML, CSS).
We need help to repair/touch up our kitchen table as our cat used it to sharpen her claws. It is not an expensive table, just an IKEA one but...touch up (sanding and painting the legs in the same color which is IKEA dark brown, unfortunately they can't say exactly what color that is). A few of the chairs do also have minor needs for the same touch up.
Have a two ecommerce site or intial intallation of 'abantecart' and 'opencart' site these site seo url not working .In opencart its works with 404 not found error its very minor issue seems been ok in 5 minutes . so all work complete when 2 site seo url working Now Showing ----- [login to view URL] category no24 pr no 65 seo url--- [login to view URL] note--
Edit an existing pitch deck using photoshop and keynote work files. Happy with deck creatively but just needs some minor adjustments. Specifically -swap out a photo -edit copy (both quality and quantity) -add 3 slides I have all files and notations. Thank you
I've got a large e...rows from the OLD SQL rows and remove specific rows with column data that matches old column data - Remove NEW SQL Rows if the column data matches old SQL Table I'm not a database expert, but I understand some basics of what I need done via EXCEL. I'm not married to SQL if some C# SCRIPT or something else works, its fine by me.
Hello, I have a simple php/mysql application. I want to setup a elastic search for my search application. Need the following: 1. Write a script that will fetch data from the mysql db into elastic search 2. Provide a simple and robust elastic search integration for php For this task, a simple search will do. But later I will post separately about the
I want someone expert on Django to implement a simple website looks like twitter