Help on Explode

[Ynot]

Hi all,

is there a cleaner way of doing this?

for ($g = 0; $g < count($tempjoin); $g++)
{
	$tempjoin2[$g] = explode("ON", $tempjoin[$g]);
	for ($h = 0; $h < count($tempjoin2[$g]); $h++)
	{
		$tempjoin3 = explode("WHERE", $tempjoin2[$g][$h]);
		for ($f = 0; $f < count($tempjoin3); $f++)
		{
			if (strpos($tempjoin3[$f], "="))
			{
				$tempjoin4 = explode("=", $tempjoin3[$f]);
				for ($d = 0; $d < count($tempjoin4); $d++)
				{
					$joins[$join_nudge2][$join_nudge] = explode(".", $tempjoin4[$d]);
					$join_nudge++;
				}
				$join_nudge2++;
				$join_nudge = 0;
			}
		}
	}
}

What it's doing is analysing an sql string and splitting it into segments
First splitting "ON"
then "WHERE"
cycling through all segments, seeing if they contain an equals sign "="
If equals found, further split segment into it's values

(building an SQL parser to analyse sql select statements and populate an array)

It works, but this particular bit is messy
anyone got any ideas on how to clean it up (explode doesn't seem to like array inputs)

Thanks in advance

Tony

Setup:
Windows 2000 Professional
Apache 2.0.54
Php 4.3.11
Php as apache module

[kakki]

i once did something similar with regular expressions ...
the regex was looking like
([ ]+[a-zA-Z0-9]+[ ]=[ ][a-zA-Z0-9]+) to cut out all cols/values

[Ynot]

Thanks for the reply

It's more the nested 'for' loops I was hoping to clean up
(adding any more SQL operators to the function will make it cumbersome)

Basically:

Function input =

"SELECT tbl_jobs.job_id, tbl_jobs.job_name, tbl_jobs.job_budget_fee, tbl_clients.client_id, tbl_clients.client_name
FROM tbl_clients
	INNER JOIN tbl_jobs
ON tbl_clients.client_id = tbl_jobs.client_id
WHERE tbl_jobs.job_id = " . $id;

function output =

Array
(
    [0] => Array
        (
            [table_name] => tbl_jobs
            [primary_key] => job_id
            [main_table] => 1
            [fields] => Array
                (
                    [0] => Array
                        (
                            [field_name] => job_id
                            [blob] => 0
                            [curr_max_len] => 4
                            [max_col_len] => 8
                            [multiple_key] => 0
                            [not_null] => 1
                            [numeric] => 1
                            [primary_key] => 1
                            [table] => tbl_jobs
                            [type] => int
                            [unique_key] => 0
                            [unsigned] => 0
                            [zerofill] => 0
                            [current_values] => Array
                                (
                                    [0] => 7003
                                )

                    )

                [1] => Array
                    (
                        [field_name] => job_name
                        [blob] => 0
                        [curr_max_len] => 15
                        [max_col_len] => 150
                        [multiple_key] => 0
                        [not_null] => 0
                        [numeric] => 0
                        [primary_key] => 0
                        [table] => tbl_jobs
                        [type] => string
                        [unique_key] => 0
                        [unsigned] => 0
                        [zerofill] => 0
                        [current_values] => Array
                            (
                                [0] => Hereford Square
                            )

                    )

                [2] => Array
                    (
                        [field_name] => job_budget_fee
                        [blob] => 0
                        [curr_max_len] => 4
                        [max_col_len] => 8
                        [multiple_key] => 0
                        [not_null] => 0
                        [numeric] => 1
                        [primary_key] => 0
                        [table] => tbl_jobs
                        [type] => int
                        [unique_key] => 0
                        [unsigned] => 0
                        [zerofill] => 0
                        [current_values] => Array
                            (
                                [0] => 2004
                            )

                    )

                [3] => Array
                    (
                        [field_name] => client_id
                        [blob] => 0
                        [curr_max_len] => 1
                        [max_col_len] => 8
                        [multiple_key] => 0
                        [not_null] => 1
                        [numeric] => 1
                        [primary_key] => 1
                        [table] => tbl_jobs
                        [type] => int
                        [unique_key] => 0
                        [unsigned] => 0
                        [zerofill] => 0
                        [joins] => Array
                            (
                                [table_name] => tbl_clients
                                [field_name] => client_id
                            )

                        [current_values] => Array
                            (
                                [0] => 1
                            )

                    )

            )

    )

[1] => Array
    (
        [table_name] => tbl_clients
        [primary_key] => client_id
        [main_table] => 0
        [fields] => Array
            (
                [0] => Array
                    (
                        [field_name] => client_id
                        [blob] => 0
                        [curr_max_len] => 1
                        [max_col_len] => 8
                        [multiple_key] => 0
                        [not_null] => 1
                        [numeric] => 1
                        [primary_key] => 1
                        [table] => tbl_clients
                        [type] => int
                        [unique_key] => 0
                        [unsigned] => 0
                        [zerofill] => 0
                        [joins] => Array
                            (
                                [table_name] => tbl_jobs
                                [field_name] => client_id
                            )

                        [current_values] => Array
                            (
                                [0] => 1
                            )

                    )

                [1] => Array
                    (
                        [field_name] => client_name
                        [blob] => 0
                        [curr_max_len] => 12
                        [max_col_len] => 150
                        [multiple_key] => 0
                        [not_null] => 0
                        [numeric] => 0
                        [primary_key] => 0
                        [table] => tbl_clients
                        [type] => string
                        [unique_key] => 0
                        [unsigned] => 0
                        [zerofill] => 0
                        [current_values] => Array
                            (
                                [0] => Saunders Foo
                            )

                    )

            )

    )

)

The more complicated my test SQL statements get, more the nested for's are going to be a problem

Thanks

Tony