function adddata() { db_connect(); $maxidemployee = mysql_query("SELECT MAX(id_employee) AS maximum FROM employee"); $maxidemployee = mysql_fetch_array($maxidemployee); $newidemp = $maxidemployee[maximum] + 1; $maxidpost = mysql_query("SELECT MAX(id_post) AS maxpost FROM post"); $rang = mysql_query("SELECT id_post, rang FROM post ORDER BY id_post"); $prev = 0; $j = 0; $i = 0; while ($ran = mysql_fetch_array($rang)) { if ($i >= 1) { $prev = $curr; } $curr = $ran[rang]; if ($prev != $curr) { $rangmass[] = $ran[id_post]; $j++; } $i++; } $queryinsert = "INSERT INTO `employee` (`id_employee`, `fio`, `id_post`,`datestart`,`salary`, `id_boss`, `counter`) \n VALUES (" . $newidemp . ", 'Сотрудник1', " . $rangmass[0] . ", '" . gen_data() . "'," . rand(10900, 15000) . ",0,100)"; $idbossstart = $newidemp + 1; //rang 2 for ($i = 2; $i < 102; $i++) { $str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[1], $rangmass[2] - 1) . ", '" . gen_data() . "'," . rand(8000, 10000) . "," . ($idbossstart - 1) . ",1)"; } $idbossend = $newidemp; //rang 3 for ($i; $i < 603; $i++) { $str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[2], $rangmass[3] - 1) . ", '" . gen_data() . "'," . rand(6000, 8000) . "," . rand($idbossstart, $idbossend) . ",1)"; } //rang 4 $idbossstart = $idbossend; $idbossend = $newidemp; for ($i; $i < 903; $i++) { $str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[3], $rangmass[4] - 1) . ", '" . gen_data() . "'," . rand(5000, 7000) . "," . rand($idbossstart, $idbossend) . ",1)"; } //rang 5 $idbossstart = $idbossend; $idbossend = $newidemp; for ($i; $i < 1500; $i++) { $str_1 .= ",(" . ++$newidemp . ", 'Сотрудник" . $i . "', " . rand($rangmass[4], $maxidpost[maxpost]) . ", '" . gen_data() . "'," . rand(5000, 7000) . "," . rand($idbossstart, $idbossend) . ",1)"; } $queryinsert .= $str_1; mysql_query($queryinsert); if (mysql_errno() == 0) { echo "<p class='resultadd'>Данные успешно добавлены</p>"; } else { echo "<p class='resultadd'>" . mysql_errno() . "</p>"; } }
require_once 'config.php'; // require_once 'debug.php'; // DEBUG # Generate and return a text-data data array: function gen_data($rows, $points) { $data = array(); for ($r = 0; $r < $rows; $r++) { $row = array("Row{$r}"); for ($c = 0; $c < $points; $c++) { $row[] = $r + $c + 1; } $data[] = $row; } return $data; } $data = gen_data($tp['nrows'], $tp['ncols']); if ($tp['longlabel']) { $data[min(3, $tp['nrows'] - 1)][0] = 'Long Label Test'; } if ($tp['negative'] > 0) { $phase = $tp['negative']; for ($r = 0; $r < $tp['nrows']; $r++) { for ($c = 1; $c <= $tp['ncols']; $c++) { if (--$phase <= 0) { $data[$r][$c] *= -1; $phase = $tp['negative']; } } } } $p = new PHPlot(800, 800);