<?php session_start(); require "accrp.php"; require "security/secure.php"; beginDocument("Main", $sess_user); $db = getDBConnection(); beginPrettyTable("2", "Backup"); deldir("/tmp/accrpexport/"); mkdir("/tmp/accrpexport", 0333); # 0333 does not work properly :-( so chmod ... chmod("/tmp/accrpexport", 0733); $result = mysql_query("SHOW TABLES FROM {$DBNAME}"); checkMySQLError(); while ($row = mysql_fetch_array($result, $db)) { $tablename = $row["Tables_in_accrp"]; $filename = "/tmp/accrpexport/" . $tablename . ".txt"; $query = "SELECT * FROM {$tablename} INTO OUTFILE \"{$filename}\""; $result2 = mysql_query($query, $db); checkMySQLError($query); } $today = get_today_srd_string(); $backup_filename = "accrp-datadump-{$today}.tar.gz"; exec("tar -czf /tmp/accrpexport/{$backup_filename} /tmp/accrpexport/*"); $doc_root = $_SERVER["DOCUMENT_ROOT"]; copy("/tmp/accrpexport/{$backup_filename}", "{$doc_root}/crp/backups/{$backup_filename}"); echo "<a href=\"backups/{$backup_filename}\"> click here to download datadump</a>"; endDocument();
checkMySQLError(); mysqlReport($result, "Employer sucessfully updated", "main.php", "Home"); mysql_close($db); } else { $query = "INSERT INTO PERSONAL (EMP_NAME, DESIG_ID, STATUS, AC_NO, CONF_DT,JOIN_DT) VALUES ('{$emp_name}','{$desig_id}','{$status}', '{$ac_no}', '{$conf_dt}','{$join_dt}')"; echo $query; $result = mysql_query($query, $db); checkMySQLError(); mysqlReport($result, "Employer sucessfully added", "main.php", "Home"); mysql_close($db); } } else { $db = getDBConnection(); if ($EMP_ID3) { $result = mysql_query("select * from PERSONAL where EMP_ID3 = {$EMP_ID3}"); checkMySQLError(); $edit = mysql_fetch_array($result); } $desig_array = get_designation_array(); ?> <table cellpadding=5 cellspacing=0 border=0 width='100%'> <tr> <td valign=top width='15%'> <?php beginPrettyTable("1"); ?> <tr> <?php echo "<td><a href='list_personal.php'>show List</a></td>";
function Accounts($where_clause, $startdate, $enddate, $type_string) { $this->whereClause = $where_clause . " AND " . get_whereclause_for_accounts($type_string); $this->startdate = $startdate; $this->enddate = $enddate; $this->sum = 0; $this->finish_flag = 0; $db = getDBConnection(); $query = "SELECT * FROM `AC_CODE5` WHERE {$this->whereClause}"; #echo "$query<br>"; $this->result = mysql_query($query, $db); checkMySQLError("Accounts"); }