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; }
$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;