/** * 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"];