Export option gives strange errors in 4.3.2deb0.1 version for Ubuntu

See also questions close to this topic

• update query work in phpmyadmin but not with mysql_query function

  I have one update query like this:

  UPDATE tbl_xyz SET abc='test' WHERE test='axy'
  

  This one works when I run in phpmyadmin but on server I have use it with mysql_query but it can not work not give any mysql error nor update my data..!! Very strange.!!
• Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000] in using coalesce

  I am trying to create a function in php that will give me the same result as what i get in running this in my phpmyadmin.

  PHPmyadmin Query:

  SELECT BRGY_ID, F_NAME, L_NAME, M_INIT, STATUS FROM TBL_BRGY WHERE 
  (LOWER(BRGY_ID) LIKE '%%' OR COALESCE('', '') IS NULL) 
  AND (LOWER(F_NAME) LIKE '%%' OR COALESCE('', '') IS NULL)
  AND (LOWER(L_NAME) LIKE '%%' OR COALESCE('', '') IS NULL);
  

  PHP Function:

  public static function getList($data){
      $sqlStmt = '
      SELECT BRGY_ID, L_NAME, F_NAME, M_INIT, STATUS FROM TBL_BRGY WHERE (`LOWER`(BRGY_ID) LIKE ? OR `COALESCE`(?, "") `IS` NULL) AND (`LOWER`(F_NAME) LIKE ? OR `COALESCE`(?, "") `IS` NULL) AND (`LOWER`(L_NAME) LIKE ? OR `COALESCE`(?, "") `IS` NULL)';
  
      $arrayValues = array(
          '%'.$data['barangayid'].'%',
          '%'.$data['barangayid'].'%',
          '%'.$data['firstname'].'%',
          '%'.$data['firstname'].'%',
          '%'.$data['lastname'].'%',
          '%'.$data['lastname'].'%'
      );
  
      return Database::query($sqlStmt, $arrayValues); 
  
  }
  

  Database::query:

  public static function query($query, $params = array())
  {
      $result = self::$connection->prepare($query);
      $result->execute($params);
      return $result->rowCount();
  }
  

  **ERROR: **

  Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%?% OR COALESCE(?, "") IS NULL) AND (LOWER(F_NAME) LIKE %?% OR COALESCE(?,' at line 1' in /home3/z8zyzdzs/appointment.barangay183villamorpasay.com.ph/models/Database.model.php:116 Stack trace: #0 /home3/z8zyzdzs/appointment.barangay183villamorpasay.com.ph/models/Database.model.php(116): PDO->prepare('\n\t\tSELECT BRGY_...') #1 /home3/z8zyzdzs/appointment.barangay183villamorpasay.com.ph/models/RegistrationModel.model.php(333): Database::query('\n\t\tSELECT BRGY_...', Array) #2 /home3/z8zyzdzs/appointment.barangay183villamorpasay.com.ph/controllers/BarangayMaintenanceController.class.php(100): RegistrationModel::retrieveBarangayResidents(Array) #3 /home3/z8zyzdzs/appointment.barangay183villamorpasay.com.ph/controllers/RouterController.class.php(72): BarangayMaintenanceCo in /home3/z8zyzdzs/appointment.barangay183villamorpasay.com.ph/models/Database.model.php on line 116

  Help please. Thanks
• PHP - How to upload image in a multidimensional array loop

  I am not able to upload image, I tried using the below code to display. But nothing gets displayed.

  PHP Code is as

  $question_image = $allquestion["'ques_image'"];<br>
  $imagetemp = $_FILES[$question_image]['name'];<br>
  echo "IMAGE NAME".$imagetemp;
  

  And Returned Array

  Array
  (
  [1] => Array
      (
          ['ques_title'] => Question 1
          ['ques_image'] => galaxy_s7_black.png
          ['choice'] => Array
              (
                  [0] => Array
                      (
                          [0] => Question 1 - First Choice
                          [1] => 127
                      )
  
                  [1] => Array
                      (
                          [0] => Question 1 - second Choice
                          [1] => 128
                      )
              )
      )
  
  [2] => Array
      (
          ['ques_title'] => Question 2
          ['ques_image'] => iphone7_rosegold.png
          ['choice'] => Array
              (
                  [0] => Array
                      (
                          [0] => Question 2 - First Choice
                          [1] => 131
                      )
  
                  [1] => Array
                      (
                          [0] => Question 2 - second Choice
                          [1] => 132
                      )
              )
      )
  )
  

  How to upload image in a multidimensional array loop.
• How to export Chrome localStorage data for a given website URL without visiting it

  I used to have a development website : http://foo.dev

  Due to recent updates on how Chrome behaves with *.dev urls (redirecting them to https (https://ma.ttias.be/chrome-force-dev-domains-https-via-preloaded-hsts/), I cannot access any longer my local website.

  I have changed it's url to : http://foo.local

  My problem is that I would like to export the localStorage data stored from site_1 (http://foo.dev) and import it into site_2 (http://foo.local).

  I know I can export the localStorage data with devTools while visiting site_1, but I cannot do that due to the redirection...

  Is there a way to export the localStorage data for a website without visiting it ?
• Prometheus sum get no data , can i set to default value?

  i am trying to sum network traffic in/out from different IDC, also using snmp_export to get those information, but sometimes the snmp export can't get some switch's infomations ,maybe timeout or lost. so there is no date update for this switch and "/metric" will only show parts traffic info. The problem is when i using

  sum(irate(ifInOctets{ifIndex=...,instance=...})) + 
  sum(irate(ifInOctets{ifIndex=...,instance=...}))+ 
  sum(irate(ifInOctets{ifIndex=...,instance=...}))
  

  to get all traffic total value , the expr will return no data and break the graph.

  I am newbie to prometheus. not sure if the using method is wrong .

  Thanks
• How to export a table to Excel with UTF-8 format in order to include accent marks in the words?

  This scripts helps to export SQL tables to Excel, however it doesn't export words with accent marks properly.

  What I want is to fix this code in order to be able to export words with accent marks, for example México.

  I'm don't know how to fix this code to export the text of the tables in UTF-8 format.

  /*      =================================
  **      ====  Export to Excel - Js   ====
  **      ================================= 
  */
  
  var xport = {
    _fallbacktoCSV: true,  
    toXLS: function(tableId, filename) {   
  this._filename = (typeof filename == 'undefined') ? tableId : filename;
  
  //var ieVersion = this._getMsieVersion();
  //Fallback to CSV for IE & Edge
  if ((this._getMsieVersion() || this._isFirefox()) && this._fallbacktoCSV) {
    return this.toCSV(tableId);
  } else if (this._getMsieVersion() || this._isFirefox()) {
    alert("Not supported browser");
  }
  
  //Other Browser can download xls
  var htmltable = document.getElementById(tableId);
  var html = htmltable.outerHTML;
  
  this._downloadAnchor("data:application/vnd.ms-excel" + encodeURIComponent(html), 'xls'); 
    },
    toCSV: function(tableId, filename) {
  this._filename = (typeof filename === 'undefined') ? tableId : filename;
  // Generate our CSV string from out HTML Table
  var csv = this._tableToCSV(document.getElementById(tableId));
  
  // Create a CSV Blob
  var blob = new Blob([csv], { type: "text/csv" });
  
  
  // Determine which approach to take for the download
  if (navigator.msSaveOrOpenBlob) {
    // Works for Internet Explorer and Microsoft Edge
    navigator.msSaveOrOpenBlob(blob, this._filename + ".csv");
  } else {      
    this._downloadAnchor(URL.createObjectURL(blob), 'csv');      
  }
    },
    _getMsieVersion: function() {
  var ua = window.navigator.userAgent;
  
  var msie = ua.indexOf("MSIE ");
  if (msie > 0) {
    // IE 10 or older => return version number
    return parseInt(ua.substring(msie + 5, ua.indexOf(".", msie)), 10);
  }
  
  var trident = ua.indexOf("Trident/");
  if (trident > 0) {
    // IE 11 => return version number
    var rv = ua.indexOf("rv:");
    return parseInt(ua.substring(rv + 3, ua.indexOf(".", rv)), 10);
  }
  
  var edge = ua.indexOf("Edge/");
  if (edge > 0) {
    // Edge (IE 12+) => return version number
    return parseInt(ua.substring(edge + 5, ua.indexOf(".", edge)), 10);
  }
  
  // other browser
  return false;
    },
    _isFirefox: function(){
  if (navigator.userAgent.indexOf("Firefox") > 0) {
    return 1;
  }
  
  return 0;
    },
    _downloadAnchor: function(content, ext) {
    var anchor = document.createElement("a");
    anchor.style = "display:none !important";
    anchor.id = "downloadanchor";
    document.body.appendChild(anchor);
  
    // If the [download] attribute is supported, try to use it
    
    if ("download" in anchor) {
      anchor.download = this._filename + "." + ext;
    }
    anchor.href = content;
    anchor.click();
    anchor.remove();
    },
    _tableToCSV: function(table) {
  // We'll be co-opting `slice` to create arrays
  var slice = Array.prototype.slice;
  
  return slice
    .call(table.rows)
    .map(function(row) {
      return slice
        .call(row.cells)
        .map(function(cell) {
          return '"t"'.replace("t", cell.textContent);
        })
        .join(",");
    })
    .join("\r\n");
    }
  };