dynamic array and building functions

[Daikamar]

Hi,

I'm having trouble dealing with dynamic arrays for building some javascript functions.

I make the following array:

// Define PHP arrays
$sbu_phparray = array();
$sql = mysql_query("SELECT sbu_id,sbu_name FROM sbu");
while ($row = mysql_fetch_array($sql)) {
	$sbu_phparray[$row['sbu_id']] = $row['sbu_name'];
	list ($sbu, $name) = $sbu_phparray;
	}

With the current contents of table sbu that gives me an array that looks like this:
[1][Digital]
[2][Analog]
[3][IPSG]

From that, I want to produce the following snippet of javascript:

var U=0;L=1;// (U)nlocked & (L)ocked
function doIt(v)
{
if(v==1){unlock(1);lock(2);lock(3);}
if(v==2){lock(1);unlock(2);lock(3);}
if(v==3){lock(1);lock(2);unlock(3);}
}

I've tried something along the lines of:

reset ($sbu_phparray);
while (list ($id, $name) = each ($sbu_phparray)) {
    echo "if(_v==$id){unlock($id);";
	while (list ($id, $name) = each ($sbu_phparray)) {
	    echo "lock($id);";
	}
    echo "}\n";		
}

but that only results in me getting the first portion of the function because of the array pointer. I've considered putting in a variable to prev() me back to where I belong in the array but I'm not sure how to go about it properly or if that's the best way to go.

Any ideas?

Thanks!

[IceD]

Try following:

reset_($sbu_phparray);
foreach (array_keys($sbu_phparray) as $id)
{
   echo "if (_v == $id) unlock($id); else lock($id);\n";
}

It'll produce different code, but it should work...

[IceD]

BTW. Why do you need such strange code for storing data:

while ($row = mysql_fetch_array($sql))
{
  $sbu_phparray[$row['sbu_id']] = $row['sbu_name'];
}

It'll be much better to use:

$rows = array();
while ($row= mysql_fetch_array($sql))
{
  $rows[] = $row;
}

[Daikamar]

That seemed to do it, thanks!

As far as the code for building the array....I'm not sure but when I try it the way you suggested, then all my key values are off by 1. Weird.

Thanks again!

[IceD]

To Daikamar

then all my key values are off by 1
Not right. In this case data will be organized in this way:

$data = array(array("id" => 1, "name" => "foo"), array("id" => 2, "name" => "bar"), array("id" => 3, "name" => "baz"));

instead of

$data = array(1 => "foo", 2 => "bar", 3 => "baz");

Advantages of the my way (from my point of view 😉 ) are:
1. Code, which retrives data from db is much smaller:

while ($row = mysql_fetch_assoc($res))
{
  $rows[] = $row;
}

comparing to

while ($row = mysql_fetch_assoc($res))
{
  $rows[$row["id"]] = $row["name"];
  $rows[$row["id"]] = $row["age"];
  $rows[$row["id"]] = $row["address"];
  ......
}

2. It's really easy to grep through all data in this case:

foreach ($rows as $row)
{
   do_smth($row);
}

otherwise you should

reset($rows);
while (list($id, $name, ...) = each($rows))
{
  do_smth($id, $name, ...);
}