PHP Conectar::ruta方法代码示例

 public function estatus_user()
 {
     parent::conexion();
     $sql = sprintf("update usuarios set\r\n                status=%s\r\n                where\r\n                cve_usu=%s\r\n                ", parent::comillas_inteligentes($_POST["es"]), parent::comillas_inteligentes($_POST["cve"]));
     mysql_query($sql);
     header("Location: " . Conectar::ruta() . "c-secretaria/");
     exit;
 }

 public function actualizar_maes()
 {
     parent::conexion();
     $sql = sprintf("update maestros set\r\n                direccion_maes=%s,\r\n                telefono_maes=%s,\r\n                correo_maes=%s\r\n                where\r\n                cve_maes=%s\r\n                ", parent::comillas_inteligentes($_POST["dire"]), parent::comillas_inteligentes($_POST["tel"]), parent::comillas_inteligentes($_POST["correo"]), parent::comillas_inteligentes($_POST["cve"]));
     mysql_query($sql);
     header("Location: " . Conectar::ruta() . "c-maestros/e-1/v-" . $_POST["cve"] . "/");
     exit;
 }

 public function add_reservacion()
 {
     if (isset($_POST["dst"]) && isset($_POST["nombre"]) && isset($_POST["apellido"])) {
         parent::con();
         $sql = "CALL PA_DDRVN('" . $_POST["apellido"] . "','" . $_POST["dst"] . "','" . $_POST["nombre"] . "')";
         $res = mysql_query($sql) or die(mysql_error());
         if ($res) {
         } else {
             echo '<script type="text/javascript">window.location="' . Conectar::ruta() . '?verreservacion; </script>';
         }
     }
 }

 public function add_unidad()
 {
     if (isset($_POST["c1"]) && isset($_POST["c2"]) && isset($_POST["c3"]) && isset($_POST["c4"]) && isset($_POST["c5"])) {
         parent::con();
         $sql = "INSERT INTO unidad(placa,disponibilidad,id_tipo_unidad,matricula,tarjeta_circulacion) values('" . $_POST["c1"] . "','" . $_POST["c2"] . "','1','" . $_POST["c4"] . "','" . $_POST["c5"] . "')";
         $res = mysql_query($sql) or die(mysql_error());
         if ($res) {
             echo "<script type='text/javascript'>window.location='view/menu.phtml'</script>";
         } else {
             echo '<script type="text/javascript">window.location="' . Conectar::ruta() . '?verunidad&m=3"; </script>';
         }
     }
 }

 public function add_mpasajero()
 {
     $i = 1;
     $j = 0;
     if (isset($_POST["nom" . $i]) && isset($_POST["ape" . $i]) && isset($_POST["fec" . $i]) && isset($_POST["sx" . $i])) {
         parent::con();
         while (isset($_POST["nom" . $i]) && isset($_POST["ape" . $i]) && isset($_POST["fec" . $i]) && isset($_POST["sx" . $i])) {
             $sql = "INSERT INTO pasajeros(nombre,apellido,sexo,fec_nac) values('" . $_POST["nom" . $i] . "','" . $_POST["ape" . $i] . "','" . $_POST["sx" . $i] . "','" . $_POST["fec" . $i] . "')";
             $res = mysql_query($sql) or die(mysql_error());
             $i++;
             $j++;
         }
         $sql2 = "UPDATE reservacion_transporte SET costo = (SELECT F_COSTO_RES({$j})),num_personas={$j} WHERE id_reservacion = (SELECT F_ID_RES())";
         $res2 = mysql_query($sql2) or die(mysql_error());
         if ($res2) {
             $sql3 = "SELECT F_ID_RES()";
             $res3 = mysql_query($sql3) or die(mysql_error());
             $req = mysql_fetch_array($res3);
             echo '<script type="text/javascript">window.location="' . Conectar::ruta() . '?addreservacion&idres="' . $req["F_ID_RES"] . '"; </script>';
         } else {
             echo '<script type="text/javascript">window.location="' . Conectar::ruta() . '?addreservacion"; </script>';
         }
     }
 }

 public function npractica()
 {
     parent::conexion();
     $query = sprintf("insert into practicas \r\n                        values\r\n                        (null,%s,%s,0,%s,%s,%s,1);\r\n                        ", parent::comillas_inteligentes($_POST["cv_m"]), parent::comillas_inteligentes($_POST["img"]), parent::comillas_inteligentes($_POST["fcha"]), parent::comillas_inteligentes($_POST["des"]), parent::comillas_inteligentes($_POST["gpo"]));
     mysql_query($query);
     header("Location: " . Conectar::ruta() . "c-mini/e-3/");
     exit;
 }

 public function actualizar_alumnos()
 {
     parent::conexion();
     echo $sql = sprintf("update alumnos set\r\n                tel_al=%s,\r\n                obser_al=%s,\r\n\t\tcalle_al=%s,\r\n\t\tnum_al=%s,\r\n\t\tcol_al=%s,\r\n                estado_al=%s,\r\n\t\tmuni_al=%s\r\n                where\r\n                cve_alum=%s\r\n                ", parent::comillas_inteligentes($_POST["tele"]), parent::comillas_inteligentes($_POST["obser"]), parent::comillas_inteligentes($_POST["calle"]), parent::comillas_inteligentes($_POST["numero"]), parent::comillas_inteligentes($_POST["colo"]), parent::comillas_inteligentes($_POST["estado"]), parent::comillas_inteligentes($_POST["muni"]), parent::comillas_inteligentes($_POST["cve_a"]));
     mysql_query($sql);
     header("Location: " . Conectar::ruta() . "c-aini/v-6/");
     exit;
 }

 public function alta_grupo()
 {
     parent::conexion();
     $query = sprintf("insert into grupo \r\n                        values\r\n                        (null,%s,%s,%s,%s,%s,%s,%s,1);\r\n                        ", parent::comillas_inteligentes($_POST["nom_gpo"]), parent::comillas_inteligentes($_POST["maestro"]), parent::comillas_inteligentes($_POST["horario"]), parent::comillas_inteligentes($_POST["aula"]), parent::comillas_inteligentes($_POST["Laboratorio"]), parent::comillas_inteligentes($_POST["hl"]), parent::comillas_inteligentes($_POST["dia"]));
     mysql_query($query);
     header("Location: " . Conectar::ruta() . "c-grupos/");
     exit;
 }

<?php

session_start();
session_destroy();
header("location:" . Conectar::ruta() . "c-home/");

 public function login()
 {
     if (!empty($_POST["user"]) and !empty($_POST["pass"])) {
         parent::conexion();
         $sql = sprintf("select * from admin where login_dire='%s' and pass_dire='%s'", parent::comillas_inteligentes($_POST["user"]), parent::comillas_inteligentes($_POST["pass"]));
         $res = mysql_query($sql);
         if (mysql_num_rows($res) != 0) {
             while ($reg = mysql_fetch_array($res)) {
                 $_SESSION["admin"] = $reg["nombre_dire"] . " " . $reg["apellidos_dire"];
                 header("Location: " . Conectar::ruta() . "c-admin/");
                 exit;
             }
         } else {
             /////////////////////////
             parent::conexion();
             $sql = sprintf("select * from alumnos where login_al='%s' and pass_al='%s' and status_al!=0", parent::comillas_inteligentes($_POST["user"]), parent::comillas_inteligentes($_POST["pass"]));
             $res = mysql_query($sql);
             if (mysql_num_rows($res) != 0) {
                 while ($reg = mysql_fetch_array($res)) {
                     $_SESSION["nom_alumn"] = $reg["nombre_alum"] . " " . $reg["apellidos_al"];
                     $_SESSION["cve_alum"] = $reg["cve_alum"];
                     header("Location: " . Conectar::ruta() . "c-aini/");
                     exit;
                 }
             } else {
                 /////////////////////////
                 parent::conexion();
                 $sql = sprintf("select * from maestros where login_maes='%s' and pass_maes='%s' and status_maes!=0", parent::comillas_inteligentes($_POST["user"]), parent::comillas_inteligentes($_POST["pass"]));
                 $res = mysql_query($sql);
                 if (mysql_num_rows($res) != 0) {
                     while ($reg = mysql_fetch_array($res)) {
                         $_SESSION["nom_maes"] = $reg["nombre_maes"] . " " . $reg["apellido_maes"];
                         $_SESSION["cve_maes"] = $reg["cve_maes"];
                         header("Location: " . Conectar::ruta() . "c-mini/");
                         exit;
                     }
                 } else {
                     /////////////////////////
                     parent::conexion();
                     $sql = sprintf("select * from usuarios where login_usu='%s' and pass_usu='%s' and cve_cat_user=1 and status!=0", parent::comillas_inteligentes($_POST["user"]), parent::comillas_inteligentes($_POST["pass"]));
                     $res = mysql_query($sql);
                     if (mysql_num_rows($res) != 0) {
                         while ($reg = mysql_fetch_array($res)) {
                             $_SESSION["nom_se"] = $reg["nombre_usu"] . " " . $reg["apellidos_usu"];
                             $_SESSION["cve_se"] = $reg["cve_usu"];
                             header("Location: " . Conectar::ruta() . "c-sini/");
                             exit;
                         }
                     } else {
                         header("Location: " . Conectar::ruta() . "c-login/v-2/");
                         exit;
                     }
                     ////////////////////////
                 }
                 ////////////////////////
             }
             ////////////////////////
         }
     } else {
         header("Location: " . Conectar::ruta() . "c-login/v-1/");
         exit;
     }
 }

 public function desactivar_gpo()
 {
     if ($_POST["dia"] == "Lunes") {
         $d = 1;
     }
     if ($_POST["dia"] == "Martes") {
         $d = 2;
     }
     if ($_POST["dia"] == "Miercoles") {
         $d = 3;
     }
     if ($_POST["dia"] == "Jueves") {
         $d = 4;
     }
     if ($_POST["dia"] == "Viernes") {
         $d = 5;
     }
     if ($_POST["dia"] == "Sabado") {
         $d = 6;
     }
     if ($_POST["dia"] == "Domingo") {
         $d = 7;
     }
     parent::conexion();
     $sql = sprintf("update grupo set\r\n                    status_gpo=%s\r\n                    where\r\n                    cve_grupo=%s\r\n                    ", parent::comillas_inteligentes($_POST["es"]), parent::comillas_inteligentes($_POST["cve_grupo"]));
     mysql_query($sql);
     header("Location: " . Conectar::ruta() . "c-grupos/d2-{$d}/");
     exit;
 }