include_once './db_connect.php'; //подключаемся к базе $dbh = mysql_connect(host, user, pswd) or die("Не могу соединиться с MySQL."); mysql_select_db(SCAD) or die("Не могу подключиться к базе."); $res = mysql_query("SET NAMES utf8"); //обновляем узлы $nodes = new TNode(); $sql = "UPDATE " . document . " SET text = '" . $nodes->set_to_scad_txt() . "' WHERE id = " . D_node; mysql_query($sql); //обновляем элементы $members = new TMember(); $s = iconv('UTF-8', 'CP1251', $members->set_to_scad_txt()); $sql = "UPDATE " . document . " SET text = '{$s}' WHERE id = " . D_member; mysql_query($sql); //обновляем группы для подбора стали $groups_for_steel = new TMemberGroupSteel(); $s = iconv('UTF-8', 'CP1251', $groups_for_steel->set_to_scad_txt()); $sql = "UPDATE " . document . " SET text = '{$s}' WHERE id = " . D_member_group_for_steel; mysql_query($sql); //собираем документ $today = date("d.m.Y"); header("Content-Disposition: attachment; filename={$today}.txt"); header("Content-Type: application/octet-stream"); $sql = "SELECT * FROM " . document; mysql_query($sql); switch (mysql_errno()) { case 1146: echo "<b>Table " . document . " doesn't exist. Please create DB.</b><br>"; break; default: if (mysql_errno() > 0) {
$document[$doc_number] = $doc_content; } echo 'Загружены документы:<br/>'; // print_r($document); //разбираем группы элементов $TIMESTART = timeMeasure(); if (isset($document[D_member_group])) { $member_groups = new TMemberGroup(); $member_groups->get_from_scad_txt($document[D_member_group]); echo D_member_group . ' - группы элементов;<br/>'; } echo round(timeMeasure() - $TIMESTART, 6) . ' сек<br/>'; $TIMESTART = timeMeasure(); //разбираем группы для подбора стали if (isset($document[D_member_group_for_steel])) { $member_groups_for_steel = new TMemberGroupSteel(); $member_groups_for_steel->get_from_scad_txt($document[D_member_group_for_steel]); echo D_member_group_for_steel . ' - группы элементов для подбора;<br/>'; } echo round(timeMeasure() - $TIMESTART, 6) . ' сек<br/>'; $TIMESTART = timeMeasure(); //разбираем узлы if (isset($document[D_node])) { //замена переносов $document[D_node] = str_replace("\r\n", ' ', $document[D_node]); $document[D_node] = str_replace("\n", ' ', $document[D_node]); //замена двойных пробелов $document[D_node] = preg_replace("|\\s{2,}|", ' ', $document[D_node]); $nodes = new TNode(); $nodes->get_from_scad_txt($document[D_node]); echo D_node . ' - узлы;<br/>';