PHP Connectgto Examples

Example #1

File: Cartas.php Project: kailIII/Inventarios-1

$count = 0;
$dif = 0;
$num_suc = 0;
$sumacant = 0;
$restacant = 0;
$numId = 0;
$idArray = 0;
$num = 0;
include "conex.php";
while ($num_suc <= 10) {
    if ($num_suc == 0) {
        $conn = Connectmex();
        $ABR = 'MEX';
    }
    if ($num_suc == 1) {
        $conn = Connectgto();
        $ABR = 'GTO';
    }
    if ($num_suc == 2) {
        $conn = Connectgdl();
        $ABR = 'GDL';
    }
    if ($num_suc == 3) {
        $conn = Connectmty();
        $ABR = 'MTY';
    }
    if ($num_suc == 4) {
        $conn = Connectpue();
        $ABR = 'PUE';
    }
    if ($num_suc == 5) {

Example #2

File: TRASPASOS_C.php Project: kailIII/Inventarios-1

$count = 0;
while ($S = ibase_fetch_row($sal)) {
    $diferencia = 0;
    $fechasal = $S[2];
    $maskSAL = $fechasal[8] . $fechasal[9] . $fechasal[7] . $fechasal[5] . $fechasal[6] . $fechasal[4] . $fechasal[0] . $fechasal[1] . $fechasal[2] . $fechasal[3];
    //CONECTA MEXICO
    $conn1 = Connectmex();
    $sql1 = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, SUM(MINVE03.CANT) AS CANTIDAD FROM MINVE03 WHERE MINVE03.CVE_CPTO = 7 AND ((MINVE03.FECHA_DOCU)>='{$fecha}') and ((MINVE03.FECHA_DOCU)<='{$fechaf}') and MINVE03.CVE_ART='{$clave}' GROUP BY MINVE03.CVE_ART, MINVE03.CVE_CPTO,MINVE03.FECHA_DOCU,MINVE03.REFER ORDER BY MINVE03.REFER, MINVE03.CVE_ART, MINVE03.FECHA_DOCU ASC  ";
    $ent1 = ibase_query($conn1, $sql1);
    while ($MX = ibase_fetch_row($ent1)) {
        if ($S[3] == $MX[3] and $S[0] == $MX[0]) {
            $mex = 1;
        }
    }
    //CONECTA LEON
    $conn2 = Connectgto();
    $sql2 = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, SUM(MINVE03.CANT) AS CANTIDAD FROM MINVE03 WHERE MINVE03.CVE_CPTO = 7 AND ((MINVE03.FECHA_DOCU)>='{$fecha}') and ((MINVE03.FECHA_DOCU)<='{$fechaf}') and MINVE03.CVE_ART='{$clave}' GROUP BY MINVE03.CVE_ART, MINVE03.CVE_CPTO,MINVE03.FECHA_DOCU,MINVE03.REFER ORDER BY MINVE03.REFER, MINVE03.CVE_ART, MINVE03.FECHA_DOCU ASC  ";
    $ent2 = ibase_query($conn2, $sql2);
    while ($GTO = ibase_fetch_row($ent2)) {
        if ($S[3] == $GTO[3] and $S[0] == $GTO[0]) {
            $gto = 1;
        }
    }
    //CONECTA GUADALAJARA
    $conn3 = Connectgdl();
    $sql3 = "SELECT MINVE03.CVE_ART, MINVE03.CVE_CPTO, MINVE03.FECHA_DOCU,MINVE03.REFER, SUM(MINVE03.CANT) AS CANTIDAD FROM MINVE03 WHERE MINVE03.CVE_CPTO = 7 AND ((MINVE03.FECHA_DOCU)>='{$fecha}') and ((MINVE03.FECHA_DOCU)<='{$fechaf}') and MINVE03.CVE_ART='{$clave}' GROUP BY MINVE03.CVE_ART, MINVE03.CVE_CPTO,MINVE03.FECHA_DOCU,MINVE03.REFER ORDER BY MINVE03.REFER, MINVE03.CVE_ART, MINVE03.FECHA_DOCU ASC  ";
    $ent3 = ibase_query($conn3, $sql3);
    while ($GDL = ibase_fetch_row($ent3)) {
        if ($S[3] == $GDL[3] and $S[0] == $GDL[0]) {
            $gdl = 1;
        }