public function DigerSahane() { $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if (!$connection->connect_error) { $connection->set_charset("utf8"); $results = $connection->query("SELECT * FROM threads ORDER BY threadPoint DESC LIMIT 8 OFFSET 10 "); 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=\"margin:2%;\">"; echo "<form id=\"loadMoreBestForm\" method=\"post\" action=\"loadMoreBest.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>"; } }
public function Find() { $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $myQuery = "SELECT MAX(usedID) FROM usedIDs"; $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { return -1; } /* database'e girdik */ $result = $connection->query($myQuery); if ($result->num_rows != 0) { $curResult = $result->fetch_assoc(); $newResult = $curResult["MAX(usedID)"]; $newResult = (int) $newResult; $newResult = $newResult + 1; } else { $newResult = 1; } if ($connection->query("INSERT INTO usedIDs(usedID) VALUES (" . $newResult . ")") === TRUE) { $connection->close(); return $newResult; } $connection->close(); return -1; }
public function Find2() { $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { return false; } else { $connection->set_charset("utf8"); $query1 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Alakasız\""; $query2 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Bilim/Kültür\" "; $query3 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Sosyal ilişkiler\""; $query4 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Sağlık/Spor\""; $query5 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Yemek/İçmek\""; $query6 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Bilgisayar/Elektronik\""; $query7 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Sanat/Eğlence\""; $res1 = $connection->query($query1); $res2 = $connection->query($query2); $res3 = $connection->query($query3); $res4 = $connection->query($query4); $res5 = $connection->query($query5); $res6 = $connection->query($query6); $res7 = $connection->query($query7); $res1_assoc = $res1->fetch_assoc(); $res2_assoc = $res2->fetch_assoc(); $res3_assoc = $res3->fetch_assoc(); $res4_assoc = $res4->fetch_assoc(); $res5_assoc = $res5->fetch_assoc(); $res6_assoc = $res6->fetch_assoc(); $res7_assoc = $res7->fetch_assoc(); $connection->close(); return array($res1_assoc["count(distinct threadWriter)"], $res2_assoc["count(distinct threadWriter)"], $res3_assoc["count(distinct threadWriter)"], $res4_assoc["count(distinct threadWriter)"], $res5_assoc["count(distinct threadWriter)"], $res6_assoc["count(distinct threadWriter)"], $res7_assoc["count(distinct threadWriter)"]); } }
public function Activate() { global $code; echo "<div style=\"margin-top:10%;padding:3%;font-family:Verdana,Geneva,sans-serif;font-size:20px;background-color:#e6e6e6;border:1px solid #c7d0d5;border-radius:15px;width: 100%; max-width:100%;color:#6e6e6e;height:250px;\">"; echo "<img src=\"images/headerfil2.jpg\" style=\"max-width:60px;\"/>"; echo "<br/>"; if (isset($_SESSION["user_name"])) { $usr = $_SESSION["user_name"]; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { echo "Veritabanı bağlantı sorunu."; } else { $query = "UPDATE users SET activation=\"OK\" WHERE ( userName=\"" . $usr . "\" AND activationCode=\"" . $code . "\")"; if ($connection->query($query) === TRUE) { echo "Üyeliğiniz başarıyla aktive edildi."; } else { echo "Veritabanı hatası."; } } } else { echo "Üyeliğinizi aktive etmeden önce giriş yapmalısınız."; } echo "<br/><br/>"; echo "<button id=\"anasayfaya_don_buttonu\" class=\"btn btn-primary\">"; echo "Anasayfaya git"; echo "</button>"; echo "<br/>"; echo "</div>"; echo "<script type=\"text/javascript\">"; echo "\n\t\t\t\t\$(document).ready(function(){\n\t\t\t\t\t\$('#anasayfaya_don_buttonu').click(function(){\n\t\t\t\t\t\twindow.location.replace(\"http://www.serinhikaye.com\");\n\t\t\t\t\t});\n\t\t\t\t});\n\t\t\t"; echo "</script>"; }
public function ConversationsToHTML() { global $conversationsInfos; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { echo "Database bağlantı hatası"; } else { $query = "SELECT * FROM conversations WHERE (user1=\"" . $conversationsInfos["Pour Qui"] . "\" OR user2=\"" . $conversationsInfos["Pour Qui"] . "\") ORDER BY lastDate DESC "; $results = $connection->query($query); if ($results->num_rows == 0) { echo "<div style=\"margin:2%;background-color:#e6e6e6;color:#6e6e6e;font-size:18px;font-family: Verdana,Geneva,sans-serif;\">"; echo "Henüz mesajlaşmamışsınz."; echo "</div>"; } else { while ($curResult = $results->fetch_assoc()) { if ($curResult["user1"] == $conversationsInfos["Pour Qui"]) { $other = $curResult["user2"]; } else { $other = $curResult["user1"]; } $ary = array($other, $conversationsInfos["Pour Qui"], $conversationsInfos["Pour Qui"]); $myConversation = new Conversation($ary); $myConversation->ConversationToHTML(); } } $connection->close(); } }
public function GetTop3() { global $whichUser; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { return false; } else { $connection->set_charset("utf8"); $ress0 = $connection->query("SELECT * FROM users WHERE userName = '******'"); if ($ress0->num_rows == 0) { echo "<script type=\"text/javascript\"> window.location='oops.php'; </script>"; } $query = "SELECT * FROM `threads` WHERE threadWriter='{$whichUser}' ORDER BY `threadPoint` DESC LIMIT 3 "; $results = $connection->query($query); if ($results->num_rows < 3) { return false; } else { $returnAry = array(); while ($curResult = $results->fetch_assoc()) { $returnAry[] = $curResult["threadPicture"]; $returnAry[] = $curResult["threadName"]; $returnAry[] = $curResult["threadID"]; } return $returnAry; } } }
public function loadStep($stepNo) { global $threadInfos; $threadID = $threadInfos['Thread ID']; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { return "CONNECT_ERR"; } else { /* database'e girdik */ $sqlRequest = "SELECT * FROM steps WHERE (threadID='{$threadID}' AND stepNo='{$stepNo}')"; if ($result = $connection->query($sqlRequest)) { $ary = array(); $row = $result->fetch_assoc(); $ary[0] = $row["stepNo"]; $strx1 = str_replace('\\"', '"', $row["baslik"]); $strx2 = str_replace("\\'", "'", $strx1); $ary[1] = $strx2; $ary[2] = $row["resimLink"]; $str1 = str_replace('\\"', '"', $row["icerik"]); $str2 = str_replace("\\'", "'", $str1); $ary[3] = $str2; $myStep = new Step($ary); return $myStep; } else { return "QUERY_ERR"; } $connection->close(); } }
public function YazarBasliklariToHTML() { global $yazarAdi; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { echo "Database'e bağlantı sorunu"; } else { $connection->set_charset("utf8"); echo "<div style=\"overflow:auto;border:1px solid #c7d0d5;border-radius:15px;background-color:#e6e6e6;width:100%;margin-top:4%;font-size:19px;font-family: 'Josefin Sans', sans-serif;color:#cb7c7a;max-width:100%;\">"; echo "<div style=\"margin-top:5%;text-align:left;margin-right:5%;margin-left:5%;font-size:19px;font-family: 'Josefin Sans', sans-serif;color:#cb7c7a;\">"; echo "<p style=\"word-wrap:break-word;text-align:left;width:80%;max-width:80%;\">"; echo "Aynı yazardan bazı süper başlıklar"; echo "</p>"; echo "<hr style=\"border:1px solid #c7d0d5;\"/>"; echo "</div>"; $res = $connection->query("SELECT * from threads where threadWriter='{$yazarAdi}' ORDER BY threadPoint LIMIT 10"); while ($curres = $res->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>"; $connection->close(); } }
public function LoadMessages() { global $conversationInfos; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { echo "Database bağlantı hatası"; } else { mysqli_set_charset($connection, "utf8"); $query = "SELECT * FROM messages WHERE ((From_msg='" . $conversationInfos["User1"] . "' AND To_msg='" . $conversationInfos["User2"] . "') OR (From_msg='" . $conversationInfos["User2"] . "' AND To_msg='" . $conversationInfos["User1"] . "'))"; $results = $connection->query($query); $num = $results->num_rows; echo "<form style=\"display:none;\" id=\"offsetForm_" . $conversationInfos["other"] . "\" method=\"post\" action=\"instantmessage.php?usr1=" . $conversationInfos["User1"] . "&usr2=" . $conversationInfos["User2"] . "&monitor=" . $conversationInfos["WhoIsMonitoring"] . "\">"; echo "<input name=\"offset\" id=\"offset_" . $conversationInfos["other"] . "\" style=\"display:none;\" type=\"text\" value=\"" . $num . "\"/>"; echo "</form>"; while ($curResult = $results->fetch_assoc()) { if ($conversationInfos["WhoIsMonitoring"] == $curResult["From_msg"]) { $mode = "EvSahibi"; } else { $mode = "Deplasman"; } $myMessage = new Message(array($curResult["MessageDate"], $curResult["From_msg"], $curResult["To_msg"], $curResult["Message"], $mode, $curResult["Read_msg"])); $myMessage->MessageToHTML(); } $connection->close(); } }
public function BoardRightUpToHTML() { global $infos; $myIndexSocial = new IndexSocial(); echo "<div id=\"catcher2\" style=\"border:1px solid #c7d0d5; border-radius:15px;\">"; $myIndexSocial->IndexSocialToHTML(); echo "</div>"; echo "<div id=\"sticky2\" style=\"margin-top:2%;width:100%;\">"; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); $connection->set_charset("utf8"); $query = "SELECT * FROM threads WHERE threadCategory=\"" . $infos['boardCategory'] . "\" ORDER BY rand() LIMIT 2"; $results2 = $connection->query($query); while ($curResult2 = $results2->fetch_assoc()) { $threadID2 = $curResult2["threadID"]; $threadDate2 = $curResult2["threadDate"]; $threadWriter2 = $curResult2["threadWriter"]; $threadCategory2 = $curResult2["threadCategory"]; $threadPicture2 = $curResult2["threadPicture"]; $stepCount2 = $curResult2["stepCount"]; $threadName2 = $curResult2["threadName"]; $threadPoint2 = $curResult2["threadPoint"]; $myThread2 = new Thread(array($threadID2, $threadDate2, $threadWriter2, $threadCategory2, $threadPicture2, $stepCount2, $threadName2, $threadPoint2)); $myThread2->ThreadToPetitHTML(); } echo "</div>"; echo "<script>"; echo "\n\t\t\$(document).ready(function(){\n\t\t\tif (\$(window).width()<=1028)\n\t\t\t{\n\t\t\t\t\$('#catcher2').remove();\n\t\t\t\t\$('#sticky2').remove();\n\t\t\t\t\$('#random_for_mobile').show();\n\t\t\t}\n\t\t});\n\tvar wid = \$('#sticky2').width();\n\tfunction isScrolledTo(elem) {\n var docViewTop = \$(window).scrollTop(); //num of pixels hidden above current screen\n var docViewBottom = docViewTop + \$(window).height();\n \n var elemTop = \$(elem).offset().top; //num of pixels above the elem\n var elemBottom = elemTop + \$(elem).height();\n \n return ((elemTop <= docViewTop));\n}\n\n\tvar catcher = \$('#catcher2');\nvar sticky = \$('#sticky2');\n\n\t\$(window).scroll(function() {\n\tif (\$(window).width()>1028){\n if(isScrolledTo(sticky)) {\n sticky.css('position','fixed');\n sticky.css('top','100px');\n\tsticky.css('max-width',wid);\n\t\$('#sticky_footer_div').show(500);\n }\n\t\n var stopHeight = catcher.offset().top + catcher.height(); \n\t if ( stopHeight > sticky.offset().top) {\n sticky.css('position','absolute');\n sticky.css('top',stopHeight-70);\n\t\$('#sticky_footer_div').hide(500);\n }\n}\n});\n\t\t"; echo "</script>"; }
public function deletePhoto($userId) { $connector = new DBConnector(); $connection = $connector->createConnection(); $query = 'DELETE FROM photo WHERE fk_id_user=' . $userId; mysql_query($query) or die("Error in query: {$query}. " . mysql_error()); mysql_close($connection); }
function __construct(DBConnector $db) { Assert::isTrue(isset(self::$drivers[$db->getDriver()->getId()]), "unknown driver is specified: {$db->getDriver()}"); $className = self::$drivers[$db->getDriver()->getId()]; $driver = new ReflectionClass($className); Assert::isTrue($driver->isSubclassOf(new ReflectionClass('DBBackup')), "{$className} should implement DBBackup"); $this->driver = $driver->newInstance($db); }
public function deleteQueryByID($queryID) { $connector = new DBConnector(); $connection = $connector->createConnection(); $query = "DELETE FROM queries WHERE id={$queryID}"; mysql_query($query) or die("Error in query: {$query}. " . mysql_error()); mysql_close($connection); return $queryID; }
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>"; }
public function contributorCount() { global $boardInfos; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); $query = "SELECT distinct(contributor) FROM contributions WHERE boardID =\"" . $boardInfos['boardID'] . "\""; $results = $connection->query($query); return $results->num_rows; }
public function SuggestionsBarToHTML() { $myIndexSocial = new IndexSocial(); echo "<div style=\"border:1px solid #c7d0d5; border-radius:15px;\">"; $myIndexSocial->IndexSocialToHTML(); echo "</div>"; global $sinf; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection2 = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection2->connect_error) { echo "Database'e bağlantı sorunu"; } else { $connection2->set_charset("utf8"); echo "<div style=\"border:1px solid #c7d0d5;border-radius:15px;margin-top:3%;overflow:auto;height:100%;width:100%;max-width:100%;background-color:#e6e6e6;\">"; echo "<div style=\"margin-top:5%;text-align:left;margin-right:5%;margin-left:5%;font-size:19px;font-family: 'Josefin Sans', sans-serif;color:#cb7c7a\">"; echo "<p style=\"word-wrap:break-word;text-align:left;width:80%;max-width:80%;\">"; echo "İlginizi çekebilecek başlıklar"; echo "</p>"; echo "<hr style=\"border:1px solid #c7d0d5;\"/>"; echo "</div>"; $quelloThreddo = $connection2->real_escape_string($sinf['quelleThread']); $sugQuery = "SELECT * FROM threads WHERE threadCategory =\"" . $sinf['quelleCategorie'] . "\" AND threadName<>\"" . $quelloThreddo . "\" ORDER BY RAND() LIMIT 30"; $results2 = $connection2->query($sugQuery); while ($curResult2 = $results2->fetch_assoc()) { $threadID2 = $curResult2["threadID"]; $threadDate2 = $curResult2["threadDate"]; $threadWriter2 = $curResult2["threadWriter"]; $threadCategory2 = $curResult2["threadCategory"]; $threadPicture2 = $curResult2["threadPicture"]; $stepCount2 = $curResult2["stepCount"]; $threadName2 = $curResult2["threadName"]; $threadPoint2 = $curResult2["threadPoint"]; $myThread2 = new Thread(array($threadID2, $threadDate2, $threadWriter2, $threadCategory2, $threadPicture2, $stepCount2, $threadName2, $threadPoint2)); $myThread2->ThreadToPetitHTML(); } $sugQuery = "SELECT * FROM threads WHERE threadCategory <>\"" . $sinf['quelleCategorie'] . "\" AND threadName<>\"" . $quelloThreddo . "\" ORDER BY RAND() LIMIT 10"; $results2 = $connection2->query($sugQuery); while ($curResult2 = $results2->fetch_assoc()) { $threadID2 = $curResult2["threadID"]; $threadDate2 = $curResult2["threadDate"]; $threadWriter2 = $curResult2["threadWriter"]; $threadCategory2 = $curResult2["threadCategory"]; $threadPicture2 = $curResult2["threadPicture"]; $stepCount2 = $curResult2["stepCount"]; $threadName2 = $curResult2["threadName"]; $threadPoint2 = $curResult2["threadPoint"]; $myThread2 = new Thread(array($threadID2, $threadDate2, $threadWriter2, $threadCategory2, $threadPicture2, $stepCount2, $threadName2, $threadPoint2)); $myThread2->ThreadToPetitHTML(); } echo "</div>"; $connection2->close(); } }
public function getStatisticTitleById($sid) { $connector = new DBConnector(); $connection = $connector->createConnection(); $query = 'SELECT title FROM statistics WHERE id=' . $sid; $result = mysql_query($query) or die("Error in " . $query); $row = mysql_fetch_assoc($result); $title = $row['title']; mysql_free_result($result); mysql_close($connection); return $title; }
public function getJSONFromDB() { $db = new DBConnector(); $sql = "SELECT s.spieltag, s.datum, sp.datum, sp.stadion, sp.heim, sp.gast, sp.tore_heim, sp.tore_gast FROM spieltag s, spiele sp WHERE s.spieltag = sp.spieltag_id"; $mysql = $db->connect(); $result = $mysql->query($sql); $json = array(); while ($row = $result->fetch_assoc()) { $json[] = $row; } return $json; }
public function loadAllComments($qId) { $connector = new DBConnector(); $connection = $connector->createConnection(); $result = mysql_query("SELECT * FROM comment WHERE FK_queryId='{$qId}'") or die("Error"); //TODO DATE $ans = array(); while ($row = mysql_fetch_assoc($result)) { $ans[$row['id']] = $row['text']; } mysql_free_result($result); mysql_close($connection); return $ans; }
public function getMessage($mid) { $connector = new DBConnector(); $connection = $connector->createConnection(); $result = mysql_query("SELECT * FROM messages WHERE message_id = '{$mid}'"); $message = mysql_fetch_array($result); $ans = array(); $ans['title'] = $message['message_title']; $ans['from'] = $message['from_user']; $ans['content'] = $message['message_contents']; mysql_free_result($result); mysql_close($connection); return $ans; }
public function UserThreadsToHTML() { global $whichUsr; echo "<div style=\"margin-top:2%;\">"; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { echo "Database'e bağlantı sorunu"; } else { $connection->set_charset("utf8"); $res0 = $connection->query("SELECT * from threads where threadWriter= '{$whichUsr}'"); $totalCount = $res0->num_rows; $res = $connection->query("SELECT * from threads where threadWriter='{$whichUsr}' ORDER BY threadPoint DESC LIMIT 6"); $curCount = $res->num_rows; while ($curres = $res->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(); } $connection->close(); } echo "<div id=\"more_data_div\" style=\"\">"; echo "</div>"; echo "<div style=\"margin:2%;\">"; if ($totalCount != 0) { echo "<form method =\"post\" id =\"userThreadsForm\" action=\"usrThreadsLoadMore.php?usr="******"\">"; echo "<input name=\"offsetUsrThread\" id=\"offsetUsrThread\" value=\"" . $curCount . "\" style=\"display:none;\" />"; echo "<input name=\"totalUsrThread\" id=\"totalUsrThread\" value=\"" . $totalCount . "\" style=\"display:none;\" />"; echo "<button id=\"loadMoreDataButton\" class=\"btn btn-block btn-success\" style=\"\">"; echo "<i id=\"loadMoreThreadSpinner\" style=\"display:none;\" class=\"fa fa-refresh fa-spin\"></i>"; echo "<span id=\"loadMoreDataTXT\"> Daha fazla göster </span>"; echo "</button>"; echo "</form>"; } else { echo "<span style=\"font-family: 'Josefin Sans', sans-serif;font-size:18px;color:#6e6e6e;\"> Bu yazar henüz başlık oluşturmamış. </span>"; } echo "</div>"; echo "</div>"; echo "<script type=\"text/javascript\">"; echo "\n\t\t\t\$('#loadMoreDataButton').click(function(e){\n\t\t\t\te.preventDefault();\n\t\t\t\t\$('#loadMoreDataTXT').hide();\n\t\t\t\t\$('#loadMoreThreadSpinner').show();\n\t\t\t\t\$('#userThreadsForm').ajaxForm({\n\t\t\t\t\tsuccess : function(msg){\n\t\t\t\t\t\t\$('#loadMoreDataTXT').show();\n\t\t\t\t\t\t\$('#loadMoreThreadSpinner').hide();\n\t\t\t\t\t\toldoffset = \$('#offsetUsrThread').val();\n\t\t\t\t\t\tnewoffset = msg.charAt(0);\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\$('#loadMoreDataTXT').html('Hepsi yüklendi');\n\t\t\t\t\t\t\t \$('#loadMoreDataButton').attr(\"disabled\", true);\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\$('#offsetUsrThread').val(oldint+newint);\n\t\t\t\t\t\tmsg2 = msg.substring(1);\n\t\t\t\t\t\t\$('#more_data_div').append(msg2);\n\t\t\t\t\t\t\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});\n\t\t"; echo "</script>"; }
/** * * @param <type> $id the user id to modify the values here * @param <type> $userInstanceNewValues the new values of the user info * that are in the user instance */ public function modifyUserInfo($id, $userInstanceNewValues) { $connector = new DBConnector(); $connection = $connector->createConnection(); $userId = $userInstanceNewValues->getId(); $gender = $userInstanceNewValues->gender; $maritalStatus = $userInstanceNewValues->maritalSt; $studies = $userInstanceNewValues->studies; $institutionName = $userInstanceNewValues->getInstitutionName(); $country = $userInstanceNewValues->getCountry(); $religion = $userInstanceNewValues->getReligion(); $query = "UPDATE userinfo set gender='" . $gender . "', maritalSt='" . $maritalStatus . "', studies='" . $studies . "' , InstitutionName='" . $institutionName . "' , currentLocation='" . $country . "' , religion='" . $religion . "' where FK_users=" . $userId; mysql_query($query) or die("Error in query modifying user info : {$query}. " . mysql_error() . " and the user id is" . $id); mysql_close($connection); }
public function Find() { global $whichThread; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { return "?"; } else { $query = "SELECT * FROM favoriler WHERE threadID='{$whichThread}'"; $result = $connection->query($query); $connection->close(); return $result->num_rows; } }
/** * @deprecated since version 4.0 Use selectDatabase('dbname', true) instead */ public function createDatabase() { Deprecation::notice('4.0', 'Use selectDatabase(\'dbname\',true) instead'); $database = $this->connector->getSelectedDatabase(); $this->selectDatabase($database, true); return $this->isActive(); }
/** * Return the global unique instance of DBConnector. * * @param string $sIncDir The base include path of the system. [optional, default=INC_DIR] * * @return DBConnector * * @throws Exception */ public static function getInstance() { if (!isset(self::$aInstances) || !self::$aInstances instanceof DBConnector) { self::$aInstances = new DBConnector(); } return self::$aInstances; }
public function AgentInsert($Device, $task, $data, $xtype) { try { if (self::getTaskUID($Device, $task) == "true") { parent::Sorgu("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'"); parent::Sorgu("INSERT INTO datas ( `deviceID`,`taskUID`,`data`,`type`) VALUES ( '" . @$Device . "', '" . @$task . "', '" . mysql_real_escape_string(@$data) . "','" . $xtype . "')"); if (mysql_affected_rows() >= 0) { parent::Sorgu("UPDATE tasklist SET taskStat='2' where deviceId = '" . $Device . "' and taskUID = '" . $task . "'"); if (mysql_affected_rows() >= 0) { $ExportXML = '<result> <stat>true</stat> <taskUID>' . $task . '</taskUID> </result>'; return $ExportXML; } else { $ExportXML = '<result> <stat>false</stat> <taskUID>' . $task . '</taskUID> </result>'; return $ExportXML; } } } } catch (Exception $e) { return $e->getMessage(); } }
/** * Get posts from DB according to input parameters * * @param int $count * @param int $id * @param string $tag * @return Posts */ public function get($count = false, $id = false, $tag = false) { $queryString = ' SELECT resyst_db.time as timestamp, resyst_db.name as title, resyst_db.text as contents, resyst_db.id as id, resyst_tag.id as tag_id, resyst_tag.tagname as tag_name, resyst_tag.parenttag as tag_parentName, resyst_tag.colour as tag_colour FROM resyst_db INNER JOIN resyst_tag ON resyst_db.tag = resyst_tag.id ' . ($id ? "WHERE resyst_db.id = {$id}" : '') . ' ' . ($tag ? "WHERE resyst_tag.tagname = '{$tag}'" : '') . ' ORDER BY id DESC ' . ($count ? "LIMIT {$count}" : '') . ' '; $pdo = DBConnector::getPDO(); $query = $pdo->prepare($queryString); $query->execute(array()); $result = $query->fetchAll(PDO::FETCH_ASSOC); foreach ($result as &$postData) { $postData['contents'] = html_entity_decode($postData['contents']); $postData = $this->_processTagData($postData); $this->_posts[] = new Post($postData); } return $this; }
public function Find() { global $threadID; $myDBConnector = new DBConnector(); $dbARY = $myDBConnector->infos(); $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]); if ($connection->connect_error) { return false; } else { $query = "SELECT count(comment) FROM `comments` WHERE threadID = " . $threadID; $results = $connection->query($query); $resassoc = $results->fetch_assoc(); $connection->close(); return $resassoc["count(comment)"]; } }
/** * returns an instance of a sqlite connection * * @return instance of this class */ public static function getInstance() { if (null === self::$instance) { self::$instance = new SQLite3(self::$dbfile); } return self::$instance; }
/** * Get PDO instance * * @return PDO */ public static function getPDO() { if (empty(self::$_pdo)) { self::$_pdo = new PDO(Conf::get(self::DSN), Conf::get(self::USER), Conf::get(self::PASSWORD)); } return self::$_pdo; }