ok first,
am using dreamweaver to design a page via PHP
- having a table called attendance to monitor student who attends class
- the table sturcture is as follows
1.ID
2.Student_ID
3.Attendance i.e Absent Or Present
4.Date created i.e Timsetamp
5.Firstname
6.lastname
I created a database called "school" with two tables in it i.e "Studentreg""Attendance"
I wish i can upload the image of the table on the page but the table consists of
1. textfielf1=firstname
2.textfield=lastname
3.textfield=student_ID
4.listmenu=attendance
5.Hidden field
6.Button
A repeated region is then applied to the table thatr contains the text fields
..."Fistname" textfield and "lastname" textfield are populated from studentReg table i.e database school.
so my main issue is how to store multiple datas generated by the repeated regions with just a single submit button in to the database because i tried it alot of time and it stores just only one data instead of storing all the datas generated by the region.
here is the code view of the from
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form action="" method="POST" name="form1">
| | | | |
ID | First Name | Last Name | Other Name | Attendance |
<input name="txtID" type="text" id="txtID" value="" /> | <input name="firstname" type="text" id="firstname" value="" /> | <input name="lastname" type="text" id="lastname" value="" /> | <input name="othername" type="text" id="othername" value="" /> | <select name="attendance" id="attendance">
<option selected="selected">---Choose---</option>
<option>Present</option>
<option>Absent</option>
</select> |
<input name="ID" type="hidden" id="ID" value="" /> | | | | |
| | | | <input type="submit" name="Submit" value="Mark Attendance !" /> |
<input type="hidden" name="MM_insert" value="form1">
</form>
</body>
</html>