include("blocks/sql_function.php"); $mysqli = ConnectDB(); // require("blocks/sql_connect.php"); // соединение ?>
if (isset($_GET['file'])) {$file = $_GET['file'];} $query = "select person.name p_name, job.name j_name, org.name o_name, doc.date, doc.number, doc.comment from person left join hire on hire.person_id = person.id left join job on job.id = hire.job_id left join org on org.id = hire.org_id left join doc on doc.hire_id = hire.id where doc.file = '$file'"; $result= $mysqli->query($query); CheckResult($result,$query); $row = $result->fetch_row(); $doc = "Архивный документ №".$row[4]." от ".$row[3]; $autor = $row[0]; $pos = $row[1]; $org = $row[2]; $com = $row[5]; PRINT "
PRINT "".$doc.""; PRINT "Автор: ".$autor; PRINT "Должность: ".$pos; PRINT " Организация: ".$org; PRINT " ".$com; PRINT "
| |||||
|
|||||