Beispiel #1
0
 function __construct()
 {
     //propiedades de la clase Conexion
     self::$gestor = GESTOR_DB;
     self::$servidor = SERVIDOR_BD;
     self::$usuario = USUARIO_BD;
     self::$password = PASS_BD;
     self::$db = DB_BD;
     self::$port = PORT_DB;
 }
Beispiel #2
0
                $modificar_precio = mysql_query("UPDATE lhs6n_virtuemart_product_prices SET product_price='{$precio}', product_tax_id='1', product_discount_id='14' WHERE virtuemart_product_id='{$virtuemart_product_id}'");
                break;
            case '20%':
                $modificar_precio = mysql_query("UPDATE lhs6n_virtuemart_product_prices SET product_price='{$precio}', product_tax_id='1', product_discount_id='15' WHERE virtuemart_product_id='{$virtuemart_product_id}'");
                break;
            case '30%':
                $modificar_precio = mysql_query("UPDATE lhs6n_virtuemart_product_prices SET product_price='{$precio}', product_tax_id='1', product_discount_id='16' WHERE virtuemart_product_id='{$virtuemart_product_id}'");
                break;
            default:
                echo "No Sirve Script" . "<br>";
        }
    }
}
$mysqlconexion = new Conexion();
$mysqlconexion->hostdb($host, $base);
$mysqlconexion->usuario($usuario, $pass);
$mysqlconexion->con('si');
$xml = simplexml_load_file("http://www.grupocva.com/catalogo_clientes_xml/lista_precios.xml?cliente=26813&marca=%&grupo=%&clave=%&codigo=%&promos=1&tc=1&dc=1&dt=1");
if ($xml) {
    $i = 0;
    foreach ($xml->item as $child) {
        //LEYENDO EL XML
        $grupo = $child->grupo;
        $marca = $child->marca;
        $clave = $child->clave;
        $disponible = $child->disponible;
        $precio = $child->precio;
        $moneda = $child->moneda;
        $cambio = $child->tipocambio;
        $nombre = $child->descripcion;
        $descripcion = $child->ficha_comercial;