sql - How I can get an auto incremented value -

-

i have here table corresponds orders of customers. use auto_increment determine id of order. have sql code orders table:

create table if not exists `orders` (   `order_id` int(11) not null auto_increment,   `customer_id` int(11) not null,   `customer_name` varchar(500) not null,   `order_total_price` decimal(20, 2) not null,   `order_date` varchar(100) not null,   primary key (`order_id`) ) engine=innodb

what need insert each of products of order in table foreign key order_id specify order products belongs to. sql code purchased_products table is:

create table if not exists `purchased_products` (   `order_id` int (11) not null,   foreign key (`order_id`) references orders(`order_id`),   `product_name` varchar(500) not null,   `product_price` decimal(20, 2) not null,   `product_quantity` int(11) not null,   primary key (`order_id`) )

when user buy something, use insert data in orders table:

insert orders (customer_id, customer_name, order_total_price, order_date) values ('{$customer_id}', '{$customer['customer_name']}', '{$order_total_price}', '{$order_date}')";

and here problem. need insert in purchased_products table products order id generated:

insert purchased_products (order_id, product_name, product_price, product_quantity) values ('*/the id of order need goes here*/', '{$product['product_name']}', '{$product['product_price']}', '{$product['quantity']}')";

this giving me headache. i'm not knowing how it. should done different way? how associate order id products belonging it?

use function last_insert_id(). give value auto-incremented last 1 before call it.


Comments

Post a Comment

Popular posts from this blog

SQL php on different pages to Insert (mysqli) -

-
i have piece of php code, works when placed on index page ( index.php ), nothing if put in page, i.e. add.php for example: having code add.php page, tried go to: www.myhost.com/add.php , nothing happen. if copy code index.php , go page www.myhost.com/index.php add row in sql table. why that? <?php $server="mysql.server.com"; $user="randomusr"; $pass="randompwd"; $db="randomdb"; $link=mysqli_connect($server, $user, $pass, $db); $result=mysqli_query($link,"select * `battery` `id`"); $query = "insert battery (id,type,owner,charge,time) values ('1','lily002','maisnow','15','2015-04-22 17:20:28')"; mysqli_query($link, $query); header("location: index.php"); //this 1 comment out when copied index.php ?> l # name type collation attributes null 1 id int(16) no ...
Read more

How to combine associative arrays in bash? -

-
does know of elegant way combine 2 associative arrays in bash normal array? here's i'm talking about: in bash can combine 2 normal arrays follows: declare -ar array1=( 5 10 15 ) declare -ar array2=( 20 25 30 ) declare -ar array_both=( ${array1[@]} ${array2[@]} ) item in ${array_both[@]}; echo "item: ${item}" done i want same thing 2 associative arrays, following code not work: declare -ar array1=( [5]=true [10]=true [15]=true ) declare -ar array2=( [20]=true [25]=true [30]=true ) declare -ar array_both=( ${array1[@]} ${array2[@]} ) key in ${!array_both[@]}; echo "array_both[${key}]=${array_both[${key}]}" done it gives following error: ./associative_arrays.sh: line 3: array_both: true: must use subscript when assigning associative array the following work-around came with: declare -ar array1=( [5]=true [10]=true [15]=true ) declare -ar array2=( [20]=true [25]=true [30]=true ) declare -a array_both=() key in ${!array1[@]}; ...
Read more

c++ - No viable overloaded operator for references a map -

-
i trying use map can make tag names reference number. when try , use it, in code error (6 in total every time reference map): src/main.cpp:25:45: error: no viable overloaded operator[] type 'std::map<std::string, std::string>' const char* idcs = node.child_value(tagmap[3]); this code: #include "pugi/pugixml.hpp" #include <iostream> #include <string> #include <map> int main() { pugi::xml_document doca, docb; std::map<std::string, pugi::xml_node> mapa, mapb; std::map<std::string, std::string> tagmap {{"1", "data"}, {"2", "entry"}, {"3", "id"}, {"4", "content"}}; if (!doca.load_file("a.xml") || !docb.load_file("b.xml")) { std::cout << "can't find input files"; return 1; } (auto& node: doca.child(tagmap[1]).children(tagmap[2])) { co...
Read more