Am not entirely sure I get your question. I am going to guess you trying to have some "default/filler"value for a checkbox that isn’t checked.
When a checkbox element is not checked no variable is sent at all, so technically you can’t. HOWEVER, if you know you ALWAYS want to have some default value for your checkbox you could check AFTER SUBMIT if it was passed at all, and add the default value if it wasn’t.
eg.: if ($submited) {if (!isset ($learner['id'])) {$learner['id']=1;} }
Hi,
Thanks for the reply. Sorry for not being clear.
When the checkbox is ticked I want a new row in the table with a ‘1’ in the ‘absence’ column and the learner’s id in the userid column.
So only want to send a value if the checkbox is ticked.
I didn’t know this was possible and it might be useful.
So then is it not possible that using a checkbox, both the value ‘1’ and the learner’s id are sent to POST?
Thanks,
Shane
the DB table or the table you are using to lay out your form?
either way the best method would be as I mentioned earlier and check for the existence of the variable after the form is submitted
IF , on the other hand what you want to happen is that as soon as the checkbox is ticked, the user sees a new the row appear in the form, you will need to use AJAX (or at least .js) to insert the element.
As you can see from the other columns in the table, I will want to add to the form a column of other checkboxes to fill the other columns in the table. But that is the next stage!
(NB The course called ‘computing’ is just an example, I do not teach computing, clearly!!!)
Well you don’t really need to pass 1 if the student is absence, just their id. However I believe you will also need the course id otherwise how will you know what class they were absent from? I would suggest putting the course id as the KEY for absence and the student id as the value for the check box. Then a simple foreach loop can grab those values for DB insert. Here’s a rough sample.
Hi,
Thanks for your reply. You are correct I should also pass the student’s id and their course id.
Thanks for the sample code. Setting up an array like that means knowing the size of the array but the array length may change as courses and students are added and deleted.
I will try to get your suggestion working.
Thanks,
Shane
ITS IMPERATIVE TO PUT THE KEY in your variable name, this way you can iterate through each row, and still check whether corresponding checkboxes are set or not.
I used the format like dresden_phoenix described when I made a similar attendance script where I had multiple checkboxes for “Late”, “Absent”, “Excused” etc and passed course and student id’s with hidden field with forced KEYs. It all depends upon your needs.
Hi,
I am sorry I have not replied. Drummin I was rwading your script and realised I don’t really get arrays so I had to go off and play with them for a while. I now understand what you did in your script.
What I am looking for is a table of checkboxes which corresponds with the table, almost exactly in the DB. So if a student is absent a row in the DB is created and with a 1 for the absence and the student’s id and course id. All this info goes on one row of the DB.
dresden_phoenix I am not really lookimg to simply increase the absence value by one each time, because that way i won’t be able to tell on what day a student was absent.
If I can get this to work I would like to then add another column to the checkbox form of say for example ‘equipment’ and ticking this box would add this info to the same row as the previous information.
If that succeeds it shouldn’t be difficult to add any number of columns to the table of checkboxes.
I have been thinking about the idea mentioned above of using type=‘hidden’ to get variables from the for to index.php for putting in to the DB.
I will have to read up on what is meant by a ‘forced’ KEY. I have only just figured out how the key => value works for arrays!!!
Thank you all for your replies,
Shane
If you are planning on adding other checkboxes then you should switch to using hidden fields and forced KEYs. All I really mean by that is setting a variable before the foreach loop, then incrementing as you iterate through the different loops so each set of form inputs has a unique key. Processing would need to be handled differently. Here’s an example with forced keys.
Hi,
I did try to get this method to work but I can’t figure out how to get it in this form into the database.
So I have gone back to my original form. I have two column of checkboxes which produce two arrays absence and late. And am trying to match the nth element of the first array to the nth element of the second array. When there is a match, if($i==$j) one row of data should be sent to the database.
$i is the nth element of the $absence array and
$j is the nth element of the $late array.
Here are the html form and an excerpt form the index.php
if (isset($_GET['addnotes']))
{
include $_SERVER['DOCUMENT_ROOT'] . '/artgibney/includes/db.inc.php';
try
{
$sql = 'INSERT INTO notes SET
date = CURDATE(),
late = :tardy,
absence = :id';
$s = $pdo->prepare($sql);
$i = 0;
$j = 0;
foreach($_POST['absence'] as $absence)
{
$j=0;//reset $j
foreach($_POST['late'] as $late)
{
if($i==$j){//condition for the same nth element from each array
$s->bindValue(':id', $absence);
$s->bindValue(':tardy', $late);
$s->execute();//should input one row of database
}
$j++;
}
$i++;
}
}
catch (PDOException $e)
{
$error = 'Error adding submitted daily notes data. Click the back button to continue.';
include 'error.html.php';
exit();
}
header('Location: .');
exit();
}
I can put in the student and course id later.
But it only works if both the late and absence checkboxes are ticked.
Thanks,
Shane
Well, if you will please forgive me for making the assumption based on your previous posts, you do wish to have courses listed across the top, students names down the left side and attendance under each class column. I believe you also need to add the student and class id’s to your “notes” table at the time of processing or it will be very hard after the fact to update these records with the correct student and class id’s. I’ve made another sample, which hopefully will work for you that includes processing code. This is untested and table field names might need to be modified. Hopefully you can add your $courses and $learners array building queries to this and make it work.
Hi Drummin,
Thanks. I am looking at your code and will try to get it to work for me. (it will take me some time )
Sorry, I should have included all of my html table.
Included is a screenshot,
The courses are to the left. I would prefer if the table did not repeat the course name in the first column.
Basically I’d like to have each row of the html table copy as a new row in the table. With a “1” or empty as the check box data.
Each student only does one course.
I thought I would be able to just put in hidden type values in the form to send the course and student ids.
Maybe like this,
Can you post a sample of the arrays you are using? print_r($courses) etc. From the look of the screen shot it would seem that you would use a single array of data to build this table. Maybe show the query and array building process as well.
In order to get input fields to match, you will need to use a forced KEY like I did on my version.
)