Home
Name Modified Size InfoDownloads / Week
readme.txt 2015-12-21 3.5 kB
handyqmysqli04.zip 2015-12-21 127.2 MB
handyqnew.sql 2015-09-30 490.8 kB
Totals: 3 Items   127.7 MB 0
Download handyqv0X.zip. I will update the archive so far as i fix things.


1. Upload the zip archive to your local-remote server. Preferably the root.

2. Create a DB in Myadmin (or execute the sql).

3. Create a user and give him all the prvilleges.

4. Open includes/mysqli.php, and change the connection datas (database name, user y passw).

5. Give 777 to the uploads folder.

6. Go to http://wherever-you-put-the-folder-handyqmysqli/index.php

Take prevention of other permissions that may appear as a failure. Look the error-log in this case (cpanel). It´s almost sure due to correct chmods...

7. That´s it!

Mail me back (javier@textblock.org) if you have some problem. I´ll try to help.




RECENT FIXES:

2015/12/15 - There was some issues with sql´s into a pair of archives (revsistema_print; revsistema2;...). I had´nt notice it , due to the few times i had used them...

Continue with the use of css bootstrap.

Add some other modules, with the intention of increse the number of graphs.

Sorry for the lack of the explanations, but i have´nt any time.

2015/10/07 - Some days ago, i found a pair of historical errors in "name" tags. I did´nt use it usually an i did´nt take care. Sorry if i dont remember what archives was.

2015/09/30 - Deleted many (&#65279) - the Unicode Character 'ZERO WIDTH NO-BREAK SPACE' (U+FEFF), with this stackoverflow script:

(copy-paste, and call it whateveryouwant. Run it in the root)

<?php 
// Tell me the root folder path.
// You can also try this one
// $HOME = $_SERVER["DOCUMENT_ROOT"];
// Or this
// dirname(__FILE__)
$HOME = dirname(__FILE__);

// Is this a Windows host ? If it is, change this line to $WIN = 1;
$WIN = 0;

// That's all I need
?>
<!DOCTYPE html">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>UTF8 BOM FINDER and REMOVER</title>
<style>
body { font-size: 10px; font-family: Arial, Helvetica, sans-serif; background: #FFF; color: #000; }
.FOUND { color: #F30; font-size: 14px; font-weight: bold; }
</style>
</head>
<body>
<?php
$BOMBED = array();
RecursiveFolder($HOME);
echo '<h2>These files had UTF8 BOM, but i cleaned them:</h2><p class="FOUND">';
foreach ($BOMBED as $utf) { echo $utf ."<br />\n"; }
echo '</p>';

// Recursive finder
function RecursiveFolder($sHOME) {
  global $BOMBED, $WIN;

  $win32 = ($WIN == 1) ? "\\" : "/";

  $folder = dir($sHOME);

  $foundfolders = array();
  while ($file = $folder->read()) {
    if($file != "." and $file != "..") {
      if(filetype($sHOME . $win32 . $file) == "dir"){
        $foundfolders[count($foundfolders)] = $sHOME . $win32 . $file;
      } else {
        $content = file_get_contents($sHOME . $win32 . $file);
        $BOM = SearchBOM($content);
        if ($BOM) {
          $BOMBED[count($BOMBED)] = $sHOME . $win32 . $file;

          // Remove first three chars from the file
          $content = substr($content,3);
          // Write to file 
          file_put_contents($sHOME . $win32 . $file, $content);
        }
      }
    }
  }
  $folder->close();

  if(count($foundfolders) > 0) {
    foreach ($foundfolders as $folder) {
      RecursiveFolder($folder, $win32);
    }
  }
}

// Searching for BOM in files
function SearchBOM($string) { 
    if(substr($string,0,3) == pack("CCC",0xef,0xbb,0xbf)) return true;
    return false; 
}
?>
</body>
</html>
Source: readme.txt, updated 2015-12-21