Databases
StackOverflow2013
Postsdbo
PODatamapper set_join_field without update
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatamapper set_join_field without update
    primarykey
    data
    text
    <p>I'm trying to save some date with a join_field basically I have an add-up function and an count-down function</p> <pre><code>if(isset($_POST['min_product'])) { foreach($_POST['min_product'] as $index =&gt; $min_product_id) { $minproduct = new Product($min_product_id); $minproduct-&gt;save($order); $minproduct-&gt;set_join_field($order, 'amount', $_POST['min_prod_amount'][$index]); $minproduct-&gt;check_last_query(); } } if(isset($_POST['product'])) { foreach($_POST['product'] as $index =&gt; $product_id) { $product = new Product($product_id); $product-&gt;save($order); $product-&gt;set_join_field($order, 'amount', $_POST['prod_amount'][$index]); $product-&gt;check_last_query(); } } $this-&gt;set_order_row($order-&gt;id); </code></pre> <p>the Query's look like this:</p> <pre><code>UPDATE `link_orders_products` SET `amount` = '-1' WHERE `product_id` = 2 AND `order_id` = 391 UPDATE `link_orders_products` SET `amount` = '5' WHERE `product_id` = 1 AND `order_id` = 391 UPDATE `link_orders_products` SET `amount` = '1' WHERE `product_id` = 2 AND `order_id` = 391 </code></pre> <p>As query i would like to have something like:</p> <pre><code>INSERT `link_orders_products` SET `amount` = '-1' WHERE `product_id` = 2 AND `order_id` = 391 INSERT `link_orders_products` SET `amount` = '5' WHERE `product_id` = 1 AND `order_id` = 391 INSERT `link_orders_products` SET `amount` = '1' WHERE `product_id` = 2 AND `order_id` = 391 </code></pre> <p>The problem is that the amount of the first query will be override by the amount of the last one. But I would like to have them all tree in to inset in my database</p> <p>My question is How do I insert the value's that are handled by the set_join_field so they don't update?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPhearOfRayne
    1. USWouterV
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThis isn't a CodeIgniter question. It's specific to the ORM you are using. As a side note though, you shouldn't use $_POST. You should use $this->input->post('product') instead. This will sanitize your inputs.
      singulars
      1. PODatamapper set_join_field without update
      1. USCharlie
    2. COanybody an idea how i can solve my problem?
      singulars
      1. PODatamapper set_join_field without update
      1. USWouterV
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload