Hello World! It’s my first post on this forum, hello everybody
I’m working on the small simple voting system. The system is based on php/javascript. I’m getting values from form and I’m sending it to database through php-mysql_query.
1. I must have option to delete the selected gruop/option (for example if somebody do mistake). 2. There must be an option that you cannot add another group, if you don’t add in the previous at least one option.
It must be working for form and post php.
I would be grateful if you help me solve these problems
<?php
ob_start();
session_start(); // rozpoczecie sesji
require_once('../inc/db.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Dokument bez tytułu</title>
<script src="js/jquery-1.5.2.min.js" type="text/javascript"></script>
<script src="js/hideshow.js" type="text/javascript"></script>
<script src="js/jquery.tablesorter.min.js" type="text/javascript"></script>
<script type="text/javascript" src="js/jquery.equalHeight.js"></script>
<script type="text/javascript">
var counter_group = 0;
var limit_group = 10;
var counter_option = 0;
var limit_option = 10;
var addInput = function(divName) {
if (counter_option == limit_option - 1) {
alert('You cannot add more options.');
} else {
counter_option++;
var newdiv = document.createElement('div');
newdiv.innerHTML = "<font style='margin-left:50px;'>Option</font> " + (counter_option + 1) + "<input type='text' name='groups[" + counter_group + "][options][]'>";
document.getElementById(divName).appendChild(newdiv);
}
}
var addGroup = function(divName) {
if (counter_group == limit_group - 1) {
alert('You cannot add more groups.');
} else {
counter_group++;
counter_option = -1;
var newdiv = document.createElement('div');
newdiv.innerHTML = "Group " + (counter_group + 1) + "<input type='text' name='groups[" + counter_group + "][name]'>";
document.getElementById(divName).appendChild(newdiv);
}
}
</script>
</head>
<body>
<form action="costam.php" method="post">
<input type="hidden" name="sent" value="true" />
<div id="dynamicInput">
Group 1
<br>
<input type="text" name="groups[0][name]">
<div id="dynamicInput" style="margin-left:50px;">
Option 1
<br>
<input type="text" name="groups[0][options][]">
</div>
</div>
<input type="button" value="Add another group" onClick="addGroup('dynamicInput');">
<input type="button" value="Add another option" onClick="addInput('dynamicInput');">
<input type="submit" value="Add to database" class="alt_btn">
</form>
<?php
if($_POST['sent'])
{
echo 'form sent<br />';
foreach ($_POST['groups'] as $group) {
$name = $group['name'];
//print_r($options = $group['options']); - this will show options // $name - groups
//echo '|asdf|'.$name.'|asdf|';
$wynik = mysql_query("INSERT INTO `grupa` VALUES('',1,'$name','opis',1,1)") or die("<br /> Error: (" . mysql_errno() . ") " . mysql_error());
echo 'taka powinna byc grupa'.$name;
$wynik = mysql_query("SELECT * FROM `grupa` WHERE nazwa = '$name'") or die("<br /> Error: (" . mysql_errno() . ") " . mysql_error());
if(mysql_num_rows($wynik) > 0)
{
while($r = mysql_fetch_assoc($wynik))
{
$id_of_group = $r['id'];
}
}
echo $id_of_group;
$options = $group['options'];
foreach($options as $k => $v)
{
echo 'key='.$k.'value='.$v;
$query = "INSERT INTO `opcje_glosowania` VALUES('','$v',9,'$id_of_group',1)";
mysql_query($query) or die("Twoje QUERY: ".$query."<br /> Error: (" . mysql_errno() . ") " . mysql_error());
}
}
}
?>
</body>
</html>
Database looks similar at:
|====GROUP====|
|------id-----|
|----name----|
|=============|
|====OPTION====|
|------id-----|
|–id_group—| //FK to GROUP.ID
|----name----|
|=============|
A standard way to delete an item is to show an X icon, such as beside the group itself.
With regard to preventing another group from being added, you could have the add group button disable itself, and the add option button enable the group button.
That much is simple. You give the add group button an identifier so that you can easily access it from the script.
When you add a group, you set the disabled property of the button to be true. When you add an option, you set the disabled property of the group button to false.
[list=1][]give the add group button an identifier
[]when adding a group, set the disabled property of the group button to true
[*]when adding an option, set the disabled property of the group button to false[/list]
Which of those tasks do you need further assistance with?
When I will add the group, add the option 1 to this, add the another option 2 to this and delete these two options, later add option you will see Option 3 - not option 1 in this group. Why and how to repair that?
Second questions is if I mind to delete group - it’s delete only group - not all content of a div (all options). I must have two different divs for that?
Thank you very much for your answers @pauls_wikins from New Zealand, greetings from Poland
Thank you very much @paul_wikins I’m pausing my project for a week, but I will be writing in the future Thank you again and I hope - see you next time Merry Christmas 4every1
beside the group itself.
With some effort, but … it’s workinkg 