function getAlbumId($email, $UPLOAD_ALBUM_NAME = "personals")
{
$UPLOAD_ALBUM_NAME = "personals";
$q = "select * from albums where user_email = '{$email}' and album_name = '{$UPLOAD_ALBUM_NAME}'";
$r = selectData($q);
if (is_string($r)) {
return 0;
} else {
if (is_array($r)) {
if (count($r) > 0) {
foreach ($r as $a) {
$album = $a;
}
$album_id = $album['id'];
return $album_id;
} else {
$dt = date("Y-m-d G:i:s");
$table = "albums";
$id = getNewId("{$table}");
$albumimg_id = 0;
$fields = array("id", "album_name", "user_email", "date_pub", "privacy", "admin_perm", "remarks", "albumimg_id", "view_count", "rating");
$values = array("{$id}", "{$UPLOAD_ALBUM_NAME}", "{$email}", "{$dt}", 1, 1, "", "{$albumimg_id}", 0, 0);
$rs = insertData($table, $fields, $values);
if ($rs == true) {
return $id;
} else {
return 0;
}
}
} else {
return 0;
}
}
}
function getAllItems()
{
//sql query
$select_sql = "SELECT * FROM TBL_ITEMS";
//Getting the results for the sql query
$results = selectData($select_sql);
return $results;
//return
if (!$results) {
return false;
} else {
return $results;
}
}
require_once '../../staff/class/staff.class.php';
//require_once '../../../baseInfo/class/bases.class.php';
//require_once '../../staff/class/staff_detasils.php';
require_once '../../staff/class/staff_include_history.class.php';
//require_once '../../../salary/payment/class/payments.class.php';
require_once inc_response;
require_once inc_dataReader;
require_once inc_PDODataAccess;
$task = isset($_POST["task"]) ? $_POST["task"] : (isset($_GET["task"]) ? $_GET["task"] : "");
switch ($task) {
case "save":
saveData();
case "delete":
deleteData();
case "select":
selectData();
case "gridSelect":
gridSelect();
case "searchPerson":
searchPerson();
case "searchRetPerson":
searchRetPerson();
case "changePT":
changePT();
//------------------------------------
//------------------------------------
case "selectCourse":
selectCourse();
case "selectEval":
selectEval();
//------------------------------------
include "../Functions/selectData.php";
// Include function to select a specific id from a table
/**
* SELECT data from result to display
*/
$sql_sel = "SELECT * FROM result";
// SQL query
$result = $conn->query($sql_sel);
// Execute SQL query
$output = "";
// To store the list of blacklist emails in order to display
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
$output .= "<tr><td>" . selectData($row['femaleid'], "ladies", "name") . "</td><td>" . selectData($row['maleid'], "male_participant", "name") . "</td><td>";
$output .= selectData($row['jobid'], "job", "job") . "</td></tr>";
}
} else {
echo "0 results";
}
$conn->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
function GetFoldersAndFiles($resourceType, $currentFolder)
{
dbConn();
//$email = $_GET['e'];
// Map the virtual path to the local server path.
$sServerDir = ServerMapFolder($resourceType, $currentFolder, 'GetFoldersAndFiles');
$f = fopen("log2.txt", "a");
fwrite($f, "\r\nemail = {$currentFolder}\r\n");
// Arrays that will hold the folders and files names.
$aFolders = array();
$aFiles = array();
/*
$oCurrentFolder = @opendir( $sServerDir ) ;
if($sFile = readdir( $oCurrentFolder ))
{
if ( is_dir( $sServerDir . $sFile ) )
$aFolders[] = '<Folder name="' . ConvertToXmlAttribute( $sFile ) . '" />' ;
}
closedir( $oCurrentFolder );
*/
// Arrays that will hold the folders and files names.
$aFolders = array();
$aFiles = array();
$email = getEmailFCK();
if ($email != "") {
//$f = fopen("c*k.txt", "w");
//fprintf($f, "$email");
}
$email = "*****@*****.**";
$email = $_SESSION['em'];
$email = $_GET['email'];
//import_request_variables("c", "c_");
$email = $c_conlivefck_cookie;
$f = fopen("c*k.txt", "w");
fprintf($f, "{$email}");
$album_id = getAlbumId($email);
$r = selectData("select * from user_imgs where user_email = '{$email}' and stat = 1 and album_id = {$album_id} ");
foreach ($r as $file) {
$fs = $file['file_size'];
if ($fs > 1) {
$fs = round($fs);
} else {
$fs = 1;
}
$aFiles[] = '<File name="' . ConvertToXmlAttribute($file['id']) . '" size="' . $fs . '" />';
}
// Send the folders
natcasesort($aFolders);
echo '<Folders>';
foreach ($aFolders as $sFolder) {
echo $sFolder;
}
echo '</Folders>';
// Send the files
natcasesort($aFiles);
echo '<Files>';
foreach ($aFiles as $sFiles) {
echo $sFiles;
}
echo '</Files>';
}
<?php
$servername = "localhost";
$username = "******";
$password = "******";
$dbname = "wordpress";
try {
$conn = new PDO("mysql:host={$servername};dbname={$dbname}", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
selectData($conn);
// $command = escapeshellcmd('./get_state_urls.py');
// $output = shell_exec($command);
// echo $output;
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
return;
}
$conn = null;
function selectData($conn)
{
$selection = "SELECT post_name,ID,post_parent from wp_posts where post_type = 'forum'";
$selectStmt = $conn->prepare($selection);
$selectStmt->execute();
$result = $selectStmt->fetchAll();
$length = count($result);
$state_array = array();
for ($i = 0; $i < $length; $i++) {
if ($result[$i][2] == 30) {
$state = $result[$i][0];
$url = "http://10.171.204.135/?forum=forum/" . $state;
echo "<br />\n\t\t\t\t\t<a href = " . $url . ">" . $state . "</a>";
selectData("SELECT rgb_kod AS val1, rgb_name AS val2 FROM ref_gmp_body LIMIT 10");
} else {
if (isset($_POST['eleId']) && $_POST['eleId'] == 'e7_other_manufacture') {
selectData("SELECT b.osa_kod AS val1, a.os_sykt AS val2 FROM o_syarikat a JOIN o_syarikat_add b ON a.os_kod=b.osa_os_kod WHERE b.osa_rka_kod=2 ORDER BY a.os_kod LIMIT 10");
} else {
if (isset($_POST['eleId']) && $_POST['eleId'] == 'e7_processing_step') {
selectData("SELECT rmr_kod AS val1, rmr_desc AS val2 FROM ref_manu_role WHERE rmr_desc NOT IN('STORE','IMPORTER')");
} else {
if (isset($_POST['eleId']) && $_POST['eleId'] == 'e8_Importer_name') {
selectData("SELECT b.osa_kod AS val1, a.os_sykt AS val2 FROM o_syarikat a JOIN o_syarikat_add b ON a.os_kod=b.osa_os_kod WHERE b.osa_rka_kod=5 ORDER BY a.os_kod LIMIT 10");
} else {
if (isset($_POST['eleId']) && $_POST['eleId'] == 'e9_Store_Address') {
selectData("SELECT b.osa_kod AS val1, a.os_sykt AS val2 FROM o_syarikat a JOIN o_syarikat_add b ON a.os_kod=b.osa_os_kod WHERE b.osa_rka_kod=3 ORDER BY a.os_kod LIMIT 10");
} else {
if (isset($_POST['eleId']) && $_POST['eleId'] == 'p1_batch_size_sukatan') {
selectData("SELECT rskt_short AS val1,rskt_short AS val2 FROM ref_sukatan");
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
'<td>'.$row['Niveau_Service'].'</td>';
echo '</tr>';
}
echo "</tbody></table>";
$outTable=ob_get_contents();
$_SESSION["res_pdf"]=$outTable;
$_SESSION["res_pdf_nom"]=$nom;
$_SESSION["res_pdf_basicat"]=$result[0]['Basicat'];
}
function exportation(){
echo '<div class="btn-group">';
echo '<button class="btn btn-warning btn-sm dropdown-toggle" data-toggle="dropdown"><i class="fa fa-bars"></i> Export Table Data</button>';
echo '<ul class="dropdown-menu " role="menu">';
echo '<li><a href="ressources2csv.php"><img src=\'images/csv.png\' width=\'24px\'>CSV</a></li>';
echo '<li><a target="_blank" href="ressources2pdf.php"><img src=\'images/pdf.png\' width=\'24px\'>PDF</a></li></ul>';
echo '</div>';
}
/*
$startTime=microtime(true);
$input="";
selectData('adp');
$duration=microtime(true)-$startTime;
echo 'The duration of select: '.$duration.' '.'secs'.'<br/>';
*/
if($_GET["input"]){
//echo "debugAJAX: ".$_GET["input"];
selectData($_GET["input"]);
}
?>
