Help: Student Attendance Management in Joomla

[aryans14]

I have created a website for my College and want to have free module that allows teacher to mark attendance and allow students to view it and it creates attendance reports as well.

Please experts help me.

[fleischwolf]

Hi aryans14 and welcome to the forum!

It sounds like, for instance, Fabrik could help you out here -> http://fabrikar.com/.

[aryans14]

I tried that already. It fails to install. Moreover i dont know that how to work in fabrik

[fleischwolf]

It fails to install.

What was the error message?

Moreover i dont know that how to work in fabrik

Then you should look for another component that suits your needs in the JED -> http://extensions.joomla.org/. However, without diving into the particulars of how a specific component works you will find it very difficult to achieve your goal.

[aryans14]

fabric is installed and ok now.
But i dont know how to create forms and work on it.
I have attendence lists of stdnts. Just teacher have to log in and mark chacks on attendance of student who were present. And student must be able to view it.

[aryans14]

Please help me experts. Where are you.Where is Joomla Support!!!!

[waqas07]

i am developing student management system in joomla it will be available in next 10 days. if you want to build your own module i will refer you component builder tool which is v.easy and effective

[waqas07]

I created this script and i think its fullfill your initial requirements for attendance.
you can use this scripts in sorcerer joomla and then you can create table and columns as in script or you can change by ur requirements. jquery with php and sql.

[waqas07]

here are scripts


jquery_post.php

<?php

//DataWriter

if($_POST["name"])
{

$name = $_POST["name"];
$class = $_POST["class"];
$present = $_POST["present"];

insertAttendance($name, $class, $present);

echo "Welcome ". $name ."!"; // Success Message
}

if ( isset($_SESSION['count']) ){
echo $_SESSION['count'];
}



function insertAttendance($student_name, $student_class, $student_present) {

$mysqli = new mysqli('localhost', 'root', '', 'hrc');

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

$stmt = $mysqli->prepare(" INSERT INTO Attendance(name, class, present) VALUES (?, ?, ?) ");
$stmt->bind_param("sss", $student_name, $student_class, $student_present);


/* execute prepared statement */
$stmt->execute();

/* close statement and connection */
$stmt->close();

/* close connection */
$mysqli->close();
}

[waqas07]

jquery_send.php

<?php

$mysqli = new mysqli("localhost", "root", "", "hrc");

/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}

$result = $mysqli->query("SELECT * FROM Attendance");

$mysqli->close();

?>

[waqas07]

fabrik is solution for that as well. list plugins will help you for attendance management system.