horsensspejder-web/ajax/ajaxcommon.php

<?php

require_once( "../inc/mysql.php" );

function findPersoner($enheder, $individer) {
        $personer = array();

        $enhed_array = explode( "|", $enheder);
        foreach($enhed_array as $enhed) {
                if ($enhed == "")
                        continue;

                $enhed = utf8_decode( $enhed );

                $sql = "SELECT * FROM roller WHERE enhed='{$enhed}' ";
                $res = query($sql);

                foreach ($res as $row) {
                        $uid = $row->medlemsid;
                        $personer[$uid] = $uid;
                }

        }
        $individ_array = explode( "|", $individer);
        foreach($individ_array as $individ) {
                if ($individ == "")
                        continue;

                $individ = utf8_decode($individ);

                $res = query("SELECT distinct medlemsid FROM roller WHERE navn LIKE '{$individ}'" );
                foreach($res as $row) {
                        $uid = $row->medlemsid;
                        $personer[$uid] = $uid;
                }
        }

        return $personer;
}


?>
1	<?php
2
3	require_once( "../inc/mysql.php" );
4
5	function findPersoner($enheder, $individer) {
6	$personer = array();
7
8	$enhed_array = explode( "\|", $enheder);
9	foreach($enhed_array as $enhed) {
10	if ($enhed == "")
11	continue;
12
13	$enhed = utf8_decode( $enhed );
14
15	$sql = "SELECT * FROM roller WHERE enhed='{$enhed}' ";
16	$res = query($sql);
17
18	foreach ($res as $row) {
19	$uid = $row->medlemsid;
20	$personer[$uid] = $uid;
21	}
22
23	}
24	$individ_array = explode( "\|", $individer);
25	foreach($individ_array as $individ) {
26	if ($individ == "")
27	continue;
28
29	$individ = utf8_decode($individ);
30
31	$res = query("SELECT distinct medlemsid FROM roller WHERE navn LIKE '{$individ}'" );
32	foreach($res as $row) {
33	$uid = $row->medlemsid;
34	$personer[$uid] = $uid;
35	}
36	}
37
38	return $personer;
39	}
40
41
42	?>