exec('CREATE TABLE IF NOT EXISTS USERS(id INT PRIMARY KEY,NAME TEXT,USERNAME TEXT,PASSWORD TEXT,LOGO TEXT)'); $rows = $db_check1->query('SELECT COUNT(*) as count FROM USERS'); $row = $rows->fetchArray(); $numRows = $row['count']; if ($numRows == 0) { $db_check1->exec('INSERT INTO USERS(id,NAME,USERNAME,PASSWORD,LOGO) VALUES(\'1\',\'Your Name\',\'admin\',\'admin\',\'img/logo.png\')'); } $res_login = $db_check1->query('SELECT * '."\n\t\t\t\t".' FROM USERS '."\n\t\t\t\t".' WHERE id=\'1\''); $row_login = $res_login->fetchArray(); $name_login = $row_login['NAME']; $logo_login = $row_login['LOGO']; if (isset($_POST['login'])) { $sql_check = 'SELECT * from USERS where USERNAME="'.$_POST['username'] .'"'; $ret_check = $db_check1->query($sql_check); while ($row_check = $ret_check->fetchArray()) { $id_check = $row_check['id']; $NAME = $row_check['NAME']; $USERNAME = $row_check['USERNAME']; $PASSWORD = $row_check['PASSWORD']; $LOGO_check = $row_check['LOGO']; } if (empty($id_check)) { $message = '
Time Of Arrival: "'; // echo date('d-m-Y H:i:s'); // echo '"
'."\n"; // echo "\t\t\t\t".'IP Address: "'; // echo real_ip(); // echo ' "
'."\n"; // echo "\t\t\t".'