Thread: button to fill text box with value from database

**bonnit** · 8 Oct 2009 @ 08.50

i seriously am having issues with this, im not the sql guru i would like to be, in fact a million miles from it lol and php is not my first language

i am trying to have a button which searches a database for a customers current gift voucher balance, to quiterally be labelled apply and fill an empty text box, it has no other function as there is another button to checkout etc etc, it is for zen cart but ill worry bout replacing values etc etc later

any help as always is much appreciated

(even if its just a list of functions i should be looking at lol)

ta x

**WelshStew** · 8 Oct 2009 @ 09.10

Is this to be shown back to logged in customers or within the admin panel?

If within the admin panel, then this already exists under admin > gift certificate/coupons > gift certificates queue.

**bonnit** · 8 Oct 2009 @ 09.16

it is shown on their checkout page while they are logged in, there is already a field on there pulling the data from the database and its that i would either like to copy and insert into the text box, or using the same values for the logged in customer to "apply" their balance.

not sure how much you know about zen but it uses this as far as i can see to display the value

Line #48 : $this->checkbox = $this->user_prompt . '<input type="text" size="6" onkeyup="submitFunction()" name="cot_gv" value="' . number_format($_SESSION['cot_gv'], 2) . '" onfocus="if (this.value == \'' . number_format($_SESSION['cot_gv'], 2) . '\') this.value = \'\';" />' . ($this->user_has_gv_account($_SESSION['customer_id']) > 0 ? '<br />' . MODULE_ORDER_TOTAL_GV_USER_BALANCE . $currencies->format($this->user_has_gv_account($_SESSION['customer_id'])) : '');

MODULE_ORDER_TOTAL_GV_USER_BALANCE is just the language call to display the text next to it

does this mean anything to you lol, im not even sure if im on the right track ha!