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;
}
}
}
/**
* Author : Jan Germann
* Datum : 01.05.2010
* Modul : menu
* Beschreibung : Erstellen von einem Menüpunkt
*/
function create()
{
if (!$_POST['submit']) {
return showFormCreate();
} elseif ($_POST['submit']) {
return insertData();
}
}
function signupOverride($coreUserInfo)
{
global $gasDatabaseName, $CoreUserTableName;
$insert = array();
$uid = $coreUserInfo["Result"]["Uid"];
$insert["CustomerType"] = post("CustomerType");
$insertAddress = array();
$insertAddress["Uid"] = $uid;
$insertAddress["Username"] = "";
$insertAddress["PhoneNumber"] = post("PhoneNumber");
$insertAddress["City"] = post("RegionFirstLevel");
$insertAddress["Area"] = post("RegionSecondLevel");
$insertAddress["DetailAddress"] = post("DetailAddress");
$insertAddress["Floor"] = 0;
$insertAddress["Elevator"] = 0;
$insertAddress["IsDefault"] = 1;
$_POST = null;
connectDB($gasDatabaseName);
// insertData("Customer", $insert);
updateData($CoreUserTableName, "Uid = {$uid}", $insert);
insertData("CustomerAddress", $insertAddress);
printResultByMessage("", 0, $coreUserInfo["Result"]);
}
function saveImages($paths, $artistId)
{
global $mysqli;
// Artistbilder
//beim hinzufügen neuer Bilder die höchste SortId raus suchen und +1
$anzahlBilder = "SELECT MAX(Images_SortId) Anzahl FROM artistimages WHERE Artists_ID = " . $artistId;
$result = mysqli_query($mysqli, $anzahlBilder);
if (isset($result)) {
$anzahlBilder = mysqli_fetch_assoc($result);
} else {
$anzahlBilder = 0;
}
if (intval($anzahlBilder['Anzahl']) >= 1) {
$sort = $anzahlBilder['Anzahl'] + 1;
} else {
$sort = 1;
}
foreach ($paths as $path) {
$artistImages = array("Artists_Id" => $artistId, "Images_Name" => $path, "Images_SortId" => $sort);
insertData("artistimages", $artistImages);
$sort++;
}
}
//log status
//MODEL:: WHERE THE DATABASE CAPTURES THE APPROVAL DETAILS .....STARTS HERE
mysqlquery("insert into vl_samples_verify
(sampleID,outcome,outcomeReasonsID,comments,created,createdby)
values
('$id','$outcome','$outcomeReasonsID','$comments','$datetime','$trailSessionUser')");
if(isset($other_reasons)){
foreach ($other_reasons as $other_reason) {
if(!empty($other_reason)){
$data=array("sampleID"=>$id,
"reasonID"=>$other_reason,
"created"=>$datetime,
"createdby"=>$trailSessionUser);
insertData($data,'vl_samples_verify_reasons');
}
}
}
//MODEL:: WHERE THE DATABASE CAPTURES THE APPROVAL DETAILS ..... ENDS HERE
//redirect to home with updates on the tracking number
if($saveChangesProceed) {
//proceed to next sample within the search results
if($encryptedSample && $searchQueryCurrentPosition && $searchQueryNextPosition) {
go("/verify/approve.reject/$searchQueryNextPosition/$pg/search/$encryptedSample/1/");
} elseif($envelopeNumberFrom && $envelopeNumberTo && $searchQueryCurrentPosition && $searchQueryNextPosition) {
go("/verify/approve.reject/$searchQueryNextPosition/$pg/search/$envelopeNumberFrom/$envelopeNumberTo/1/");
}
} elseif(!$searchQueryNextPosition || $saveChangesReturn) {
if($encryptedSample) {
go("/verify/search/$encryptedSample/pg/$pg/modified/");
function FileUpload($resourceType, $currentFolder, $sCommand)
{
dbConn();
$email = getEmailFCK();
$thumb_widthpx = 160;
if (!isset($_FILES)) {
global $_FILES;
}
$sErrorNumber = '0';
$sFileName = '';
if (isset($_FILES['NewFile']) && !is_null($_FILES['NewFile']['tmp_name']) && $email != "") {
global $Config;
$oFile = $_FILES['NewFile'];
// Map the virtual path to the local server path.
//$sServerDir = ServerMapFolder( $resourceType, $currentFolder, $sCommand ) ;
$s = GetRootPath() . $Config['UserTempPath'] . $currentFolder . "/";
$s = str_replace("\\", "/", $s);
$sServerDir = $s;
$f = fopen("log2.txt", "a");
fwrite($f, "\r\n s = {$s} \r\n");
// Get the uploaded file name.
$sFileName = $oFile['name'];
$sFileName = SanitizeFileName($sFileName);
$sOriginalFileName = $sFileName;
// Get the extension.
$sExtension = substr($sFileName, strrpos($sFileName, '.') + 1);
$sExtension = strtolower($sExtension);
if (isset($Config['SecureImageUploads'])) {
if (($isImageValid = IsImageValid($oFile['tmp_name'], $sExtension)) === false) {
$sErrorNumber = '202';
}
}
if (isset($Config['HtmlExtensions'])) {
if (!IsHtmlExtension($sExtension, $Config['HtmlExtensions']) && ($detectHtml = DetectHtml($oFile['tmp_name'])) === true) {
$sErrorNumber = '202';
}
}
// Check if it is an allowed extension.
if (!$sErrorNumber && IsAllowedExt($sExtension, $resourceType)) {
$iCounter = 0;
while (true) {
$sFilePath = $sServerDir . "/" . $sFileName;
//fwrite($f, "\r\n sFilePath = $sFilePath \r\n");
//fwrite($f, "\nsServerDir = $sServerDir\n");
if (is_file($sFilePath)) {
$iCounter++;
$sFileName = RemoveExtension($sOriginalFileName) . '(' . $iCounter . ').' . $sExtension;
$sErrorNumber = '201';
} else {
move_uploaded_file($oFile['tmp_name'], $sFilePath);
if (is_file($sFilePath)) {
$ftype = $_FILES['NewFile']['type'];
$file_size = $_FILES['NewFile']['size'];
$originalpic = file_get_contents($sFilePath);
list($width, $height) = getimagesize($sFilePath);
if ($width > $thumb_widthpx) {
$count = 1;
$p = str_replace($sFileName, "", $sFilePath, $count);
//fwrite($f, "\r\nfpath: $sFilePath\r\n");
$thumbpic = getThumbImage($p, $thumb_widthpx, $sFileName);
} else {
$thumbpic = $originalpic;
unlink($sFilePath);
}
$album_id = getAlbumId($email);
$table = 'user_imgs';
$fields = array('id', 'user_email', 'large_image', 'thumb_image', 'file_type', 'stat', 'file_name', 'file_size', 'album_id', 'admin_perm', 'view_count', 'rating');
$values = array(null, $email, $originalpic, $thumbpic, $ftype, 1, $sFileName, $file_size, $album_id, 1, 0, 0);
$rs = insertData($table, $fields, $values);
if (is_string($rs) || $rs == false) {
//$sErrorNumber = '202' ;
//file_put_contents("$sFileName", $thumbpic);
} else {
//fwrite($f, "is inserted = true");
}
if (isset($Config['ChmodOnUpload']) && !$Config['ChmodOnUpload']) {
break;
}
$permissions = 0777;
if (isset($Config['ChmodOnUpload']) && $Config['ChmodOnUpload']) {
$permissions = $Config['ChmodOnUpload'];
}
$oldumask = umask(0);
chmod($sFilePath, $permissions);
umask($oldumask);
}
break;
}
}
if (file_exists($sFilePath)) {
//previous checks failed, try once again
if (isset($isImageValid) && $isImageValid === -1 && IsImageValid($sFilePath, $sExtension) === false) {
@unlink($sFilePath);
$sErrorNumber = '202';
} else {
if (isset($detectHtml) && $detectHtml === -1 && DetectHtml($sFilePath) === true) {
@unlink($sFilePath);
$sErrorNumber = '202';
}
}
}
} else {
$sErrorNumber = '202';
}
} else {
$sErrorNumber = '202';
}
$sFileUrl = CombinePaths(GetResourceTypePath($resourceType, $sCommand), $currentFolder);
$sFileUrl = CombinePaths($sFileUrl, $sFileName);
SendUploadResults($sErrorNumber, $sFileUrl, $sFileName);
exit;
}
$conn = dbConnect($dbHost, $dbUser, $dbPass);
//Create table (and database)
dbCreate($conn);
//Close the MySQL connection
mysqli_close($conn);
//Finish
return;
} else {
//Process the CSV file - loading, capitalization, email validation etc
$lines = csvProcessing($filename);
//Connect to the MySQL database
$conn = dbConnect($dbHost, $dbUser, $dbPass);
//Create table (and database)
dbCreate($conn);
//Insert the CSV data into the table
insertData($lines, $conn);
//Close the MySQL connection
mysqli_close($conn);
//Finish
return;
}
}
}
//Process the CSV file - loading, capitalization, email validation etc
function csvProcessing($filename)
{
//Open the CSV file
$file = fopen($filename, "r");
//Create an empty array to put the csv file into
$lines = [];
//Load each line of the CSV file, to the end of the file, into the array
<?php
header('Content-Type: application/json');
require_once 'app/init.php';
//include 'app/checksession.php';
global $datbase;
// = Database::getDB();
$jsonData = '';
if (isset($_POST['jsonData'])) {
$jsonData = json_decode($_POST['jsonData']);
//var_dump($jsonData);
foreach ($jsonData as $obj) {
$item = ['Inventory_Link' => $obj->recId, 'Item_Desc' => $obj->partDesc, 'Qty' => $obj->qty];
insertData($item, $database);
}
} else {
die("no JSON DATA");
}
function insertData($item, $dbObj)
{
$dbObj->table('tblPartRequestItems')->insert($item);
print_r($dbObj);
}
<?php
// Worker Code to store values in database
$worker = new GearmanWorker();
$worker->addServer();
$worker->addFunction("saveRecord", function ($job) {
return insertData($job->workload());
});
while ($worker->work()) {
}
function insertData($data)
{
$dataArray = json_decode($data, true);
// connect to database and save records
$dbhost = 'localhost';
$dbuser = '******';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if (!$conn) {
return false;
}
$sql = "INSERT INTO records(name, email, phone) VALUES('" . $dataArray['name'] . "', '" . $dataArray['email'] . "', " . $dataArray['phone'] . ");";
mysql_select_db('gearman');
$retval = mysql_query($sql, $conn);
if (!$retval) {
echo 'Could not enter data: ' . mysql_error();
} else {
echo 'Data Stored';
}
mysql_close($conn);
return;
<?php
session_start();
$_SESSION['info'] = "qweqwe";
if (isset($_POST['text'])) {
$component_id = $_POST['text'];
insertData($component_id);
} else {
if (isset($_POST['releaseSKU'])) {
$invlines_id = $_POST['releaseSKU'];
releaseSKU($invlines_id);
} else {
exit;
}
}
function insertData($component_id)
{
mysql_connect("localhost", $_SESSION['database_user'], $_SESSION['database_user_pswd']);
mysql_select_db("radiosklad");
mysql_query("SET NAMES 'utf8'");
mysql_query("INSERT INTO invlines VALUES \n (null,\n " . $component_id . ",\n " . $_SESSION['user_id'] . ",\n '1',\n null)");
exit;
}
function releaseSKU($invlines_id)
{
mysql_connect("localhost", $_SESSION['database_user'], $_SESSION['database_user_pswd']);
mysql_select_db("radiosklad");
mysql_query("SET NAMES 'utf8'");
$query = mysql_query("SELECT invdate FROM invlines WHERE id =" . $invlines_id);
$result_row = mysql_fetch_object($query);
if ($result_row->invdate == "") {
if ($isDefault == "1") {
query("UPDATE CustomerAddress SET IsDefault=0 WHERE Uid = {$uid}");
}
$insert = array();
$insert["Uid"] = $uid;
$insert["CustomerId"] = $customerId;
$insert["Username"] = $username;
$insert["PhoneNumber"] = $phoneNumber;
$insert["City"] = $regionFirstLevel;
$insert["Area"] = $regionSecondLevel;
$insert["DetailAddress"] = $detailAddress;
$insert["Floor"] = $floor;
$insert["Elevator"] = $elevator;
$insert["IsDefault"] = $isDefault;
$_POST = NULL;
insertData("CustomerAddress", $insert);
}
if ($actionType == "edit") {
$addressId = post("CustomerAddressId");
if ($isDefault == "1") {
query("UPDATE CustomerAddress SET IsDefault=0 WHERE Uid = {$uid}");
}
query("UPDATE `CustomerAddress` SET UserName='******', PhoneNumber='{$phoneNumber}', City='{$regionFirstLevel}', Area='{$regionSecondLevel}', DetailAddress='{$detailAddress}', Floor={$floor}, Elevator={$elevator}, IsDefault={$isDefault} WHERE CustomerAddressId={$addressId}");
}
if ($actionType == "delete") {
$addressId = post("CustomerAddressId");
query("DELETE FROM `CustomerAddress` WHERE CustomerAddressId={$addressId}");
}
printResultByMessage("", 0);
} else {
if ($action == "EditName") {
$puntos = "";
$letra = "";
$x = "x";
echo $idpreg[0]['Id_Pregunta'] . "";
echo $Pregunta . "<br> RESPUESTAS: <br>";
//Desglosar la Cadena dada y obtener las respuestas y los puntos
for ($i = 0; $x; $i++) {
if ($str[$i] == ":") {
$i++;
for ($a = $i; $letra != "," || $letra != null; $a++) {
$puntos = $puntos . $str[$a];
$i++;
$letra = $str[$i];
}
echo $respuesta . " - " . $puntos . "<br>";
insertData("INSERT INTO respuestas(Respuesta, Id_Pregunta, Puntos) VALUES ('" . $respuesta . "', " . $idpreg[0]['Id_Pregunta'] . ", " . $puntos . ")");
} else {
$respuesta = $respuesta . $str[$i];
}
$x = $str[$i];
}
}
if ($_GET['z'] == "Configuraciones") {
echo "\n\t\t\t<label id='equipos' class='btn btn-default btn-lg' style='width: 100%; margin-top: 5px;'>Equipos</label>\n\t\t\t<label id='juego' class='btn btn-default btn-lg' style='width: 100%; margin-top: 10px;'>Juego</label>\n\t\t\t<label id='cpreguntas'class='btn btn-default btn-lg' style='width: 100%; margin-top: 10px;'>Preguntas</label>\n\t\t\t<label id='extras'class='btn btn-default btn-lg' style='width: 100%; margin-top: 10px;'>Extras</label>\n\t\t\t<br>\n\n\t\t\t<script type='text/javascript'>\n\t\t\t\$(document).ready(function () {\n\t\t\t\$('#equipos').on('click', function(){\n\t\t\t \$('#tabla').load('php/configuraciones/equipos.php'); \n\t\t\t });\n\n\n\t\t\t\$('#juego').on('click', function(){\n\t\t\t \$('#tabla').load('php/configuraciones/juego.php'); \n\t\t\t });\n\n\t\t\t\$('#cpreguntas').on('click', function(){\n\t\t\t \$('#tabla').load('php/configuraciones/cpreguntas.php'); \n\t\t\t });\n\t\n\t\t\t\$('#extras').on('click', function(){\n\t\t\t \$('#tabla').load('php/configuraciones/extra.php'); \n\t\t\t });\n\n\n\t\t\t});\n\n\t\t\t</script>\n\n\t\t\t\t\t";
}
}
function MusicOFF()
{
SQL("UPDATE juego SET music = 0");
echo "<script>\n \$(document).ready( \n function(){ \n \$('#auto8').load('php/music.php?z=None');\n });\n </script>";
}
include "function.php";
@($username = $_SESSION['username']);
if (@$username == null || @$username == "") {
echo "<script>location.href='http://mdm.techandtheory.com/alpha/login.php'</script>";
}
if (isset($_POST['submit'])) {
unset($_SESSION['user_id']);
if (!empty($_POST['userlist'])) {
$_SESSION['user_id'] = $_POST['userlist'];
echo '<script>window.location.replace("add_device.php");</script>';
} else {
$f_name = mysql_real_escape_string(trim($_POST['f_name']));
$l_name = mysql_real_escape_string(trim($_POST['l_name']));
$office_loc = mysql_real_escape_string(trim($_POST['office_loc']));
$insert_data = array('f_name' => $f_name, 'l_name' => $l_name, 'office_loc' => $office_loc);
$data = insertData('users', $insert_data);
if ($data) {
$_SESSION['success'] = "New User Added Successfully...";
$_SESSION['user_id'] = mysql_insert_id();
echo '<script>window.location.replace("add_device.php");</script>';
}
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>Mobile Device Management ALPHA - Add</title>
<link href="css/styles.css" rel="stylesheet" type="text/css" />
printError("CBX_ERROR_002", "通行证不正确");
exit;
}
}
//从JSON中获取用户通行证
$thePassport = $phpJson->passport;
//从JSON中获取用户装过数
$theInstCount = $phpJson->install_count;
//查询是否存在该通行证，没有则插入数据
$sql = "SELECT * FROM `user` WHERE `passport`='{$thePassport}'";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result)) {
//insertData($phpJson,$thePassport,$userName,$theInstCount);
refactorJson($thePassport, $userName);
} else {
insertData($phpJson, $thePassport, $userName, $theInstCount);
refactorJson($thePassport, $userName);
}
//从服务器获取的JSON数据插入数据库
function insertData($phpJson, $thePassport, $userName, $theInstCount)
{
//插入数据库用户表
$sqlString_1 = "INSERT INTO `recommend_contrast`.`user` (`id` ,`passport` ,`name`,`install_count`) VALUES (NULL ,'{$thePassport}', '{$userName}','{$theInstCount}');";
$sqlResult_1 = mysql_query($sqlString_1);
//如果插入失败，返回error
/*if(!$sqlResult_1){
echo "error1";
exit;
}*/
//将软件推荐数据插入软件表
for ($i = 0; $i < count($phpJson->software); $i++) {
<?php
//connect to database
$mysqli = new mysqli('localhost', 'elliothc', 'elliothc', 'history_chains');
$action = $_POST["action"];
//depending on the action value, run a different function
switch ($action) {
case 0:
insertData($mysqli);
//sign up - insert data
break;
case 3:
login($mysqli);
//checks to see if login matches
break;
}
function insertData($mysqli)
{
//insert data
$person_firstname = $_POST["personFName"];
$person_lastname = $_POST["personLName"];
$person_dob = $_POST["personDOB"];
$person_username = $_POST["personUserName"];
$person_password = $_POST["personPassword"];
$person_institution = $_POST["personInstitution"];
//if one of the names is missing, do nothing
if ($person_firstname == null || $person_lastname == null) {
return;
}
$query = "INSERT INTO user(fname, lname) VALUES ('" . $person_firstname . "', '" . $person_lastname . "')";
$result = $mysqli->query($query);
<?php
include_once '../utiliti/crud_function.php';
#declare variable
$nim = isset($_POST['nim']) ? $_POST['nim'] : null;
$nama = isset($_POST['nama']) ? $_POST['nama'] : null;
$aktivasi = rand();
$status = "belum di aktivasi";
if (isset($_POST['simpan'])) {
#eksekusi quey insert
$array_obj = array('id_pemilih' => '', 'nim' => $nim, 'nama' => $nama, 'no_aktivasi' => $aktivasi, 'status' => $status);
$query_insert = insertData($array_obj, 'voter', $conn);
$query_insert;
if ($query_insert) {
?>
<div class="alert alert-success">
Data Pemilih Berhasil di Tambahkan. Silahkan KLIK <a href="?page=master&ref=data_pemilih">Disini</a> Untuk Kembali.
</div>
<?php
}
}
//$worksheetName=0;
//$worksheetName=getDetailedTableInfo2("vl_samples_worksheetcredentials","id='$worksheetID' limit 1","worksheetName");
$worksheetReferenceNumber=0;
$worksheetReferenceNumber=getDetailedTableInfo2("vl_samples_worksheetcredentials","id='$worksheetID' limit 1","worksheetReferenceNumber");
//create worksheet
if($proceed) {
if(count($no_spots_samples)>0){
define("NO_SPOTS_RES","Invalid test result. There is insufficient sample to repeat the assay");
foreach($no_spots_samples AS $s_id){
$data=array("sampleID"=>$s_id,
"worksheetID"=>$worksheetID,
"result"=>NO_SPOTS_RES,
"created"=>$datetime,
"createdby"=>$trailSessionUser);
insertData($data,"vl_results_override");
}
}
if(count($worksheetSamples)) {
//first delete all samples from this worksheet
mysqlquery("delete from vl_samples_worksheet where worksheetID='$worksheetID'");
$insert_sql = "";
foreach($worksheetSamples as $ws) {
$ws=validate($ws);
$insert_sql .= "('$worksheetID','$ws','$datetime','$trailSessionUser'),";
}
$insert_sql = trim($insert_sql, ",");
mysqlquery("insert into vl_samples_worksheet
(worksheetID,sampleID,created,createdby)
$userStmt->bindValue(':name', $name, PDO::PARAM_STR);
$userStmt->bindValue(':location', $location, PDO::PARAM_STR);
$userStmt->bindValue(':date_established', $date, PDO::PARAM_STR);
$userStmt->bindValue(':area_in_acres', $area, PDO::PARAM_STR);
$userStmt->bindValue(':description', $description, PDO::PARAM_STR);
try {
$userStmt->execute();
} catch (Exception $e) {
$errors[] = $e->getMessage();
throw new Exception('Error: {$e->getMessage()}');
}
}
}
return $errors;
}
insertData($dbc);
$data = 'SELECT * FROM national_parks LIMIT :limit OFFSET :offset';
$stmt = $dbc->prepare($data);
// Bind the query parameters
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$parks = $stmt->fetchAll();
?>
<!doctype html>
<html>
<head>
<title>National Parks</title>
<meta charset="utf-8">
$host = $argv[2];
$user = $argv[3];
$pass = $argv[4];
$db = $argv[5];
switch ($method) {
case "inidb":
echo "running...";
echo "\n";
$dbms_schema = $argv[6];
inidb($host, $user, $pass, $db, $dbms_schema);
break;
case "insertData":
echo "running...";
echo "\n";
$dbms_data = $argv[6];
insertData($host, $user, $pass, $db, $dbms_data);
break;
default:
break;
}
function remove_comments(&$output)
{
$lines = explode("\n", $output);
$output = "";
// try to keep mem. use down
$linecount = count($lines);
$in_comment = false;
for ($i = 0; $i < $linecount; $i++) {
if (preg_match("/^\\/\\*/", preg_quote($lines[$i]))) {
$in_comment = true;
}
if (count($ArtistAnzahl) > 1) {
//im Array die Werte absteigend sortieren
array_multisort($Anzahl, SORT_DESC, $ArtistAnzahl);
//jetzt noch die TOP 8 raus suchen, wenn mehr als 8 Artists vorhanden sind
if (count($ArtistAnzahl) > 8) {
$Top8 = array();
for ($x = 0; $x <= 7; $x++) {
//die TOP 8 ins Array schreiben
$Top8[] = $ArtistAnzahl[$x];
}
} else {
//ansonsten die Artists ins Array schreiben
$Top8 = array();
for ($x = 0; $x < count($ArtistAnzahl); $x++) {
$Top8[] = $ArtistAnzahl[$x];
}
}
} else {
if (count($ArtistAnzahl) == 1) {
//wenn nur 1 Artist gefunden wurde, diesen ins Array schreiben
$Top8 = array();
$Top8[] = $ArtistAnzahl[0];
}
}
//Array fuer DB vorbereiten
foreach ($Top8 as $relatedArtist) {
$relatedArtists = array("RelatedArtists_Artist" => $relatedArtist['relArtist'], "Artists_ID" => $artist['Artists_ID'], "RelatedArtists_SortId" => $relatedArtist['Anzahl']);
//Jeden einzelnen Eintrag in die DB schreiben
insertData('relatedartists', $relatedArtists);
}
}
function addNewEntry()
{
if ($valid_request = validateRequest()) {
//prepare Post vars
/**
* XSS Cleaner For Name and Email Fields
*/
//sanitize vars
$name = strip_tags($_POST['name']);
$email = strip_tags($_POST['email']);
//checking if post vars are empty or invalid
$name = trim($name);
$email = trim($email);
//prepare insert SQL Script
$insert_sql = "INSERT INTO TBL_ITEMS (NAME,EMAIL) VALUES ('" . $name . "','" . $email . "')";
//insert into database
$resp = insertData($insert_sql);
//check anwser and redirect
if (!$resp) {
$_SESSION['errors'] .= "- Fail to insert into database!<br/>";
} else {
$_SESSION['success'] .= "- The data was inserted successfully!<br/>";
}
//Close Session Write
session_write_close();
//redirect
header("Location: ../../add");
die;
} else {
$_SESSION['errors'] .= "- The request was not accepted!<br/>";
//Close Session Write
session_write_close();
//redirect
header("Location: ../../add");
die;
}
}
if ($action == "MakeOrderRequest") {
unset($_POST["Action"]);
connectDB($gasDatabaseName);
$couponId = post("CouponId");
if (!empty($couponId)) {
$sql = "update Coupon set IsUse = 1 where CouponId = '{$couponId}'";
query($sql);
}
$merchantOrderNo = time();
$_POST["MerchantOrderNo"] = $merchantOrderNo;
$_POST["Uid"] = session("Uid");
$_POST["UserName"] = session("Info")["CustomerName"];
$_POST["PhoneNumber"] = session("Info")["PhoneNumber"];
$_POST["CustomerId"] = session("Info")["Uid"];
$_POST["OrderTime"] = date("Y-m-d H:i:s");
insertData("GasOrder");
$result["MerchantOrderNo"] = $merchantOrderNo;
$result["OrderAmount"] = post("OrderAmount");
printResultByMessage("", 0, $result);
} else {
if ($action == "AffirmReceiveGas") {
connectDB($gasDatabaseName);
$orderId = post("OrderId");
$orderCompleteTime = date("Y-m-d H:i:s");
$sql = "update GasOrder set OrderComplete = 1, OrderCompleteTime = '{$orderCompleteTime}' where OrderId = '{$orderId}'";
query($sql, $error);
if (empty($error)) {
printResultByMessage("", 0);
} else {
printResultByMessage("Fail", 1001);
}
<?php
include_once '../utiliti/crud_function.php';
#input ke log
$id = isset($_GET['id']) ? $_GET['id'] : null;
$array_obj = array('id_log' => '', 'id_calon' => $id);
insertData($array_obj, 'log', $conn);
# Update data calon yang sudah memilih
$id_voter = $_SESSION['no_aktv'];
$array_obj2 = array('status' => 'sudah memilih');
updateData($array_obj2, 'voter', $id_voter, 'no_aktivasi', $conn);
#unset nomor aktv
unset($_SESSION['no_aktv']);
?>
<h1 align="center"> TERIMA KASIH SUDAH MENGGUNAKAN HAK PILIH</h1>
<h2 align="center">SILAHKAN TINGGALKAN BILIK SUARA DAN PASTIKAN TIDAK ADA YANG TERTINGGAL</h2>
<?php
include_once '../utiliti/crud_function.php';
$id = 1;
$waktu_selesai = date("H:i:s");
$status = "pemungutan selesai";
#eksekusi query
$array_obj = array('status' => $status, 'waktu_selesai' => $waktu_selesai);
updateData($array_obj, 'waktu_pemilihan', $id, 'id_waktu', $conn);
#input data statistik :
$query_calon = $conn->query("SELECT * FROM calon");
while ($result_calon = $query_calon->fetch_array()) {
$id_calon = $result_calon['id_calon'];
$query_log = $conn->query("SELECT * FROM log WHERE id_calon = '{$id_calon}'");
$hitung_log = $query_log->num_rows;
$array_obj1 = array('id_statistik' => '', 'id_calon' => $id_calon, 'jum_suara' => $hitung_log);
insertData($array_obj1, 'statistik', $conn);
}
# mengitung prosentase data
$query_jum = $conn->query("SELECT SUM(jum_suara) AS jumlah_suara FROM statistik");
$result_jum = $query_jum->fetch_array();
$jumlah = $result_jum['jumlah_suara'];
$query_prosentase = $conn->query("SELECT * FROM statistik");
while ($result_prosentase = $query_prosentase->fetch_array()) {
$id_calon = $result_prosentase['id_calon'];
$jum_temp = $result_prosentase['jum_suara'];
#hitung prosentase
$prosentase = $jum_temp * 100 / $jumlah;
$array_obj2 = array('prosentase' => $prosentase);
updateData($array_obj2, 'statistik', $id_calon, 'id_calon', $conn);
}
?>
</div>
<?php
} else {
?>
<div class="alert alert-danger">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Gagal Tambah Data
</div>
<?php
}
} else {
if ($format == "image/jpeg" || $format == "image/jpg" || $format == "image/png" || $format == "image/JPG") {
if (move_uploaded_file($temp, $dir)) {
$array_param = array('id_calon' => '', 'nim' => $nim, 'nama' => $nama, 'prodi' => $prodi, 'visi' => $visi, 'img' => $foto);
// declare var yang mendefinisikan function insert
$query_simpan = insertData($array_param, 'calon', $conn);
$query_simpan;
if ($query_simpan) {
?>
<div class="alert alert-success">
<strong>Berhasil!</strong> Calon berhasil di tambahkan .. klik <a href="?page=master&ref=data_calon">Disini</a> Untuk Kembali
</div>
<?php
} else {
?>
<div class="alert alert-danger">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Gagal Tambah Data
</div>
<?php
}
function logUpdate($table="",$cols="",$cond=""){
global $trailSessionUser;
$res=mysqlquery("SELECT id,$cols FROM $table WHERE $cond");
while($row=mysqlfetchassoc($res)){
$log_data=array();
$log_data['table_name']=$table;
$log_data['table_id']=$row['id'];
$log_data['old_information']=json_encode($row);
$log_data['created']=date("Y-m-d H:i:s");
$log_data['createdby']=$trailSessionUser;
insertData($log_data,"vl_logs_edits");
}
}
<?php
session_start();
require LIBRARY_PATH . "function.php";
$curr_time = date("Y-m-d H:i:s");
if (isset($_POST['action'])) {
$db = Mysql::getInstance('localhost');
switch ($_POST['action']) {
case "create":
$data_point = array("userid" => $_SESSION['userid'], "lat" => $_POST['lat'], "lng" => $_POST['lng'], "curr_time" => $curr_time);
insertData("web3.map_point", $data_point, $new_markerid);
$data_photo = array("userid" => $_SESSION['userid'], "set" => $set, "title" => $title, "description" => $desc, "post_time" => $curr_time, "point_id" => $new_markerid);
insertData("web3.photo", $data_photo, $new_photo);
$db->close();
echo "{new_markerid:{$new_markerid}}";
break;
case "update":
$sql = "UPDATE web3.map_point SET ";
$sql .= "lat = '{$_POST['lat']}', lng = '{$_POST['lng']}', curr_time = '{$curr_time}' ";
$sql .= "WHERE id = '{$_POST['point_id']}'";
$db->query($sql);
$db->close();
break;
}
}
$note = str_replace("\r\n", " ", $note);
$devices_row = getRow("SELECT * FROM `devices` WHERE `user_id` ='{$user_ID}'");
$insert_data = array('user_id' => $user_ID, 'make' => $manufac, 'model' => $model, 'phone_num' => $phone, 'serial_num' => $serial, 'imei_string' => $imei, 'purchaser' => $purchaser, 'price' => $price, 'purchase_date' => $purchase_date, 'carrier' => $carrier, 'device_status' => $status);
if ($devices_row == null) {
$data = insertData('devices', $insert_data);
$devices_ID = mysql_insert_id();
} else {
$where = array('user_id' => $user_ID);
$data = updateData('devices', $insert_data, $where);
$devices_ID = $devices_row[0];
}
if ($data) {
$activity_data = array('user_id' => $user_ID, 'device_id' => $devices_ID, 'activity_type' => '', 'activity_notes' => $note, 'activity_date' => date("Y-m-d"));
$activity_row = getRow("SELECT * FROM `activity_log` WHERE `user_id` ='{$user_ID}'");
if ($activity_row == null) {
insertData('activity_log', $activity_data);
echo "<h3 class='success-msg'>Device Added Successfully.</h3>";
} else {
$where = array('user_id' => $user_ID);
$data = updateData('activity_log', $activity_data, $where);
echo "<h3 class='success-msg'>Device Updated Successfully.</h3>";
}
}
}
if (!empty($_SESSION['user_id'])) {
$user_data = get_user_data($_SESSION['user_id']);
$name = $user_data->f_name . ' ' . $user_data->l_name;
if ($device_data = get_device_data($_SESSION['user_id'])) {
$purchase_date = $device_data->purchase_date ? $device_data->purchase_date : '';
$price = $device_data->price ? $device_data->price : '';
$imei = $device_data->imei_string ? $device_data->imei_string : '';
$cltId = '';
$getVehi = "SELECT ci_clientName,di_deviceId,di_deviceName,di_imeiId,ci_clientId FROM tb_deviceinfo,tb_clientinfo WHERE ci_id = di_clientId AND di_mobileNo='" . $src . "' AND di_status=1";
$resVehi = $db->query($getVehi);
if ($db->affected_rows > 0) {
$fetVehi = $db->fetch_array($resVehi);
//print_r($fetVehi);
$cltId = $fetVehi[di_imeiId];
$path = $GLOBALS[dataPath] . "src/data/" . date('d-m-Y') . "/" . $fetVehi[di_imeiId] . ".txt";
//$path=$dataPath."client_".$fetVehi[vi_clientId]."/10-05-2009/".$src.".txt";
if ($fetVehi[di_deviceName] != "") {
$devName = $fetVehi[di_deviceName];
} else {
$devName = $fetVehi[di_deviceId];
}
PrintKMLFolder($path, $devName, $fetVehi[ci_clientId]);
insertData($src);
} else {
print "Invalid data.";
$from = "Shastra";
$to = $_GET[from];
//sendLocation($from,$to,$message,$fetVehi[ci_clientId]);
}
} else {
print "Parameter missing. Please check the data once.";
$from = "";
$to = $_GET[from];
//sendLocation($from,$to,$message);
//echo "Invalid";
}
function insertData($src)
{
$user = "******";
$url = getFirstURL($token);
echo $url;
// die();
// $url = "";
$tot = 500;
for ($i = 0; $i < $tot; $i++) {
// Initialize cURL session
$ch = curl_init($url);
// Option to Return the Result, rather than just true/false
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
// setting headers
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Fk-Affiliate-Id: ' . $user, 'Fk-Affiliate-Token: ' . $token));
// Perform the request, and save content to $result
$result = curl_exec($ch);
// print_r($result);
if ($result === FALSE) {
die("Curl failed: " . curL_error($ch));
}
$data = json_decode($result, true);
curl_close($ch);
// print_r($data);
insertData($data);
$url = $data['nextUrl'];
echo "<br>trying next URL<br>";
if ($url == null) {
echo "<br> exiting the loop";
break;
}
}
