Leitgedanken/test.php
2022-11-21 09:47:28 +01:00

19 lines
599 B
PHP

<?php
require_once("config.inc.php");
require_once("func_htmlclean.php");
$db = dbconnect();
$query = "SELECT luesid, stichwort
FROM lue_stichworte";
$result = $db->query($query) or die("Cannot execute query");
while ($row = $result->fetch_array()) {
$stichwort = htmlentities($row['stichwort']);
$stichwort = htmlclean($stichwort, $db);
echo "$stichwort<br>";
$sql = $db->query("UPDATE lue_stichworte
SET stichwort=trim('$stichwort')
WHERE luesid=$row[luesid]");
}
?>