Jump to content

Got a javascript script for checking a check box which I cant get to work


Recommended Posts

Hi All

 

I have got a javascrit script which should on a button press check all or uncheck all checkbox's it works on the web site I got it from but when I have placed it into my php page I cant get it to work. I have tried the javascript in a none php page and it works. Below is my php page. Can some one point in the right direction please.

 

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<?php 
//*******************************************************
//
// Open Connection to Database
//
//*******************************************************

  include ("connection.php");
//$row_ID = (isset($_GET['row_ID'])) ? $_GET['row_ID'] : '';
$row_ID = (isset($_POST['row_ID'])) ? $_POST['row_ID'] : '';
//if(isset($_POST['row_ID']) && $_POST['row_ID']) $row_ID = $_POST['row_ID']; 
if(isset($_POST['COMPANY_id']) && $_POST['COMPANY_id']) $COMPANY_id1 = $_POST['COMPANY_id'];

//$row_ID = "RMAD100";
$SHIPDATE = date("Y-m-d");
?> 

<head>
<link rel="stylesheet" type="text/css" href="robtest1.css" />
</head>
<body>
<SCRIPT LANGUAGE="JavaScript">
<!-- 	
// by Nannette Thacker
// http://www.shiningstar.net
// This script checks and unchecks boxes on a form
// Checks and unchecks unlimited number in the group...
// Pass the Checkbox group name...
// call buttons as so:
// <input type=button name="CheckAll"   value="Check All"
//onClick="checkAll(document.myform.list)">
// <input type=button name="UnCheckAll" value="Uncheck All"
//onClick="uncheckAll(document.myform.list)">
// -->

<!-- Begin
function checkAll(field)
{
for (i = 0; i < field.length; i++)
field[i].checked = true ;
}

function uncheckAll(field)
{
for (i = 0; i < field.length; i++)
field[i].checked = false ;
}
//  End -->
</script>

<div id="wrapper">
<fieldset>
<legend>JOB ID Update</legend>
<?php 

include 'menus.php';

?>
<br>
<br>
<br>
<form name="myform" action="jobid.php" method="POST">
<?php
echo "<input type=\"hidden\" name=\"row_ID\" value=\"$row_ID\"><br>";

echo"<div class=\"mytext2\">Advice Note No.</div><input type=\"text\" id=\"ADVICENOTE\" name=\"ADVICENOTE\" value=\"\" title=\"ADVICENOTE\"><br>
<div class=\"mytext2\">Job ID</div><input type=\"text\" id=\"JOBID2\" name=\"JOBID2\" value=\"\" title=\"JOBID2\"><br>
<div class=\"mytext2\"><b>Shipped Date</b></div>
<input type=\"text\" id=\"SHIPDATE\" name=\"SHIPDATE\" value=\"$SHIPDATE\" title=\"SHIPDATE\" maxlength=\"10\" size=\"10\"><br>";

echo "<div class=\"mytext2\"><b>Customer</b></div>
<select name=\"COMPANY_id\">
<option>$COMPANY_id</option>";

$query1 = "SELECT DISTINCT COMPANY_id FROM addresses ORDER BY COMPANY_id ASC";
$result1 = mysql_query($query1);
$num_rows=mysql_num_rows($result1);
while ($row=mysql_fetch_array($result1))
{
$COMPANY_id = $row["COMPANY_id"];
echo "<option value=\"$COMPANY_id\">$COMPANY_id</option>";
}
echo "<option></option></select><br>";

echo "<table width=\"50%\"><tr>";
echo "<td align=\"center\" Class=\"TableRowTitle\" width=\"12.5%\">Serial No</td><td align=\"center\" Class=\"TableRowTitle\" width=\"12.5%\">Select</td></tr>";

$query1 = "SELECT * FROM products where jobid = '$row_ID' order by SERIALNO asc LIMIT 0 , 1000;";
$result1 = mysql_query($query1);
$num_rows=mysql_num_rows($result1);
while ($row=mysql_fetch_array($result1))
{

$SERIALNO  = $row['SERIALNO'];

echo "<tr  onMouseOver=\"this.bgColor = '#C0C0C0'\" onMouseOut =\"this.bgColor = '#EDEDED'\" bgcolor=\"#EDEDED\">
<td Class=TableRow8 width=\"12.5%\">$SERIALNO</td><td Class=TableRow8><input type=\"checkbox\" name=\"id[]\" value=\"$SERIALNO\"></td></tr>";


}
echo "</table>";


$ADVICENOTE =$_POST['ADVICENOTE'];
$SHIPDATE =$_POST['SHIPDATE'];
$JOBID2 =$_POST['JOBID2'];
//$COMPANY_ID =$_POST['COMPANY_ID'];


if (!empty($_POST['id'])) {


//echo "ROW_id = $row_ID<br>";

$query =("UPDATE products SET ADVICENOTE = '$ADVICENOTE' , SHIPDATE = '$SHIPDATE' , COMPANY_ID = '$COMPANY_id1' , JOBID = '$JOBID2' WHERE SERIALNO IN('" . implode("','",$_POST['id']) . "')");

//AND SERIALNO IN('" . implode("','",$_POST['id']) . "')");  
//echo "$query<br>";

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
}
?>
<input type="button" name="CheckAll" value="Check All" onClick="checkAll(document.myform.list)">
<input type="button" name="UnCheckAll" value="Uncheck All" onClick="uncheckAll(document.myform.list)">
<input type="submit" name="submit1" value="SAVE" Class="LoginButtons">
</form>
</div>
</body>
</html>

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.