require_once "functions.php"; require_once "edit_functions.php"; if (!isset($_SESSION["logged_in_user_id"])) { header("Location: login.php"); } // kas kustutame // ?delete=vastav id mida kustutada on aadressireal if (isset($_GET["delete"])) { echo "Kustutame id " . $_GET["delete"]; //käivitan funktsiooni, saadan kaasa id! deleteAnimal($_GET["delete"]); } //salvestan andmebaasi uuendused if (isset($_POST["save"])) { updateAnimal($_POST["id"], $_POST["animal"], $_POST["animal_name"]); } $array_of_animals = getAllData(); //käivitan funktsiooni //$array_of_animals = getEditData($edit_id); //trükin välja esimese looma //echo $array_of_animals[0]->id." ".$array_of_animals[0]->animal; ?> <h2>Tabel</h2> <table border=1 > <tr> <th>id</th> <th>kasutaja id</th> <th>Looma liik</th> <th>Looma nimi</th>
function lookUpAnimalByDescription($text, $lat, $lon) { if ($lat != "" && $lon != "") { $wordArray = explode(",", strtolower($text)); for ($a = 0; $a < count($wordArray); $a++) { $suche = $wordArray[$a]; $abfrage = "SELECT * FROM `EINTRAEGE` WHERE `ATTRIBUTES` LIKE '%" . $suche . "%'"; $ergebnis = mysql_query($abfrage) or die(mysql_error()); while ($zeile = mysql_fetch_array($ergebnis, MYSQL_ASSOC)) { $arr[$a]['ID'] = $zeile['ID']; $arr[$a]['NAME'] = $zeile['NAME']; $arr[$a]['LATINNAME'] = $zeile['LATINNAME']; $arr[$a]['DESCRIPTION'] = $zeile['DESCRIPTION']; $arr[$a]['PHOTOS'] = $zeile['PHOTOS']; $arr[$a]['LONGITUDE'] = $zeile['LONGITUDE']; $arr[$a]['LATITUDE'] = $zeile['LATITUDE']; $arr[$a]['LINKS'] = $zeile['LINKS']; $arr[$a]['DATES'] = $zeile['DATES']; $arr[$a]['COUNT'] = $zeile['COUNT']; $arr[$a]['ATTRIBUTES'] = $zeile['ATTRIBUTES']; $arr[$a]['RELEVANT'] = null; $anzahlen[$a] = $zeile['NAME']; $rangliste = array_count_values($anzahlen); if ($rangliste[0] = $arr[$a]['NAME']) { $arr[$a]['RELEVANT'] = $rangliste[0]; $gefundenerOrganismus = $arr[$a]; } } } updateAnimal($gefundenerOrganismus, $lat, $lon); return $gefundenerOrganismus; } else { return false; } }