• 0

Insert via checkbox


Question

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

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.