function read($fname)
{
$xls = PHPExcel_IOFactory::load($fname);
$xls->setActiveSheetIndex(0);
$sheet = $xls->getActiveSheet();
$nRow = $sheet->getHighestRow();
$nColumn = PHPExcel_Cell::columnIndexFromString($sheet->getHighestColumn());
$arr = [];
for ($i = 1; $i <= $nRow; $i++) {
for ($j = 0; $j <= $nColumn; $j++) {
$row[$j] = trim($sheet->getCellByColumnAndRow($j, $i)->getValue());
}
if ($row[0] != '') {
$pass = generate_password(6);
$var = explode(' ', trim($row[0]));
$fio = array();
foreach ($var as $word) {
if ($word != '') {
$fio[] = trim($word);
}
}
$fam = $fio[0];
$name = $fio[1];
$otch = $fio[2];
$email = trim($row[1]);
$ou = trim($row[2]);
$arr[] = ['fam' => $fam, 'name' => $name, 'otch' => $otch, 'email' => $email, 'phone' => '', 'login' => getLogin($fam, $name, $otch), 'password' => $pass, 'password_md5' => md5($pass), 'mr' => '', 'ou' => $ou];
} else {
}
}
return $arr;
}
function Main()
{
global $TPLV, $urls, $usuario, $imovel;
$TPLV = new TemplatePower(TEMPLATE_PATH . "login.tpl");
$TPLV->assignGlobal("uploadPath", UPLOAD_PATH);
$TPLV->assignGlobal("imagePath", IMAGE_PATH);
$TPLV->assignGlobal("swfPath", SWF_PATH);
$TPLV->assignGlobal("localPath", LOCAL_PATH);
$TPLV->assignGlobal('navBottom', $bottom);
$TPLV->assignGlobal($urls->var);
$TPLV->prepare();
$in = $_GET['in'];
switch ($in) {
//FILTROS DE BUSCAS
default:
case 'deletaUsuario':
deletaUsuario();
break;
case 'deletaMidia':
deletaMidia();
break;
//LOGIN E RECUPERA SENHA
//LOGIN E RECUPERA SENHA
case 'getLogin':
getLogin();
break;
case 'login':
login();
break;
case 'getSenha':
getSenha();
break;
case 'recuperaSenha':
recuperaSenha();
break;
case 'isLogado':
if ($usuario->isLogado()) {
echo 'logado';
} else {
echo 'erro';
}
break;
//CADASTRO
//CADASTRO
case 'validaEmailCadastro':
validaEmailCadastro();
break;
//LEADS DETALHES
//LEADS DETALHES
case 'getCadastro':
getCadastro();
break;
case 'salvarCadastro':
salvarCadastro();
break;
case 'verificaCPF':
verificaCPF();
break;
}
}
function login()
{
require_once 'modulos/principal/modelos/login.php';
if (isset($_POST['pagina'])) {
$pagina = $_POST['pagina'];
} else {
$pagina = "/";
}
if (isset($_POST['usuario']) && isset($_POST['password'])) {
$usuario = $_POST['usuario'];
$password = md5($_POST['password']);
$num = getLogin($usuario, $password);
if ($num == 0) {
//no hay usuario correcto
setSessionMessage("<h4 class='error'>Nombre de usuario y/o contraseña incorrectos</h4>");
} else {
require_once 'modulos/usuarios/modelos/usuarioModelo.php';
$usuarios = getUsuarios();
if (isset($_POST['recuerdame']) && $_POST['recuerdame'] == 1) {
//Guardamos la cookie para recordar
$tiempo = 2592000;
//tiempo que va a durar la cookie, 30 días
$clv = $password;
setcookie("email", $usuario, time() + $tiempo);
setcookie("clv", $clv, time() + $tiempo);
}
}
}
redirect($pagina);
}
public static function getHiddenFormHtml($action, $identifiant, $buttonText)
{
$htmlCode = FormManager::beginForm("post", $action);
$htmlCode .= FormManager::addHiddenInput("login", "login", html_entity_decode($identifiant > getLogin(), ENT_QUOTES, "UTF−8"));
$htmlCode .= FormManager::addHiddenInput("mdp", "mdp", html_entity_decode($identifiant > getMdp(), ENT_QUOTES, "UTF−8"));
$htmlCode .= FormManager::addSubmitButton($buttonText, "class=\"sansLabel\"");
$htmlCode .= FormManager::endForm();
return $htmlCode;
}
function PHPMailer($toAddr, $subject, $htmlmessage, $message)
{
$mail = new PHPMailer();
$login = getLogin();
$mail->isSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->SMTPAuth = true;
$mail->Username = $login['un'];
$mail->Password = $login['pw'];
$mail->SMTPSecure = 'ssl';
$mail->Port = 465;
$mail->From = '*****@*****.**';
$mail->FromName = 'ADK46er Correspondence Website';
$mail->addAddress($toAddr);
$mail->isHTML(true);
$mail->Subject = $subject;
$mail->Body = $htmlmessage;
$mail->AltBody = $message;
$mail->send();
}
/**
* Validate the identity of the user using BrowserID
* If the assertion is valid then the email address is stored in session with a random key to prevent XSRF.
*
* @param string $assertion Assertion from BrowserID.org
* @param string $audience Audience from BrowserID.org
* @return boolean
*/
public function login($provider, $params)
{
$email = getLogin($provider)->verifyEmail($params);
if ($email === false) {
return false;
}
$this->setEmail($email);
return true;
}
<?php
require __DIR__ . '/../../../vendor/autoload.php';
use Nostromo\Models\MConnexion;
function getLogin($email, $pwd)
{
$conn = MConnexion::getBdd();
$resultats = $conn->prepare('SELECT * FROM client WHERE mailClt = ? AND mdpClt = ?');
$resultats->execute([$email, sha1($pwd)]);
$resultats->setFetchMode(PDO::FETCH_OBJ);
return $resultats->fetch();
}
$user = getLogin($_GET['email'], $_GET['pwd']);
header('Content-Type: application/json');
echo utf8_encode(json_encode(['result' => $user]));
function getUser()
{
global $forbidUserSettings;
return !$forbidUserSettings ? getLogin() : '';
}
if ($user) {
//tenemos un usuario logeado en facebook
//Datos de facebook
$email = $user_info['email'];
$nombre = $user_info['name'];
require_once 'modulos/principal/modelos/login.php';
require_once 'modulos/usuarios/modelos/usuarioModelo.php';
//validamos si este usuario ya tiene su email registrado, sino creamos un usuario nuevo
$usuario = getUsuarioFromEmail($email);
if (!isset($usuario) || $usuario->email == "") {
//el usuario no existe en la bd, crearlo!
require_once 'modulos/usuarios/clases/Usuario.php';
require_once 'modulos/principal/modelos/login.php';
require_once 'modulos/usuarios/modelos/usuarioModelo.php';
$usuario = new Usuario();
$usuario->email = $email;
$usuario->habilitado = 1;
$usuario->password = md5(getUniqueCode(10));
$usuario->tipo = 0;
$id = crearUsuario($usuario);
$usuario->idUsuario = $id;
}
//el usuario ya existe en la bd, loggearlo!
getLogin($usuario->email, $usuario->password);
//Redireccionarlo a la página
if (isset($_SESSION['paginaLoginFacebook'])) {
$pagina = $_SESSION['paginaLoginFacebook'];
redirect($pagina);
$_SESSION['paginaLoginFacebook'] = null;
}
}
<?php
require_once "includes/dblib.php";
$access = getLogin($_POST['login'], $_POST['password']);
if ($access != false) {
session_start();
$_SESSION['login'] = $access;
header("Location: main.php");
} else {
header("Location: cms.php?error");
}
?>
<?php
$pagina = getUrl();
if (isset($_COOKIE['email']) && isset($_COOKIE['clv'])) {
require_once 'modulos/principal/modelos/login.php';
getLogin($_COOKIE['email'], $_COOKIE['clv']);
}
if (isset($_SESSION['email'])) {
if (isset($_SESSION['habilitado']) && $_SESSION['habilitado'] != '1') {
}
$aux = explode("@", $_SESSION['email']);
$nombreDePila = $aux[0];
?>
<div class="row-fluid">
<div class="span6">
<div class="saludoTextRed">
Hola <?php
echo $nombreDePila;
?>
!!
</div>
</div>
<div class="span6 headerSocial">
<div class="span5 centerText">
<a href="https://twitter.com/eFoodMX" class="socialRedText" target="_blank">
<img src="layout/imagenes/Home/twitterCheff.png"><br>
<span >Síguenos</span>
</a>
</div>
<div class="span7 centerText">
<a href="http://www.facebook.com/eFoodMX" class="socialRedText" target="_blank">
<?php
header("Content-Type: text/html; charset=utf-8");
require "truefalse.php";
if (!empty($_POST)) {
$username = $_POST['username'];
$password = $_POST['password'];
$result = getLogin($username, $password);
if (preg_match("/(你输入的密码错误，你输入的密码是)(.*)]/", $result, $matches)) {
// print_r($matches);
echo "<div align=\"center\">{$matches['0']}</div>";
echo "<div align=\"center\"><a href=\"javascript:top.location.href='login.php';\">点击进入登陆页面</a></div>";
} else {
session_start();
$_SESSION['username'] = $username;
$_SESSION['password'] = $password;
$_SESSION['hiddenfild'] = getHidden();
// echo $_SESSION['username'];
// echo "登录成功";
echo "<script>alert('登录成功！');window.location.href='index.php';</script>";
}
}
?>
<form name="form1" method="post">
<div><font size="2" color="#006666">学号：</font><input name="username" type="text" size="15" value="12401241"></div>
<div><font size="2" color="#006666">密码：</font><input name="password" type="password" size="15"></div>
<div>
<input type="submit" value=" 登 录 ">
<input type="reset" value=" 重 写 ">
</div>
if ($username == null) {
return $app->redirect("/login");
}
$posts = $dbConnection->fetchAll("SELECT * FROM blog_post");
return $templating->render('blog.all.html.twig', array('active' => 'blog', 'posts' => $posts, 'loggedIn' => true));
});
$app->get('/blog/{id}', function ($id) use($templating, $dbConnection, $app) {
$username = getLogin($app)["username"];
if ($username == null) {
return $app->redirect("/login");
}
$post = $dbConnection->fetchAssoc("SELECT * FROM blog_post WHERE id=?", array($id));
return $templating->render('blog.edit.html.twig', array('active' => 'blog', 'post' => $post, 'loggedIn' => true));
});
$app->match('/new', function (Request $request) use($templating, $dbConnection, $app) {
$username = getLogin($app)["username"];
if ($username == null) {
return $app->redirect("/login");
}
//Überprüfen ob alle Felder ausgefüllt
$allFieldsCorrect = true;
if ($request->isMethod('POST')) {
if (!$request->get("title") || !$request->get("text")) {
//Fehlermeldung einblenden
$allFieldsCorrect = false;
}
}
$return_site = 'blog.new.html.twig';
if ($allFieldsCorrect == true && $request->isMethod('POST')) {
//Daten in DB schreiben
$dbConnection->insert("blog_post", array("title" => $request->get("title"), "text" => $request->get("text"), "created_at" => date("c"), "author" => $username));
$moyFrancais = 0;
// moyenne pour l'informatique
$moyInfo = 0;
// entête HTML du tableau
echo "<table>\n\t <tr>\n\t <th>Nom</th>\n\t <th>Login</th>\n\t <th>Français</th>\n\t <th>Maths</th>\n\t <th>Info</th>\n\t <th>Moyenne</th>\n\t </tr>";
// première boucle
$nbElem = count($tableau);
for ($i = 0; $i < $nbElem; $i++) {
echo "<tr>";
// pour la moyenne de l'élève
$moyenne = 0;
// boucle intérieure
foreach ($tableau[$i] as $cle => $elem) {
if ($cle == 'Nom') {
echo '<td>' . $elem . '</td>
<td>' . getLogin($elem) . '</td>';
} else {
echo '<td bgcolor="' . getCouleur($elem) . '">' . $elem . "</td>";
}
//calcul des moyennes
switch ($cle) {
case 'Francais':
$moyenne = $moyenne + $elem;
$moyFrancais += $elem;
//idem ligne du dessus
break;
case 'Maths':
$moyenne = $moyenne + $elem;
$moyMaths += $elem;
//idem ligne du dessus
break;
public function __construct()
{
$login = getLogin();
echo $login;
}
<?php
session_start();
require_once 'connectDB.php';
if (isset($_POST['login_submit'])) {
if ($_POST['password'] != '' && $_POST['username'] != '') {
$username = $_POST['username'];
$password = $_POST['password'];
$user = getLogin($username, $password);
if (sizeof($user) != 0) {
$check = setSession($user);
if ($check) {
if ($_SESSION['user'][2] == 0) {
header('Location: ../view/AdminUtama/index.php');
} else {
if ($_SESSION['user'][2] == 1) {
$id_masjid_admin = querySelect('*', 'masjid', 'id_user='******'user'][3], null);
var_dump($id_masjid_admin);
$_SESSION['id_masjid_admin'] = $id_masjid_admin[0]['id_masjid'];
header('Location: ../view/AdminMasjid/index.php');
}
}
}
} else {
header('Location: ../view/penggunaUmum/login.php?e=2');
}
} else {
header('Location: ../view/penggunaUmum/login.php?e=1');
}
} else {
if (isset($_GET['logout'])) {
