Пример #1
0
function getData($sql)
{
    $res = exeSQL($sql);
    $data = "";
    while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
        $item = "";
        foreach ($row as $key => $value) {
            $keyEn = rawurlencode($key);
            $valueEn = rawurlencode($value);
            $item = $item . $keyEn . "=" . $valueEn . " ";
        }
        if ($data == "") {
            $data = trim($item);
        } else {
            $data = $data . "#" . trim($item);
        }
    }
    return $data;
}
Пример #2
0
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php 
require "../dbase/dbFunction.php";
if (isset($_POST['submitLogin'])) {
    $userName = $_POST['UserName'];
    $password = $_POST['Password'];
    if (checkLogin($userName, $password)) {
        session_start();
        $_SESSION['UserName'] = $userName;
        $sql = "SELECT UserID FROM UserInfoTable WHERE UserName='******'";
        $res = exeSQL($sql);
        $row = mysql_fetch_array($res);
        $userID = $row['UserID'];
        $_SESSION['UserID'] = $userID;
        echo "<script type=text/javascript>window.location=\"/index.php\";</script>";
    }
}
?>

<html  xmlns="http://www.w3.org/1999/xhtml" lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="chrome=1">
    <link href="Login.css" rel='stylesheet' type='text/css' />
    <title>PicMap</title>
  </head>

  <body>
    
    
    <div class="LoginDiv">
Пример #3
0
function getUserName($userID)
{
    $sql = "SELECT UserName FROM UserInfoTable WHERE UserID='{$userID}'";
    $result = exeSQL($sql);
    $row = mysql_fetch_array($result);
    if (empty($row)) {
        return 0;
    } else {
        return $row[0];
    }
}
Пример #4
0
function setUserPos($name, $longitude, $latitude)
{
    global $dbHost, $dbUser, $dbPwd, $dbName;
    $tabName = $dbName . "_USER";
    $sql = "UPDATE {$tabName} SET longitude='{$longitude}', latitude='{$latitude}' WHERE name='{$name}'";
    $result = exeSQL($sql);
}
Пример #5
0
{
    $str = '<li><div class="AlbumItemDiv" id="AlbumItemDiv' . $index . '">' . '<div class="AlbumImgDivB1"></div>' . '<div class="AlbumImgDivB2"></div>' . '<div class="AlbumImgDiv">' . '  <img src="' . $imgPath . '" />' . '</div>' . '  <span class="AlbumItemTitle">' . $albumName . ' (' . $createTime . ')' . '</span>' . '</div></li>';
    return $str;
}
$sql = "SELECT * FROM AlbumTable WHERE UserID='{$homeUserID}'";
$res = exeSQL($sql);
$index = 0;
while ($row = mysql_fetch_array($res)) {
    $index = $index + 1;
    $albumID = $row['AlbumID'];
    $albumName = $row['AlbumName'];
    $createTime = date("Y/m/d", $row['CreateTime']);
    $picNum = $row['PicNum'];
    $facePicID = $row['FacePicID'];
    $sql2 = "SELECT PicPath FROM PicTable WHERE AlbumID={$albumID} LIMIT 0,1";
    $res2 = exeSQL($sql2);
    $row2 = mysql_fetch_array($res2);
    $facePicPath = $row2[0] . "_snap.jpg";
    $str = createAlbumItem($index, $albumName, $facePicPath, $createTime);
    printf($str);
}
?>
    
<!--
      <li>
	    <div class="AlbumItemDiv">
          <div class="AlbumImgDivB1" id="AlbumImg0"></div>
          <div class="AlbumImgDivB2" id="AlbumImg0"></div>
          <div class="AlbumImgDiv" id="AlbumImg0">
            <img src="/images/0.JPG" />
    	  </div>
Пример #6
0
if (isset($_GET['files'])) {
    $error = false;
    $files = array();
    $uploaddir = './uploads/';
    $random = substr(md5(rand()), 0, 4);
    substr(basename($file['name']), -3);
    foreach ($_FILES as $file) {
        if (substr(basename($file['name']), -3) == "csv") {
            if (move_uploaded_file($file['tmp_name'], $uploaddir . $random . "_" . basename($file['name']))) {
                $files[] = $uploaddir . $random . "_" . $file['name'];
                $filename = $uploaddir . $random . "_" . $file['name'];
                ///////////
                $handle = fopen($filename, "r");
                fgetcsv($handle, 100000, ",", "'");
                //loop through the csv file and insert into database
                do {
                    if ($data[0]) {
                        exeSQL("INSERT INTO rutas (mes, anio, estado_origen, estado_destino, ciudad_origen, ciudad_destino, transportadora, tipo_transporte, tipo_combustible, tipo_movimiento, costo, carga, rendimiento, diesel, tiempo) VALUES\n                (\n                    '" . addslashes($data[0]) . "',\n                    '" . addslashes($data[1]) . "',\n                    '" . addslashes($data[2]) . "',\n                    '" . addslashes($data[3]) . "',\n                    '" . addslashes($data[4]) . "',\n                    '" . addslashes($data[5]) . "',\n                    '" . addslashes($data[6]) . "',\n                    '" . addslashes($data[7]) . "',\n                    '" . addslashes($data[8]) . "',\n                    '" . addslashes($data[9]) . "',\n                    '" . addslashes($data[10]) . "',\n                    '" . addslashes($data[11]) . "',\n                    '" . addslashes($data[12]) . "',\n                    '" . addslashes($data[13]) . "',\n                    '" . addslashes($data[14]) . "'\n                )\n            ");
                    }
                } while ($data = fgetcsv($handle, 100000, ",", "'"));
                //////////
            } else {
                $error = true;
            }
        }
    }
    $data = $error ? array('error' => 'Ocurrio un error al subir el archivo, por favor verifique que el archivo tenga una extension .csv') : array('files' => $files);
} else {
    $data = array('success' => 'El archivo ha sido importado correctamente, recarge esta pagina para reflejar los cambios.', 'formData' => $_POST);
}
echo json_encode($data);
Пример #7
0
{
    $conexion = mysqli_connect("localhost", "mexicotr_sitex", "W5OQ%~9S_4(W", "mexicotr_sitex");
    return $conexion;
}
function disconnectDB($conexion)
{
    $close = mysqli_close($conexion);
    return $close;
}
function exeSQL($sql)
{
    //Creamos la conexión con la función anterior
    $conexion = connectDB();
    //generamos la consulta
    mysqli_set_charset($conexion, "utf8");
    //formato de datos utf8
    if (!($result = mysqli_query($conexion, $sql))) {
        die;
    }
    //si la conexión cancelar programa
    disconnectDB($conexion);
    //desconectamos la base de datos
}
$data = array();
if (isset($_GET['deleteidrow'])) {
    exeSQL("DELETE FROM rutas WHERE id = " . $_GET['deleteidrow']);
    $data = array('success' => 'Fila borrada correctamente, recarga la pagina para reflejar los resultados', 'formData' => $_POST);
} else {
    $data = array('success' => 'Error Borrando Fila', 'formData' => $_POST);
}
echo json_encode($data);