function db_connect() { $db = new ezSQL_sqlite3(DB_PATH, DB_FILENAME); if ($db->last_error) { debug_to_console("DATABASE FAILED TO INITIALIZE"); die; } return $db; }
function createDocument($data) { global $conn; debug_to_console('fct create doc c.php'); /*$sql = "INSERT INTO documents (nom, latlng, url) VALUES (".$data["nom"].", ".$data["latlng"].", ".$data["url"].")"; //echo $sql; if ($conn->query($sql) === TRUE) { debug_to_console('create document successfully'); } else { debug_to_console('Error create Document. SQL : '. $sql ); }*/ }
function main($id, $mode) { global $db, $user, $auth, $template, $cache, $request; global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx; debug_to_console("Dice: User"); debug_to_console($user); //$user->add_lang('acp/common'); $user->add_lang_ext('hanelyp/fancydice', 'common'); $this->tpl_name = 'fancydice_body'; $this->page_title = $user->lang('ACP_FANCYDICE_TITLE'); add_form_key('hanelyp/fancydice'); if ($request->is_set_post('submit')) { if (!check_form_key('hanelyp/fancydice')) { trigger_error('FORM_INVALID'); } $action = $request->variable('action', ''); if ($action == 'dicedef') { $this->set_macros(); trigger_error($user->lang('ACP_FANCYDICE_SETTING_SAVED') . adm_back_link($this->u_action)); } elseif ($action == 'presentation') { //echo $request->variable('display', '', true),'<br />'; //echo html_entity_decode($request->variable('display', '', true)),'<br />'; $config->set('fancyDicePresent', html_entity_decode($request->variable('display', '', true)), 0); trigger_error($user->lang('ACP_FANCYDICE_SETTING_PRESENT') . adm_back_link($this->u_action)); } elseif ($action == 'resetbb') { $this->reset_BB_code(); trigger_error($user->lang('ACP_FANCYDICE_RESET_BB') . adm_back_link($this->u_action)); } } $macros = $this->get_macros(); //echo htmlentities($config['fancyDicePresent']), '<br />'; $i = 1; $dice = new \hanelyp\fancydice\event\main_listener($config, $user); foreach ($macros as $macro) { //$macro['index'] = $i; //echo json_encode($macro),'<br />'; // construct a test case $spec = $macro['NAME']; if (preg_match('/(\\@)/', $macro['DEF'])) { $spec = '3' . $spec; } //echo preg_match('/(\>)/', $macro['DEF']), $macro['DEF'], '<br />'; if (preg_match('/(\\>)/', $macro['DEF'])) { $spec = $spec . '6'; } $macro['ROLL'] = $dice->bb_replace_dice($spec, 0, $dice->validate(0, $spec, 0)); $template->assign_block_vars('macros', $macro); $i++; } $template->assign_vars(array('U_ACTION' => $this->u_action, 'U_NEXTINDEX' => $i, 'U_DISPLAY_DEF' => htmlentities($config['fancyDicePresent']))); }
<?php function debug_to_console($data) { if (is_array($data)) { $output = "<script>console.log( 'Debug Objects: " . implode(',', $data) . "' );</script>"; } else { $output = "<script>console.log( 'Debug Objects: " . $data . "' );</script>"; } echo $output; } $output = shell_exec("php /usr/share/nginx/html/UselessFacts/emails.php {rolsthoorn12@gmail.com} {2} {r} {r} {10} {2} 'alert' >> /log/uselessfacts.log &"); debug_to_console("OUTPUT_FROM_TEST" + $output);
$transport->setPassword($pass); $mailer = Swift_Mailer::newInstance($transport); try { $result = $mailer->send($message); debug_to_console($result); } catch (\Exception $e) { debug_to_console("Error"); debug_to_console("{$e->getMessage()}"); } $mailer2 = Swift_Mailer::newInstance($transport); try { $result2 = $mailer2->send($receipt_message); debug_to_console($result2); } catch (\Exception $e) { debug_to_console("Error"); debug_to_console("{$e->getMessage()}"); } //done. redirect to thank-you page. header('Location: thank-you.html'); // Function to validate against any email injection attempts function IsInjected($str) { $injections = array('(\\n+)', '(\\r+)', '(\\t+)', '(%0A+)', '(%0D+)', '(%08+)', '(%09+)'); $inject = join('|', $injections); $inject = "/{$inject}/i"; if (preg_match($inject, $str)) { return true; } else { return false; } }
/** * This will generate random password * @return string */ private function randomPassword() { debug_to_console('line 258'); $alphabet = "abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789"; $pass = array(); //remember to declare $pass as an array $alphaLength = strlen($alphabet) - 1; //put the length -1 in cache for ($i = 0; $i < 8; $i++) { $n = rand(0, $alphaLength); $pass[] = $alphabet[$n]; } return implode($pass); //turn the array into a string }
<?php require_once '../../BazaDanych/DBconnection.php'; $numer = $_POST['numer']; //pobranie danych z HTMLa $opis = $_POST['opis']; $idMagazyn = $_COOKIE['id_magazyn']; var_dump($numer . "i: " . $opis . "i: " . $idMagazyn); debug_to_console("Jestem w insert"); $dbconn = getConnection(); mysqli_query($dbconn, "INSERT INTO inwentaryzacja (inw_mag_id, inw_numer, inw_opis) VALUES ('{$idMagazyn}', '{$numer}', '{$opis}');"); if (mysqli_errno($dbconn)) { debug_to_console("Problem z dodaniem inwentaryzacji do BD"); //$_SESSION['errorDodaniaMagazynuDoBD'] = true; } $dbconn->close(); header('Location: inwentaryzacja.php');
} else { debug_to_console("błąd podczas logowania1!"); setcookie('bladSQL', true, time() + 3600, "/"); header('Location: index.php'); } } else { debug_to_console("Wchodzi 4 i 2pol"); mysqli_query($dbconn, sprintf("INSERT INTO test VALUES (NULL, '%s');", mysqli_real_escape_string($dbconn, 'niach14242'))); mysqli_query($dbconn, sprintf("INSERT INTO sesja (ses_uzk_id, ses_id, ses_ip, ses_web)\n VALUES ('%s', '%s', '%s', '%s')", mysqli_real_escape_string($dbconn, $id_uzyt), mysqli_real_escape_string($dbconn, $id_sesja), mysqli_real_escape_string($dbconn, $ip), mysqli_real_escape_string($dbconn, $web))); if (!mysqli_errno($dbconn)) { setcookie('id_sesja', $id_sesja, time() + 3600, "/"); $_COOKIE['id_sesja'] = $id_sesja; setcookie('id_uzytkownik', $id_uzyt, time() + 3600, "/"); $_COOKIE['id_uzytkownik'] = $id_uzyt; } else { debug_to_console("błąd podczas logowania2!"); setcookie('bladSQL', true, time() + 3600, "/"); header('Location: index.php'); } } } //$records->close(); header("location: ../StrGlowna/strGlowna.php"); } else { if (isset($_COOKIE['id_uzytkownik']) || isset($_COOKIE['id_sesja'])) { setcookie('id_uzytkownik', null, time() - 1, '/'); unset($_COOKIE['id_uzytkownik']); setcookie('id_sesja', null, time() - 1, '/'); unset($_COOKIE['id_sesja']); } setcookie('bladHasla', true, time() + 3600, "/");
<?php /** * Created by PhpStorm. * User: Marcin * Date: 2016-01-02 * Time: 17:49 */ require_once "../../BazaDanych/DBconnection.php"; $idArkusz = $_POST['idArkusz']; debug_to_console($idArkusz); echo "<script type='text/javascript'>alert('{$idArkusz}');</script>"; $dbconn = getConnection(); mysqli_query($dbconn, "UPDATE arkusz_spisowy SET ark_czyZablokowany = '1' WHERE ark_id = '{$idArkusz}';"); if (mysqli_errno($dbconn)) { debug_to_console("Problem z usunieciem magazynu z BD"); //$_SESSION['errorDodaniaMagazynuDoBD'] = true; } $dbconn->close();
<?php require_once "../common/connect_database.php"; require_once "../common/debug_utils.php"; $ids = $_POST['wine_to_offline_ids']; $sqls = ""; foreach ($ids as $value) { $sqls .= "DELETE FROM web_wine_to_offline\n\t\t\t\tWHERE id = '{$value}';"; } debug_to_console($sqls); if (!$conn->multi_query($sqls)) { // echo "Multi query failed: (" . $conn->errno . ") " . $conn->error; }
$second = $_POST['second']; $third = $_POST['third']; $fourth = $_POST['fourth']; $fifth = $_POST['fifth']; } error_reporting(E_ALL); ini_set('display_errors', 1); $data = array('Inputs' => array('input1' => array('ColumnNames' => array("X1", "X2", "X3", "X4", "X5", "Y"), 'Values' => array(array($first, $second, $third, $fourth, $fifth, "0")))), 'GlobalParameters' => new StdClass()); debug_to_console($first); $body = json_encode($data); debug_to_console($body); $url = 'https://europewest.services.azureml.net/workspaces/1ce72f845b6d4b40a0c44018ce41c9aa/services/f72d0fb1e47d4b3fbdf1d2d1cb4b54ac/execute?api-version=2.0&details=true'; $api_key = '6fdbBStLMO4EbSTC5eb7BfaeLd6XuB0ppzXnPLU8jPuVghrZQMtMTxjyU17vWrBKRnhwuJfp3VPCLLQga8K5eQ=='; //$headers = array('Content-Type: application/json', 'Authorization:Bearer ' . $api_key, 'Content-Length: ' . strlen($body)); $headers = array('Content-Type: application/json', 'Authorization:Bearer ' . $api_key, 'Content-Length: ' . strlen($body)); debug_to_console(strlen($body)); $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_HTTPHEADER, $headers); curl_setopt($curl, CURLOPT_POST, 1); curl_setopt($curl, CURLOPT_POSTFIELDS, $body); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); //$response = json_decode(curl_exec($curl), true); $response = curl_exec($curl); curl_close($curl); echo "<p>This is the response: " . $response . "</p>"; //echo "This is var_dump: " . var_dump($response); $json = json_decode($response); echo "<p>This is the value 'type': " . $json->Results->output1->type . "</p>"; $sought_arr = $json->Results->output1->value->Values;
public function oauth($path, array $parameters = []) { function debug_to_console($data) { if (is_array($data)) { $output = "<script>console.log( 'Debug Objects: " . implode(',', $data) . "' );</script>"; } else { $output = "<script>console.log( 'Debug Objects: " . $data . "' );</script>"; } echo $output; } $response = []; $this->resetLastResponse(); $this->response->setApiPath($path); $url = sprintf('%s/%s', self::API_HOST, $path); $result = $this->oAuthRequest($url, 'POST', $parameters); if ($this->getLastHttpCode() != 200) { debug_to_console($parameters); throw new TwitterOAuthException($result); } parse_str($result, $response); $this->response->setBody($response); return $response; }
<?php /** * Created by PhpStorm. * User: Marcin * Date: 2015-12-30 * Time: 00:40 */ require_once "../../BazaDanych/DBconnection.php"; $numerArkusz = $_POST['numerArkusz']; debug_to_console($numerArkusz); echo "<script type='text/javascript'>alert('{$numerArkusz}');</script>"; /** * w zawiazku z tym iz nie zawsze dzialalo usuwanie po ID * wybieram nazwe i usuwam po nazwie. */ $dbconn = getConnection(); //$magNazwa = mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT mag_nazwa FROM magazyn WHERE mag_id = '$nazwaMagazyn';")); mysqli_query($dbconn, "DELETE FROM arkusz_spisowy WHERE ark_numer = '{$numerArkusz}';"); if (mysqli_errno($dbconn)) { debug_to_console("Problem z usunieciem inwentaryzacji z BD"); //$_SESSION['errorDodaniaMagazynuDoBD'] = true; } $dbconn->close();
if (!isset($_SESSION)) { /*if($seedChart!=0) { // don't forget to clean up // that chart nonsense as well $qry = "chart".$seedChart.".png"; unlink($qry); // reset seedChart variable to // ensure new filename. $seedChart = (int)((rand(1,183927)*1.2-9*rand(1,3))*rand(8,12)*.1); }*/ // start up that php session // for grabbing POST variables. session_start(); $thePortable = 'this is session id from index.php: ' . session_id(); // this function lives in <include>.php debug_to_console($thePortable); } ?> </head> <body> <?php if (!isset($_GET['created'])) { ?> <!-- IF $_GET===null --> <!-- MAIN MENU --> <div class="container"> <h1>Name Generator</h1> <form class="form" action="name.php?created=1" method="post"> <!-- <p> <label for="island"><small>base land masses (1-20) </small></label>
} } //Call SaveUserVariables which takes the values that the user set in PostingEditor.html and writes them back into variables to be written into the database //CVC - 11/25/15 include $phpbb_root_path . 'includes/SaveUserVariables.' . $phpEx; //CVC - 11/25/15 // ***** Write all variables for the post back into the datbase. **** $sel = 'SELECT * FROM ' . USERS_TABLE . ' WHERE user_id=' . $poster_id; $result = $db->sql_query($sel); $topic_row = $db->sql_fetchrow($result); $md_myupdate = md5($myupdate); $data = array('topic_title' => empty($post_data['topic_title']) ? $post_data['post_subject'] : $post_data['topic_title'], 'topic_first_post_id' => isset($post_data['topic_first_post_id']) ? (int) $post_data['topic_first_post_id'] : 0, 'topic_last_post_id' => isset($post_data['topic_last_post_id']) ? (int) $post_data['topic_last_post_id'] : 0, 'topic_time_limit' => (int) $post_data['topic_time_limit'], 'topic_attachment' => isset($post_data['topic_attachment']) ? (int) $post_data['topic_attachment'] : 0, 'post_id' => (int) $post_id, 'topic_id' => (int) $topic_id, 'forum_id' => (int) $forum_id, 'icon_id' => (int) $post_data['icon_id'], 'poster_id' => (int) $poster_id, 'poster_name' => (string) $poster_name, 'user_colour' => $updated_color, 'enable_sig' => (bool) $post_data['enable_sig'], 'enable_bbcode' => (bool) $post_data['enable_bbcode'], 'enable_smilies' => (bool) $post_data['enable_smilies'], 'enable_urls' => (bool) $post_data['enable_urls'], 'enable_indexing' => (bool) $post_data['enable_indexing'], 'message_md5' => (string) $message_md5, 'post_checksum' => isset($post_data['post_checksum']) ? (string) $post_data['post_checksum'] : '', 'post_edit_reason' => $post_data['post_edit_reason'], 'post_edit_user' => $mode == 'edit' ? $poster_id : (isset($poster_name) ? (int) $poster_name : 0), 'forum_parents' => $post_data['forum_parents'], 'forum_name' => $post_data['forum_name'], 'notify' => $notify, 'notify_set' => $post_data['notify_set'], 'poster_ip' => isset($post_data['poster_ip']) ? $post_data['poster_ip'] : $user->ip, 'post_edit_locked' => (int) $post_data['post_edit_locked'], 'bbcode_bitfield' => $message_parser->bbcode_bitfield, 'bbcode_uid' => $message_parser->bbcode_uid, 'message' => $message_parser->message, 'attachment_data' => $message_parser->attachment_data, 'filename_data' => $message_parser->filename_data, 'topic_status' => $post_data['topic_status'], 'topic_visibility' => isset($post_data['topic_visibility']) ? $post_data['topic_visibility'] : false, 'post_visibility' => isset($post_data['post_visibility']) ? $post_data['post_visibility'] : false, 'PLAYERINFO' => request_var('PLAYERINFO', ''), 'CLASS_INFO' => request_var('CLASS_INFO', ''), 'AC' => request_var('AC', ''), 'selected_current_hit' => request_var('select_current_count', ''), 'selected_maximum_hit' => request_var('select_maximum_count', ''), 'seleted_non_lethal' => request_var('select_non_lethal', ''), 'seleted_bad_condition' => json_encode(request_var('negative_condition', array('' => '')), JSON_FORCE_OBJECT), 'seleted_good_condition' => json_encode(request_var('positive_condition', array('' => '')), JSON_FORCE_OBJECT), 'spell_class_type' => $sct, 'level' => $l, 'level_min' => $lmin, 'level_max' => $lmax, 'ability_name' => $a, 'min_ability' => $amin, 'max_ability' => $amax, 'gear' => $gear_quality, 'quick_stats' => request_var('quick_stats', ''), 'hero_point' => request_var('select_hero_points', ''), 'quick_skill' => $skill_quality, 'spell' => $spell_variable1, 'spell_decription' => $spell_desc1, 'gear_description' => $gear_desc, 'skill_description' => $skill_desc, 'positive_condition_description' => $pc_desc, 'negative_concdition_description' => $nc_desc, 'abilities_description' => $abilities_desc); $message = $data; $message_parser->message = utf8_normalize_nfc(request_var('message', '', true)); $chekcsum = md5($message_parser->message); //print_r($dmessage); exit; debug_to_console("Loading SaveUserVariables ahead of data_upate_post."); $data_update_post = array('AC' => request_var('AC', ''), 'PLAYERINFO' => request_var('PLAYERINFO', ''), 'CLASS_INFO' => request_var('CLASS_INFO', ''), 'selected_current_hit' => request_var('select_current_count', ''), 'selected_maximum_hit' => request_var('select_maximum_count', ''), 'seleted_non_lethal' => request_var('select_non_lethal', ''), 'seleted_bad_condition' => json_encode(request_var('negative_condition', array('' => '')), JSON_FORCE_OBJECT), 'seleted_good_condition' => json_encode(request_var('positive_condition', array('' => '')), JSON_FORCE_OBJECT), 'spell_class_type' => $sct, 'level' => $l, 'level_min' => $lmin, 'level_max' => $lmax, 'ability_name' => $a, 'min_ability' => $amin, 'max_ability' => $amax, 'gear' => $gear_quality, 'quick_stats' => request_var('quick_stats', ''), 'hero_point' => request_var('select_hero_points', ''), 'quick_skill' => $skill_quality, 'spell' => $spell_variable1, 'spell_decription' => $spell_desc1, 'abilities_description' => $abilities_desc); $sql = 'UPDATE ' . USER_VARIABLES_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $data_update_post) . ' WHERE user_id = ' . $poster_id; $db->sql_query($sql); // to update post table //if ($mode == 'edit') { $dmessage = $message_parser->message; //Updated 12/02/15 to fix the blank edit issue. $dmessage = str_replace("'", "\\'", $dmessage); //Updated 12/02/15 to fix the blank edit issue. //$sql = 'UPDATE ' . POSTS_TABLE . ' SET post_text = \'' . $dmessage . '\', post_checksum = "' . md5($message_parser->message) . '" WHERE post_id = ' . $data['post_id']; //$db->sql_query($sql); //} if ($mode == 'edit') { $data['topic_posts_approved'] = $post_data['topic_posts_approved']; $data['topic_posts_unapproved'] = $post_data['topic_posts_unapproved'];
* * For full copyright and license information, please see * the docs/CREDITS.txt file. * */ /** * @ignore */ define('IN_PHPBB', true); $phpbb_root_path = defined('PHPBB_ROOT_PATH') ? PHPBB_ROOT_PATH : './'; $phpEx = substr(strrchr(__FILE__, '.'), 1); include $phpbb_root_path . 'common.' . $phpEx; include $phpbb_root_path . 'includes/functions_display.' . $phpEx; include $phpbb_root_path . 'includes/bbcode.' . $phpEx; include $phpbb_root_path . 'includes/functions_user.' . $phpEx; debug_to_console("Loading viewtopic.php"); // Start session management $user->session_begin(); $auth->acl($user->data); // Initial var setup $forum_id = request_var('f', 0); $topic_id = request_var('t', 0); $post_id = request_var('p', 0); $voted_id = request_var('vote_id', array('' => 0)); $voted_id = sizeof($voted_id) > 1 ? array_unique($voted_id) : $voted_id; $start = request_var('start', 0); $view = request_var('view', ''); $default_sort_days = !empty($user->data['user_post_show_days']) ? $user->data['user_post_show_days'] : 0; $default_sort_key = !empty($user->data['user_post_sortby_type']) ? $user->data['user_post_sortby_type'] : 't'; $default_sort_dir = !empty($user->data['user_post_sortby_dir']) ? $user->data['user_post_sortby_dir'] : 'a'; $sort_days = request_var('st', $default_sort_days);
/** * sprawdzam czy ustawione zmienne $_COOKIE['id_uzytkownik'] */ debug_to_console($_COOKIE['id_sesja']); debug_to_console($_COOKIE['id_uzytkownik']); if (!isset($_COOKIE['id_uzytkownik']) || $_COOKIE['id_uzytkownik'] == null) { debug_to_console('jestem w'); header('location: ../StrLogowanie/index.php'); exit; } /** * Sprawdzam czy istnieje record w tabeli SESJA o podanych cookisach. */ $dbconn = getConnection(); $wierszSesja = mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT ses_uzk_id FROM sesja WHERE\n ses_id = '{$_COOKIE['id_sesja']}';")); debug_to_console("Taki uzk: " . $wierszSesja['ses_uzk_id']); if (empty($wierszSesja['ses_uzk_id'])) { header('location: ../StrLogowanie/index.php'); exit; } /** * Sprawdzam czy wybrano magazyn */ if (!isset($_COOKIE['id_magazyn']) && $_COOKIE['id_magazyn'] == null) { header('Location: ../Magazyn/magazyn.php'); } /** * Sprawdzam czy wybrano inwentaryzacje */ if (!isset($_COOKIE['id_inwentaryzacji']) && $_COOKIE['id_inwentaryzacji'] == null) { header('Location: ../Inwentaryzacja/inwentaryzacja.php');
<?php /** * Created by PhpStorm. * User: Marcin * Date: 2016-01-10 * Time: 02:19 */ require_once '../../BazaDanych/DBconnection.php'; $nazwa = $_POST['nazwa']; //pobranie danych z HTMLa debug_to_console("Jestem w insert"); $dbconn = getConnection(); mysqli_query($dbconn, "INSERT INTO kategoria_towaru VALUES (NULL, '{$nazwa}');"); if (mysqli_errno($dbconn)) { debug_to_console("Problem z dodaniem magazynu do BD"); //$_SESSION['errorDodaniaMagazynuDoBD'] = true; } $dbconn->close(); header('Location: kategoria.php');
function sprawdzTowary() { $ilosc = 0; //var_dump("ilosc: " . $ilosc); if (isset($_POST['wybraneTowary'])) { $dbconn = getConnection(); mysqli_autocommit($dbconn, false); $arrWybraneTowary = $_POST['wybraneTowary']; $ilosc = count($arrWybraneTowary); $idArk = $_COOKIE['id_arkusza']; $idKat = $_COOKIE['id_kategoria']; //var_dump($idArk); //var_dump($idKat); try { $result = mysqli_query($dbconn, "SELECT tow_id FROM towar WHERE tow_ark_id = '{$idArk}' AND tow_kat_id='{$idKat}';"); $resultStare = array(); while ($row = mysqli_fetch_array($result)) { $resultStare[] = $row[0]; } //var_dump($resultStare); /*if ($arrWybraneTowary == null) { $rozmiar = count($resultStare); for ($i = 0; $i < $rozmiar; $i++) { $idTow = $resultStare[$i]; var_dump("Jestem w null: " . $idTow); $result2 = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = NULL WHERE tow_id = '$idTow';"); if (!$result2) { throw new Exception("Error details: " . mysqli_error($dbconn) . "."); } } return; }*/ if (false) { throw new Exception("Error details: " . mysqli_error($dbconn) . "."); } else { $resultMaxID = mysqli_fetch_array(mysqli_query($dbconn, "SELECT tow_id FROM towar ORDER BY tow_id DESC LIMIT 1")); if (false) { throw new Exception("Error details: " . mysqli_error($dbconn) . "."); } else { $maxTowID = $resultMaxID['tow_id']; //var_dump($maxTowID); /** * jesli zadne towary NIE byly przypisane do arkusza */ if ($resultStare == null) { //var_dump("1 opcja"); for ($idTow = 1; $idTow <= $maxTowID; $idTow++) { if (in_array($idTow, $arrWybraneTowary)) { //var_dump($idTow . ' w 1 opcji zaznaczony'); debug_to_console($idTow . ' w 1 opcji zaznaczony'); $resultUpdate = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = '{$idArk}' WHERE tow_id = '{$idTow}';"); if (!$resultUpdate) { throw new Exception("Error details: " . mysqli_error($dbconn) . "."); } } } } else { //var_dump("2 opcja"); for ($idTow = 1; $idTow <= $maxTowID; $idTow++) { //te ktore byly zaznaczone if (in_array($idTow, $resultStare)) { //jesli teraz nie sa = UPDATE if (!in_array($idTow, $arrWybraneTowary)) { //var_dump($idTow . ' w 2 opcji odznaczony'); $resultUpdate = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = NULL WHERE tow_id = '{$idTow}';"); if (!$resultUpdate) { throw new Exception("Error details: " . mysqli_error($dbconn) . "."); } } } else { if (in_array($idTow, $arrWybraneTowary)) { //var_dump($idTow . ' w 2 zaznaczony!'); debug_to_console($idTow . ' was checked!'); $resultUpdate = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = '{$idArk}' WHERE tow_id = '{$idTow}';"); if (!$resultUpdate) { throw new Exception("Error details: " . mysqli_error($dbconn) . "."); } } } } } } } $dbconn->commit(); debug_to_console("transakcja zakonczona powodzeniem"); } catch (Exception $e) { $dbconn->rollback(); debug_to_console("transakcja zakonczona NIE-powodzeniem: " . $e->getMessage()); } } return $ilosc; }
<?php require_once '../../BazaDanych/DBconnection.php'; $dbconn = getConnection(); //w oparciu o cookies $numer = $_POST['numer']; //pobranie danych z HTMLa $opis = $_POST['opis']; $idInw = $_COOKIE['id_inwentaryzacji']; $dataRozpoczecia = date('Y-m-d H:i:s'); debug_to_console("Jestem w insert"); $dbconn = getConnection(); mysqli_query($dbconn, "INSERT INTO arkusz_spisowy (ark_inw_id, ark_numer, ark_data_rozp, ark_opis) VALUES ('{$idInw}', '{$numer}', '{$dataRozpoczecia}', '{$opis}');"); if (mysqli_errno($dbconn)) { debug_to_console("Problem z dodaniem arkusza_spisowego do BD"); //$_SESSION['errorDodaniaMagazynuDoBD'] = true; } $dbconn->close(); header('Location: arkusz.php');
debug_to_console(strlen($body)); $curl = curl_init($url); curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "POST"); curl_setopt($curl, CURLOPT_POSTFIELDS, $body); curl_setopt($curl, CURLOPT_HTTPHEADER, $headers); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); debug_to_console(curl_exec($curl)); debug_to_console($curl); $result = curl_exec($curl); echo "curl_getinfo: " . curl_getinfo($result) . '<br/>'; echo "curl_errno: " . curl_errno($result) . '<br/>'; echo "curl_error: " . curl_error($result) . '<br/>'; echo "The var dump outputs the following: "; var_dump($result); $percent = floor($result * 100); debug_to_console($result); echo "<p>This is your result: " . $result . "</p>"; #echo "<p>You are "$percent"% </p>; #header('Location: '); } } } catch (Exception $e) { die(var_dump($e)); } echo "<h3>Your're registered!</h3>"; } // Retrieve data $sql_select = "SELECT * FROM registration_tbl"; $stmt = $conn->query($sql_select); $registrants = $stmt->fetchAll(); if (count($registrants) > 0) {
<div class=" col-lg-4 col-med-4 col-sm-4 col-xs-12 text-center"> <a href="<?php bloginfo('url'); ?> "><img src="<?php echo get_theme_mod('site_logo'); ?> " class="brand-logo"/> </a> <div class="site-social"> <?php $facebook = get_theme_mod('facebook_textbox'); $twitter = get_theme_mod('twitter_textbox'); $instagram = get_theme_mod('instagram_textbox'); $linkedin = get_theme_mod('linkedin_textbox'); debug_to_console('facebook: ' . $facebook); if ($facebook != NULL) { ?> <a href="<?php echo $facebook; ?> " ><i class="fa fa-facebook-square" aria-hidden="true"></i></a> <?php } if ($twitter != NULL) { ?> <a href="<?php echo $twitter; ?> " ><i class="fa fa-twitter-square" aria-hidden="true"></i></a> <?php
<a class="arrow-down" href="#onepagerstory"> <svg width="80" height="80" viewBox="0 0 80 80" version="1.1" xmlns="http://www.w3.org/2000/svg"><circle class="" cx="40" cy="40" r="32" /><line x1="20" y1="30" x2="40" y2="50" /><line x1="40" y1="50" x2="60" y2="30" /></svg> </a> </div> </div> <div class="row"> <section class="onepage-section" id="onepagerstory"> <?php if ($the_query->have_posts()) { ?> <?php while ($the_query->have_posts()) { $the_query->the_post(); ?> <?php debug_to_console(get_field('bild')); ?> <article id="<?php echo $post->post_name; ?> " class="onepage-element "> <div class="row"> <div class="container"> <div class="onepage-image col-md-6"> <img src="<?php echo get_field('bild')['url']; ?> " alt="<?php echo get_field('bild')['alt']; ?>
/** * @param type $obj */ static function debug($obj) { if (function_exists('debug_to_console')) { debug_to_console($obj); } }
/** * Created by PhpStorm. * User: Marcin * Date: 2015-12-26 * Time: 13:20 */ ?> <div id="header"> <div class="tytul"> <?php $wierszUzytkownik = mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT * FROM uzytkownik WHERE\n uzk_id = '{$wierszSesja['ses_uzk_id']}';")); if (!mysqli_errno($dbconn) && !empty($wierszUzytkownik['uzk_id'])) { echo "Witaj " . $wierszUzytkownik['uzk_imie'] . " " . $wierszUzytkownik['uzk_nazwisko'] . "!"; } else { debug_to_console("błąd podczas pobierania uzytkownika o ID: " . $wierszUzytkownik['uzk_id']); $_SESSION['bladSQL'] = true; header('Location: index.php'); } $dbconn->close(); ?> </div> <div class="dane"> <?php if (isset($_COOKIE['id_magazyn']) && $_COOKIE['id_magazyn'] != null) { $dbconn = getConnection(); $wierszMagazyn = mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT mag_nazwa FROM magazyn WHERE mag_id = '{$_COOKIE['id_magazyn']}';")); echo 'Magazyn: ' . $wierszMagazyn['mag_nazwa']; $dbconn->close(); } else { echo '<a href="../Magazyn/magazyn.php" class="tilelink">Wybierz magazyn</a>';
function request_var_condition() { debug_to_console("* Calling request_var_condition"); $array = array("negative_condition" => request_var('negative_condition', ''), "positive_condition" => request_var('positive_condition', ''), "gear" => request_var('gear', '')); return $array; }
<?php /** * Created by PhpStorm. * User: Marcin * Date: 2015-12-16 * Time: 14:54 */ require_once "../../BazaDanych/DBconnection.php"; $haslo = $_POST['haslo2']; $hasloCheck = $_POST['haslo2Check']; debug_to_console($haslo); debug_to_console($hasloCheck); if ($haslo != $hasloCheck) { echo "*Hasła nie zgadzają się!"; } else { debug_to_console("Hasla takie same"); }
if ($stan->getPelnowartosciowe() != null || $stan->getUszkodzone() != null || $stan->getZniszczone() != null || $stan->getPrzeterminowane() != null) { var_dump("sprawdzam nulle"); $idStan = $stan->getStanId(); $pelnowartosciowe = $stan->getPelnowartosciowe(); if ($pelnowartosciowe == null) { $pelnowartosciowe = 0; } $uszkodzone = $stan->getUszkodzone(); if ($uszkodzone == null) { $uszkodzone = 0; } $zniszczone = $stan->getZniszczone(); if ($zniszczone == null) { $zniszczone = 0; } $przeterminowane = $stan->getPrzeterminowane(); if ($przeterminowane == null) { $przeterminowane = 0; } $dbconn = getConnection(); $result = mysqli_query($dbconn, "UPDATE stan_rzeczywisty SET stan_pelnowartosciowe = '{$pelnowartosciowe}', stan_uszkodzone = '{$uszkodzone}',\n stan_zniszczone = '{$zniszczone}', stan_przeterminowane = '{$przeterminowane}' WHERE stan_id = '{$idStan}';"); if ($result) { /*var_dump("zaktualizacjowano " . $idStan);*/ } else { debug_to_console("jakis problem"); } $dbconn->close(); } } } header('Location: towaryArkusz.php');
function selectOneDocument($data) { global $conn; $list = array(); $tab_ligne = array(); $id = 'id_doc'; $name = 'nom'; $lat = 'lat'; $lng = 'lng'; $url = 'url'; $sql = "SELECT id_doc, nom, X(latlng) lat, Y(latlng) lng , url FROM documents WHERE id=" . $data["id"]; $result = $conn->query($sql); if ($result->num_rows > 0) { $nbLigne = 0; while ($row = $result->fetch_row()) { $list[] = $row; } echo json_encode($list); } else { debug_to_console('No Result. Select Document. SQL : ' . $sql); } }
<div class="hellk-mobile" > <a href = "http://www.twitch.tv/hellkevilk?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Stream Hellkevilk </a ><br /> <a href = "http://www.twitch.tv/hllava?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Stream TM </a > <a href = " http://www.twitch.tv/thecylo?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Strem Cylo </a > </div > <div class="tmWrapper" > <div class="tm" > <iframe src = "http://www.twitch.tv/hellkevilk/embed" frameborder = "0" scrolling = "no" height = "264" width = "434" ></iframe > <a href = "http://www.twitch.tv/hellkevilk?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Watch live video from hellkevilk on www . twitch . tv </a > </div > <div class="tm" style = "margin-left: 1em;float: right;" > <iframe src = "http://www.twitch.tv/hllava/embed" frameborder = "0" scrolling = "no" height = "264" width = "434" ></iframe > <a href = "http://www.twitch.tv/hllava?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Watch live video from hllava on www . twitch . tv </a > </div > <div class="tm" > <iframe src = " http://www.twitch.tv/thecylo/embed" frameborder = "0" scrolling = "no" height = "264" width = "434" ></iframe > <a href = " http://www.twitch.tv/thecylo?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Watch live video from thecylo on www . twitch . tv </a > </div >'; $time_elapsed_secs = microtime(true) - $start; debug_to_console("twitch " . $time_elapsed_secs);