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	torben	2125	<?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			?>