Find Jobs
Hire Freelancers

insert records with same id in database

€2-6 EUR / hour

Closed
Posted about 5 years ago

€2-6 EUR / hour

Hello, when I insert records from shopping card, these records don't have a common id, but I need a common id because these records are from the same order, and I want to display orders. Can someone help me to change my query or what to do to have a common ID per Order?
Project ID: 18691164

About the project

23 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average €6 EUR/hour for this job
User Avatar
Hello! I can do this for you where for one order there would one id. I would be really happy to hear from you. Thanks
€10 EUR in 40 days
5.0 (94 reviews)
6.6
6.6
User Avatar
Hi can you please show me your database so that i can check out the solution. I am expert in database. Thanks Shihan
€4 EUR in 40 days
4.9 (318 reviews)
6.8
6.8
User Avatar
hi there, how are you doing? can you please come over chat and lets share the code details so I will review first and try to fix asap. Thanks
€5 EUR in 4 days
4.8 (217 reviews)
6.6
6.6
User Avatar
Hi, I would like to fix the issue of common id. Available for discussion and ready to start now. Regards, Manish
€5 EUR in 40 days
4.9 (125 reviews)
6.2
6.2
User Avatar
Hi. I am a full stack developer and have been working for over 5 years on the freelancer.com. I have read your description in detail and have interests in your project. I have some experiences that have ever done what is similar to your project. As a solution, I have a good idea to build your project perfectly I would like to have a discussion with chat to get more about your project. Thanks.
€6 EUR in 40 days
4.9 (49 reviews)
6.1
6.1
User Avatar
Dear sir, I am very interested in this database query work project. I have 8+ Year of Experience in this field and I can surely do this project, I work as freelancer with my inhouse team. Please try to give me one chance to prove my strength and quality of work. I always believe in quality work and always ready to provide you best solution for your project. Trust me sir i never disappoint you at least you can give me one chance. Please check my profile in freelancer.com https://www.freelancer.com/u/mdubey.html Please message me on PM for further discussion. Thanks & Regards Mohit
€5 EUR in 40 days
4.3 (61 reviews)
6.0
6.0
User Avatar
HI thanks for the response i can make a sql record entry using php Looking for a positive response Open project message board plz best regards anwar
€3 EUR in 40 days
4.9 (11 reviews)
2.7
2.7
User Avatar
Hi i wont tike more than a hour to solv ur problem but before that let me know ur schema to fix and my bid is fixed
€22 EUR in 5 days
4.6 (6 reviews)
3.0
3.0
User Avatar
Hi there! I have read what you exactly need, however I would like to ask you a few questions. Please feel free to ping me anytime so we can have a detailed discussion. Thanks.
€4 EUR in 40 days
4.1 (5 reviews)
2.9
2.9
User Avatar
Bonjour, si vous parlez français contactez moi, on va trouver une solution, ne vous inquiétez pas. Merci.
€5 EUR in 2 days
5.0 (5 reviews)
2.1
2.1
User Avatar
Hi, I have very good working knowledge in sql. I can help you with this work. Pls Let me know if you are interested.
€4 EUR in 40 days
5.0 (1 review)
0.9
0.9
User Avatar
I read the task description and I can do it.I have worked on many such projects.I can work on urgent basis and for a reasonable rate..Contact me so we can discuss further
€5 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to do this project. need further details of task. may I know when we can talk? I am always available feel free to ping me.
€4 EUR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am having experience in handling database. most of my applications are dynamic based applications. so i can handle your project easily.
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can solve the query issue . I have 3 years of experience in java development and 1 year experience in PHP development with core and Laravel framework. As it is look like SQL side work I can work on it. please consider my profile if it is suitable to your work. Thanks and Regards Vinit Vyas
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi there, I am developer with 4 years of experience in PHP and NodeJs. Your database should have two different tables. e.g: tbl_orders: here your orders will be placed like. id, user_id, total_amount, order_date tbl_order_detail: here you will insert your cart items. First you have to insert into tbl_orders and then get the last inserted id and insert that id and shopping cart values in tbl_order_details. You will tables structures like: TBL_ORDERS: id | user_id | total_amount | datetime | discount | coupon | TBL_ORDER_DETAILS: id | order_id (id of tbl_order) | product_id (items in cart) | price (price of single item) | quantity (quantity of single item) If you wish to store these in single table : you must generate RANDOM ID before inserting in order table and it should passed with all records so it will same for all records and you must fetch it using this random id. Hope that helps. If you want to discuss more. Ping me. Thanks Regards, Taimur Tariq
€4 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I 'am expert in Database administration and DB architect and will help you to create a unique ID or some columns to be composite key (primary key)
€3 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sender, Thanks for the requirement. I have profound experience in sql , pl/sql , Oracle forms and reports 11g and work on various projects on same technologies. I would like to complete your requirement within given timelines. Thanks.
€5 EUR in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BELGIUM
leuven, Belgium
4.9
151
Payment method verified
Member since Apr 13, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.