arrays

[thekidscareya]

i have 2 variables:
$operation and $value

$operation = array('0'=>'Robert',
'1'=>'William',
'2'=>'Joseph'
);

$value = array('0'=>'Bob',
'1'=>'Bill',
'2'=>'Joe'
);

how do i search in $operation (array) for all the number in $value (array)?

i know it would be easier to remove the numbers and have Robert=>Bob, but it will mess up my whole program, if I did that.

Thanks.

[sneakyimp]

if you want to return the index of $operation for a given item in $value, you will have to loop through all the elements of $operation. Given your example, though, I cannot think of any programmatic way to correlate a given item in $operation with a given $value. I know because I'm an anglo-saxon human being that 'Bill' is a nickname for 'William' and that the two correspond, but a computer is not going to know this...unless i define another array which gives me the nickname for a given full name....something like

$nicknames['William'] = 'Bill';

if this extra array existed, then i might be able to write a function like this:

function get_operation_index($val_name) {
global $operation;

foreach($operation as $key=>$name) {
if ($nicknames[$name] == $val_name) {
return $key
}
}

return false;
}

and call it like this:
$index = get_operation_index($value[0]);
// this should say 'William'
echo $operation[$index];

On the other hand, your example suggests that $operation and $value refer to the same items, only $value contains nicknames and $operation contains full names. If you are certain that this relationship is always true, then you know that the nickname if $operation[1] is $value[1].

[thekidscareya]

what you wrote helped a lot

i just modified it a little bit and made this

function get_operation_index($val_name) 
	{
		global $operation;

		foreach($operation as $key=>$name) 
			{
				if ($key == $val_name) 
					{
					return $name;
					}
			}	
	return false;
} 

that is what i was looking for

thanks soooooooooo much...this saved soome of my brain cells 🙂

[thekidscareya]

one more prob:

$val_name & $name are both arrays - the function works if they are both just a regular old string...but not arrays - how should i go on fixing that?

thanks.

[sneakyimp]

if you looked at my example, i didn't intend for $val_name to be an array. it's a string.

I suggest you work at it yourself. You might just figure it out.

[thekidscareya]

It doesn't seem to work very well in the following script.

<?php
// process the search 
function search_process($table)
	{
	// rename all the post variables
	$orderby = $_POST['orderby'];
	$fields = $_POST['fields'];
	$limit = $_POST['LIMIT'];
	$sortby = $_POST['sortby'];
	$value = $_POST['value'];
	$operation = $_POST['operation'];

// build sql
$sql = "SELECT * FROM $table "; // which table

// filter out all values w/o a WHERE clause value
$value = array_filter($value);


	$field_sql = "SELECT * FROM $table";
	$field_query = mysql_query($field_sql) or error(mysql_error());
	foreach($value as $number=>$val)
		{
		echo "<br>value Number=$number Val=$val <br>"; // debug
		for($i=0; $i <= $number; $i++)
			{
			echo "<br> Z=$i - num=$number <br>";
			$field_name = mysql_field_name($field_query,$i) or error(mysql_error());
			$index = get_operation_index($value[$i]);
			$newsql = "$field_name $index $value[$i]<br>";
			echo "<br> WHERE $newsql <br>";  //debug
			}
		}


$sql .= "ORDER BY $orderby $sortby "; // how to sort data - if any


if(is_numeric($limit))
	{
	$sql .= "LIMIT $limit"; // set the limit - if any
	}

echo $sql;
// perform query
$query = mysql_query($sql) or error(mysql_error());
$count = count($fields);

while($row = mysql_fetch_row($query))
	{
	for($i=0; $i<$count; $i++)
		{
		$name = mysql_field_name($query,$i) or error(mysql_error());
		echo "<table width='580' border='1'>";
			echo "<tr><th align='left' scope='col'>{$name}: {$row[$i]}</th></tr>";
		echo "</table>";
		}
	echo "<br>";
	}
}

// show search form
function search_form($tbl)
	{
	// get field data
	$sql = "SELECT * FROM $tbl";
	$query = mysql_query($sql) or error(mysql_error());
	$field_count = mysql_num_fields($query) or error(mysql_error());

// show the main headings
echo "<form method='post' action='{$PHP_SELF}?act={$tbl}'>";
		echo "<table width='642' height='68' border='0'>";
		echo "<tr>";

			echo "<th width='158' height='64' scope='col'>Fields:";
			echo "<select name='fields[]' size='5' multiple>";

				for ($x=0; $x < $field_count; $x++) 
					{
					$field = mysql_field_name($query, $x);
					echo "<option value='{$field}' selected>{$field}</option>";
					}

			echo "</select>";
			echo "</th>";

			echo "<th width='220' scope='col'>Number of Rows:";
			echo "<input name='LIMIT' type='text'>";
			echo "</th>";

			echo "<th width='250' scope='col'>";
			echo "Display By ";
			echo "<select name='orderby'>";

				for ($x=0; $x < $field_count; $x++) 
					{
					$field = mysql_field_name($query, $x);
					echo "<option value='{$field}'>{$field}</option>";
					}


			echo "</select>";
			echo "<br><input name='sortby' type='radio' value='ASC' checked>Ascending";
			echo "<br><input name='sortby' type='radio' value='DESC'>Descending";
			echo "</th>";

		echo "</tr>";
	echo "</table><br>";

	// field headings
	echo "<table width='590' border='0'>";
		echo "<tr>";
			echo "<th scope='col'>Field</th>";
			echo "<th scope='col'>Operation</th>";
			echo "<th scope='col'>Value</th>";
		echo "</tr> Not WORKING";

// create an array of all the fields in the table
for ($x=0; $x < $field_count; $x++) 
	{
	$field = mysql_field_name($query, $x);
		echo "<tr>";
			echo "<th width='111' scope='col'>{$field}</th>";
			echo "<th width='183' scope='col'>";
					echo "<select name='operation[]'>";
					 echo "<option value='='>=</option>";
								echo "<option value='&gt;'>&gt;</option>";
								echo "<option value='&gt;='>&gt;=</option>";
								echo "<option value='&lt;'>&lt;</option>";
								echo "<option value='&lt;='>&lt;=</option>";
								echo "<option value='!='>!=</option>";
								echo "<option value='LIKE'>LIKE</option>";
								echo "<option value='NOT LIKE'>NOT LIKE</option>";
					echo "</select>";
					echo "</th>";
				echo "<th width='282' scope='col'><input name='value[]' type='text'></th>";
			echo "</tr>";
	}

// finish up the form
	echo "</table>";
echo "<input name='Search' type='submit' value='Search'>";	
echo "</form>";
}

function get_operation_index($val_name) 
	{
		global $operation;

		foreach($operation as $key=>$name) 
			{
			echo "<br>operation: $key => $name <br>"; // debug
				if ($key == $val_name) 
					{
					return $name;
					}
			}	
	return false;
} 

?>

search_form() echoes out the form and it goes to search_process() for processing

(im not finished with the search_process() part - the WHERE clause isn't part of $sql yet - i havent implemented that yet)

when i enter 1 WHERE clause it seems to be working fine, but when i add 2 or more WHERE clauses it acts weird and i get bad results

i get this

value Number=0 Val=sdfsdf

Z=0 - num=0

operation: 0 => =

WHERE DeptID = sdfsdf

value Number=1 Val=sddd

Z=0 - num=1

operation: 0 => =

WHERE DeptID = sdfsdf

Z=1 - num=1

operation: 0 => =

WHERE Name = sddd

SELECT * FROM tbldept ORDER BY DeptID ASC

and the results from the db

thanks in advance for all ur help

[sneakyimp]

i think you are confused by foreach. $number is not the size of an array in your code, it's the index of that particular array element

if $arr is an array with four elements, this code:

$arr[0] = 'zero;'
$arr[1] = 'one';
$arr[2] = 'two';
$arr[3] = 'three';
$arr[4] = 'four';


foreach($arr as $key=>$value) {
  echo "$key is $value\n";
}

will output something like this:

0 is zero;
1 is on'
2 is two
3 is three
4 is four

Sorry, but I can't provide a solution for you. I'm trying to pay the rent myself.