/**
* Constructor for FPBDatabase object - sets up database connections
*
* Assumes database credentials have been defined
*
* Private for singleton pattern
* @return void
* @access private
* @see FPB_DB_HOST
* @see FPB_DB_USER
* @see FPB_DB_PASS
* @see FPB_DB_NAME
* @see FPB_DB_PREFIX
*/
private function __construct()
{
if (!($this->_sql_link_id = mysql_connect(FPB_DB_HOST, FPB_DB_USER, FPB_DB_PASS))) {
trigger_error('Could not connect to MySQL database: ' . mysql_error());
}
if (!mysql_select_db(FPB_DB_NAME)) {
trigger_error('Coult not select MySQL database: ' . myql_error());
}
}
$verbindung = mysql_connect($db_server, $db_user, $db_userpw);
//alle InputFelder = Variablen
if ($_POST['angestellt'] == 'Volzeit') {
$angestellt = '1';
} else {
$angestellt = '2';
}
$nachname = $_POST['nachname'];
$vorname = $_POST['vorname'];
$rang = $_POST['rang'];
$gehalt = $_POST['gehalt'];
$urlaubstage = $_POST['urlaubstage'];
mysql_select_db($db_name) or die(mysql_error());
$ergebnis = mysql_db_query($db_name, "select * from mitarbeiter") or die(mysql_error());
$start = mysql_num_rows($ergebnis) or die(mysql_error());
mysql_query("INSERT INTO mitarbeiter (Name, Vorname, Anstellung, Urlaubstage, Rang, Gehalt) VALUES ('{$nachname}', '{$vorname}', '{$angestellt}', '{$urlaubstage}', '{$rang}', '{$gehalt}');") or die($error = myql_error());
$ergebnis2 = mysql_db_query($db_name, "select * from mitarbeiter") or die(mysql_error());
$anzahl = mysql_num_rows($ergebnis2) or die(mysql_error());
if ($anzahl > $start) {
// $ma_nummer = mysql_query("SELECT COUNT(name)FROM mitarbeiter");
echo 'Es wurde erfolgreich ein neuer Mitarbeiter hinzugefügt.<br/>';
// echo 'Es war der ';
// echo $ma_nummer;
// echo '. Mitarbeiter.';
} else {
echo "Es wurde keine Mitarbeiter angelegt.";
echo $error;
}
}
?>
</div>
$totAfdTdkLang[$rKaryStaff['subbagian']] += $rKaryStaff['total'];
$totAfdTdkLangJen[$rKaryStaff['subbagian']][$rKaryStaff['jeniskelamin']] += $rKaryStaff['total'];
}
}
$sKaryStaff2 = "select distinct count(karyawanid) as total,jeniskelamin from " . $dbname . ".datakaryawan where " . $addTmb . " and \r\n subbagian not in (select distinct kodeorganisasi from " . $dbname . ".organisasi where induk='" . $kdUnit . "') and substr(tanggalmasuk,1,7)<='" . $periode . "' and \r\n (substr(tanggalkeluar,1,7)>'" . $periode . "' or substr(tanggalkeluar,1,7)='0000-00') and \r\n kodejabatan NOT in(24,35,37,38,48,52,53,54,55,118,119,120,121,122,123,132,136,138,60,168,45,88) and tipekaryawan in (2,3) group by jeniskelamin";
$qKaryStaff2 = mysql_query($sKaryStaff2) or die(mysql_error());
while ($rDataStaff = mysql_fetch_assoc($qKaryStaff2)) {
$grRowLainKht3[$kdUnit] += $rDataStaff['total'];
$totRowLainKht3[$kdUnit][$rDataStaff['jeniskelamin']] += $rDataStaff['total'];
$totKanBes += $rDataStaff['total'];
$totKanBesJen[$kdUnit][$rDataStaff['jeniskelamin']] += $rDataStaff['total'];
}
//###################//
//### Query pekerja tidak langsung lain-lain khl####//
$sTotKhtL = "select distinct count(karyawanid) as total,jeniskelamin from " . $dbname . ".datakaryawan where " . $addTmb . " and kodejabatan NOT in(24,35,37,38,48,52,53,54,55,118,119,120,121,122,123,132,136,138,60,168,45,88) \r\n and tipekaryawan in (4) and substr(tanggalmasuk,1,7)<='" . $periode . "' and (substr(tanggalkeluar,1,7)>'" . $periode . "' or substr(tanggalkeluar,1,7)='0000-00') group by jeniskelamin";
$qTotKhtL = mysql_query($sTotKhtL) or die(myql_error());
while ($rTotKhtL = mysql_fetch_assoc($qTotKhtL)) {
$grRowLainKhl[$kdUnit] += $rTotKhtL['total'];
$totRowLainKhl[$kdUnit][$rTotKhtL['jeniskelamin']] += $rTotKhtL['total'];
$totTdkLang += $rTotKhtL['total'];
$totTdkLangJen[$kdUnit][$rTotKhtL['jeniskelamin']] += $rTotKhtL['total'];
}
foreach ($dataAfd as $kdAfd) {
$sKaryStaff = "select distinct count(karyawanid) as total,jeniskelamin,subbagian from " . $dbname . ".datakaryawan where " . $addTmb . " and subbagian='" . $kdAfd . "' \r\n and kodejabatan NOT in(24,35,37,38,48,52,53,54,55,118,119,120,121,122,123,132,136,138,60,168,45,88) and tipekaryawan in (4) and substr(tanggalmasuk,1,7)<='" . $periode . "' and \r\n (substr(tanggalkeluar,1,7)>'" . $periode . "' or substr(tanggalkeluar,1,7)='0000-00') group by jeniskelamin,subbagian";
$qKaryStaff = mysql_query($sKaryStaff) or die(mysql_error());
while ($rKaryStaff = mysql_fetch_assoc($qKaryStaff)) {
$grRowLainKhl2[$rKaryStaff['subbagian']] += $rKaryStaff['total'];
$totRowLainKhl2[$rKaryStaff['subbagian']][$rKaryStaff['jeniskelamin']] += $rKaryStaff['total'];
$totAfdTdkLang[$rKaryStaff['subbagian']] += $rKaryStaff['total'];
$totAfdTdkLangJen[$rKaryStaff['subbagian']][$rKaryStaff['jeniskelamin']] += $rKaryStaff['total'];
}
DEFINE('DBNAME', 'csashesi_mohammed-abdulai');*/
DEFINE('DBUSER', 'root');
DEFINE('DBPW', 'Dream1234');
DEFINE('DBHOST', 'localhost');
DEFINE('DBNAME', 'datasaver');
$username = "";
$password = "";
$errorMessage = "";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// $username = test_input($_POST[username]);
// $pword = test_input($_POST[password]);
$username = $_POST[username];
$pword = md5($_POST[password]);
$conn = mysql_connect(DBHOST, DBUSER, DBPW);
if (!$conn) {
die('Could not connect: ' . myql_error());
}
$db_conn = mysql_select_db(DBNAME, $conn);
if ($db_conn) {
$query = "SELECT username, firstname, lastname, email, phone FROM data_saver_users WHERE username='******' AND password='******'";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
$info = mysql_fetch_assoc($result);
//check to see if the $result variable is true
if ($result) {
if ($num_rows > 0) {
session_start();
$_SESSION['login'] = "******";
$_SESSION['username'] = $info["username"];
$_SESSION['firstname'] = $info["firstname"];
$_SESSION['lastname'] = $info["lastname"];
