CE Phoenix Cart Forum

Please can someone guide me how to query the database products_options_values table to get the product_options_values_name using product_options_values_id value?

Thank you.

I would think something like
Would do it. I don't remember whether the language_id is fetched differently in catalog compared to admin, but if memory serves, the above goes for admin at least.

//Daniel

Thanks very much @Kofod95 , very much appreciated.

Another question if I may. How can I pass a selectbox value/option to it using a link?

I'm am a little unsure about what it is you want to do, but if you just want the ability to create links that will show the name of the option_value, you could populate the variable in the above query like and create the link like You may need to use $GLOBALS['Linker']->build(...
$Admin->link(...
Or $GLOBALS['Admin']->link(...
depending on the context.
Also, I may be misremembering, but you could look at any nearby link in core to check for the correct syntax

//Daniel

Thank you again Daniel.

What I want to do is set a selectbox value using a link or JavaScript instead of clicking the selectbox. For example:

<script type="text/javascript">
$(document).ready(()=>{
$("#input_5") option[value=8]").attr('selected', 'selected');
});
</script>

Perhaps this can be done a better way or using a URL to set the value?

For product_info or somewhere else?
Is it the same option you want to be preselected, or do you want the power to have different options preselected in different circumstances?
My approach to it would vary based on the outcome wanted

//Daniel

Thank you @Kofod95

Yes, this is for product_info and a different value will be passed to the selectbox each time. How would you go about this. Is using PHP an option or just JavaScript?

EG: product_info.php?products_id=4%7B1%7D2

In a new install, gets you to the product_info page for "Shiny Red Apples", with the "Box Size" of "24" pre-selected.

This piece: %7B1 is the Option (here is option "1"), and this piece is the Attribute %7D2 (here is attribute "2"). If you have multiple Options, then the URL would end up longer, something like this;

product_info.php?products_id=4%7B1%7D2%7B2%7D4

Which says product_info page for "Shiny Red Apples", with the "Box Size" [%7B1] of "24" [%7D2] pre-selected and "another option" [%7B2] of "whatever" %7D4 selected.

You can see this in action, by performing the following;

1. Go to the product info page of any product with selectable option(s).
2. Select options and Add To Cart.
3. From the Cart page, click the LINK back to the product. This link would look something like the URLS above.
4. Scroll down and see that the options are pre-selected.

Now you need to think how to use this piece of core functionality to do what you need to do.

@burt's answer shows the reason I asked what you wanted - core is able to preselect attributes from link-parameters, so no need to re-invent the wheel

//Daniel

Hello @burt . Thanks so much for this guide. I followed the steps you outlined and it works only if a product is already in the cart and you want to click back to it.

In my case, I want to make the selection before adding item to the cart. For example:

product_info.php?products_id=781{2}8{3}4

The above will not work if I just pass it in the URL if it's not already in my cart.