tech.dip/body.php at master · LEV13/tech.dip · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<div class="b2">
	<?php
	function check_image($a)
	{
			$image = "/images/noname.JPG";
			if ($a != NULL) {$image = $a;}
			return $image;
	}
	$query = mysql_query(
	"SELECT `elements`.`name`,
	`elements`.`code` AS `element_code`,
	`elements`.`description`,
	`libs`.`code` AS `lib_code`,
	`libs`.`name` AS `lib_name`,
	`element_types`.`name` AS `type_name`,
	`simulators`.`name` AS `simulator_name`,
	`clients`.`name` AS `client_name`
	FROM `elements`
	JOIN `libs`
	ON
	`elements`.`lib_id` = `libs`.`id`
	JOIN `simulators`
	ON
	`libs`.`simulator_id` = `simulators`.`id`
	JOIN `clients`
	ON
	`simulators`.`client_id` = `clients`.`id`
	JOIN `element_types`
	ON
	`elements`.`type_id` = `element_types`.`id`
	ORDER BY `lib_code` ASC, `element_code` ASC	");
	$row = mysql_fetch_array($query);
	echo "<div class='b02'>
			<div class='b11'>&nbsp;</div>
			<div class='b14 b15' >Клиент</div>
			<div class='b14 b15'>Тренажер</div>
			<div class='b14 b15'>Библиотека</div>
			<div class='b14 b15'>Тип</div>
			<div class='b14 b15'>Код</div>
			<div class='b14 b15'>Название</div>
		</div>"
			;

	do
	{

	echo "<div class='b01'>
			<div class='b11'>&nbsp;</div>
			<div class='b14 b-popup-content' >". $row['client_name']."</div>
			<div class='b14'>". $row['simulator_name']."</div>
			<div class='b14'>". $row['lib_name']."</div>
			<div class='b14'>". $row['type_name']."</div>
			<div class='b14'>".$row['lib_code'].$row['element_code']."</div>
			<div class='b14'>". $row['name']."</div>
		</div>"
			;
	}

	while ($row = mysql_fetch_array($query));
	?>
	</div>