Displaying values from database using checkboxes issue
I have an issue regarding displaying data from database using checkboxes.
I am able to display them but some of them or all of them display more
than once. I have around 20 checkboxes. I want to be able to select any
number of them and according to conditions form the table database,
display results. Problem are duplicate entries because for more than one
checkboxes i also have more stuff. For example, OCTAVE supports three
phases: risk identification, risk analysis and risk evaluation. If I check
all three checboxes (each for a different phase i will get OCTAVE
displayed three times.) Disregard some name because syntax is croatian but
That's why i gave the entire code here.
any help or suggestion about removing duplicate values? Ty
This is what I've got.
table
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 12, 2013 at 10:22 PM
-- Server version: 5.5.24-log
-- PHP Version: 5.4.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `magistarski`
--
-- --------------------------------------------------------
--
-- Table structure for table `kriteriji`
--
CREATE TABLE IF NOT EXISTS `kriteriji` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`ime` varchar(25) NOT NULL,
`identifikacija` int(3) NOT NULL,
`analiza` int(3) NOT NULL,
`evaluacija` int(3) NOT NULL,
`obrada` int(3) NOT NULL,
`prihvacanje` int(3) NOT NULL,
`komunikacija` int(3) NOT NULL,
`malesrednje` int(3) NOT NULL,
`velike` int(3) NOT NULL,
`vlada` int(3) NOT NULL,
`profitne` int(3) NOT NULL,
`neprofitne` int(3) NOT NULL,
`cijena` int(3) NOT NULL,
`vjestine` int(3) NOT NULL,
`dokumentiranost` int(3) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
--
-- Dumping data for table `kriteriji`
--
INSERT INTO `kriteriji` (`id`, `ime`, `identifikacija`, `analiza`,
`evaluacija`, `obrada`, `prihvacanje`, `komunikacija`, `malesrednje`,
`velike`, `vlada`, `profitne`, `neprofitne`, `cijena`, `vjestine`,
`dokumentiranost`) VALUES
(1, 'ISO 27005:2008', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1),
(2, 'NIST SP 800 - 30', 1, 1, 0, 1, 1, 0, 1, 1, 1, 1, 1, 0, 2, 3),
(3, 'OCTAVE', 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 2, 3),
(4, 'CobIT', 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 2),
(5, 'CRAMM', 1, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, 1, 3, 3),
(6, 'FMEA', 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 0, 1, 2, 2),
(7, 'FRAP', 1, 1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 2, 2),
(8, 'EBIOS', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 2, 2),
(9, 'RuSecure', 1, 1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 1, 1, 1),
(10, 'ALE', 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 1),
(14, 'Cobra', 1, 1, 1, 0, 0, 0, 1, 0, 0, 1, 0, 1, 2, 2),
(16, 'MEHARI', 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 0, 2, 1);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
index.php
<!doctype html>
<html>
<head>
<?php
//spajanje na server
$spajanje = mysql_connect("localhost", "root", "") or die("Nije se
mouæe povezati na server :("); //spajanje na server
//spajanje na bazu
$baza = mysql_select_db("magistarski") or die("Nije se moguæe
povezati na bazu podataka :(");
?>
<meta charset="utf-8">
<title>test</title>
</head>
<body>
<form action="index.php" method="post">
<p>
<table width="766" height="418" border="0">
<caption>
<h1>Savjetnik o metodama upravljanja rizicima</h1>
</caption>
<tr>
<td width="203" height="203"><h3 align="left"><em>risk
assessment</em></h3>
<div align="justify"><em>
<input type="checkbox" name="chkbox[]"
value="identifikacija" />
Identifikacija rizika<br>
<input type="checkbox" name="chkbox[]"
value="analiza" />Analiza rizika<br>
<input type="checkbox" name="chkbox[]"
value="evaluacija" />Evaluacija rizika<br>
</em></div></td>
<td width="194"><h3 align="left"><em>risk
management</em></h3>
<div align="justify"><em>
<input type="checkbox" name="chkbox[]"
value="assess" />
Obrada rizika<br>
<input type="checkbox" name="chkbox[]"
value="accept" />Prihvaæanje rizika<br>
<input type="checkbox" name="chkbox[]"
value="comunicate" />Komunikacija o
riziku<br>
</em></div></td>
<td width="212"><h3 align="justify"><em>Ukljuèenost
cijene</em></h3>
<div align="justify"><em>
<input type="checkbox" name="chkbox[]"
value="Besplatno" />
Besplatne<br>
<input type="checkbox" name="chkbox[]"
value="Komercijalno" />Komercijalne<br>
</em></div></td>
</tr>
<tr>
<td height="181"><h3 align="justify"><em>Vrsta
organizacije</em></h3>
<div align="justify"><em>
<input type="checkbox" name="chkbox[]"
value="malesrednje" />
Male i srednje organizacije<br>
<input type="checkbox" name="chkbox[]"
value="velike" />Velike organizacije<br>
<input type="checkbox" name="chkbox[]"
value="vladine" />Vladine organizacije<br>
<input type="checkbox" name="chkbox[]"
value="profitne" />Profitne
organizacije<br>
<input type="checkbox" name="chkbox[]"
value="neprofitne" />Neprofitne
organizacije<br>
</em></div></td>
<td><h3 align="justify"><em>Vještine</em></h3>
<div align="justify"><em>
<input type="checkbox" name="chkbox[]"
value="osnovna" />
Osnovna razina<br>
<input type="checkbox" name="chkbox[]"
value="srednja" />Srednja razina<br>
<input type="checkbox" name="chkbox[]"
value="visoka" />Visoka razina<br>
</em></div></td>
<td><h3 align="justify"><em>Dokumentiranost</em></h3>
<div align="justify"><em>
<input type="checkbox" name="chkbox[]"
value="slaba" />
Slaba dokumentiranost<br>
<input type="checkbox" name="chkbox[]"
value="dobra" />Dobra dokumentiranost<br>
<input type="checkbox" name="chkbox[]"
value="velika" />Jako dobra
dokuemntiranost<br>
</em></div></td>
</tr>
</table>
</p>
<div align="center">
<input type="submit" name="gumbposlan" value="Prikaz" />
</div>
</form>
<?php
if (isset($_POST['gumbposlan'])) {
if (isset($_POST['chkbox[]1']) || (isset($_POST['chkbox[]2'])) ||
(isset($_POST['chkbox[]3']))) {
if ((isset($_POST['chkbox[]1']) &&
(isset($_POST['chkbox[]2'])))) {
$upit = mysql_query("SELECT DISTINCT ime FROM kriteriji
where identifikacija = 1 and analiza = 1");
while ($red = mysql_fetch_array($upit)) {
$cijena = $red['ime'];
if ($cijena < 1)
echo $cijena . "<br>";
}
}
if ((isset($_POST['chkbox[]1'])) &&
(isset($_POST['chkbox[]3']))) {
$upit = mysql_query("SELECT DISTINCT ime FROM kriteriji
where identifikacija = 1 and evaluacija = 1");
while ($red = mysql_fetch_array($upit)) {
$cijena = $red['ime'];
if ($cijena < 1)
echo $cijena . "<br>";
}
}
if ((isset($_POST['chkbox[]2'])) &&
(isset($_POST['chkbox[]3']))) {
$upit = mysql_query("SELECT DISTINCT ime FROM kriteriji
where analiza = 1 and evaluacija = 1");
while ($red = mysql_fetch_array($upit)) {
$cijena = $red['ime'];
if ($cijena < 1)
echo $cijena . "<br>";
}
}
if ((isset($_POST['chkbox[]1']))) {
$upit = mysql_query("SELECT DISTINCT ime FROM kriteriji
where identifikacija = 1");
while ($red = mysql_fetch_array($upit)) {
$cijena = $red['ime'];
if ($cijena < 1)
echo $cijena . "<br>";
}
}
if ((isset($_POST['chkbox[]2']))) {
$upit = mysql_query("SELECT DISTINCT ime FROM kriteriji
where analiza = 1");
while ($red = mysql_fetch_array($upit)) {
$cijena = $red['ime'];
if ($cijena < 1)
echo $cijena . "<br>";
}
}
if ((isset($_POST['chkbox[]3']))) {
$upit = mysql_query("SELECT DISTINCT ime FROM kriteriji
where evaluacija = 1");
while ($red = mysql_fetch_array($upit)) {
$cijena = $red['ime'];
if ($cijena < 1)
echo $cijena . "<br>";
}
}
}
else {
$upit = mysql_query("SELECT DISTINCT * FROM kriteriji where
identifikacija = 1 and analiza = 1 and evaluacija = 1");
while ($red = mysql_fetch_array($upit)) {
$cijena = $red['ime'];
if ($cijena < 1)
echo $cijena . "<br>";
}
}
}//button
?>
</body>
</html>
No comments:
Post a Comment