PHP and JavaScript

Anon

hi there!!

I have a problem with PHP and JavaScript!
The following code doesn't work! Does anybody knows why??

Thank's and regards,
Georg

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">

<HEAD>
<TITLE>Delete User</TITLE>
<SCRIPT LANGUAGE="JavaScript">

function checkAll(field)
{
for (i = 0; i < field.length; i++)
field.checked = true ;
}
function uncheckAll(field)
{
for (i = 0; i < field.length; i++)
field.checked = false ;
}
</script>
</HEAD>
<body background="../images/cla_background.gif">
<H3><font face='Arial' size='2'>Delete User/s</font></H3>
<HR>
<FORM name='form' action='deleteusr.php' method='post'>
<?php
$link=mysql_connect();
mysql_select_db("eclaro");
$request="SELECT usr FROM user;";
$result=mysql_query($request) or die ("Error=".mysql_error());
$number=mysql_num_rows($result);
echo $number."<font face='Arial' size='2'> User/s</font><P>";

  for ($i=0; $i<mysql_num_fields($result); $i++)
   echo "<TABLE border='0' width='25%'>";
   while ($zeile=mysql_fetch_row($result))

      {echo "<TR align='center' font face='Arial' size='2'><TD><INPUT type='checkbox'
         name='Kontroll[]' value='$zeile[0]'></TD>";
       		for ($i=0; $i<mysql_num_fields ($result); $i++)
                    {echo "<TD align='left'><font face='Arial' size='2'>".$zeile[0]."</font></TD>";};
	echo "</TR>";};
echo "</TABLE>";

mysql_free_result($result);
mysql_close($link);

?>
<P>
<INPUT type='submit' value='Delete'>
<INPUT type='reset' value='Reset'>
</FORM>
<HR>
<table border="0" width="30%">
<tr>
<td width="50%"><font face='Arial' size='2'><a href='javascript:checkAll(document.form.Kontroll[])'>Select all</a></font></td>
<td width="50%"><font face='Arial' size='2'><a href='javascript:uncheckAll(document.form.Kontroll[])'>Unselect all</a></font></td>
</tr>
</table>

[deleted]

Could be a million reasons.
How about giving us a hint about what it's not doing, like what kind of errors do you get?

Anon

hi vincent

when I click on the link "Select all" or "Unselect all", all checkboxes should be activated/unactivated but I get the following error message:
Line: 1
Char: 33
Code: 0
URL: http://.......

Thank's for your support,
Georg


<HEAD>
<TITLE>Delete User</TITLE>
<SCRIPT LANGUAGE="JavaScript">

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 ;
         }
</script>
</HEAD>
<body background="../images/cla_background.gif">
<H3><font face='Arial' size='2'>Delete User/s</font></H3>
<HR>
<FORM name='form' action='deleteusr.php' method='post'>
<?php
     $link=mysql_connect();
     mysql_select_db("eclaro");
	$request="SELECT usr FROM user;";
	$result=mysql_query($request) or die ("Error=".mysql_error());
	$number=mysql_num_rows($result);
	echo $number."<font face='Arial' size='2'> User/s</font><P>";

  for ($i=0; $i<mysql_num_fields($result); $i++)
   echo "<TABLE border='0' width='25%'>";
   while ($zeile=mysql_fetch_row($result))

      {echo "<TR align='center' font face='Arial' size='2'><TD><INPUT type='checkbox'
         name='Kontroll[]' value='$zeile[0]'></TD>";
       		for ($i=0; $i<mysql_num_fields ($result); $i++)
                    {echo "<TD align='left'><font face='Arial' size='2'>".$zeile[0]."</font></TD>";};
	echo "</TR>";};
echo "</TABLE>";

  mysql_free_result($result);
  mysql_close($link);

?>
<P>
<INPUT type='submit'  value='Delete'>
<INPUT type='reset'  value='Reset'>
</FORM>
<HR>
<table border="0" width="30%">
  <tr>
    <td width="50%"><font face='Arial' size='2'><a href='javascript:checkAll(document.form.Kontroll[])'>Select all</a></font></td>
    <td width="50%"><font face='Arial' size='2'><a href='javascript:uncheckAll(document.form.Kontroll[])'>Unselect all</a></font></td>
  </tr>
</table>

tomhath

I don't think you want an href here, you're just calling a javascript function:

There's also some problem with using "Kontroll[]" as en element name in Javascript (maybe it works in Javascript, but I've never seen it except when posting an array back to php).

tomhath

The href is okay. Its the [] that's causing problems.

andrin

Try this:

Instead of:

AND

Instead of:

<table border="0" width="30%">
<tr>
<td width="50%"><a href='javascript:checkAll(document.form.Kontroll[])'>Select all</a></td>
<td width="50%"><a href='javascript:uncheckAll(document.form.Kontroll[])'>Unselect all</a></td>
</tr>
</table>

Do like this:

<a href="javascript:checkUncheckAll()">Select/Unselect all</a>

Hope it will work out for you :-) Get back to me if it don´t, OK?
/Andrin

andrin

Hehehe...

I forgot to tell you to rename your form to something other then "form". If you use my example you should name your form to "formMyFormName". I am not sure but your problem could be in your form name. When calling on a form in JavaScript you could do in many different ways:

1) document.forms

i being a numeric value telling you wich form you want to use. Starts at 0 (zero)

2) document.formName

formName being the name you given your form in <form name="formName">

3) document.form["formName"]

formName being the name you given your form in <form name="formName">. This can be were your script fails. You have given your form the name "form" and this maybe (I am not sure) is a reserved word for JavaScript. A tip is to always name your forms something like "formMyOwnName".

4) document.all.elementID

Will only work in MS IE. elementID being the id you given your form in <form id="elementID">.

Good luck :-)