public function IndexGuncelToHTML() { $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); $connection->set_charset("utf8"); echo "<div style=\"margin:2%;background-color:#e6e6e6;border-bottom:1px solid #c7d0d5;\">"; echo "<p style=\"font-size:20px;word-wrap:break-word;color:#cb7c7a;font-family: 'Josefin Sans', sans-serif;\">"; echo "Güncel panolar"; echo "</p>"; echo "</div>"; echo "<div style=\"\">"; $results = $connection->query("SELECT * FROM boards ORDER BY boardID DESC LIMIT 6 OFFSET 0"); while ($boardInfos = $results->fetch_assoc()) { $myBoard = new Board(array($boardInfos['boardID'], $boardInfos['boardName'], $boardInfos['boardCategory'], $boardInfos['boardCreator'], $boardInfos['boardImage'], $boardInfos['boardDate'])); $myBoard->BoardToPetitHTML(); } echo "</div>"; echo "<div id=\"x\" style=\"margin:2%;background-color:#e6e6e6;border-bottom:1px solid #c7d0d5;\">"; echo "<p style=\"font-size:20px;word-wrap:break-word;color:#cb7c7a;font-family: 'Josefin Sans', sans-serif;\">"; echo "Güncel içerikler"; echo "</p>"; echo "</div>"; echo "<div style=\"\">"; if (!$connection->connect_error) { $results = $connection->query("SELECT * FROM threads ORDER BY threadID DESC LIMIT 12 OFFSET 0 "); while ($curres = $results->fetch_assoc()) { $threadID5 = $curres["threadID"]; $threadDate5 = $curres["threadDate"]; $threadWriter5 = $curres["threadWriter"]; $threadCategory5 = $curres["threadCategory"]; $threadPicture5 = $curres["threadPicture"]; $stepCount5 = $curres["stepCount"]; $threadName5 = $curres["threadName"]; $threadPoint5 = $curres["threadPoint"]; $myThread5 = new Thread(array($threadID5, $threadDate5, $threadWriter5, $threadCategory5, $threadPicture5, $stepCount5, $threadName5, $threadPoint5)); $myThread5->ThreadToPetitHTML(); } echo "<div id=\"moreBestDiv\"></div>"; echo "<div style=\"\">"; echo "<form id=\"loadMoreBestForm\" method=\"post\" action=\"loadMoreRecentIndex.php\">"; echo "<input id=\"loadMoreBestOffset\" name=\"loadMoreBestOffset\" style=\"display:none;\" value=\"" . $results->num_rows . "\"/>"; echo "<button id=\"loadMoreBestButton\" class=\"btn btn-block btn-success\">"; echo "<i id=\"loadMoreBestSpinner\" style=\"display:none;\" class=\"fa fa-refresh fa-spin\"></i>"; echo "<span id=\"loadMoreBestTXT\">"; echo "Daha fazla göster"; echo "</span>"; echo "</button>"; echo "</form>"; echo "</div>"; } echo "</div>"; echo "<script type=\"text/javascript\">"; echo "\n\t\t\t\$(window).scroll(function(){\n\t\t\t\tvar p = \$('#x');\n\t\t\t\tvar pos = p.position();\n\t\t\t\tvar windowpos = \$(window).scrollTop();\n\t\t\t\tif (windowpos >= pos.top) {\n\t\t\t\t\t\$('#indexStickyFooter').fadeIn(500);\n\t\t\t\t}\n\t\t\t\telse\n\t\t\t\t\t\$('#indexStickyFooter').fadeOut(500);\n\t\t\t});\n\t\t\t\$('#loadMoreBestButton').click(function(e){\n\t\t\t\te.preventDefault();\n\t\t\t\t\$('#loadMoreBestTXT').hide();\n\t\t\t\t\$('#loadMoreBestSpinner').show();\n\t\t\t\t\$('#loadMoreBestForm').ajaxForm({\n\t\t\t\t\tsuccess : function(msg){\n\t\t\t\t\t\t\$('#loadMoreBestTXT').show();\n\t\t\t\t\t\t\$('#loadMoreBestSpinner').hide();\n\t\t\t\t\t\tnewoffset = msg.charAt(0);\n\t\t\t\t\t\toldoffset = \$('#loadMoreBestOffset').val();\n\t\t\t\t\t\toldint = parseInt(oldoffset);\n\t\t\t\t\t\tnewint = parseInt(newoffset);\n\t\t\t\t\t\tif (newint==0)\n\t\t\t\t\t\t{\n\t\t\t\t\t\t\t\$('#loadMoreBestTXT').html(\"Hepsi yüklendi\");\n\t\t\t\t\t\t\t\$('#loadMoreBestButton').attr(\"disabled\",true);\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\$('#loadMoreBestOffset').val(oldint+newint);\n\t\t\t\t\t\tmsg2 = msg.substring(1);\n\t\t\t\t\t\t\$('#moreBestDiv').append(msg2);\n\t\t\t\t\t},\n\t\t\t\t\terror : function(){\n\n\t\t\t\t\t}\n\t\t\t\t}).submit();\n\t\t\t});\t\n\t\t"; echo "</script>"; }