Jump to content

Archived

This topic is now archived and is closed to further replies.

piskie

Prefix/Prepend a Text Field Entery

Recommended Posts

I am storing product details in a MYSQL Table.
This is to hold Multiple Merchants each with their own Merchant Code.
Each Product code must be Unique.

To achieve this but still allow each Merchant to freely assign his own Product Code system I need to prefix the entered Product Code with the appropriate Merchant Code.

The Merchant Admin uses php forms and the product code field is:
<input type="text" name="code" id="code" value="<?php echo KT_escapeAttribute($row_rsstock['code']);?>" size="12" />

The insert function in the head of the page is:
$ins_stock->addColumn("code", "STRING_TYPE", "POST", "code");

For example I would like a product code ABC123 entered by Merchant D100 to automatically become:
D100-ABC123 on insert.
I also need to prevent the automatically inserted prefix being overtyped in the form field.

As I am very much a beginner in PHP & MYSQL, a simple expression would be preferred with enough info for me to impliment with my limited knowledge.

Thanks in advance.

Share this post


Link to post
Share on other sites
Why not just add the merchant code after they've input their code?  Let them input ABC123 and whatever other details and submit it, and then just add the prefix right before you insert it to the DB

Share this post


Link to post
Share on other sites
The form has 14 fields. Some Text and some Hidden.
It also has several image file upload, resize and rename fields and functions.
All this happens on "Submit".

I want to add the Merchants Code to the Product Code with the least complications possible.
When the Submit Button operates, there's a lot going on and I don't feel able to intercept just the "code" value and modify it and then continue to submit.

I am hoping for some function or other to be include around the Insert Function:
$ins_stock->addColumn("code", "STRING_TYPE", "POST", "code");

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.