$k = $_REQUEST["k"];
include('fejlec.php');
?>
FoNo VIII
$muvelet = $_REQUEST["muvelet"];
$szo = $_REQUEST["szo"];
include("../kapcsi_admin.php");
/*
Az átnevezendő dupla szó
$i = 1;
if ($muvelet == "dupla") {
$pp = 'SELECT * FROM `fono8_alapanyag` WHERE `rovid`="' . $szo .'"';
print "M: " . $muvelet;
if ($result = $kapcsolat->query($p)) {
while($obj = $result->fetch_object()){
// $gynev = $obj->tunet;
$fid = $obj->fid;
$ujszo = $szo . $i;
print $ujszo . " - ";
$u = "UPDATE `fono8_alapanyag` SET `rovid` = $ujszo WHERE `fono8_alapanyag`.`fid` = $fid";
$i++;
}
$result->close();
}
$pp = 'SELECT * FROM `fono8_eloirat` WHERE `rovid`="' . $szo .'"';
if ($result = $kapcsolat->query($p)) {
while($obj = $result->fetch_object()){
// $gynev = $obj->tunet;
$fid = $obj->fid;
$ujszo = $szo . $i;
print $ujszo . " - ";
$u = "UPDATE `fono8_eloirat` SET `rovid` = $ujszo WHERE `fono8_eloirat`.`fid` = $fid";
$i++;
}
$result->close();
}
print $i . " sor kicserélve.
";
}
*/
?>
if ($k) {
$p = 'SELECT * FROM `fono8_eloirat` WHERE SUBSTR(`nev`, 1, 1)="' . $k .'"';
} else {
$p = 'SELECT * FROM `fono8_eloirat`';
}
if ($result = $kapcsolat->query($p)) {
while($obj = $result->fetch_object()){
// $gynev = $obj->tunet;
$nev = $obj->nev;
$betegt = $obj->betegt;
$olink = $obj->olink;
$gylink = $obj->gylink;
$rovid = $obj->rovid;
print '| ' . $nev . ' | |
';
// $r[$rovid]++; Duplázások összeszámolása
}
$result->close();
}
/* Duplák kiíratása
foreach ($r AS $kulcs=>$ertek) {
if ($ertek == 1) {continue;}
print $kulcs . " (" . $ertek . ")
";
}
*/
?>
// Keresés: SELECT `nev` FROM `fono8_alapanyag` WHERE SUBSTR(`nev`, 1, 1)="s"
?>
include('lablec.php'); ?>