generating queries for multiple tables from 1 array

[pepijn]

Ok I have been working with PHP for years but am not very skilled at arrays..
I am working on an existing class which was used to generate forms and the mysql query to insert the generated form.. However, this only supported one table, predefined at the start of the script. This will not work for this project and I need to make it support multiple tables.. And it's been breaking my brain!

Maybe I'm just missing something, but I couldn't find an easy way to do it..
So far I have managed to generate 3 arrays with the necessary info:

$fields (field name in the database)
$values (the value that belongs to the field)
$table (the table that field should be inserted into)

Example:

$fields[0] = 'name'
$values[0] = 'Tony'
$table[0] = 'users'

$fields[1] = 'adres'
$values[1] = 'Sesamestreet 17'
$table[1] = 'adres'

$fields[2] = 'name'
$values[2] = 'Albert'
$table[2] = 'users'

There's just one problem, the $table array holds multiple tables, as you can see..
I need to check how many different ones there are to start with, which is already beyond me.. (I'm more of a mysql buff, but of course there's no "count(*) where xxx = xxx" )

Am I just thinking way too difficult again (like usual)?

[pepijn]

Ok I forgot to post some code which I've been brainstorming on...

$table_numbers = array_keys($tabels_array, $tabels_array[0]);

This gets me all the $array[numbers] that I can use, so it's actually easy to generate a query like this, but I just need to figure out a way to get a list of all the unique table names.

Lets say the array looks like this:
Array (
[0] => ouder
[1] => ouder
[2] => ouder
[3] => ouder
[4] => ouder
[5] => ouder
[6] => ouder
[7] => ouder
[8] =>
[9] => ouder
[10] => huis
[11] => huis
[12] => huis
[13] =>
[14] =>
[15] => huis
)

I want something which just counts the different types, and NOT include the empty values.. So in this case it would just output "2"..

I feel like such a n00b for not being able to figure this out 🙁

[devinemke]

[man]array_unique[/man]
[man]array_count_values[/man]

[pepijn]

Yes I have been messing around with those two already..
The unique didn't work at all before, but now it seems to work better.. Guess I solved a problem somewhere else in my 3000 lines of code

But yeah it still counts the NULL value, so I guess I'll just UNSET that, which should work fine..

[pepijn]

Ok I've gotten really close to solving the problem..

$tot=count($veld);


		for ($j=0; $j < $tot; $j++)
		{


			if($j==0)
			{

				$velden.=$data[$veld[$j]]['veld'];
				$waarden.="'".$data[$veld[$j]]['waarde']."'";
				$tabellen.=$data[$veld[$j]]['tabel'];
			}
			else
			{
				$velden.=','.$data[$veld[$j]]['veld'];
				$waarden.=",'".$data[$veld[$j]]['waarde']."'";
				$tabellen.=','.$data[$veld[$j]]['tabel'];
			}
		}

//----------------------------------------------------------------------------------------------

		$veld_array = explode(",", $velden);
		$waarde_array = explode(",", $waarden);
		$tabellen_array = explode(",", $tabellen);
		$array_unique = array_unique($tabellen_array);
		$key = array_keys($array_unique, '');
		unset($array_unique[$key[0]]);
		$aantal_queries = count($array_unique)-1;
		$tabel_array = implode(",", $array_unique);
		$tabel_array = explode(",", $tabel_array);
		for($i=0;$i<=$aantal_queries;$i++){
			$array_keys = array_keys($tabellen_array, $nieuw_array[$i]);
			$array_count = count($array_keys);

			for($j=0;$j<=$array_count;$j++){
				if($j==0){
					$query_velden	=	"id$tabel_array[$i], ".$veld_array[$array_keys[$j]];
					$query_waarden	=	"'',".$waarde_array[$array_keys[$j]];

				}elseif($j==$array_count){
					$query_velden	.=	$veld_array[$array_keys[$j]];
					$query_waarden	.=	$waarde_array[$array_keys[$j]];
				}else{
					$query_velden	.=", ".$veld_array[$array_keys[$j]];
					$query_waarden	.=", ".$waarde_array[$array_keys[$j]];
				}
			}
			$queries[$i] = "INSERT INTO $tabel_array[$i] ($query_velden) VALUES ($query_waarden)";
			print "<br /><br />".$queries[$i];

		}

Now all i have to do is figure out a way to define the foreign keys for each table...