$mysql_link = mysql_connect("localhost", "c11_default", "LibRary12"); mysql_select_db("c11_default", $mysql_link); mysql_set_charset('utf8',$mysql_link); ?>
![]() |
![]() |
![]() |
|||
Іменні колекції
settype($_GET[letter], "integer");
settype($_GET[box], "integer");
settype($_GET[image], "integer");
if($_GET[letter]!=NULL){
$sql_letter = 'SELECT * FROM `cards_letter_o_rare` WHERE `idLetter` = '.$_GET[letter].' ';
$result_letter = mysql_query($sql_letter);
$thisPage_letter=mysql_fetch_array($result_letter);
$nowLetter=$thisPage_letter[idLetter];
}
$sql = 'SELECT * FROM `cards_letter_o_rare` ORDER BY `idLetter` ASC ';
$result_in = mysql_query($sql);
echo "
if($_GET[letter]==NULL && $_GET[q]==NULL){ ?>
} ?>
if($_GET[image]!=NULL){ ?>
$sql_test = 'SELECT * FROM `cards_title_o_rare` WHERE `idTitle` = '.$_GET[image].' ';
$result_test = mysql_query($sql_test);
if(mysql_num_rows($result_test)!=NULL){
$thisPage=mysql_fetch_array($result_test);
$sql_test1 = 'SELECT * FROM `cards_title_o_rare` WHERE `idTitle` = '.$thisPage[parent].' ';
$result_test1 = mysql_query($sql_test1);
$thisPage1=mysql_fetch_array($result_test1);
$naz_fail = explode($_SERVER['SCRIPT_NAME'], $_SERVER['SCRIPT_FILENAME']);
echo file_get_contents("http://fs.onu.edu.ua/clients/client11/web11/t.php?p=rarebook/$thisPage1[idBox]/$thisPage[idBox]");
}
?>
} ?> if($_GET[letter]!=NULL){
$sql = 'SELECT * FROM `cards_title_o_rare` WHERE `region` = '.$nowLetter.' AND `parent` = 0 ORDER BY `idBox` ASC';
$result_in = mysql_query($sql);
while($thisPage=mysql_fetch_array($result_in)){
if($_GET[box]!=NULL && $_GET[box]==$thisPage[idTitle]){
echo " $thisPage[title]";
}else{
echo " if($_GET[letter]!=NULL && $_GET[box]!=NULL){ ?>$thisPage[title]";
}
if($cardsEdit)
echo " ";
} }
?>![]() $sql = 'SELECT * FROM `cards_title_o_rare` WHERE `parent` = '.$_GET[box].' ORDER BY `idBox` ASC';
$result_in = mysql_query($sql);
while($thisPage=mysql_fetch_array($result_in)){
if($_GET[image]!=NULL && $_GET[image]==$thisPage[idTitle]){
echo " $thisPage[title]";
}else{
echo " } ?> if($_GET[letter]==NULL && $_GET[q]!=NULL){
?>
$thisPage[title]";
}
if($cardsEdit)
echo " ";
}
?>![]() $sql = 'SELECT * FROM `cards_title_o_rare` WHERE `title` LIKE CONVERT( \'%'.$searchRequest.'%\' USING cp1251) COLLATE cp1251_general_ci ORDER BY `idTitle` ASC'; $result_in = mysql_query($sql); $lessThenOne=0; while($thisPage=mysql_fetch_array($result_in)){ $lessThenOne=1; $sqlh = 'SELECT * FROM `cards_title_o_rare` WHERE `idTitle`='.$thisPage['parent']; $result_inh = mysql_query($sqlh); $thisPageh=mysql_fetch_array($result_inh); echo " "; } ?> if($lessThenOne!=1) echo " |
|
||||
![]() |