Содержимое файла | Последнее изменение | Открыть журнал | RSS
| Редакция | Автор | № строки | Строка |
|---|---|---|---|
| 2 | leon | 1 | <?PHP |
| 2 | session_start(); |
||
| 3 | if ($_SESSION['$user_privileges'] < 16) |
||
| 4 | header("Location: index.php"); |
||
| 5 | include "head.php"; |
||
| 6 | $db = mysql_connect("localhost", "linwin"); |
||
| 7 | mysql_select_db("linwin", $db); |
||
| 8 | mysql_query("SET NAMES 'utf8';", $db); |
||
| 9 | $query=mysql_query("SELECT id, pid, sid FROM prog_in_sect;", $db); |
||
| 10 | $num_record = mysql_num_rows($query); |
||
| 11 | $mas_id = array(); |
||
| 12 | $mas_pid = array(); |
||
| 13 | $mas_sid = array(); |
||
| 14 | for ($i = 0; $i < $num_record; $i++) |
||
| 15 | { |
||
| 16 | $mas_id[$i] = mysql_result($query,$i,0); |
||
| 17 | $mas_pid[$i] = mysql_result($query,$i,1); |
||
| 18 | $mas_sid[$i] = mysql_result($query,$i,2); |
||
| 19 | } |
||
| 20 | print " |
||
| 21 | <p>Тестирование баз</p> |
||
| 22 | <p>1) Проверяем, есть ли в базе prog_in_sect записи, в которых спользуется pid, равный id несуществующей программы:</p>"; |
||
| 23 | for ($i = 0; $i < $num_record; $i++) |
||
| 24 | { |
||
| 25 | $sql = "SELECT id FROM program WHERE id = '". $mas_pid[$i]. "';"; |
||
| 26 | $query=mysql_query($sql, $db); |
||
| 27 | $num_record_prog = mysql_num_rows($query); |
||
| 28 | if (!$num_record_prog) |
||
| 29 | print "<p>id = $mas_id[$i]<br/>pid = $mas_pid[$i]<br/>sid = $mas_sid[$i]<br/></p>"; |
||
| 30 | } |
||
| 31 | print "<p>2) Проверяем, есть ли в базе prog_in_sect записи, в которых спользуется sid, равный id несуществующей группы:</p>"; |
||
| 32 | for ($i = 0; $i < $num_record; $i++) |
||
| 33 | { |
||
| 34 | $sql = "SELECT id FROM section WHERE id = '". $mas_sid[$i]. "';"; |
||
| 35 | $query=mysql_query($sql, $db); |
||
| 36 | $num_record_sect = mysql_num_rows($query); |
||
| 37 | if (!$num_record_sect) |
||
| 38 | print "<p>id = $mas_id[$i]<br/>pid = $mas_pid[$i]<br/>sid = $mas_sid[$i]<br/></p>"; |
||
| 39 | } |
||
| 40 | $query=mysql_query("SELECT id, name FROM program;", $db); |
||
| 41 | $num_record = mysql_num_rows($query); |
||
| 42 | $mas_program_id = array(); |
||
| 43 | $mas_program_name = array(); |
||
| 44 | for ($i = 0; $i < $num_record; $i++) |
||
| 45 | { |
||
| 46 | $mas_program_id[$i] = mysql_result($query,$i,0); |
||
| 47 | $mas_program_name[$i] = mysql_result($query,$i,1); |
||
| 48 | } |
||
| 49 | print "<p>3) Проверяем, есть ли в базе program записи, id которой не использует ни одна запись из базы prog_in_sect:</p>"; |
||
| 50 | for ($i = 0; $i < $num_record; $i++) |
||
| 51 | { |
||
| 52 | $sql = "SELECT id FROM prog_in_sect WHERE pid = '". $mas_program_id[$i]. "';"; |
||
| 53 | $query=mysql_query($sql, $db); |
||
| 54 | $num_record_program = mysql_num_rows($query); |
||
| 55 | if (!$num_record_program) |
||
| 56 | print "<p>id = $mas_program_id[$i]<br/>name = $mas_program_name[$i]</p>"; |
||
| 57 | } |
||
| 58 | print "<p>4) Проверяем, есть ли в базе URL записи, использующие id несуществующей программы:</p>"; |
||
| 59 | $query=mysql_query("SELECT id, pid, url, description FROM url;", $db); |
||
| 60 | $num_record = mysql_num_rows($query); |
||
| 61 | $mas_program_url_id = array(); |
||
| 62 | $mas_program_url_pid = array(); |
||
| 63 | $mas_program_url_description = array(); |
||
| 64 | for ($i = 0; $i < $num_record; $i++) |
||
| 65 | { |
||
| 66 | $mas_program_url_id[$i] = mysql_result($query,$i,0); |
||
| 67 | $mas_program_url_pid[$i] = mysql_result($query,$i,1); |
||
| 68 | $mas_program_url_description[$i] = mysql_result($query,$i,2); |
||
| 69 | } |
||
| 70 | |||
| 71 | for ($i = 0; $i < $num_record; $i++) |
||
| 72 | { |
||
| 73 | $sql = "SELECT id FROM program WHERE id = '". $mas_program_url_pid[$i]. "';"; |
||
| 74 | $query=mysql_query($sql, $db); |
||
| 75 | $num_record_prog = mysql_num_rows($query); |
||
| 76 | if (!$num_record_prog) |
||
| 77 | print "<p>id = $mas_program_url_id[$i]<br/>pid = $mas_mas_program_url_pid[$i]<br/>sid = $mas_program_url_description[$i]<br/></p>"; |
||
| 78 | } |
||
| 79 | mysql_close($db); |
||
| 80 | include "foot.php"; |
||
| 81 | ?> |