function deleteStudent($cne)
{
$mysql = dbConn::getConnection();
$q = $mysql->prepare("DELETE FROM etudiant WHERE cne = ?");
$q->execute(array($cne));
$mysql = dbConn::disconnect();
}
function validateLogin()
{
$app = Slim\Slim::getInstance();
// Creating a Slim instance
$request = $app->request();
// Creating a Slim request object
// Taking in the Username and password
$username = htmlspecialchars($request->post('username'));
$password = $request->post('password');
// Encrypting the password and checking the password and the user name againest the database
$encript_Pass = md5($password);
$query = "CALL CHECK_LOGIN_DETAILS('{$username}','{$encript_Pass}');";
$db = dbConn::getConnection();
// Create an instance of the database
$result = $db->query($query);
$current_user = $result->fetch();
if (!empty($current_user)) {
// If it is in the database
// Add session variables used to secure pages and for role controle
$_SESSION['user_id'] = $current_user['account_no'];
$_SESSION['fname'] = $current_user['first_name'];
$_SESSION['lname'] = $current_user['last_name'];
$_SESSION['role'] = $current_user['user_roles_role_id'];
$_SESSION['user_token'] = $current_user['account_no'];
if ($current_user['user_roles_role_id'] == 1 || $current_user['user_roles_role_id'] == 2) {
// Redirest to the Admin section or the support section
$app->redirect('dashboard/admin/' . $current_user['account_no']);
} else {
// Redirect to the User section
$app->redirect('dashboard/user/' . $current_user['account_no']);
}
} else {
$error = array("error" => "Login Details Not Found");
// Render the page
$app->render('../api/resources/login.php', array('myerror' => $error));
}
}
<?php
session_start();
require_once '../lib/class.dbConnect.php';
require_once '../lib/class.contents.php';
require_once '../lib/class.favorites.php';
$DB = new dbConn();
$Favorite = new clsFavorites($DB->getConnection());
$idx = $_POST['idx'];
$m_idx = $_SESSION['USER_IDX'];
$arr = array("tags" => trim($_POST['tags']));
$result = $Favorite->modify($idx, $m_idx, $arr);
echo json_encode($result);
<?php
session_start();
require_once '../lib/class.dbConnect.php';
require_once '../lib/class.contents.php';
require_once '../lib/class.favorites.php';
$DB = new dbConn();
$Content = new clsContents($DB->getConnection());
$Favorite = new clsFavorites($DB->getConnection());
$result = array();
if ($_SESSION['USER_IDX'] == "") {
$result = array("r" => "error", "msg" => "Available after sign in.");
echo json_encode($result);
return;
}
if (trim($_POST['cidx']) == "") {
$arr = array("c_id" => trim($_POST['id']), "c_type" => trim($_POST['c_type']), "s_name" => trim($_POST['s_name']), "c_info" => trim($_POST['info']));
$result = $Content->save($arr);
if ($result['r'] == "success" || $result['r'] == "exist") {
$c_idx = $result['idx'];
}
} else {
$c_idx = trim($_POST['cidx']);
}
$arr = array("m_idx" => $_SESSION['USER_IDX'], "c_idx" => $c_idx, "search_word" => trim($_POST['keyword']), "tags" => trim($_POST['tags']));
$result = $Favorite->save($arr);
if ($result['r'] == "success") {
$result['f_cnt'] = $Content->incrementFavorite($result['c_idx']);
}
echo json_encode($result);
<?php
session_start();
require_once '../lib/class.dbConnect.php';
require_once '../lib/class.members.php';
$DB = new dbConn();
$Member = new clsMembers($DB->getConnection());
if ($Member->confirmPasswd(trim($_POST['email']), trim($_POST['currentPasswd'])) === true) {
echo "true";
} else {
echo "false";
}
</style>
<?php
if ($TopMenu == "member") {
?>
<ul>
<li><a href="list.php?pgkey=list">List</a></li>
</ul>
<?php
} else {
if ($TopMenu == "favorite") {
require_once '../../lib/class.dbConnect.php';
require_once '../../lib/class.contents.php';
$DB = new dbConn();
$Content = new clsContents($DB->getConnection());
$arrServerList = $Content->getServerList();
?>
<ul>
<?php
$type_temp = "";
for ($i = 0; $i < count($arrServerList); $i++) {
if ($type_temp == $arrServerList[$i]['c_type']) {
continue;
}
$type_temp = $arrServerList[$i]['c_type'];
?>
<li><a href="list.php?c_type=<?php
echo $arrServerList[$i]['c_type'];
?>
" ><?php
function postDelete($value)
{
$app = Slim\Slim::getInstance();
$db = dbConn::getConnection();
$user_details = getAccount($value);
$request = $app->request();
$ticket_id = $request->post('ticket_id');
$db_mongo_coll = mongoConn::getConnection();
// remove a ticket with a chosen id
$db_mongo_coll->remove(array('_id' => new MongoId($ticket_id)), true);
$user_tickets = $db_mongo_coll->find()->sort(array('_id' => -1));
$app->render('../api/resources/view_all_tickets.php', array('user' => $user_details, 'tickets' => $user_tickets));
}
/* Create TwitteroAuth object with app key/secret and token key/secret from default phase */
$connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, $_SESSION['oauth_token'], $_SESSION['oauth_token_secret']);
/* Request access tokens from twitter */
$access_token = $connection->getAccessToken($_REQUEST['oauth_verifier']);
/* Save the access tokens. Normally these would be saved in a database for future use. */
$_SESSION['access_token'] = $access_token;
$return_url = $_SESSION['return_url'] != "" ? $_SESSION['return_url'] : "/index.php";
/* Remove no longer needed request tokens */
unset($_SESSION['oauth_token']);
unset($_SESSION['oauth_token_secret']);
/* If HTTP response is 200 continue otherwise send to connect page to retry */
if (200 == $connection->http_code) {
/* The user has been verified and the access tokens can be saved for future use */
$content = $connection->get('account/verify_credentials');
$DB = new dbConn();
$Member = new clsMembers($DB->getConnection());
$oauth_type = "twitter";
$result = $Member->getOauthMemberIdx($oauth_type, $content->id_str);
if ($result['r'] == 'success') {
$_SESSION['USER_IDX'] = $result['idx'];
$_SESSION['USER_TYPE'] = $oauth_type;
$_SESSION['USER_ID'] = $content->id_str;
$_SESSION['USER_NAME'] = $content->name;
$_SESSION['USER_IMAGE'] = $content->profile_image_url;
$_SESSION['USER_AGREE'] = $result['policy_agree'];
$c_idx = "";
$keyword = "";
if (!isset($_SESSION['favorite_cidx']) || $_SESSION['favorite_cidx'] != "") {
$c_idx = $_SESSION['favorite_cidx'];
$keyword = $_SESSION['favorite_keyword'];
$_SESSION['favorite_cidx'] = "";
<?php
require_once '../lib/class.dbConnect.php';
require_once '../lib/class.contents.php';
require_once '../lib/class.favorites.php';
$DB = new dbConn();
$conn = $DB->getConnection();
$Content = new clsContents($conn);
$Favorite = new clsFavorites($conn);
$curPage = trim($_POST['cur_page']);
$pageLen = trim($_POST['page_cnt']) ? trim($_POST['page_cnt']) : 0;
$c_type = trim($_POST['type']);
if ($c_type == "") {
exit;
}
$totalcount = $Content->getFavoriteContentsCount($c_type, 'y');
$result = array("total" => $totalcount);
$start = $curPage * $pageLen;
$data = $Content->getFavoriteContents($c_type, $start, $pageLen, 'y');
for ($i = 0; $i < count($data); $i++) {
$info = json_decode($data[$i]['c_info']);
$info->idx = $data[$i]['idx'];
$info->s_name = $data[$i]['s_name'];
$info->f_count = $data[$i]['f_count'];
$result['data'][] = $info;
}
echo json_encode($result);
private function showData($tableName, $columnArray)
{
$dbname = dbname;
$MongoConnect = new MongoClient();
$db = $MongoConnect->{$dbname};
$tableCreation = $db->createCollection($tableName);
$db = dbConn::getConnection();
$query = $db->query("SELECT * from `{$tableName}`");
while ($results = $query->fetch(PDO::FETCH_ASSOC)) {
$rowColumn_combined = array_combine($columnArray, $results);
//combining column and data to insert
$tableCreation->insert($rowColumn_combined);
}
echo 'Successfully Imported Table ' . $tableName . "\n";
}
