PHP MySQL::MySQLClose方法代码示例

function getData($name, $nombre1, $integrador, $producto)
{
    $dataArray = "";
    $fecha = date('H');
    $dia = date('d', strtotime("+1 day"));
    try {
        $conexion = new MySQL(0);
        $query0 = '	select hour(date_add(NOW(), INTERVAL -' . HOURDB . ' hour));';
        $result0 = $conexion->consulta($query0);
        $exec0 = $conexion->fetch_row($result0);
        $fecha = $exec0[0];
        $query = 'CALL GetProductChargeToday("' . strtolower($name) . '",' . HOURDB . "," . $integrador . ',' . $producto . ');';
        $result = $conexion->consulta($query);
        $conexion->prepareNextResult();
        $query1 = 'CALL GetProductChargeYesterday("' . strtolower($name) . '",' . HOURDB . "," . $integrador . ',' . $producto . ');';
        $result1 = $conexion->consulta($query1);
        $conexion->prepareNextResult();
        $query2 = 'CALL GetProductChargeProm("' . strtolower($name) . '",' . HOURDB . "," . $integrador . ',' . $producto . ');';
        $result2 = $conexion->consulta($query2);
        $conexion->prepareNextResult();
        if (!$result or !$result1 or !$result2) {
            throw new Exception("No se logro obtener informacion de cobros....\n");
        } else {
            $cont = 0;
            $hoy = $conexion->fetch_row($result);
            $ayer = $conexion->fetch_row($result1);
            $prom = $conexion->fetch_row($result2);
            while ($cont <= $fecha) {
                if ($ayer[1] == $cont) {
                    $valor = $ayer[0];
                    $ayer = $conexion->fetch_row($result1);
                } else {
                    $valor = 0;
                }
                if ($hoy[1] == $cont) {
                    $valor1 = $hoy[0];
                    $hoy = $conexion->fetch_row($result);
                } else {
                    $valor1 = 0;
                }
                if ($prom[0] == $cont) {
                    $valor2 = $prom[1];
                    $prom = $conexion->fetch_row($result2);
                } else {
                    $valor2 = 0;
                }
                $dataArray = $dataArray . "data1.addRow([" . $cont . ", " . $valor2 . "," . $valor . ", " . $valor1 . "]);\n";
                $cont++;
            }
        }
        $conexion->MySQLClose();
    } catch (Exception $e) {
        echo 'Excepcion capturada: ', $e->getMessage(), "\n";
    }
    return $dataArray;
}

 function GoHome()
 {
     $conexion = new MySQL(0);
     $query = 'call GetHomeURL(' . $_SESSION['pais'] . ');';
     $result1 = $conexion->consulta($query);
     $row = $conexion->fetch_row($result1);
     $conexion->MySQLClose();
     switch ($_SESSION['access']) {
         case 1:
         case 2:
         case 3:
             $home = 'http://' . URL . DS . 'dashboard' . DS . 'metricas';
             break;
         default:
             $home = 'http://' . URL . DS . $row[0];
             break;
     }
     return $home;
 }

function GetSecondLevel($carrier, $al)
{
    $conexion1 = new MySQL(0);
    if ($_SESSION['access'] == 5) {
        $query = 'call GetSubMenuLimits(' . $carrier . ');';
    } else {
        $query = 'call GetSubMenu(' . $carrier . ');';
    }
    $result = $conexion1->consulta($query);
    $miniBody = '';
    while ($link = $conexion1->fetch_row($result)) {
        $urlC = $link[2] == 1 ? 'http://' . URL . DS . $link[0] : $link[0];
        $IamHere = $al == $urlC ? 'class="active""' : '';
        if ($link[2] == 1) {
            $miniBody = $miniBody . "\t\t\t\t\t\t\t" . '<li ' . $IamHere . '><a href="' . $urlC . '">' . $link[1] . '</a></li>' . "\n";
        } else {
            $miniBody = $miniBody . "\t\t\t\t\t\t\t" . '<li ><a href="' . $urlC . '" target="_blank">' . $link[1] . '</a></li>' . "\n";
        }
    }
    $conexion1->MySQLClose();
    return $miniBody;
}

    if (!$combo) {
        throw new Exception("No se logro obtener informacion de cobros....\n");
    } else {
        if ($integrador == 0) {
            echo "<option value='' selected>Integrador</option>";
        }
        while ($dato = $conexion->fetch_row($combo)) {
            if ($integrador == $dato[0]) {
                $tituloG = $dato[1];
                echo '<option value=' . $dato[0] . ' selected>' . $dato[1] . '</option>';
            } else {
                echo '<option value=' . $dato[0] . '>' . $dato[1] . '</option>';
            }
        }
    }
    $conexion->MySQLClose();
} catch (Exception $e) {
    echo 'Excepcion capturada: ', $e->getMessage(), "\n";
}
?>
                                        </select>
									</div>
								</div>
							</form>
                        </div>
                    </div>
                    <!-- end panel -->

				  <!-- BEGIN CarrierD_I -->
			        <div class="panel panel-inverse" data-sortable-id="ui-buttons-2">
                        <div class="panel-heading">

 function disable()
 {
     if (isset($_POST["usuario"]) and $_POST["usuario"] != '') {
         $conexion = new MySQL(0);
         $strIngreso = "update usuario set estatus = 'Baja' where Id_usuario = '" . $_POST["usuario"] . "';";
         $value = $conexion->consulta($strIngreso);
         $conexion->MySQLClose();
         $_SESSION['value'] = 'El usuario fue dado de baja.';
         session_write_close();
         exit(header('Location: http://' . URL . DS . 'dashboard' . DS . 'start'));
     } else {
         $_SESSION['value'] = "error";
         session_write_close();
         exit(header('Location: http://' . URL . DS . 'usuario' . DS . 'delete'));
     }
 }

 function save_g()
 {
     if (isset($_POST["carrier"]) and isset($_POST["host"]) and isset($_POST["esquema"]) and isset($_POST["tabla"]) and isset($_POST["campo"]) and isset($_POST["cond"]) and $_POST["carrier"] != '' and $_POST["host"] != '' and $_POST["esquema"] != '' and $_POST["tabla"] != '' and $_POST["campo"] != '' and $_POST["cond"] != '') {
         $conexion = new MySQL(0);
         $strIngreso = "\tinsert into billing.cobro_carrier  (id_cobro_carrier,id_carrier,id_base,esquema,tabla,condicion,estatus,field_sum)\r\n\t\t\t\t\t\t\t\t\tvalues (null," . $_POST["carrier"] . "," . $_POST["host"] . ",'" . $_POST["esquema"] . "','" . $_POST["tabla"] . "','" . $_POST["cond"] . "',1,'" . $_POST["campo"] . "');";
         $value = $conexion->consulta($strIngreso);
         $conexion->MySQLClose();
         $_SESSION['value'] = "ok";
         session_write_close();
         exit(header('Location: http://' . URL . DS . 'database' . DS . 'generate'));
     } else {
         exit(header('Location: http://' . URL . DS . 'database' . DS . 'generate'));
     }
 }

function getData($name, $num)
{
    $dataArray = "";
    $fecha = date('H', strtotime("+1 Hours"));
    $dia = date('d', strtotime("+1 day"));
    try {
        $conexion = new MySQL(0);
        $query0 = ' select hour(date_add(NOW(), INTERVAL -' . HOURDB . ' hour));';
        $result0 = $conexion->consulta($query0);
        $exec0 = $conexion->fetch_row($result0);
        $fecha = $exec0[0];
        $query = 'CALL GetCarrierChargeToday("' . strtolower($name) . '",' . HOURDB . ');';
        $result = $conexion->consulta($query);
        $conexion->prepareNextResult();
        $query1 = 'CALL GetCarrierChargeYesterday("' . strtolower($name) . '",' . HOURDB . ');';
        $result1 = $conexion->consulta($query1);
        $conexion->prepareNextResult();
        $query2 = 'CALL GetCarrierChargeProm("' . strtolower($name) . '",' . HOURDB . ');';
        $result2 = $conexion->consulta($query2);
        $conexion->prepareNextResult();
        if (!$result or !$result1 or !$result2) {
            throw new Exception("No se logro obtener informacion de cobros....\n");
        } else {
            $cont = 0;
            @($hoy = $conexion->fetch_row($result));
            @($ayer = $conexion->fetch_row($result1));
            @($prom = $conexion->fetch_row($result2));
            while ($cont <= $fecha) {
                if ($ayer[1] == $cont and $ayer[1] != '') {
                    @($valor = $ayer[0]);
                    @($ayer = $conexion->fetch_row($result1));
                } else {
                    $valor = 0;
                }
                if ($hoy[1] == $cont and $hoy[1] != '') {
                    @($valor1 = $hoy[0]);
                    @($hoy = $conexion->fetch_row($result));
                } else {
                    $valor1 = 0;
                }
                if ($prom[1] == $cont and $prom[1] != '') {
                    @($valor2 = $prom[0]);
                    @($prom = $conexion->fetch_row($result2));
                } else {
                    $valor2 = 0;
                }
                $dataArray = $dataArray . "data" . $num . ".addRow([" . $cont . ", " . number_format($valor2, 0, '', '') . ", " . $valor . " , " . $valor1 . "]);\n";
                //$dataArray = $dataArray."data1.addRow([".$cont.", ".$valor2.",".$valor.", ".$valor1."]);\n";
                $cont++;
            }
            /*while ($hoy = $conexion->fetch_row($result)){
                if( @$ayer  = $conexion->fetch_row($result1) and
                    @$prom1 = $conexion->fetch_row($result2)){
                    if($hoy[0]    == ''){$hoy[0]    = 0;}
                    if($ayer[0]   == ''){$ayer[0]   = 0;}
                    if($prom1[0]  == ''){$prom1[0]  = 0;}
                    $dataArray = $dataArray."data".$num.".addRow([".$hoy[1].", ".number_format($prom1[0],0,'','').", ".$ayer[0]." , ".$hoy[0]."]);\n";
                }
              }*/
        }
        $conexion->MySQLClose();
    } catch (Exception $e) {
        echo 'Excepcion capturada: ', $e->getMessage(), "\n";
    }
    return $dataArray;
}

 function disable()
 {
     if (isset($_POST["key"]) and isset($_POST["key2"])) {
         $conexion = new MySQL(0);
         $strIngreso = "update usuario set status = '" . $_POST["key2"] . "' where Id_usuario = '" . $_POST["key"] . "';";
         $value = $conexion->consulta($strIngreso);
         $conexion->MySQLClose();
         $_SESSION['value'] = 'El usuario fue dado de baja.';
         session_write_close();
         echo 'http://' . URL . DS . 'usuario' . DS . 'delete';
         //exit(header( 'Location: http://'.URL.DS.'superagregador'.DS.'delete'));
     } else {
         $_SESSION['value'] = "error";
         session_write_close();
         echo 'http://' . URL . DS . 'usuario' . DS . 'delete';
         //exit(header( 'Location: http://'.URL.DS.'superagregador'.DS.'delete'));
     }
 }

 function GetCharges($db_selection, $query, $opt, $SaveAction)
 {
     if (isset($db_selection) and isset($query)) {
         try {
             $conectorLocal1 = new MySQL(0);
             $dbdata = "call GetDBKey(" . $db_selection . ");";
             $exec = $conectorLocal1->consulta($dbdata);
             $conectorLocal1->prepareNextResult();
             $result = $conectorLocal1->fetch_row($exec);
             self::MySQLExternal($result[1], $result[2], $result[3], $this->schema);
             if (!$this->ErrorExternalConector) {
                 $execute = self::externalQuery($query);
                 $i = 0;
                 while ($row = self::externalfetch_row($execute)) {
                     switch ($opt) {
                         case 1:
                             $LoadCant = 0;
                             if ($row[0] != "") {
                                 $LoadCant = $row[0];
                             }
                             self::AddBodyLog("Cobros generados: " . $LoadCant);
                             self::AddBodyLog("Enviando a guardar informacion...........");
                             self::SaveCharges($row, $opt, $SaveAction);
                             break;
                         case 2:
                             self::AddBodyLog("Cobros generados para " . $row[1] . ": " . $row[2]);
                             self::AddBodyLog("Enviando a guardar informacion...........");
                             self::SaveCharges($row, $opt, $SaveAction);
                             $i++;
                             break;
                         case 3:
                             $LoadCant = 0;
                             if ($row[0] != "") {
                                 $LoadCant = $row[0];
                             }
                             $dbdata = "call GetAVGChargesPerCarrier(" . $this->id_carrier . ",2);";
                             $exec = $conectorLocal1->consulta($dbdata);
                             $result = $conectorLocal1->fetch_row($exec);
                             $info[0] = $row[0];
                             $info[1] = $result[0];
                             self::AddBodyLog("Obteniendo Promedio de cobros " . $dbdata . ": " . $result[0]);
                             self::AddBodyLog("Cobros generados: " . $LoadCant);
                             self::AddBodyLog("Enviando a guardar informacion...........");
                             self::SaveCharges($info, $opt, $SaveAction);
                             break;
                         case 4:
                             self::AddBodyLog("Cobros generados para " . $row[2] . ": " . $row[3]);
                             self::AddBodyLog("Enviando a guardar informacion...........");
                             self::SaveCharges($row, $opt, $SaveAction);
                             $i++;
                             break;
                             break;
                     }
                 }
                 if ($opt == 2) {
                     self::AddBodyLog("Integradores Procesados: " . $i);
                 }
                 if ($opt == 4) {
                     self::AddBodyLog("Productos Procesados: " . $i);
                 }
             }
             $conectorLocal1->MySQLClose();
         } catch (Exception $e) {
             self::AddBodyLog("No se logro obtener la informacion de " . $this->carrier_name . " Validar conexion a Base de datos!!!!!!!!!!!!!!!");
             self::AddBodyLog("Trace " . $this->ErrorExternalConector);
         }
     }
 }

 public static function getlogged($name)
 {
     $conexion = new MySQL(0);
     $query = "select logged, date_logged,session_id,now() as fe from usuario where usuario = '{$name}'";
     $result1 = $conexion->consulta($query);
     $valor = $conexion->num_rows($result1);
     if ($valor == 1) {
         $row = $conexion->fetch_row($result1);
         $value1 = $row[0];
         $value2 = $row[1];
         $value3 = $row[2];
         $ahora = $row[3];
         $tiempo_transcurrido = strtotime($ahora) - strtotime($value2);
         if ($tiempo_transcurrido >= 875) {
             $query = "update usuario set logged = 0, date_logged = now() where usuario = '{$name}';";
             $result1 = $conexion->consulta($query);
             $value1 = 0;
         } else {
             if (isset($_COOKIE['billing'])) {
                 if ($_COOKIE['billing'] == $value3) {
                     $query = "update usuario set logged = 0, date_logged = now(),session_id = '' where usuario = '{$name}';";
                     $result1 = $conexion->consulta($query);
                     setcookie('billing', null, -1, '/');
                     $value1 = 0;
                 }
             } else {
                 if ($value1 != 0) {
                     $value1 = 1;
                 }
             }
         }
         if ($value1 == 1) {
             $return = "islogged";
         } else {
             $return = "notlogged";
         }
         $conexion->MySQLClose();
         return $return;
     } else {
         $conexion->MySQLClose();
         return "not.found";
     }
 }

 private function GetArrayInfo($option, $mensaje)
 {
     $conexion = new MySQL(0);
     $query = "call GetDescriptionInfo('" . $option . "');";
     $exec = $conexion->consulta($query);
     $row2 = $conexion->fetch_row($exec);
     $return = array("Titulo" => "Billing Vas Pass", "mensaje" => $mensaje, "name1" => strtolower($row2[0]), "data1" => "", "pais" => $row2[1], "schema" => $row2[2], "bd_id" => $row2[3]);
     $conexion->MySQLClose();
     return $return;
 }