please help. how do i add checkbox values in mysql row

Question

fortiz147 0 Newbie Poster

15 Years Ago

here's the process:
1. i display the mysql data in rows with checkboxes on each row
2. i want to add the checked values into another table under the specific field employee

here's the problem: i can't seem to insert the checked value to the specified project table.
what if i had different projects in that table, how will the query know that i want to insert that specific employee to the project table?

php

4 Contributors
5 Replies
186 Views
2 Years Discussion Span
Latest Post 13 Years Ago Latest Post by Ezzaral

All 5 Replies

phpuser 1 Junior Poster in Training

15 Years Ago

hi,may be i help you.i understand little what you want but if you paste your code here then it will be useful for me :)

fortiz147 commented: thank you for helping me ^_^ +1

ahmadjhoney 0 Newbie Poster

15 Years Ago

hello everyone,,i new in php...

plz tell me about getting page id,,\

how can i get a apecifuc page id..\\

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

fortiz147 0 Newbie Poster · Answer 1 · 2008-08-28T08:10:28+00:00

thank you!!! here's my code.

Display the Mysql Table and assign checkboxes for each value:

<html>
<head>
<link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon">
<link rel="icon" href="images/favicon.ico" type="image/x-icon">


<title>SM PORTAL WEBSITE</title>

<meta http-equiv="Content-Type" content="text/html;">
<SCRIPT language=JavaScript>
function makeArray() {
     for (i = 0; i<makeArray.arguments.length; i++)
         this[i] = makeArray.arguments[i];
 }

function getFullYear(d) {
    var y = d.getYear();
    if (y < 1000) {y += 1900};
    return y;
}

//var zone = "EDT";
var days = new makeArray("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday");
var months = new makeArray("January","February","March","April","May","June","July","August","September","October","November","December");

function format_time(t) {

    var Day = t.getDay();
    var Date = t.getDate();
    var Month = t.getMonth();
    var Year = t.getFullYear();

    timeString = "";
    timeString += days[Day];
    timeString += ", ";
    timeString += " ";
    timeString += months[Month];
    timeString += " ";
    timeString += Date;
    timeString += ", ";
    timeString += " ";
    timeString += Year;

   return timeString;
 }
</SCRIPT>
<link rel="stylesheet" href="styles.css" type="text/css">
</head>
<body bgcolor="#B49BCD" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#747AC6" vlink="#B49BCD">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
  <tr> 
    <td valign="top" height="84" background="images/header_fill.jpg"><img src="images/smheaderlogo.jpg" width="321" height="84"></td>
  </tr>
  <tr> 
    <td valign="top" height="22" background="images/blue_fill.gif" align="right"> 
      <table width="220" border="0" cellspacing="0" cellpadding="0" height="22">
        <tr> 
          <td width="37"><img name="blue_crn" src="images/blue_crn.gif" width="37" height="22" border="0"></td>
          <td background="images/lt_blue_fill.gif" class="date" width="200"> 
            <script language=JavaScript>
			<!--
			d = new Date();
			document.write(format_time(d));
			// -->
		</script>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td valign="top"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
        <tr> 
          <td width="140" bgcolor="#92A2E1" valign="top" align="center"> <br>
            <table width="80%" height="228" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td class="links"><p><a href="home.htm"><img src="images/square.gif" width="7" height="7" border="0"></a> HOME<br>
                      <br>
                      <a href="http://10.101.4.21/nagios/"><img src="images/square.gif" width="7" height="7" border="0"></a> NAGIOS<br>
                      <br>
                      <a href="http://10.101.4.21/cgi-bin/smokeping.cgi"><img src="images/square.gif" width="7" height="7" border="0"></a> SMOKE 
                  PING <br>
                      <br>
                      <a href="http://10.101.160.59:9675/account/login"><img src="images/square.gif" width="7" height="7" border="0"></a> SPICEWORKS<br>
                      <br>
                      <a href="http://10.101.160.59:9675/helpdesk"><img src="images/square.gif" width="7" height="7" border="0"></a> HELP 
                  DESK <br>
                      <br>
                      <a href="humanresourcemanagement1.htm"><img src="images/square.gif" width="7" height="7" border="0"></a> HUMAN 
                  RESOURCE MANAGEMENT</p>
                  <p><a href="memberlogin.php"><img src="images/square.gif" alt="df" width="7" height="7" border="0"></a> BLOG</p></td>
              </tr>
            </table>
            <p>&nbsp;</p></td>
          <td valign="top" bgcolor="#FFFFFF"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="30" height="100%">
              <tr>
                <td width="90%" valign="top" bgcolor="#FFFFFF" class="text"><p>&nbsp;</p>
                <p>&nbsp;</p>
				




<?php

//mysql connection
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "smportal";


	//Connect to MySQL Server
mysql_connect($dbhost, $dbuser, $dbpass);
	//Select Database
mysql_select_db($dbname) or die(mysql_error());
	// Retrieve data from Query String






$query="SELECT * FROM employee"; // query on table
$qry_result = mysql_query($query) or die(mysql_error());


$count = mysql_num_rows($qry_result); // count query result

 

  ?>


<form method="post" action="addemptoproj.php">







  <?php
$display_string = "<table border='2' cellpadding='3'>";
$display_string .= "<tr>";
$display_string .= "<th>First Name</th>";
$display_string .= "<th>Last Name</th>";
$display_string .= "<th>Qualification</th>";
$display_string .= "<th>Add</th>";
    //loop here

   while($row = mysql_fetch_array($qry_result))

    {

    //inside while

	$display_string .= "<tr>";
	$display_string .= "<td>$row[Fname]</td>";
	$display_string .= "<td>$row[Lname]</td>";
	$display_string .= "<td>$row[Qualification]</td>";



	


$display_string .= "<td><input type='checkbox' name='checkbox[]' id='checkbox[]' value='$row[empId]' /></td>";


 
$display_string .= "</tr>";
   }

$display_string .= "</table>";
$display_string .= "<table cellpadding='5' align='center'><td><input id='delete' type='submit' name='delete' value='Delete'/></td></table>";

echo $display_string;

?>



 </form>


   


</td> 
                <td width="10%" height="370" valign="top" bgcolor="#FFFFFF" class="text">&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr> 
          <td width="140" bgcolor="#92A2E1" height="27">&nbsp;</td>
          <td align="right" height="27" bgcolor="#FFFFFF"><img name="footer_right" src="images/footer_right.gif" width="110" height="27" border="0"></td>
        </tr>
        <tr> 
          <td width="140" background="images/footer_fill.jpg" height="38">&nbsp;</td>
          <td align="right" height="38" background="images/footer_fill.jpg"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0" background="images/footer_fill.jpg">
              <tr> 
                <td valign="bottom" align="center" class="footer">Copyright &copy; 
                  SM Mart Inc. All Rights Reserved.</td>
                <td align="right" width="110"><img name="footer_right2" src="images/footer_right2.gif" width="110" height="38" border="0"></td>
              </tr>
            </table>
          </td>
        </tr>
        <tr> 
          <td width="140" height="10">&nbsp;</td>
          <td align="right" height="10">&nbsp;</td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>

This code is suppose to add the checked values to the latest/maximum empId which is autogenerated in the specified field,employee, in table hrm1.

<?php
#
//mysql connection here

//mysql connection
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "smportal";


	//Connect to MySQL Server
$dbconn=mysql_connect($dbhost, $dbuser, $dbpass);
	//Select Database
mysql_select_db($dbname) or die(mysql_error());
	// Retrieve data from Query String
 
#
if($_POST['delete']) // from button name="delete"
#
{
#
$checkbox = $_POST['checkbox']; //from name="checkbox[]"
#
$countCheck = count($_POST['checkbox']);
#
 
#
for($i=0;$i<$countCheck;$i++)
#
{
#
$del_id = $checkbox[$i];
#

$sql = "SELECT * FROM employee WHERE empId=$del_id";

$result = mysql_query($sql, $dbconn);

while($row = mysql_fetch_array($result)){
$sql3 = "SELECT hrmId, MAX(hrmId) FROM hrm1";
$sql2 = "INSERT INTO hrm1 (workingemp) VALUES ('{$row[Fname]}')";
mysql_query($sql2, $dbconn);
mysql_query($sql3, $dbconn);
}



}
#
if($result)
#
{

echo "SUCCESS";

}

else

{
include("delete.php");

}

}

?>

phpuser 1 Junior Poster in Training · Answer 2 · 2010-09-23T18:54:47+00:00

Hi,fortiz147

here as per your pasted code first of all there is no connection between your new inserted data and employee id i mean your $sql2 and $sql3 on line number 41,42 are totally independent.

Your coding is right for insert Data in table but still if you cant find new entry in table "hrm1" then you can do echo $sql2 and can run query direct in Phpmyadmin sql section so can get idea wheres the problem.

Best luck..

Ezzaral 2,714 Posting Sage Team Colleague Featured Poster · Answer 3 · 2010-09-23T23:49:11+00:00

Ezzaral 2,714 Posting Sage

13 Years Ago

I doubt he is still looking for help with this two years later.

please help. how do i add checkbox values in mysql row

Recommended Answers Collapse Answers

All 5 Replies

Recommended Answers