[Resolved] [Resolved] Why does this function not work ......

[k994519]

HI guys

can someone please check this out !!!

its screwing with my mind.......

Essentially it should output the value of the check box
the echo statement prints the correct value but i cant seem to insert it into the database please help.......

<?
iif(isset($_POST["submit"]))
{
	echo "PASSED";
	if (count($_POST["box"]) != 8 )
	{
		echo "ensure u have selected 8 options!<br>";
	}
	else
	{
		for ($i = 0; $i<8; $i++)
		{
			echo "the first option 2 insert is " . ($_POST["box"][$i]) . "</br>";




		//

	}
}$query ="insert into students (module_id) VALUES ('[$box][$i]')";
		$result=mysql_query($query, $link) or die("Died inserting new student info into db.  Error returned if any: ".mysql_error());

}

?>
<form action="<?=$_SERVER["PHP_SELF"]?>" method="POST">

<?php


$query=("select module_id, description from modules order by module_id");
// Run query:
$result=mysql_query($query, $link) or die("MySQL query $query failed.  Error if any: ".mysql_error());

while($row = mysql_fetch_row($result)) 
{ 
	echo "<input type=checkbox name=box[] value=" . $row[0] . ">" . $row[1] . "<br>";
}

?>



<input name="submit" type="submit" value="Submit">&nbsp;<input type="reset" name="Reset" value="Reset">

[mtimdog]

Your insert query is outside of your For loop...so it doesn't know what the value of $_POST['box'][$i] is since $i is null.

Also, your query might work better like this...

$query ="insert into students (module_id) VALUES ('" . $_POST['box'][$i] . "')"; 

since $box doesn't look like it's defined either.

[sidney]

 <? 
iif(isset($_POST["submit"])) ///iif shouldnt that be if
{ 
    echo "PASSED"; 
    if (count($_POST["box"]) != 8 ) 
    { 
        echo "ensure u have selected 8 options!<br>"; 
  

[DigitalExpl0it]

try this, maybe it will work and you can then modify it again

<?
if($_REQUEST["submit"] == "Submit") {
    echo "PASSED";
    if (count($_REQUEST["box"]) != 8 ) {
        echo "ensure u have selected 8 options!<br>";
    } else {
        for ($i = 0; $i<8; $i++) {
            echo "the first option 2 insert is ".($_REQUEST["box"][$i])."</br>";          

        }
    }
	$query ="insert into students (module_id) VALUES ('[".$_REQUEST["box"]."][".$i."]')";
    $result=mysql_query($query, $link) or die("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
	return;
}

?>
<form action="<? echo $PHP_SELF; ?>" method="POST">
<?
$hip = "localhost";
$duser = "root";
$dpass = "";
$dname = "test";
//Connection string
$connect = mysql_connect($hip, $duser, $dpass) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$db = mysql_select_db($dname, $connect) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$query=("select module_id, description from modules order by module_id");
$result=mysql_query($query, $connect);

while($row = mysql_fetch_row($result)) { 
    echo "<input type=checkbox name=box[] value=".$row[0].">".$row[1]."<br>";
}
mysql_close($connect);
?>
    <input name="submit" type="submit" value="Submit">&nbsp;<input type="reset" name="Reset" value="Reset"> 

[k994519]

HI guys

just used ur script digitalExpl0it

made slight changes as connection is already established

I am getting this error?

1062: Duplicate entry '0' for key 1

any clues ?

[laserlight]

My guess is this:
module_id is an AUTO_INCREMENT field.
The value passed to the query that inserts a new row wasnt passed from the form, and/or has the value of 0.

I dont quite understand what you are trying to do, but in general when inserting into an AUTO_INCREMENT field one would set it to NULL, so that the correct value would be inserted by the database server, automatically.

[mtimdog]

I'm assuming you're storing all 8 in the database? If you are, then you'll need to put the query inside the FOR loop like I previously proposed.

On a side note, if you're trying to store these fields linked to a person you'll have to put that into the query (I'm assuming one of the fields is the studentid, which is a key and must be unique, which is causing your error because it's default is 0 and look at the auto-incrementing option in the previous post).

[k994519]

HI guys,

laser_light ; the module_id is not a the auto increment.

mtimdog; the order of the table which i am inserting into
is student_id, last_name, first name, start_date, module_id, module__id2, and so on till module_id8

My question is do i have to insert the other student info into the table fields before the module_id field?

thanks for your help guys

[laserlight]

Well, what is it?

A primary key or unique field?

Basically I'm trying to interpret the "the 1062: Duplicate entry '0' for key 1" error.

Actually, if it is your primary key, making it AUTO_INCREMENT would be a good idea.
You also will not have to worry about setting its value.

[k994519]

laser light,

from what i can see it is neither it is set to int (11) has a default value of '0'

what is happening is that the checked elements refer to the title
of the module_id i.e computing = 112 etc, from the table modules

what i am trying to do then is to pass all the checked elements into the table students so if computing is checked it then passed the value 112 into the table student field module_id

ideally this should loop 8 times soo all of the entries are entered.....

thanks for ur help soo far very much appriecated.....

[sidney]

are you trying to insert 8 items into a table row

or

8 items into 8 seperate table rows

[k994519]

8 items into one row.....

[sidney]

can i have the table structure

edit

and the array order of box

[k994519]

the table structure is

Student
student_ID pk int not nulll
first_name, varchar
last_name varchar
faulty_id int
course_code int
current_level int
date_started date
group_id int
module_id int
module_id2 int
module_id3 int
module_id4 int
module_id5 int
module_id6 int
module_id7 int
module_id8 int

table modules

module_id pk int
level int
description varchar

these are the main tables used for code earlier submited

[sidney]

so the table row all ready has the other info in row you are trying to insert data into

i think you may need to use update

[k994519]

sid,

as you can probably guess im a newbie how would i use the update query ?

[DigitalExpl0it]

Originally posted by k994519
the table structure is

Student
student_ID pk int not nulll
first_name, varchar
last_name varchar
faulty_id int
course_code int
current_level int
date_started date
group_id int
module_id int
module_id2 int
module_id3 int
module_id4 int
module_id5 int
module_id6 int
module_id7 int
module_id8 int

table modules

module_id pk int
level int
description varchar

these are the main tables used for code earlier submited

should do somthing like this first then change the fields later

Host: localhost

Database: test

Table: 'student'

CREATE TABLE student (
student_ID int(10) NOT NULL auto_increment,
first_name text NOT NULL,
last_name text NOT NULL,
faulty_id text NOT NULL,
course_code text NOT NULL,
current_level text NOT NULL,
date_started text NOT NULL,
group_id text NOT NULL,
module_id text NOT NULL,
module_id2 text NOT NULL,
module_id3 text NOT NULL,
module_id4 text NOT NULL,
module_id5 text NOT NULL,
module_id6 text NOT NULL,
module_id7 text NOT NULL,
module_id8 text NOT NULL,
PRIMARY KEY (student_ID)
) TYPE=MyISAM;

[sidney]

you will need to have the row id of some sort
either a name or rrow id

then
you would use somthing like this

mysql_query("UPDATE students SET module_id = '".$_POST['box'][$i]."'where id='$id'");

but before you go editing

how are you identifiying the user entering the info

[k994519]

thanks guys

DigitalExpl0it: i have set them to "NOT NULL" just forgot to type it up, (yep royally lazy git)

sid: the users who is entering the data is the school adminstration team. Access is setup on a diffrent table which stores all the authorise usernames and password.....

in regard with the query below

mysql_query("UPDATE students SET module_id = '".$_POST['box'][$i]."'where id='$id'");

what is id there? should it not be

 
"where student_id = $student_id";

I have to say thanks to everyone who's helped me soo far.....

[sidney]

id need to be student_ID other wise

where is mysql going to know where to update the table ie which row

added script which i have edited if you put a student id number in form and pass it as $id to update it should work

also you need to change database so module_id is module_id1
other wise the update cannot cycle through them

hope it helps

 <?php
 // need to get id of student
if(isset($_POST["submit"])) 
{ 
    echo "PASSED"; 
    if (count($_POST["box"]) != 8 ) 
    { 
        echo "ensure u have selected 8 options!<br>"; 
    } 
    else 
    { 
        for ($i = 0; $i<8; $i++) 
        { 
			$mod="module_id".$i+1;  // need to change database so module_id is module_id1
            echo "the first option 2 insert is " . ($_POST["box"][$i]) . "</br>";
			$query =("UPDATE students SET ".$mod." = '".$_POST['box'][$i]."' where student_ID='$id'");
			$result=mysql_query($query, $link) or die("Died inserting new student info into db.  Error returned if any: ".mysql_error()); 
        } 
    }
} 
?> 
<form action="<?=$_SERVER["PHP_SELF"]?>" method="POST"> 
<?php 
$query=("select module_id, description from modules order by module_id"); 
// Run query: 
$result=mysql_query($query, $link) or die("MySQL query $query failed.  Error if any: ".mysql_error()); 

while($row = mysql_fetch_row($result))  

{  

    echo "<input type=checkbox name=box[] value=" . $row[0] . ">" . $row[1] . "<br>"; 
} 
?> 
<input name="submit" type="submit" value="Submit">&nbsp;<input type="reset" name="Reset" value="Reset">