I'm trying to save records from checkbox. storing userid values, but when i'm saving only the last record is being saved. i fnk theres an error in the for each loop or defing the array.. can anyone help plzz.. thx
$display= mysql_query("Select user.firstname, user.lastname, department.dept_name, job_title.title, role.rolename, user.userid From user Inner Join dept_user On user.userid = dept_user.userid Inner Join department On department.dept_id = dept_user.dept_id Inner Join job_title On job_title.title_id = user.titleid Inner Join role On role.roleid = user.roleid Where user.userid = $user1 ");
//echo "first: " . $user1;
// get leader name
$leader = mysql_query("Select firstname , lastname From user Inner Join dept_user On user.userid = dept_user.lead_id Where dept_user.lead_id =$member_id");
while(($row1 = mysql_fetch_array($display)) and ($lead = mysql_fetch_array($leader)))
$second = mysql_query("select userid from dept_user where lead_id=$user1");
while($res1 = mysql_fetch_array($second)){
$user2= $res1['userid'];
echo "<br/>";
if($user2 !==0) {
// echo "Second: " . $user2;
$display2 = mysql_query("Select user.firstname, user.lastname, department.dept_name, job_title.title, role.rolename, user.userid From user Inner Join dept_user On user.userid = dept_user.userid Inner Join department On department.dept_id = dept_user.dept_id Inner Join job_title On job_title.title_id = user.titleid Inner Join role On role.roleid = user.roleid Where user.userid = $user2 ");
//get leader name for second tree view
$leader1= mysql_query("Select firstname , lastname From user Inner Join dept_user On user.userid = dept_user.lead_id Where dept_user.lead_id = $user1");
while(($res1 = mysql_fetch_array($display2)) and ($lead1 = mysql_fetch_array($leader1)))
$third = mysql_query("select userid from dept_user where lead_id=$user2");
while($res2 = mysql_fetch_array($third)) {
$user3 = $res2['userid'];
echo "<br/>";
if ($user3 !== 0){
//echo "third: " . $user3;
$display3 = mysql_query("Select user.firstname, user.lastname, department.dept_name, job_title.title, role.rolename, user.userid From user Inner Join dept_user On user.userid = dept_user.userid Inner Join department On department.dept_id = dept_user.dept_id Inner Join job_title On job_title.title_id = user.titleid Inner Join role On role.roleid = user.roleid Where user.userid = $user3");
$leader2 = mysql_query("Select firstname, lastname From user Inner Join dept_user On user.userid = dept_user.lead_id Where dept_user.lead_id = $user2");
while(($row = mysql_fetch_array($display3)) and ($lead2 = mysql_fetch_array($leader2)))
Question
vimal28
hello,
I'm trying to save records from checkbox. storing userid values, but when i'm saving only the last record is being saved. i fnk theres an error in the for each loop or defing the array.. can anyone help plzz.. thx
<form id="assign" name="assign" method="post" action="assign_individual_exec.php">
<tr><td class="style3">Select course name:</td>
<td><select name="name" class="principal2"><?php select_coursename(); ?></select></td></tr>
<tr><td class="style3"> Start Date</td>
<td><input type="date" name="sdate" ></td><td><script language="JavaScript">
new tcal ({
// form name
'formname': 'assign',
// input name
'controlname': 'sdate'
});
</script></td></tr>
<?php
include('member_table.php');
?>
<tr>
<div align="right"class="lien">
<td><input type="submit" name="individual" value="assign to individual" />
</div></td>
</tr></form></table>
assign_individual_exec.php
<?php
include('include.php');
include('config.php');
require_once('auth.php');
session_start();
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}
$user[]= clean($_POST['userid']);
$name = clean($_POST['name']);
$date = clean($_POST['sdate']);
$month = substr($date, 0 ,2);
$day= substr($date, 3, -5);
$yr = substr($date, 6);
$dash = "-";
$date_str = ($yr.$dash.$month.$dash.$day);
if($name == '') {
$errmsg_arr[] = 'Select Course Name';
$errflag = true;
}
if($date == '') {
$errmsg_arr[] = 'Enter assign date';
$errflag = true;
}
$m_name = $_SESSION['SESS_FIRST_NAME'];
foreach ($user as $user_array){
$insert_query = "INSERT INTO course_detail(userid, course_id, date_assign, owner) VALUES('$user_array','$name','$date_str', '$m_name')";
$insert = mysql_query($insert_query);
}
if($insert_buffer) {
?>
<script type="text/javascript">
alert('Selected individuals have been assigned with course');
window.location='assign_training.php';
</script>
<?php
exit();
}else {
die("Query failed");
}
?>
<?php
$member_id = $_SESSION['SESS_MEMBER_ID'];
$first= mysql_query("select userid from dept_user where lead_id=$member_id");
echo "<table border='1' id=coursetable class=coursetable>
<tr>
<th>first name</th>
<th>last name</th>
<th>dept name</th>
<th>title</th>
<th>rolename</th>
<th>leader first name</th>
<th>leader last name</th>
</tr>";
while($res = mysql_fetch_array($first)){
$user1 = $res['userid'];
//display result from sql
$display= mysql_query("Select user.firstname, user.lastname, department.dept_name, job_title.title, role.rolename, user.userid From user Inner Join dept_user On user.userid = dept_user.userid Inner Join department On department.dept_id = dept_user.dept_id Inner Join job_title On job_title.title_id = user.titleid Inner Join role On role.roleid = user.roleid Where user.userid = $user1 ");
//echo "first: " . $user1;
// get leader name
$leader = mysql_query("Select firstname , lastname From user Inner Join dept_user On user.userid = dept_user.lead_id Where dept_user.lead_id =$member_id");
while(($row1 = mysql_fetch_array($display)) and ($lead = mysql_fetch_array($leader)))
{
echo "<tr>";
//echo "<td>" . $row1['userid'] . "</td>";
echo "<td>" . $row1['firstname'] . "</td>";
echo "<td>" . $row1['lastname'] . "</td>";
echo "<td>" . $row1['dept_name'] . "</td>";
echo "<td>" . $row1['title'] . "</td>";
echo "<td>" . $row1['rolename'] . "</td>";
echo "<td>" . $lead['firstname'] ."</td>";
echo "<td>" . $lead['lastname'] . "</td>";
echo "<td>" .'<input type="checkbox" name="userid" value='.$row1['userid'].'>'."</td>";
//echo "<td>" .'<input name="['.$row['userid'].']" type="checkbox" value="['.$row['userid'].']" ."</td>" ;
echo "</tr>";
}
if ($user1 !== 0){
$second = mysql_query("select userid from dept_user where lead_id=$user1");
while($res1 = mysql_fetch_array($second)){
$user2= $res1['userid'];
echo "<br/>";
if($user2 !==0) {
// echo "Second: " . $user2;
$display2 = mysql_query("Select user.firstname, user.lastname, department.dept_name, job_title.title, role.rolename, user.userid From user Inner Join dept_user On user.userid = dept_user.userid Inner Join department On department.dept_id = dept_user.dept_id Inner Join job_title On job_title.title_id = user.titleid Inner Join role On role.roleid = user.roleid Where user.userid = $user2 ");
//get leader name for second tree view
$leader1= mysql_query("Select firstname , lastname From user Inner Join dept_user On user.userid = dept_user.lead_id Where dept_user.lead_id = $user1");
while(($res1 = mysql_fetch_array($display2)) and ($lead1 = mysql_fetch_array($leader1)))
{
echo "<tr>";
//echo "<td>" . $res1['userid'] . "</td>";
echo "<td>" . $res1['firstname'] . "</td>";
echo "<td>" . $res1['lastname'] . "</td>";
echo "<td>" . $res1['dept_name'] . "</td>";
echo "<td>" . $res1['title'] . "</td>";
echo "<td>" . $res1['rolename'] . "</td>";
echo "<td>" . $lead1['firstname'] . "</td>";
echo "<td>" . $lead1['lastname'] . "</td>";
echo "<td>" .'<input type="checkbox" name="userid" value='.$res1['userid'].'>'."</td>";
echo "</tr>";
}
if ($user2 !== 0){
$third = mysql_query("select userid from dept_user where lead_id=$user2");
while($res2 = mysql_fetch_array($third)) {
$user3 = $res2['userid'];
echo "<br/>";
if ($user3 !== 0){
//echo "third: " . $user3;
$display3 = mysql_query("Select user.firstname, user.lastname, department.dept_name, job_title.title, role.rolename, user.userid From user Inner Join dept_user On user.userid = dept_user.userid Inner Join department On department.dept_id = dept_user.dept_id Inner Join job_title On job_title.title_id = user.titleid Inner Join role On role.roleid = user.roleid Where user.userid = $user3");
$leader2 = mysql_query("Select firstname, lastname From user Inner Join dept_user On user.userid = dept_user.lead_id Where dept_user.lead_id = $user2");
while(($row = mysql_fetch_array($display3)) and ($lead2 = mysql_fetch_array($leader2)))
//$a= $row['userid'];
{
echo "<tr>";
// echo "<td>" . $row['userid'] . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['dept_name'] . "</td>";
echo "<td>" . $row['title'] . "</td>";
echo "<td>" . $row['rolename'] . "</td>";
echo "<td>" . $lead2['firstname'] . "</td>";
echo "<td>" . $lead2['lastname'] . "</td>";
echo "<td>" .'<input type="checkbox" name="userid" value='.$row['userid'].'>'."</td>";
echo "</tr>";
}
}
}
}
}
}
}
}
echo "</table>";
?>
Link to comment
Share on other sites
0 answers to this question
Recommended Posts