mirror of
https://gitlab.com/harald.mueller/aktuelle.kurse.git
synced 2024-10-18 17:35:03 +02:00
65 lines
2.1 KiB
PHP
65 lines
2.1 KiB
PHP
<?php
|
|
/*************************************************/
|
|
/** M133 DB DB Connection **/
|
|
/** Author: M. von Orelli **/
|
|
/** Datum: 5. 3.2014 **/
|
|
/** Version: 1.0 **/
|
|
/** Applikation: Theorie **/
|
|
/** **/
|
|
/** Filename: login.php **/
|
|
/** Include Files: **/
|
|
/*************************************************/
|
|
|
|
/*************************************************/
|
|
/* Datum ¦ Aenderung **/
|
|
/* 13.03.14¦ **/
|
|
/* ¦ **/
|
|
/* ¦ **/
|
|
/* ¦ **/
|
|
/* ¦ **/
|
|
/*************************************************/
|
|
|
|
/** INSERT INTO `tbl_user` (`username`, `password`, `nachname`, `vorname`, `strasse`, `e_mail`, `fk_authorisation`) VALUES
|
|
(md5('vonorellim', md5('Gugus'), 'von Orelli', 'Matthias', 'Seestrasse', 'test@tbz.ch', 3);
|
|
**/
|
|
|
|
// require_once("./include/function.inc");
|
|
require_once("./include/db_connection.inc");
|
|
// $dbcon = mysql_connect("localhost","M133","M133")
|
|
// or die("Datenbankverbindung ist fehlgeschlagen!");
|
|
// mysql_select_db("login",$dbcon);
|
|
$cName = "vonorellim";
|
|
$cPassword = "Gugus";
|
|
|
|
$cName = $_POST['username'];
|
|
$cPassword = $_POST['password'];
|
|
|
|
$Query = "Select username, password from tbl_user where username=md5('$cName') AND password=md5('$cPassword')";
|
|
|
|
$result = mysql_query($Query );
|
|
|
|
if ($result)
|
|
{
|
|
$num_rows = mysql_num_rows($result);
|
|
if ($num_rows > 0)
|
|
{
|
|
$loginstatus="login successfull";
|
|
while($row=mysql_fetch_array($result))
|
|
{
|
|
$uname=$row["username"]; // angenommen die Datenbank hat eine Spalte namens VName
|
|
$password=$row["password"]; // angenommen die Datenbank hat eine Spalte namens GName
|
|
echo ("<option>$uname $password<br></option>");
|
|
|
|
}
|
|
}
|
|
else
|
|
$loginstatus="login unsuccessfull";
|
|
}
|
|
|
|
|
|
// $login_status = check_user_password($connectionstring , $cName, $cPassword);
|
|
|
|
echo "<br>Loginstatus: ".$loginstatus;
|
|
|
|
|