<?php //require_once '../../fcnsdb.php'; $query = "SELECT img_id,img_tipo,img_marca,img_modelo FROM imagem"; PrintImgTable(query($query), 'imagem');
foreach ($arrayDescr as $key => $value) { $descr .= $key . ': ' . $value . ';<br>'; } } $query = "INSERT INTO udescti.equipamento VALUES ('{$patrimonio}','{$servidor}','{$lsetor}','{$ldepartamento}','{$tipo}','{$descr}','{$imagem}')"; query($query); $query = "SELECT * FROM udescti.equipamento WHERE patrimonio='{$patrimonio}'"; PrintTable(query($query)); } if (isset($_GET['servidor'])) { $query = "SELECT nome FROM udescti.servidor"; SelectValues(query($query)); } if (isset($_GET['lsetor'])) { $departamento = $_GET['lsetor']; $query = "SELECT setor FROM udescti.local WHERE departamento='{$departamento}' group by 1"; SelectValues(query($query)); } if (isset($_GET['ldepartamento'])) { $query = "SELECT departamento FROM udescti.local group by 1"; SelectValues(query($query)); } if (isset($_GET['imagem'])) { $tipo = $_GET['imagem']; $query = "SELECT img_id FROM udescti.equip_img WHERE tipo='{$tipo}'"; PrintImgTable(query($query)); } /* [ \w.+(?=:) ] // antes dos dois pontos (?<=:)(\W)*\w.+(?=;) //entre dois-pontos e ponto-e-virgula */
<?php //require_once '../../fcnsdb.php'; if (isset($_GET['sof_patrimonio'])) { $sof_patrimonio = $_GET['sof_patrimonio']; $query = "SELECT sof_id, sof_patrimonio FROM softwares WHERE sof_patrimonio='{$sof_patrimonio}' ORDER BY 1"; } else { $query = "SELECT sof_id, sof_patrimonio FROM softwares ORDER BY 1"; } PrintImgTable(query($query), 'softwares');