本文整理汇总了PHP中DBConnector类的典型用法代码示例。如果您正苦于以下问题:PHP DBConnector类的具体用法?PHP DBConnector怎么用?PHP DBConnector使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了DBConnector类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: DigerSahane
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>";
}
}
示例2: Find
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;
}
示例3: Find2
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)"]);
}
}
示例4: Activate
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>";
}
示例5: ConversationsToHTML
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();
}
}
示例6: GetTop3
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 = '{$whichUser}'");
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;
}
}
}
示例7: loadStep
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();
}
}
示例8: YazarBasliklariToHTML
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();
}
}
示例9: LoadMessages
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();
}
}
示例10: BoardRightUpToHTML
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>";
}
示例11: deletePhoto
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);
}
示例12: __construct
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);
}
示例13: deleteQueryByID
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;
}
示例14: IndexGuncelToHTML
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>";
}
示例15: contributorCount
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;
}