コード例 #1
0
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>
コード例 #2
0
ファイル: phpHelper.php プロジェクト: nielssi/BeachExplorer
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;
    }
}