AppGini Community Forums

Code: Select all

$j(function(){
    
    /** On changing product, retrieve unit price from products table and populate unit price field */
    $j('#ProductID-container').on('change', function(){
        var pid = $j('#ProductID').val();

        if(pid == '{empty_value}'){
            $j('#UnitPrice').val('');
        }else{
            $j.ajax({
                url: 'hooks/ajax-product-price.php?pid=' + pid,
                data: { pid: pid },
                success: function(data){
                    //$j('#UnitPrice').val(data);
                    alert(pid);
                }
            });
            
        }
        // }
    });
});

Code: Select all

<?php
    $cuffDir = dirname(__FILE__). '/..';
    include("$cuffDir/defaultLang.php");
    include("$cuffDir/language.php");
    include("$cuffDir/lib.php");
    
    /* grant access to all users who have access to the order_details table */
    $od_from = get_sql_from('order_details');
    if(!$od_from){
        header('HTTP/1.0 401 Unauthorized');
        exit;
    }

    $pid = intval($_REQUEST['pid']);

    $unit_price = sqlValue("select UnitPrice from products where ProductID='{$pid}'");

    echo $unit_price;
?>

Code: Select all

   $j('#ProductID-container').on('change', function(){
        var pid = $j('#ProductID').val();

Code: Select all

   $j('#ProductID-container').on('change', function(e){
        var pid = e.added.id;