how to use radio button in attendance system

purple · November 11, 2013

Actually, i want to do like this.This attendance system for my school.When a teacher chose class, list of student name will appear in a table. Students and class are in a database. Besides students's name there will be two radio buttons to chose.

Hope that somebody can help me.

requinix · November 11, 2013

Wouldn't checkboxes be easier? Teacher checks the students who are attending.

Regardless, what code do you have now and what doesn't work?

purple · November 11, 2013

Thanx for your time.
Let look at attendance.php

<html>

<table>

<tr>

<tr>

</tr>

<tr>

</span></td>

<option>Please Select</option>

</select></td>

</tr>

<tr>

<label>Class</label>

</span></td>

<option>Please Select</option>

<option>Yellow</option>

<option>Black </option>

</select></td>

<tr>

</tr>

</table>

</form></center>

</p>

</table>

</html>

purple · November 11, 2013

After teacher chose the class, name of student in the class will display in a table with radio buttons. Here the code that i make, but i know i do many mistake on my code.

attendance display.php

<table>

<tr>

</tr>

</table>

<tr>

<th width="300"><font size="2">Student's Name</font></th>

<th width="250"><font size="2">IC Number</font></th>

<th width="250"><font size="2">Status</font></th>

</tr>

<?php

mysql_connect("localhost", "root", "")or die(mysql_error());

mysql_select_db("attendance");

$a7=$_POST["class"];

$search=mysql_query("SELECT*from student where class='$a7' ")or die (mysql_error());

$nombor=1;

while($data=mysql_fetch_array($search))

{

$a=$data['nama'];

$b=$data['no_ic'];

?>

<tr>

<td>

<input type="radio" name="Present<?php echo $nombor; ?>" value="Present" >Hadir

<input type="radio" name="Present<?php echo $nombor; ?>" value="Absent">Tidak Hadir

</td>

</tr>

<?php

$no++;

}

?>

</center>

</table>

<label>

</label>

</center>

</form>

purple · November 11, 2013

Actually, i am not familiar with ajax. This is my first time.

codefossa · November 11, 2013

Without going into the security and whatnot you'll need to do such as logins or whatever for the person taking attendance. Here's a little example.

Demo: http://lightron.org/tmp/51/

index.php - Making the Form

<?php

/*
 * By this point you should have the list of users drawn from
 * the database.  I'm just going to use $users for this.
 * 
 * They should have an ID and name which would be for the use of
 * the one taking attendance.
 */

$users = array(
	23 => "Arnold Jackson",
	41 => "Jack Thompson",
	43 => "James Camron",
	44 => "Cindy Loo Hoo",
	56 => "Alison Spangler"
);

?>

<form id="attend" method="post" action="#" autocomplete="off">
	<?php
	
	foreach ($users as $id => $user)
		echo '<input type="checkbox" name="present[]" value="' . $id . '" /> ' . $user . '<br />';
	
	?>
	
	<input type="submit" value="Send" />
</form>

<div id="status"></div>

script.js - Submit with Javascript (Using jQuery)

$(document).ready(function()
{
	function disableForm(disabled)
	{
		$("#attend").find("*").attr("disabled", disabled);
	}
	
	$("#attend").submit(function(e)
	{
		var postdata = $(this).serialize();
		disableForm(true);
		
		$.post('attend.php', postdata, function(data)
		{
			$("#status").html(data);
			disableForm(false);
		});
		
		return false;
	});
});

attend.php - Deal with Submitted Data

<?php

if (isset($_POST['present']))
{
	foreach ($_POST['present'] as $user)
	{
		/*
		 * Now I'm making the assumption that you have a table set up and
		 * it defaults the user to 0 (not present) until changed witht he form.
		 * 
		 * $sql = "UPDATE `table` SET `present` = '1' WHERE `id` = '{$user}' LIMIT 1;";
		 * mysql_query($sql);
		 */
		
		// Just to show something back on the form.
		echo "{$user} is Present<br />";
	}
	
	// Probaby better to go with something along the lines of this.
	echo "<br /><br />The form was successfully submitted.";
}

?>

Edited November 11, 2013 by Xaotique

purple · November 12, 2013

Thanx Xaotique..

codefossa · November 12, 2013

You're welcome. If you get stuck anywhere, feel free to ask. I should note that you could make that 1 query by appending to your query in the foreach loop instead of doing a new query each time. It would make a bit more sense.

Of course, escape everything and whatnot when you do it to avoid anyone taking advantage of that, even though where it sounds like you're using it that wouldn't exactly be a problem. Just better to be safe.

Sign In

how to use radio button in attendance system

Recommended Posts

purple

Link to comment

Share on other sites

requinix

Link to comment

Share on other sites

purple

Link to comment

Share on other sites

purple

Link to comment

Share on other sites

purple

Link to comment

Share on other sites

codefossa

Link to comment

Share on other sites

purple

Link to comment

Share on other sites

codefossa

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information