Hidden Field+JavaScript+PHP

[donnierivera]

I am trying to find which check boxes the user checked (Which are created by pulling information from a db). How would I pass the information to a JavaScript function... The problem is that I want to check if the user checked any check box and which ones were checked for in insert into the db. I know I can hard code it, but I want this to be as dynamic as posibile. Here is what I have came up with so far....

this is the first page...Scripts

<SCRIPT LANGUAGE="JavaScript">
<!--
function getSelected(opt) {
var selected = new Array();
var index = 0;
for (var intLoop = 0; intLoop < opt.length; intLoop++) {
if ((opt[intLoop].selected) ||
(opt[intLoop].checked)) {
index = selected.length;
selected[index] = new Object;
selected[index].value = opt[intLoop].value;
selected[index].index = intLoop;
}
}
return selected;
}
function outputSelected(opt) {
var sel = getSelected(opt);
var strSel = "";
for (var item in sel)
strSel += sel[item].value + "/";
alert(strSel);
document.write("<input value="+strSel+" type=hidden name=facility>");
}
//-->
</SCRIPT>

<?php
$i=0;
while ($i<$z) {

                                         print("<td width='15%'>");
                                         print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type='checkbox' name='fac_cd' value='$fac_cd[$i]'> $facSortDesc[$i]");
                                         print("</td>");
                                         if ($i%4==3) print("<tr width='15%'>");
                                         $i++;
                                         if ($i%4==0) print("</tr>") ;
                                  }
                               ?>

Here is the second page Scripts...

<?php
function IsDate($orig_data){
$data=explode("/","$orig_data");
$d=$data[0];
$m=$data[1];
$y=$data[2];
$res=checkdate($m,$d,$y);
if ($res==1) { return true;}
else { return false;}
}
//Connect to informix
$dbConnection=ifx_connect() or die("Connection to the Database failed");
//Query the database for facilities
$SELECT="SELECT fac_cd ";
$FROM= "FROM informix.events_fac ";
$builtQuery=$SELECT.$FROM;
$facilityQuery=ifx_query("$builtQuery", $dbConnection) or die("Query failed");
$rowsReturned=ifx_fetch_row($facilityQuery);
$z=0;
//Return the rows form Query
while (is_array($rowsReturned)) {
for(reset($rowsReturned); $fieldName=key($rowsReturned); next($rowsReturned)){
if ($fieldName==fac_cd) {
$fieldValue=$rowsReturned[$fieldName];
$fac_cd[$z]=trim($fieldValue);
}
}
$rowsReturned=ifx_fetch_row($facilityQuery);
$z++;
}
ifx_free_result($facilityQuery);
$dbConnection=ifx_close();

  if ($title=="") $titleCheck="false";
  else $titleCheck="true";

  if (IsDate($strtDate)==false) $strtDateCheck="false";
  else $strtDateCheck="true";

  if (IsDate($endDate)==false) $endDateCheck="false";
  else $endDateCheck="true";

  if ($desc=="") $descCheck="false";
  else $descCheck="true";

  $i=0;
  $facilityCheck="false";
  while ($i<$z) {
    if ($HQ==true) $facilityCheck="true";
    $i++;
  }
  if ($titleCheck=="false" or $strtDateCheck=="false" or $endDateCheck=="false" or $descCheck=="false" or $facilityCheck=="false") {
    echo $facilityCheck;
    //header("Location: http://localhost/index/updateEvents.php?title=$titleCheck&strtDate=$strtDateCheck&endDate=$endDateCheck&desc=$descCheck&fac=$facilityCheck");
   // exit;
  }

?>

[trooper]

dr

You've got to understand that PHP is a server side language and javascript is a client side language.

Trying to mix the two is a real pain.

If you really want to use PHP then do the whole thing in PHP.
I've recently just done this and i used:

if($variable =="y")
{
// do something
}

print "<form action=$PHP_SELF;>\n";

if($variable =="y")
{
$status = "checked"
}else{
$status =""
}
print "<input type=\"checkbox\" name=\"variable\" value=\"y\" $status>\n";

input type=\"sumbit\" value=\"submit\">

print "</form>\n";

Gary Mailer

[amcgrath]

Just to show another way, gary, you could shorten the code:
if($variable =="y")
{
$status = "checked"
}else{
$status =""
}

to this:
$status = ($variable == "y" ? "checked": "");

And Dr, gary's right go one way or the other...

[donnierivera]

I understand the difference between server and client side script. I was just trying to come up with away of doing this with out having to hard code everything on the second page (I want to use a db). Is there a way to populate a variable in a hidden field, so that when the user selects submit it send that variable to the next page. I can't use a get method (I know I could parse it) because the url can only hold so much information. Any way, here is an example of what I have came up with, but it doesn't work...It locks up...Thanks for any help...

function getSelected(opt) {
var selected = new Array();
var index = 0;
for (var intLoop = 0; intLoop < opt.length; intLoop++) {
if ((opt[intLoop].selected) ||
(opt[intLoop].checked)) {
index = selected.length;
selected[index] = new Object;
selected[index].value = opt[intLoop].value;
selected[index].index = intLoop;
}
}
return selected;
}
function outputSelected(opt) {
var sel = getSelected(opt);
var strSel = "";
for (var item in sel)
strSel += sel[item].value + "/";
alert(strSel);
document.write("<input value="+strSel+" type=hidden name=facility>");
}

[trooper]

dr

if you have varibales in a form they will by default be passed onto the next page.

As for what method to use try "post"

When you click submit any fields that hae a value in thtm will also be passed onto the next page.

Remember that on the second page you'll need to print /echo the correct variable name (set in the first page)

gary mailer

[donnierivera]

I know that, but the problem is that I pull information from a field in the db. I get that value and put it into a array. Example...
if ($fieldName==fac_cd) {
$fieldValue=$rowsReturned[$fieldName];
$fac_cd[$z]=trim($fieldValue);
}
I do this so I don't have to hard code on the first page. Example...Hard Code
<imput type="checkbox" name="AV" value="bla">
<imput type="checkbox" name="HQ" value="bla">
<imput type="checkbox" name="TR" value="bla">

Example....Dynamic
while ($i<$z) { print("<td width='15%'>");
print("<input type='checkbox' name='fac_cd[$i]' value='bla'> $facSortDesc[$i]");
print("</td>");
if ($i%4==3) print("<tr width='15%'>");
$i++;
if ($i%4==0) print("</tr>") ;
}

On the second page I get the same field from the db. So that I don't have to hard code...
if ($AV==true) $facilityCheck="true";
if ($HQ==true) $facilityCheck="true";
if ($TR==true) $facilityCheck="true";
Dynamic...
while ($i<$z) {
if ($fac_cd==true) $facilityCheck="true";
$i++;
}

The problem is that I don't want to maintain this once it is done. I would rather use the db for change and not hard code it when something changes. Basically, I am stuck. I want to use the field in the db, to create the check boxes on the first page. But on the second page I want make sure they checked a check box and if one is checked insert that information into the db. Any suggestions would be greatly appreciated.

dr.

ps. I am not trying to be a smart*&%, just trying to be clear on what I am trying to do...thanks for the help...