Es wird gesucht in: Name, ID.
(function () use ($mysqli, $_search) { $sql = " SELECT Organisationen.ID AS OrgaID, Organisationen.Name, Förderer.ID AS FoerdID, Superorga.ID AS SuperOrgaID, Superorga.Name AS Superorganisation FROM Organisationen LEFT JOIN Förderer ON Organisationen.ID = Förderer.Organisation LEFT JOIN Organisationen AS Superorga ON Organisationen.Superorganisation = Superorga.ID WHERE Organisationen.Name LIKE ? OR Organisationen.ID = ? "; $s = '%' . $_search . '%'; $stmt = $mysqli->prepare($sql); $stmt->bind_param('si', $s, $_search); $stmt->execute(); $r = $stmt->get_result(); if ($r->num_rows === 1 && !isset($_GET['action'])) { $l = $r->fetch_object(); $stmt->reset(); $mysqli->close(); ?> exit(0); } $id = "orgasearch2"; $order = '[[1, "asc"]]'; include __DIR__ . '/autotable.php'; $stmt->reset(); })(); include_once __DIR__ . "/footer.php"; ?>