PHP Classes

File: src/Mind.php

Recommend this page to a friend!
  Classes of Ali YILMAZ   Mind Framework   src/Mind.php   Download  
File: src/Mind.php
Role: Class source
Content type: text/plain
Description: Class source
Class: Mind Framework
Framework that implements several design patterns
Author: By
Last change: 5.2.0
5.1.9
5.1.8
5.1.7
5.1.6
5.1.6
5.1.5
5.1.4
5.1.3
5.1.2
5.1.1
5.1.1
5.1.1
5.1.0
5.1.0
5.0.9
5.0.8
5.0.7
5.0.6
5.0.5
5.0.4
5.0.3
5.0.2
5.0.1
5.0.0
5.0.0
4.9.9
It adopts the same regex as mind.js. (4.9.8)
The is_timecode has been updated. (4.9.8)
Version 4.9.8 has been released.
Upgraded to Mind 4.9.7
Upgraded to Mind 4.9.6
Upgraded to Mind 4.9.5
Upgraded to Mind 4.9.5
Upgraded to Mind 4.9.4
Upgraded to Mind 4.9.3
Upgraded to Mind 4.9.2
Upgraded to Mind 4.9.1
Upgraded to Mind 4.9.0.
Upgraded to Mind 4.8.9
Upgraded to Mind 4.8.8
Upgraded to Mind 4.8.7
Fixed variable typo in "compressImage" method. (#11)

Thank you ismet.
Upgraded to Mind 4.8.6.
Upgraded to Mind 4.8.5
Error exceptions updated.
Database creation is enabled for mysql.
The sqlite database should not be in the home directory.
Upgraded to Mind 4.8.4
Upgraded to Mind 4.8.3;
Upgraded to Mind 4.8.2.
Upgraded to Mind 4.8.1.
Upgraded to Mind 4.8.0.
Upgraded to Mind 4.8.0.
Upgraded to Mind 4.8.0.
Upgraded to Mind 4.8.0.
Mind was upgraded to version 4.7.9
Mind was upgraded to version 4.7.8
Mind was upgraded to version 4.7.7
Mind was upgraded to version 4.7.6
Mind was upgraded to version 4.7.5
Mind was upgraded to version 4.7.4
Mind was upgraded to version 4.7.4
Mind 4.7.3 sürümüne yükseltildi.
Upgraded to Mind 4.7.3
Upgraded to Mind 4.7.3
Upgraded to Mind 4.7.2
Upgraded to Mind 4.7.1
Upgraded to Mind 4.7.0
Upgraded to Mind 4.6.9.
Mind was upgraded to version 4.6.8
Mind was upgraded to version 4.6.7
Mind was upgraded to version 4.6.7
stringToBinary() renamed.
Mind was upgraded to version 4.6.6
Mind was upgraded to version 4.6.5
is_morse() method updated.
is_morse and morse_decode updated.
Mind was upgraded to version 4.6.4
Mind was upgraded to version 4.6.4
Mind was upgraded to version 4.6.3
Mind was upgraded to version 4.6.2
Mind was upgraded to version 4.6.1
Mind was upgraded to version 4.6.0
mindLoad updated. (#10)

Co-authored-by: Hakan Kurt <info@hakankurt.com>
Mind was upgraded to version 4.5.9
get_contents() updated. (hepsiburada.com)
Mind was upgraded to version 4.5.8.
Mind was upgraded to version 4.5.7.
Mind was upgraded to version 4.5.6.
Mind was upgraded to version 4.5.5.
Mind was upgraded to version 4.5.4.
Mind was upgraded to version 4.5.3.
Mind was upgraded to version 4.5.2.
Mind was upgraded to version 4.5.1.
Mind was upgraded to version 4.5.1.
Mind was upgraded to version 4.5.0.
Mind was upgraded to version 4.5.0.
Mind was upgraded to version 4.5.0.
Mind was upgraded to version 4.5.0
The CSRF rule was removed for rewriting.
Mind was upgraded to version 4.4.9.
Mind was upgraded to version 4.4.8.
Mind was upgraded to version 4.4.8.
Mind was upgraded to version 4.4.7.
Mind was upgraded to version 4.4.6.
Mind was upgraded to version 4.4.5.
Mind was upgraded to version 4.4.4.
Mind was upgraded to version 4.4.3.
arraySort() updated. (#8)
Mind was upgraded to version 4.4.2.
Mind was upgraded to version 4.4.1.
Mind was upgraded to version 4.4.1.
Mind was upgraded to version 4.4.0.
Mind was upgraded to version 4.3.9.
Mind was upgraded to version 4.3.8.
Mind was upgraded to version 4.3.7.
Mind was upgraded to version 4.3.7.
Mind has been upgraded to version 4.3.6.
The encodeSize, decodeSize description has been updated.
Mind has been upgraded to version 4.3.5.
Mind has been upgraded to version 4.3.5.
Mind has been upgraded to version 4.3.4
Mind has been upgraded to version 4.3.3.
Mind has been upgraded to version 4.3.2.
The restore() method has been updated.
Mind has been upgraded to version 4.3.1.
The defined database is created then selected.
Mind has been upgraded to version 4.3.0.
Mind has been upgraded to version 4.3.0.
Mind has been upgraded to version 4.2.9.
Mind has been upgraded to version 4.2.9.
Mind has been upgraded to version 4.2.8.
Mind has been upgraded to version 4.2.8.
Mind has been upgraded to version 4.2.7.
Mind has been upgraded to version 4.2.6.
Mind has been upgraded to version 4.2.6.
Mind has been upgraded to version 4.2.5.
Mind has been upgraded to version 4.2.4.
Mind has been upgraded to version 4.2.4.
Mind has been upgraded to version 4.2.3.
Mind has been upgraded to version 4.2.2.
Mind has been upgraded to version 4.2.2.
The validate method has been stabilized.
Mind has been upgraded to version 4.2.1.
Mind has been upgraded to version 4.2.0.
The problem of detecting the route as a parameter has been resolved.
Mind has been upgraded to version 4.2.0.
Mind has been upgraded to version 4.1.9.
Request support was provided to Microsoft IIS servers.
Mind has been upgraded to version 4.1.8.
Update for developers using Windows.
$this->allow_folders variable added.
Added ability to specify public directories.
Directory access regulations have been updated.
Mind has been upgraded to version 4.1.6.
accessGenerate() method added.
Mind has been upgraded to version 4.1.5.
getSoftware method added.
Mind has been upgraded to version 4.1.4.
getOS method added.
Mind has been upgraded to version 4.1.3.
Mind has been upgraded to version 4.1.2.
Mind has been upgraded to version 4.1.1.
The readability of json data has also been improved.
Mind has been upgraded to version 4.1.0.
Mind has been upgraded to version 4.0.9.
Mind has been upgraded to version 4.0.8.
Adjustments are made if the database exists.
Mind has been upgraded to version 4.0.7
The get_contents method has been strengthened.
Mind has been upgraded to version 4.0.6.
coordinatesMaker method added.
Download method has been updated.
Token generator added.
Unnecessary query has been removed.
It has been upgraded to version 4.0.3.
Sorting feature has been added to pagination.
Column definition has been added to pagination.
Pagination has been updated.
Paging method was added.
Multi search rules fixed.
GetData's search rule has been updated.
getData search/column fixed.
Mind 4.0.0 version.
The table interpreter was named.
Backup and Restore method updated.
If automatic increase
newId bug fixed and restore method added.
Backup method added
Redirect Fixed.
Release: 3.2.2
Sensitivity option has been added.
Release: 3.2.1 updated.
Getdata method was developed.
Release: 3.1.8
amelia comments have been updated.
amelia and theodore methods added.
redirect method updated. is_md5 method added.
samantha updated.
Mind upgraded.
Mind upgraded.
Mind new version.
Access method has been added.
bool validation updated.
Absolute requirement added.
Wide usage and Absolute accuracy feature added.
lower case was used.
The requirement for the database has been removed.
Charset name updated.
Important character set update.
Verification method has been updated.
Verification method has been updated.
Validate method updated.
unchanged rule removed.
unchanged rule added.
Invalid measurement response updated.
The response of unacceptable measurement units has been updated.
N > n updated.
Mind version 3.1.5 has been released.
The filter method has been removed.
Distance range control has been added.
Comment of the DistanceMeter method has been updated.
The sequence of the distanceMeter method has been adjusted.
The is_coordinate method description has been added.
Latitude and Longitude control method comment updated.
Latitude and Longitude control methods have been completely added.
The verification method has been updated in general.
Coordinate rule comment updated
Coordinate rule was added.
Distance meter method and coordinate verification method were added.
The specified age was also included.
Blood group and blood compatibility rule were created.
ipv4 and ipv6 verification method and rule were added.
iban verification method and rule were added.
A special update was made to the comment lines.
Version 3.1.4 has been added to the comments.
is_url updated.
bool added.
Comment line update.
min-age, max-age, max-num, min-num, unique.
date, max-age, min-age.
is_age method and age rule added.
The max and min rules have been updated.
min and max rules have been added.
Null rule has been removed.
Validate method created.
Capital and lowercase support was provided.
get_contents / ssl_verify * host - peer updated.
Mind has been upgraded to 3.1.2
Mind has been upgraded to 3.1.2
Mind has been upgraded to 3.1.1.
The is_url and upload methods have been updated.
Update Mind.php

Updated windows support of get_absolute_path method.
$page_previous, $page_back olarak güncellendi, sürüm numarası belirtildi.
is_url metodu güncellendi, önceki sayfa ve şimdiki sayfa değişkenleri eklendi.
Redirect, Samantha ve Info metodları güncellendi.
Benzersiz bağlantılar oluşturmak için permalink metoduna unique özelliği eklendi.
Samantha ve Filter metodları güncellendi.
Samantha ve Filter metodları güncellendi.
Versiyon 3.0.7 sürümüne yükseltildi.
-columnCreate ve tableCreate metodları tarafından oluşturulan tablo sütunları, phpmyadmin tarafında yedek alırken görünmüyordu, sütun oluşturma işleminde ki yanlış söz diziminden kaynaklandığı anlaşılıp düzeltildi.
-increments sütunu basamaksal olarak sadece 11 değerini alabiliyorken artık basamaksal değeri belirtilebiliyor.
-Filter metodunda gereksiz bir filtrasyon kaldırıldı, bu filtrasyon mysqli escape metodunun fonksiyon haliydi, gerek olmadığına kanaat getirildiği için kaldırıldı.
Kritik route hatası giderildi.
Mind sürümü güncellenerek, dökümanlara yansıtılmaya başlandı.
Metodlar eklendi, get_contents güncellendi. Mind 3.0.4'e yükseltildi.
Çoklu anahtarların foreign key sütunlarında sorgulanması sağlandı.
http(s)://localhost adres olarak tanımlandı.
Foreign key özelliği eklendi.
Birden çok veritabanı oluşturmadaki hata giderildi.
set_time_limit fonksiyonu engellenmişse çalıştırılmaz.
http(s)://localhost adres olarak tanımlandı.
3.0.2 sürümüne yükseltildi
Proje yolu, yerel ve web sunucular için stabil hale getirildi.
Yerel yolları adres olarak algılama sorunu giderildi.
Permalink / transliterate güncellendi.
İsimlendirilmiş parametre varlığının kontrolü güncellendi.
download metodu kök dizin sorunu çözüldü.
remoteFileSize ve download metodları güncellendi.
Mind 3.0.1 güncellemesi.
Mantık hatası oluşmaması için koşul iptal edildi.
1 kayıt varsa onun dizisinin geri döndürülmesi sağlandı.
Metod sıralaması güncellendi.
Listesinde ki sıraya göre güncellendi.
fileWorm için ayrı bir repository oluşturuldu.
fileWorm metodu oluşturuldu, write metoduna ayraç belirtilebilir oldu.
getData - search / and & or güncellendi.
route metodunda dönüş yanıtı güncellendi.
Samantha metodu eklendi.
Mind 3.0.0 sürümü.
Mind 3.0.0 sürümü.
Mind 3.0.0 sürümü yayınlandı.
Hata gösterimleri açıldı ve permalink metodu güncellendi.
Version 2.3.7
Tekrar eden fonksiyon yerine copy kullanıldı.
Metod adı güncellendi, $data değişkeni silindi.
'download' kök dizininden farklı belirtilen yolun korunması sağlandı.
rfilesize metodu oluşturuldu, download metodunun dosya bütünlüğü sorunu giderildi.
Klasör hiyerarşisi ve isimlendirmesi stabil kılındı.
Download metodu oluÅŸturuldu.
redirect metodu yenilendi.
2.3.6 sürümüne yükseltildi.
redirect metodu güncellendi.
2.3.5 sürümüne yükseltildi.
Artık composer kullanımını önermeyeceğim.
Slash problem solved.
The problem of not accepting zero as a parameter is solved.
*2.3.4
The problem of not accepting zero as a parameter is solved.
Error page fixed.
Error page completed.
Error page updated.
Error page updated.
Error page updated.

echo trim($request, '/'); removed.
Error page updated.
Error page added.
Error page added.
Revert "Error page added."

This reverts commit 519aad2da031654044fe3f29b0a70b059d049d04.
Error page added.
The column is capacity updated.
The column is capacity updated.
Upgraded to version 2.3.2.
Update Mind.php

+Path syntax correction for Windows.(upload)
+False response removed. (upload)
Update Mind.php

+Type extension names in lowercase. (info)
+Path syntax correction for Windows.(upload)
+False response removed. (upload)
do_have updated - Multiple equality can now be queried.
Version 2.3.1
PHP 5.3 version support updated.
The is_json function was created.
Updated location.
Multiple record insertion feature update.
Multiple record insertion feature added.
Little change.
The Permalink function has been updated
Version 2.3
The use of the route in different locations was liberated.
Version 2.2
Syntax updated.
Access to methods has been added.

app/controller/HomeController:index@create
Added 'pGenerator' function.
Version 2.1
The status check is based on the answer in the Sql query. In this way, there is no need to question the existence of tables or columns.
'get' updated.
Version 2.0
The document for new column types has been updated.
$this->error variable removed.
new column types.

decimal, int, varchar added.
'is_decimal' removed.
Added 'is_decimal' function.
Updated "get" error scenario.

'start' and 'end' parameters of 'limit' feature have been added.
New feature added to 'get' method.

Multiple equation of equality was added.
echo $sql removed.
The "get" test was created.
The "get" test was created.

and (" ") ''.
Updated "insert and update" error scenario.

("column" => "value")
Updated "delete" error scenario.
Updated "update" error scenario.
Updated "update" error scenario.
Updated "insert" error scenario.
Added "cleardb,cleartable and clearcolumn" to error scenarios.
The "deletetable" test was created.
url comment edited.
Error comment added.
General updated and Error scenarios created.
The "clearcolumn" test was created.
The "deletedb" test was updated.
The "clearetable" test was created.
The "clearedb" test was created.
insert updated.
auto_increment rule updated.
auto_increment rule updated.

Comment removed.
auto_increment rule updated.
auto_increment rule updated.
auto_increment rule updated.

If a column with an auto_increment is available.
auto_increment rule added.

If a column with an auto_increment is available.
Added column creation rule.
Added column creation rule.

Error: You can use the (:) symbol once.
General update.
General update

$arr = array(
'id:increments',
'name',
'phone',
'email',
'created_at',
'updated_at+'
);
General update.
General update.
connection updated.
New tests writed. Mind updated.
Updated as version 1.4.
TDD fixed.
Version 2.0 released.
Composer file updated.
Version 2.0 released.

Comment syntax updated.
Version 2.0 released.

Version 2.0 released. The document has been updated.
The filter() function can now also filter without a database connection.
Update Mind.php
Composer added.
Turkish document added.
New functions added.
Errors are solved.
fileupload() updated.

The process starts if the file name exists. The process microsecond was added to create the unique name of the uploaded file.
fileupload() updated.

The process starts if the file name exists and The process microsecond was added to create the unique name of the uploaded file.
fileupload() updated.

If the file variable is empty, an empty array is returned in response.
fileupload() added.

A function used to load file or files added.
Date: 2 years ago
Size: 189,356 bytes
 

Contents

Class file image Download
<?php /** * * @package Mind * @version Release: 5.2.0 * @license GPL3 * @author Ali YILMAZ <aliyilmaz.work@gmail.com> * @category Php Framework, Design pattern builder for PHP. * @link https://github.com/aliyilmaz/Mind * */ /** * Class Mind */ class Mind extends PDO { private $sess_set = [ 'path' => './session/', 'path_status' => false, 'status_session' => true ]; public $post = []; public $base_url; public $page_current = ''; public $page_back = ''; public $timezone = 'Europe/Istanbul'; public $timestamp; public $lang = [ 'table' => 'translations', 'column' => 'lang', 'haystack' => 'name', 'return' => 'text', 'lang' => 'EN' ]; public $error_status = false; public $errors = []; private $db = [ 'drive' => 'mysql', // mysql, sqlite 'host' => 'localhost', 'dbname' => 'mydb', // mydb, app/migration/mydb.sqlite 'username' => 'root', 'password' => '', 'charset' => 'utf8mb4' ]; /** * Mind constructor. * @param array $conf */ public function __construct($conf = array()){ ob_start(); /* error settings */ error_reporting(-1); error_reporting(E_ALL); ini_set('display_errors', 1); /* server limit settings */ ini_set('memory_limit', '-1'); (strpos(ini_get('disable_functions'), 'set_time_limit') === false) ?: set_time_limit(0); /* Creating the timestamp */ date_default_timezone_set($this->timezone); $this->timestamp = date("Y-m-d H:i:s"); /* Database connection */ $this->dbConnect($conf); /* Interpreting Get, Post, and Files requests */ $this->request(); /* Enabling session management */ $this->session_check(); /* Activating the firewall */ $this->firewall($conf); /* Providing translation settings */ if(isset($conf['translate'])){ $this->lang['table'] = (isset($conf['translate']['table'])) ?: $conf['translate']['table']; $this->lang['column'] = (isset($conf['translate']['column'])) ?: $conf['translate']['column']; $this->lang['haystack'] = (isset($conf['translate']['haystack'])) ?: $conf['translate']['haystack']; $this->lang['return'] = (isset($conf['translate']['return'])) ?: $conf['translate']['return']; $this->lang['lang'] = (isset($conf['translate']['lang'])) ?: $conf['translate']['lang']; } /* Determining the home directory path (Mind.php) */ $baseDir = $this->get_absolute_path(dirname($_SERVER['SCRIPT_NAME'])); $this->base_url = (empty($baseDir)) ? '/' : '/'.$baseDir.'/'; /* Determining the previous page address */ $this->page_back = (isset($_SERVER['HTTP_REFERER'])) ? $_SERVER['HTTP_REFERER'] : $this->page_current; } public function __destruct() { if($this->error_status){ $this->abort('404', 'Not Found.'); } } /** * @param array|null $conf */ public function dbConnect($conf = array()){ if(isset($conf['db']['drive'])){ $this->db['drive'] = $conf['db']['drive'];} if(isset($conf['db']['host'])){ $this->db['host'] = $conf['db']['host'];} if(isset($conf['db']['dbname'])){ $this->db['dbname'] = $conf['db']['dbname'];} if(isset($conf['db']['username'])){ $this->db['username'] = $conf['db']['username'];} if(isset($conf['db']['password'])){ $this->db['password'] = $conf['db']['password'];} if(isset($conf['db']['charset'])){ $this->db['charset'] = $conf['db']['charset'];} try { switch ($this->db['drive']) { case 'mysql': parent::__construct($this->db['drive'].':host='.$this->db['host'].';charset='.$this->db['charset'].';', $this->db['username'], $this->db['password']); break; case 'sqlsrv': parent::__construct($this->db['drive'].':Server='.$this->db['host'].';', $this->db['username'], $this->db['password']); break; case 'sqlite': parent::__construct($this->db['drive'].':'.$this->db['dbname']); break; default: $this->abort('503', 'Invalid database driver.'); } if(!$this->is_db($this->db['dbname'])){ $this->dbCreate($this->db['dbname']); } $this->selectDB($this->db['dbname']); } catch ( PDOException $e ){ if(stristr($e->errorInfo[2], 'php_network_getaddresses: getaddrinfo')){ $this->abort('502', 'Invalid database connection address.'); } if(stristr($e->errorInfo[2], 'Access denied for user')){ $this->abort('401', 'Unauthorized user information.'); } $this->print_pre($e->getMessage()); } return $this; } /** * Database selector. * * @param string $dbName * @return bool */ public function selectDB($dbName){ if($this->is_db($dbName)){ switch ($this->db['drive']) { case 'mysql' OR 'sqlsrv': $this->exec("USE ".$dbName); break; } } else { return false; } $this->setAttribute( PDO::ATTR_EMULATE_PREPARES, true ); $this->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT ); $this->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING ); $this->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); return true; } /** * Lists the databases. * * @return array */ public function dbList(){ $dbnames = array(); switch ($this->db['drive']) { case 'mysql': $sql = 'SHOW DATABASES'; try{ $query = $this->query($sql, PDO::FETCH_ASSOC); foreach ( $query as $database ) { $dbnames[] = implode('', $database); } return $dbnames; } catch (Exception $e){ return $dbnames; } break; case 'sqlsrv': $sql = 'SELECT name FROM sys.databases'; $statement = $this->query($sql); $dbnames = $statement->fetchAll(PDO::FETCH_COLUMN); return $dbnames; case 'sqlite': return $this->ffsearch('./', '*.sqlite'); break; } } /** * Lists database tables. * * @param string $dbName * @return array */ public function tableList($dbname=null){ $query = []; $tblNames = array(); try{ switch ($this->db['drive']) { case 'mysql': $dbParameter = (!is_null($dbname)) ? ' FROM '.$dbname : ''; $sql = 'SHOW TABLES'.$dbParameter; $query = $this->query($sql, PDO::FETCH_ASSOC); foreach ($query as $tblName){ $tblNames[] = implode('', $tblName); } break; case 'sqlsrv': $this->selectDB($dbname); $sql = 'SELECT name, type FROM sys.tables'; $query = $this->query($sql); $tblNames = $query->fetchAll(PDO::FETCH_COLUMN); break; case 'sqlite': $statement = $this->query("SELECT name FROM sqlite_master WHERE type='table';"); $query = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($query as $tblName){ $tblNames[] = $tblName['name']; } break; } } catch (Exception $e){ return $tblNames; } return $tblNames; } /** * Lists table columns. * * @param string $tblName * @return array */ public function columnList($tblName){ $columns = array(); switch ($this->db['drive']) { case 'mysql': $sql = 'SHOW COLUMNS FROM `' . $tblName.'`'; try{ $query = $this->query($sql, PDO::FETCH_ASSOC); $columns = array(); foreach ( $query as $column ) { $columns[] = $column['Field']; } } catch (Exception $e){ return $columns; } break; case 'sqlsrv': $sql = 'SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = \'' . $tblName.'\''; $statement = $this->query($sql); $columns = $statement->fetchAll(PDO::FETCH_COLUMN); if(!in_array($tblName, $this->tableList())){ return array(); } break; case 'sqlite': $statement = $this->query('PRAGMA TABLE_INFO(`'. $tblName . '`)'); foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $key => $column) { $columns[] = $column['name']; } break; } return $columns; } /** * Creating a database. * * @param mixed $dbname * @return bool */ public function dbCreate($dbname){ $dbnames = array(); $dbnames = (is_array($dbname)) ? $dbname : [$dbname]; try{ foreach ( $dbnames as $dbname ) { switch ($this->db['drive']) { case 'mysql': $sql = "CREATE DATABASE"; $sql .= " ".$dbname." DEFAULT CHARSET=".$this->db['charset']; if(!$this->query($sql)){ return false; } break; case 'sqlsrv': $sql = "CREATE DATABASE"; $sql .= " ".$dbname; if(!$this->query($sql)){ return false; } case 'sqlite': if(!file_exists($dbname) AND $dbname !== $this->db['dbname']){ $this->dbConnect(['db'=>['dbname'=>$dbname]]); } break; } if($dbname === $this->db['dbname']){ $this->dbConnect(['db'=>['dbname'=>$dbname]]); } } }catch (Exception $e){ return false; } return true; } /** * Creating a table. * * @param string $tblName * @param array $scheme * @return bool */ public function tableCreate($tblName, $scheme){ if(is_array($scheme) AND !$this->is_table($tblName)){ // switch $engine = ''; switch ($this->db['drive']) { case 'mysql': $engine = " ENGINE = INNODB"; break; } try{ $sql = "CREATE TABLE ".$tblName." "; $sql .= "(\n\t"; $sql .= implode(",\n\t", $this->columnSqlMaker($scheme)); $sql .= "\n)".$engine.";"; if(!$this->query($sql)){ return false; } switch ($this->db['drive']) { case 'sqlsrv': $this->query('SET IDENTITY_INSERT '.$tblName.' ON;'); break; } return true; }catch (Exception $e){ return false; } } return false; } /** * Creating a column. * * @param string $tblName * @param array $scheme * @return bool */ public function columnCreate($tblName, $scheme){ if($this->is_table($tblName)){ try{ $sql = "ALTER TABLE\n"; $sql .= "\t ".$tblName."\n"; $sql .= implode(",\n\t", $this->columnSqlMaker($scheme, 'columnCreate')); if(!$this->query($sql)){ return false; } else { return true; } }catch (Exception $e){ return false; } } return false; } /** * Delete database. * * @param mixed $dbname * @return bool */ public function dbDelete($dbname){ $dbnames = array(); if(is_array($dbname)){ foreach ($dbname as $key => $value) { $dbnames[] = $value; } } else { $dbnames[] = $dbname; } foreach ($dbnames as $dbname) { if(!$this->is_db($dbname)){ return false; } switch ($this->db['drive']) { case 'mysql': try{ $sql = "DROP DATABASE"; $sql .= " ".$dbname; $query = $this->query($sql); if(!$query){ return false; } }catch (Exception $e){ return false; } break; case 'sqlsrv': try{ $query = $this->query('ALTER DATABASE '.$dbname.' SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE '.$dbname.';'); if(!$query){ return false; } }catch (Exception $e){ return false; } break; case 'sqlite': if(file_exists($dbname)){ unlink($dbname); } else { return false; } break; } } return true; } /** * Table delete. * * @param mixed $tblName * @return bool */ public function tableDelete($tblName){ $tblNames = array(); if(is_array($tblName)){ foreach ($tblName as $key => $value) { $tblNames[] = $value; } } else { $tblNames[] = $tblName; } try { $this->beginTransaction(); foreach ($tblNames as $table) { $this->query('DROP TABLE '.$table.';'); } $this->commit(); } catch (Exception $e) { $this->rollBack(); return false; } return true; } /** * Column delete. * * @param string $tblName * @param mixed $column * @return bool */ public function columnDelete($tblName, $column = null){ $columnList = $this->columnList($tblName); $columns = array(); $columns = (!is_null($column) AND is_array($column)) ? $column : $columns; // array $columns = (!is_null($column) AND !is_array($column)) ? [$column] : $columns; // string switch ($this->db['drive']) { case 'mysql': $sql = "ALTER TABLE `".$tblName."`"; foreach ($columns as $column) { if(!in_array($column, $columnList)){ return false; } $dropColumns[] = "DROP COLUMN `".$column."`"; } try{ $sql .= " ".implode(', ', $dropColumns); $query = $this->query($sql); if(!$query){ return false; } }catch (Exception $e){ return false; } break; case 'sqlsrv': try{ $this->beginTransaction(); foreach ($columns as $column) { $contraint = $this->query('SELECT name FROM sys.default_constraints WHERE name LIKE \'%'.$tblName.'__'.$this->summary($column,9).'__%\';')->fetchAll(PDO::FETCH_ASSOC); $sql = ''; if(isset($contraint[0]['name'])){ $name = $contraint[0]['name']; $sql .= 'ALTER TABLE '.$tblName.' DROP CONSTRAINT '.$name.';'; } else { $name = $column; } $sql .= 'ALTER TABLE '.$tblName.' DROP COLUMN '.$column.';'; $query = $this->query($sql); if(!$query){ return false; } } $this->commit(); }catch (Exception $e){ $this->rollBack(); return false; } break; case 'sqlite': $output = []; $data = $this->getData($tblName); foreach ($data as $key => $row) { foreach ($columns as $key => $column) { if(in_array($column, array_keys($row)) AND in_array($column, $columnList)){ unset($row[$column]); } } $output['data'][] = $row; } try{ $scheme = $this->tableInterpriter($tblName, $columns); $this->tableDelete($tblName); $this->tableCreate($tblName, $scheme); if(!empty($output['data'])){ $this->insert($tblName, $output['data']); } }catch (Exception $e){ return false; } break; } return true; } /** * Clear database. * * @param mixed $dbName * @return bool * */ public function dbClear($dbName){ $dbNames = array(); if(is_array($dbName)){ foreach ($dbName as $db) { $dbNames[] = $db; } } else { $dbNames[] = $dbName; } foreach ( $dbNames as $dbName ) { $this->dbConnect($dbName); foreach ($this->tableList($dbName) as $tblName){ if(!$this->tableClear($tblName)){ return false; } } } return true; } /** * Clear table. * * @param mixed $tblName * @return bool */ public function tableClear($tblName){ $tblNames = array(); if(is_array($tblName)){ foreach ($tblName as $value) { $tblNames[] = $value; } } else { $tblNames[] = $tblName; } foreach ($tblNames as $tblName) { $sql = ''; switch ($this->db['drive']) { case 'mysql': $sql = 'TRUNCATE `'.$tblName.'`'; break; case 'sqlsrv': $sql = 'TRUNCATE TABLE '.$tblName; break; case 'sqlite': $sql = 'DELETE FROM `'.$tblName.'`'; break; } try{ if($this->query($sql)){ return true; } else { return false; } } catch (Exception $e){ return false; } } return true; } /** * Clear column. * * @param string $tblName * @param mixed $column * @return bool */ public function columnClear($tblName, $column=null){ if(empty($column)){ return false; } $columns = array(); if(is_array($column)){ foreach ($column as $col) { $columns[] = $col; } } else { $columns[] = $column; } $columns = array_intersect($columns, $this->columnList($tblName)); foreach ($columns as $column) { $id = $this->increments($tblName); $data = $this->getData($tblName); foreach ($data as $row) { $values = array( $column => '' ); $this->update($tblName, $values, $row[$id]); } } return true; } /** * Add new record. * * @param string $tblName * @param array $values * @return bool */ public function insert($tblName, $values, $trigger=null){ if(!isset($values[0])){ $values = array($values); } if(!isset($trigger[0]) AND !is_null($trigger)){ $trigger = array($trigger); } try { $this->beginTransaction(); foreach ($values as $rows) { $sql = ''; $columns = []; $values = []; $sql .= 'INSERT INTO '.$tblName.' '; foreach (array_keys($rows) as $col) { $columns[] = $col; $values[] = '?'; } $sql .= '('.implode(', ', $columns).')'; $sql .= ' VALUES ('.implode(', ', $values).')'; $this->prepare($sql)->execute(array_values($rows)); } if(!is_null($trigger)){ foreach ($trigger as $row) { foreach ($row as $table => $data) { $sql = ''; $columns = []; $values = []; $sql .= 'INSERT INTO '.$table.' '; foreach (array_keys($data) as $col) { $columns[] = $col; $values[] = '?'; } $sql .= '('.implode(', ', $columns).')'; $sql .= ' VALUES ('.implode(', ', $values).')'; $this->prepare($sql)->execute(array_values($data)); } } } $this->commit(); return true; } catch (Exception $e) { $this->rollback(); echo $e->getMessage(); } return false; } /** * Record update. * * @param string $tblName * @param array $values * @param string $needle * @param mixed $column * @return bool */ public function update($tblName, $values, $needle, $column=null){ if(empty($column)){ $column = $this->increments($tblName); if(empty($column)){ return false; } } $xColumns = array_keys($values); $columns = $this->columnList($tblName); $prepareArray = array(); foreach ( $xColumns as $col ) { if(!in_array($col, $columns)){ return false; } $prepareArray[] = $col.'=?'; } $values[$column] = $needle; $values = array_values($values); $sql = implode(',', $prepareArray); $sql .= ' WHERE '.$column.'=?'; try{ $this->beginTransaction(); $query = $this->prepare("UPDATE".' '.$tblName.' SET '.$sql); $query->execute($values); $this->commit(); return true; }catch (Exception $e){ $this->rollback(); echo $e->getMessage(); } return false; } /** * Record delete. * * @param string $tblName * @param mixed $needle * @param mixed $column * @return bool */ public function delete($tblName, $needle, $column=null, $trigger=null, $force=null){ $status = false; // status if(is_bool($column)){ $status = $column; $column = $this->increments($tblName); if(empty($column)) return false; } if(empty($column)){ $column = $this->increments($tblName); if(empty($column)) return false; } if(is_bool($trigger) AND is_array($column)){ $status = $trigger; $trigger = $column; $column = $this->increments($tblName); if(empty($column)) return false; } if(is_bool($trigger) AND is_string($column)){ $status = $trigger; } if(is_null($trigger) AND is_array($column)){ $trigger = $column; $column = $this->increments($tblName); if(empty($column)) return false; } if(is_bool($force)){ $status = $force; } if(!is_array($needle)){ $needle = array($needle); } $sql = 'WHERE '.$column.'=?'; try{ $this->beginTransaction(); if(!$status){ foreach ($needle as $value) { if(!$this->do_have($tblName, $value, $column)){ return false; } } } if(is_null($trigger)){ foreach ($needle as $value) { $query = $this->prepare("DELETE FROM".' '.$tblName.' '.$sql); $query->execute(array($value)); } } if(!is_null($trigger)){ foreach ($needle as $value) { $sql = 'WHERE '.$column.'=?'; $query = $this->prepare("DELETE FROM".' '.$tblName.' '.$sql); $query->execute(array($value)); if(is_array($trigger)){ foreach ($trigger as $table => $col) { $sql = 'WHERE '.$col.'=?'; $query = $this->prepare("DELETE FROM".' '.$table.' '.$sql); $query->execute(array($value)); } } } } $this->commit(); return true; }catch (Exception $e){ $this->rollBack(); return false; } } /** * Record reading. * * @param string $tblName * @param array $options * @return array */ public function getData($tblName, $options=null){ $sql = ''; $andSql = ''; $orSql = ''; $keywordSql = ''; $innerColumns = ''; if(!empty($options['join'])){ $joinTypes = ['INNER JOIN', 'LEFT JOIN', 'RIGHT JOIN', 'FULL OUTER JOIN']; if(in_array(mb_strtoupper($options['join']['name']), $joinTypes)){ $options['join']['name'] = mb_strtoupper($options['join']['name']); $inner = []; foreach($options['join']['tables'] as $table => $schema){ $inner[] = $options['join']['name']." ".$table." ON ".$tblName.".".$schema['primary']."=".$table.".".$schema['secondary']; if(empty($schema['fields'])){ $schema['fields'] = $this->columnList($table); } if(!is_array($schema['fields'])){ $schema['fields'] = array($schema['fields']); } $xinnerColumns = []; foreach ($schema['fields'] as $field) { $xinnerColumns[] = $table.'.'.$field; } $innerColumns .= ','.implode(', ', $xinnerColumns); } $sql .= implode("\r\t", $inner).' '; } } $columns = $this->columnList($tblName); if(!empty($options['column'])){ if(!is_array($options['column'])){ $options['column']= array($options['column']); } $options['column'] = array_intersect($options['column'], $columns); $columns = array_values($options['column']); } $sqlColumns = $tblName.'.'.implode(', '.$tblName.'.', $columns).$innerColumns; $prefix = ''; $suffix = ' = ?'; if(!empty($options['search']['scope'])){ $options['search']['scope'] = mb_strtoupper($options['search']['scope']); switch ($options['search']['scope']) { case 'LIKE': $prefix = ''; $suffix = ' LIKE ?'; break; } } $prepareArray = array(); $executeArray = array(); if(isset($options['search']['keyword'])){ if ( !is_array($options['search']['keyword']) ) { $keyword = array($options['search']['keyword']); } else { $keyword = $options['search']['keyword']; } $searchColumns = $columns; if(!empty($options['search']['column'])){ if(!is_array($options['search']['column'])){ $searchColumns = array($options['search']['column']); } else { $searchColumns = $options['search']['column']; } $searchColumns = array_intersect($searchColumns, $columns); } foreach ( $searchColumns as $column ) { foreach ( $keyword as $value ) { $prepareArray[] = $prefix.$column.$suffix; $executeArray[] = $value; } } $keywordSql .= '('.implode(' OR ', $prepareArray).')'; } $delimiterArray = array('and', 'AND', 'or', 'OR'); if(!empty($options['search']['delimiter']['and'])){ if(in_array($options['search']['delimiter']['and'], $delimiterArray)){ $options['search']['delimiter']['and'] = mb_strtoupper($options['search']['delimiter']['and']); } else { $options['search']['delimiter']['and'] = ' AND '; } } else { $options['search']['delimiter']['and'] = ' AND '; } if(!empty($options['search']['delimiter']['or'])){ if(in_array($options['search']['delimiter']['or'], $delimiterArray)){ $options['search']['delimiter']['or'] = mb_strtoupper($options['search']['delimiter']['or']); } else { $options['search']['delimiter']['or'] = ' OR '; } } else { $options['search']['delimiter']['or'] = ' OR '; } if(!empty($options['search']['or']) AND is_array($options['search']['or'])){ if(!isset($options['search']['or'][0])){ $options['search']['or'] = array($options['search']['or']); } foreach ($options['search']['or'] as $key => $row) { foreach ($row as $column => $value) { $x[$key][] = $prefix.$column.$suffix; $prepareArray[] = $prefix.$column.$suffix; $executeArray[] = $value; } $orSql .= '('.implode(' OR ', $x[$key]).')'; if(count($options['search']['or'])>$key+1){ $orSql .= ' '.$options['search']['delimiter']['or']. ' '; } } } if(!empty($options['search']['and']) AND is_array($options['search']['and'])){ if(!isset($options['search']['and'][0])){ $options['search']['and'] = array($options['search']['and']); } foreach ($options['search']['and'] as $key => $row) { foreach ($row as $column => $value) { $x[$key][] = $prefix.$column.$suffix; $prepareArray[] = $prefix.$column.$suffix; $executeArray[] = $value; } $andSql .= '('.implode(' AND ', $x[$key]).')'; if(count($options['search']['and'])>$key+1){ $andSql .= ' '.$options['search']['delimiter']['and']. ' '; } } } $delimiter = ' AND '; $sqlBox = array(); if(!empty($keywordSql)){ $sqlBox[] = $keywordSql; } if(!empty($andSql) AND !empty($orSql)){ $sqlBox[] = '('.$andSql.$delimiter.$orSql.')'; } else { if(!empty($andSql)){ $sqlBox[] = '('.$andSql.')'; } if(!empty($orSql)){ $sqlBox[] = '('.$orSql.')'; } } if( !empty($options['search']['or']) OR !empty($options['search']['and']) OR !empty($options['search']['keyword']) ){ $sql .= 'WHERE '.implode($delimiter, $sqlBox); } if(!empty($options['sort'])){ list($columnName, $sort) = explode(':', $options['sort']); if(in_array($sort, array('asc', 'ASC', 'desc', 'DESC'))){ $sql .= ' ORDER BY '.$tblName.'.'.$columnName.' '.strtoupper($sort); } } if(!empty($options['limit'])){ if(!empty($options['limit']['start']) AND $options['limit']['start']>0){ $start = $options['limit']['start'].','; } else { $start = '0,'; } if(!empty($options['limit']['end']) AND $options['limit']['end']>0){ $end = $options['limit']['end']; } else { $end = $this->newId($tblName)-1; } $sql .= ' LIMIT '.$start.$end; } $result = array(); $this->sql = 'SELECT '.$sqlColumns.' FROM '.$tblName.' '.$sql; try{ $query = $this->prepare($this->sql); $query->execute($executeArray); $result = $query->fetchAll(PDO::FETCH_ASSOC); if(isset($options['format'])){ switch ($options['format']) { case 'json': $result = $this->json_encode($result); break; } } return $result; }catch (Exception $e){ return $result; } } /** * Research assistant. * * @param string $tblName * @param array $map * @param mixed $column * @return array */ public function samantha($tblName, $map, $column=null, $status=false) { $output = array(); $columns = array(); $scheme['search']['and'] = $map; // Sütun(lar) belirtilmi?se if (!empty($column)) { // bir sütun belirtilmi?se if(!is_array($column)){ $columns = array($column); } else { $columns = $column; } // tablo sütunlar? elde ediliyor $getColumns = $this->columnList($tblName); // belirtilen sütun(lar) var m? bak?l?yor foreach($columns as $column){ // yoksa bo? bir array geri döndürülüyor if(!in_array($column, $getColumns)){ return []; } } // izin verilen sütun(lar) belirtiliyor $scheme['column'] = $columns; } $output = $this->getData($tblName, $scheme); return $output; } /** * Research assistant. * It serves to obtain a array. * * @param string $tblName * @param array $map * @param mixed $column * @return array * */ public function theodore($tblName, $map, $column=null){ $output = array(); $columns = array(); $scheme['search']['and'] = $map; // Sütun(lar) belirtilmi?se if (!empty($column)) { // bir sütun belirtilmi?se if(!is_array($column)){ $columns = array($column); } else { $columns = $column; } // tablo sütunlar? elde ediliyor $getColumns = $this->columnList($tblName); // belirtilen sütun(lar) var m? bak?l?yor foreach($columns as $column){ // yoksa bo? bir array geri döndürülüyor if(!in_array($column, $getColumns)){ return []; } } // izin verilen sütun(lar) belirtiliyor $scheme['column'] = $columns; } $data = $this->getData($tblName, $scheme); if(count($data)==1 AND isset($data[0])){ $output = $data[0]; } else { $output = []; } return $output; } /** * Research assistant. * Used to obtain an element of an array * * @param string $tblName * @param array $map * @param string $column * @return string * */ public function amelia($tblName, $map, $column){ $output = ''; $scheme['search']['and'] = $map; // Sütun string olarak gönderilmemi?se if (!is_string($column)) { return $output; } // tablo sütunlar? elde ediliyor $getColumns = $this->columnList($tblName); // yoksa bo? bir string geri döndürülüyor if(!in_array($column, $getColumns)){ return $output; } // izin verilen sütun belirtiliyor $scheme['column'] = $column; $data = $this->getData($tblName, $scheme); if(count($data)==1 AND isset($data[0])){ $output = $data[0][$column]; } return $output; } /** * Entity verification. * * @param string $tblName * @param mixed $value * @param mixed $column * @return bool */ public function do_have($tblName, $value, $column=null){ if(!is_array($value)){ $options['search']['keyword'] = $value; if(!empty($column)){ $options['search']['column'] = $column; } } else { $options['search']['and'] = $value; } if(!empty($this->getData($tblName, $options))){ return true; } return false; } /** * Provides the number of the current record. * * @param string $tblName * @param array $needle * @return int */ public function getId($tblName, $needle){ return $this->amelia($tblName, $needle, $this->increments($tblName)); } /** * New id parameter. * * @param string $tblName * @return int */ public function newId($tblName){ $IDs = []; $length = 1; $needle = $this->increments($tblName); switch ($this->db['drive']) { case 'mysql' OR 'sqlsrv': foreach ($this->getData($tblName, array('column'=>$needle)) as $row) { if(!in_array($row[$needle], $IDs)){ $IDs[] = $row[$needle]; } } break; case 'sqlite': $getSqliteTable = $this->theodore('sqlite_sequence', array('name'=>$tblName)); $IDs[] = $getSqliteTable['seq']; break; } if(!empty($IDs)){ $length = max($IDs)+1; } else { $this->tableClear($tblName); } return $length; } /** * Auto increment column. * * @param string $tblName * @return string * */ public function increments($tblName){ $columns = ''; try{ switch ($this->db['drive']) { case 'mysql': $query = $this->query('SHOW COLUMNS FROM `' . $tblName. '`', PDO::FETCH_ASSOC); foreach ( $query as $column ) { if($column['Extra'] == 'auto_increment'){ $columns = $column['Field']; } } break; case 'sqlsrv': $query = $this->query('SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = \'' . $tblName . '\' AND COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, \'IsIdentity\') = 1', PDO::FETCH_ASSOC); foreach ( $query as $column ) { $columns = $column['COLUMN_NAME']; } break; case 'sqlite': $statement = $this->query("PRAGMA TABLE_INFO(`".$tblName."`)"); $row = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($row as $column) { if((int) $column['pk'] === 1){ $columns = $column['name']; } } break; } return $columns; } catch (Exception $e){ return $columns; } } /** * Table structure converter for Mind * * @param string $tblName * @return array */ public function tableInterpriter($tblName, $column = null){ $result = array(); $columns = array(); $columns = (!is_null($column) AND is_array($column)) ? $column : $columns; // array $columns = (!is_null($column) AND !is_array($column)) ? [$column] : $columns; // string try{ switch ($this->db['drive']) { case 'mysql': $sql = 'SHOW COLUMNS FROM `' . $tblName . '`'; break; case 'sqlsrv': $sql = 'SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = \'' . $tblName . '\';'; break; case 'sqlite': $sql = 'PRAGMA TABLE_INFO(`'. $tblName . '`)'; break; } $query = $this->query($sql)->fetchAll(PDO::FETCH_ASSOC); foreach ( $query as $row ) { switch ($this->db['drive']) { case 'mysql': if(strstr($row['Type'], '(')){ $row['Length'] = implode('', $this->get_contents('(',')', $row['Type'])); $row['Type'] = explode('(', $row['Type'])[0]; } break; case 'sqlsrv': $row['Type'] = $row['DATA_TYPE']; $row['Field'] = $row['COLUMN_NAME']; $row['Null'] = ($row['IS_NULLABLE'] == 'YES') ? 'NULL' : 'NOT NULL'; $row['Length'] = ($row['CHARACTER_MAXIMUM_LENGTH'] == -1) ? 'MAX' : $row['CHARACTER_MAXIMUM_LENGTH']; $row['Default'] =''; $row['Extra'] = ($this->increments( $tblName) == $row['COLUMN_NAME']) ? 'auto_increment' : ''; unset($row['TABLE_CATALOG'], $row['TABLE_SCHEMA'], $row['TABLE_NAME'], $row['COLUMN_NAME'], $row['ORDINAL_POSITION'], $row['COLUMN_DEFAULT'], $row['IS_NULLABLE'], $row['DATA_TYPE'], $row['CHARACTER_MAXIMUM_LENGTH'], $row['CHARACTER_OCTET_LENGTH'], $row['NUMERIC_PRECISION'], $row['NUMERIC_PRECISION_RADIX'], $row['NUMERIC_SCALE'], $row['DATETIME_PRECISION'], $row['CHARACTER_SET_CATALOG'], $row['CHARACTER_SET_SCHEMA'], $row['CHARACTER_SET_NAME'], $row['COLLATION_CATALOG'], $row['COLLATION_SCHEMA'], $row['COLLATION_NAME'], $row['DOMAIN_CATALOG'], $row['DOMAIN_SCHEMA'], $row['DOMAIN_NAME']); break; case 'sqlite': // Field $row['Field'] = $row['name']; // Type, Length if(strstr($row['type'], '(')){ $row['Length'] = implode('', $this->get_contents('(',')', $row['type'])); $row['Type'] = mb_strtolower(explode('(', $row['type'])[0]); } else { $row['Type'] = mb_strtolower($row['type']); } if($row['Type'] == 'integer') { $row['Type'] = 'int';} $row['Null'] = ($row['notnull']==0) ? 'YES' : 'NO'; $row['Key'] = ($row['pk']==1) ? 'PRI' : ''; $row['Default'] = $row['dflt_value']; $row['Extra'] = ($row['pk'] == 1) ? 'auto_increment' : ''; // remove old column name unset($row['cid'], $row['pk'], $row['name'], $row['type'], $row['dflt_value'], $row['notnull']); break; } if(!in_array($row['Field'], $columns)){ switch ($row['Type']) { case 'int': if($row['Extra'] == 'auto_increment'){ if(isset($row['Length'])){ $row = $row['Field'].':increments@'.$row['Length']; } else { $row = $row['Field'].':increments'; } } else { if(isset($row['Length'])){ $row = $row['Field'].':int@'.$row['Length']; } else { $row = $row['Field'].':int'; } } break; case 'varchar': $row = $row['Field'].':string@'.$row['Length']; break; case 'nvarchar': if($row['Length'] != 'MAX'){ $row = $row['Field'].':small@'.$row['Length']; } else { $row = $row['Field'].':small'; } break; case 'text': $row = $row['Field'].':small'; break; case 'mediumtext': $row = $row['Field'].':medium'; break; case 'longtext': $row = $row['Field'].':large'; break; case 'decimal': if($this->db['drive'] == 'sqlsrv' AND isset($row['NUMERIC_PRECISION']) AND isset($row['NUMERIC_SCALE'])){ $row['Length'] = $row['NUMERIC_PRECISION'].','.$row['NUMERIC_SCALE']; } if(isset($row['Length'])){ $row = $row['Field'].':decimal@'.$row['Length']; } else { $row = $row['Field'].':decimal'; } break; } $result[] = $row; } } return $result; } catch (Exception $e){ return $result; } } /** * Database backup method * * @param string|array $dbnames * @param string $directory * @return json|export */ public function backup($dbnames, $directory='') { $result = array(); if(is_string($dbnames)){ $dbnames = array($dbnames); } foreach ($dbnames as $dbname) { // database select $this->selectDB($dbname); // tabular data is obtained foreach ($this->tableList() as $tblName) { if($tblName != 'sqlite_sequence') { // If it is not the table added by default to the sqlite database. $incrementColumn = $this->increments($tblName); if(!empty($incrementColumn)){ $increments = array( 'auto_increment'=>array( 'length'=>$this->newId($tblName) ) ); } $result[$dbname][$tblName]['config'] = $increments; $result[$dbname][$tblName]['schema'] = $this->tableInterpriter($tblName); $result[$dbname][$tblName]['data'] = $this->getData($tblName); } } } $data = $this->json_encode($result); $filename = $this->db['drive'].'_backup_'.$this->permalink($this->timestamp, array('delimiter'=>'_')).'.json'; if(!empty($directory)){ if(is_dir($directory)){ $this->write($data, $directory.'/'.$filename); } } else { $this->saveAs($data, $filename); } return $result; } /** * Method of restoring database backup * * @param string|array $paths * @return array */ public function restore($paths){ $result = array(); if(is_string($paths)){ $paths = array($paths); } foreach ($paths as $path) { if(file_exists($path)){ foreach ($this->json_decode(file_get_contents($path)) as $dbname => $rows) { foreach ($rows as $tblName => $row) { $this->dbConnect(['db'=>['dbname'=>$dbname]]); $this->tableCreate($tblName, $row['schema']); switch ($this->db['drive']) { case 'mysql': if(!empty($row['config']['auto_increment']['length'])){ $length = $row['config']['auto_increment']['length']; $sql = "ALTER TABLE `".$tblName."` AUTO_INCREMENT = ".$length; $this->query($sql); } break; } if(!empty($row['data']) AND empty($this->getData($tblName))){ $this->insert($tblName, $row['data']); } $result[$dbname][$tblName] = $row; } } } } return $result; } /** * Paging method * * @param string $tblName * @param array $options * @return json|array */ public function pagination($tblName, $options=array()){ $result = array(); /* -------------------------------------------------------------------------- */ /* FORMAT */ /* -------------------------------------------------------------------------- */ if(!isset($options['format'])){ $format = ''; } else { $format = $options['format']; unset($options['format']); } /* -------------------------------------------------------------------------- */ /* SORT */ /* -------------------------------------------------------------------------- */ if(!isset($options['sort'])){ $options['sort'] = ''; } /* -------------------------------------------------------------------------- */ /* LIMIT */ /* -------------------------------------------------------------------------- */ $limit = 5; if(empty($options['limit'])){ $options['limit'] = $limit; } else { if(!is_numeric($options['limit'])){ $options['limit'] = $limit; } } $end = $options['limit']; /* -------------------------------------------------------------------------- */ /* PAGE */ /* -------------------------------------------------------------------------- */ $page = 1; $prefix = 'p'; if(!empty($options['prefix'])){ if(!is_numeric($options['prefix'])){ $prefix = $options['prefix']; } } if(empty($this->post[$prefix])){ $this->post[$prefix] = $page; } else { if(is_numeric($this->post[$prefix])){ $page = $this->post[$prefix]; } else { $this->post[$prefix] = $page; } } /* -------------------------------------------------------------------------- */ /* COLUMN */ /* -------------------------------------------------------------------------- */ if(!isset($options['column']) OR empty($options['column'])){ $options['column'] = array(); } /* -------------------------------------------------------------------------- */ /* SEARCH */ /* -------------------------------------------------------------------------- */ if(!isset($options['search']) OR empty($options['search'])){ $options['search'] = array(); } if(!is_array($options['search'])){ $options['search'] = array(); } /* -------------------------------------------------------------------------- */ /* Finding the total number of pages and starting points */ /* -------------------------------------------------------------------------- */ $data = $this->getData($tblName, $options); $totalRow = count($data); $totalPage = ceil($totalRow/$end); $start = ($page*$end)-$end; $result = array( 'data'=>array_slice($data, $start, $end), 'prefix'=>$prefix, 'limit'=>$end, 'totalPage'=>$totalPage, 'page'=>$page ); switch ($format) { case 'json': return $this->json_encode($result); break; } return $result; } /** * Translate * * @param string $needle * @param string|null $lang * @return string */ public function translate($needle, $lang=''){ if(!in_array($lang, array_keys($this->languages()))){ $lang = $this->lang['lang']; } $params = array( $this->lang['column']=>$lang, $this->lang['haystack']=>$needle ); return $this->amelia($this->lang['table'], $params, $this->lang['return']); } /** * infinity Tree, recursive method * @param array $data * @param string $parentColumn * @param string $childColumn * @param string $idColumn * @param int $parentId * @return array $output */ public function infinityTree($data, $parentColumn = 'parent', $childrenName = 'children', $idColumn = 'id', $parentId = 0) { $output = array(); foreach ($data as $item) { if ($item[$parentColumn] == $parentId) { $children = $this->infinityTree($data, $parentColumn, $childrenName, $idColumn, $item[$idColumn]); if ($children) { $item[$childrenName] = $children; } else { $item[$childrenName] = array(); } $output[] = $item; } } return $output; } /** * selectTree * @param array $data * @param string|null $value * @param string $childrenName * @param string $valName * @param string $textName * @param int $level * @return string $output */ public function selectTree($data, $value = null, $childrenName = 'children', $valName="id", $textName="name", $level = 0){ $output = ""; $selected = ""; foreach ($data as $key => $row) { if(!is_null($value)) { if($value == $row[$valName]){ $selected = ' selected'; } } $output .= "<option value= \"".$row[$valName]."\"".$selected.">".str_repeat('--',$level).' '.$row[$textName]."</option>" ."\n"; if($row[$childrenName]){ $output .= $this->selectTree($row[$childrenName], $value, $childrenName, $valName, $textName, $level+1); } } return $output; } /** * Database verification. * * @param string $dbname * @return bool * */ public function is_db($dbname){ switch ($this->db['drive']) { case 'mysql': $sql = 'SHOW DATABASES'; try{ $query = $this->query($sql, PDO::FETCH_ASSOC); $dbnames = array(); if ( $query->rowCount() ){ foreach ( $query as $item ) { $dbnames[] = $item['Database']; } } return in_array($dbname, $dbnames) ? true : false; } catch (Exception $e){ return false; } break; case 'sqlsrv': if(in_array($dbname, $this->dbList())){ return true; } else { return false; } break; case 'sqlite': return (isset($dbname) AND file_exists($dbname)) ? true : false; break; } return false; } /** * Table verification. * * @param string $tblName * @return bool */ public function is_table($tblName){ $sql = ''; switch ($this->db['drive']) { case 'mysql': $sql = 'DESCRIBE `'.$tblName.'`'; break; case 'sqlsrv': $sql = 'SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = \''.$tblName.'\''; break; case 'sqlite': $sql = "SELECT name FROM sqlite_master WHERE type='table' AND name='".$tblName."';"; break; } try{ return $this->query($sql)->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e){ return false; } } /** * Column verification. * * @param string $tblName * @param string $column * @return bool * */ public function is_column($tblName, $column){ $columns = $this->columnList($tblName); if(in_array($column, $columns)){ return true; } else { return false; } } /** * Phone verification. * * @param string $str * @return bool * */ public function is_phone($str){ return preg_match('/^\(?\+?([0-9]{1,4})\)?[-\. ]?(\d{3})[-\. ]?([0-9]{7})$/', implode('', explode(' ', $str))) ? true : false; } /** * Date verification. * * @param string $date * @param string $format * @return bool * */ public function is_date($date, $format = 'Y-m-d H:i:s'){ $d = DateTime::createFromFormat($format, $date); return $d && $d->format($format) == $date; } /** * Mail verification. * * @param string $email * @return bool */ public function is_email($email){ if ( filter_var($email, FILTER_VALIDATE_EMAIL) ) { return true; } else { return false; } } /** * Type verification. * * @param string $fileName * @param mixed $type * @return bool */ public function is_type($fileName, $type){ if( !empty($type) AND !is_array($fileName) ){ $exc = $this->info($fileName, 'extension'); if(!is_array($type)){ $type = array($type); } return in_array($exc, $type) ? true : false; } return false; } /** * Size verification. * * @param mixed $first_size * @param string $second_size * @return bool * */ public function is_size($first_size, $second_size){ if(is_array($first_size)){ if(isset($first_size['size'])){ $first_size = $first_size['size']; } } if(strstr($first_size, ' ')){ $first_size = $this->encodeSize($first_size); } if(strstr($second_size, ' ')){ $second_size = $this->encodeSize($second_size); } if($first_size >= $second_size){ return true; } return false; } /** * Color verification. * * @param string $color * @return bool * */ public function is_color($color){ $colorArray = json_decode('["AliceBlue","AntiqueWhite","Aqua","Aquamarine","Azure","Beige","Bisque","Black","BlanchedAlmond","Blue","BlueViolet","Brown","BurlyWood","CadetBlue","Chartreuse","Chocolate","Coral","CornflowerBlue","Cornsilk","Crimson","Cyan","DarkBlue","DarkCyan","DarkGoldenRod","DarkGray","DarkGrey","DarkGreen","DarkKhaki","DarkMagenta","DarkOliveGreen","DarkOrange","DarkOrchid","DarkRed","DarkSalmon","DarkSeaGreen","DarkSlateBlue","DarkSlateGray","DarkSlateGrey","DarkTurquoise","DarkViolet","DeepPink","DeepSkyBlue","DimGray","DimGrey","DodgerBlue","FireBrick","FloralWhite","ForestGreen","Fuchsia","Gainsboro","GhostWhite","Gold","GoldenRod","Gray","Grey","Green","GreenYellow","HoneyDew","HotPink","IndianRed ","Indigo ","Ivory","Khaki","Lavender","LavenderBlush","LawnGreen","LemonChiffon","LightBlue","LightCoral","LightCyan","LightGoldenRodYellow","LightGray","LightGrey","LightGreen","LightPink","LightSalmon","LightSeaGreen","LightSkyBlue","LightSlateGray","LightSlateGrey","LightSteelBlue","LightYellow","Lime","LimeGreen","Linen","Magenta","Maroon","MediumAquaMarine","MediumBlue","MediumOrchid","MediumPurple","MediumSeaGreen","MediumSlateBlue","MediumSpringGreen","MediumTurquoise","MediumVioletRed","MidnightBlue","MintCream","MistyRose","Moccasin","NavajoWhite","Navy","OldLace","Olive","OliveDrab","Orange","OrangeRed","Orchid","PaleGoldenRod","PaleGreen","PaleTurquoise","PaleVioletRed","PapayaWhip","PeachPuff","Peru","Pink","Plum","PowderBlue","Purple","RebeccaPurple","Red","RosyBrown","RoyalBlue","SaddleBrown","Salmon","SandyBrown","SeaGreen","SeaShell","Sienna","Silver","SkyBlue","SlateBlue","SlateGray","SlateGrey","Snow","SpringGreen","SteelBlue","Tan","Teal","Thistle","Tomato","Turquoise","Violet","Wheat","White","WhiteSmoke","Yellow","YellowGreen"]', true); if(in_array($color, $colorArray)){ return true; } if($color == 'transparent'){ return true; } if(preg_match('/^#[a-f0-9]{6}$/i', mb_strtolower($color, 'utf-8'))){ return true; } if(preg_match('/^rgb\((?:\s*\d+\s*,){2}\s*[\d]+\)$/', mb_strtolower($color, 'utf-8'))) { return true; } if(preg_match('/^rgba\((\s*\d+\s*,){3}[\d\.]+\)$/i', mb_strtolower($color, 'utf-8'))){ return true; } if(preg_match('/^hsl\(\s*\d+\s*(\s*\,\s*\d+\%){2}\)$/i', mb_strtolower($color, 'utf-8'))){ return true; } if(preg_match('/^hsla\(\s*\d+(\s*,\s*\d+\s*\%){2}\s*\,\s*[\d\.]+\)$/i', mb_strtolower($color, 'utf-8'))){ return true; } return false; } /** * URL verification. * * @param string $url * @return bool */ public function is_url($url=null){ if(!is_string($url)){ return false; } $temp_string = (!preg_match('#^(ht|f)tps?://#', $url)) // check if protocol not present ? 'http://' . $url // temporarily add one : $url; // use current if ( filter_var($temp_string, FILTER_VALIDATE_URL)) { return true; } else { return false; } } /** * HTTP checking. * * @param string $url * @return bool */ public function is_http($url){ if (substr($url, 0, 7) == "http://"){ return true; } else { return false; } } /** * HTTPS checking. * @param string $url * @return bool */ public function is_https($url){ if (substr($url, 0, 8) == "https://"){ return true; } else { return false; } } /** * Json control of a string * * @param string $scheme * @return bool */ public function is_json($scheme){ if(is_null($scheme) OR is_array($scheme)) { return false; } if($this->json_decode($scheme)){ return true; } return false; } /** * is_age * @param string $date * @param string|int $age * @param string $type * @return bool * */ public function is_age($date, $age, $type='min'){ $today = date("Y-m-d"); $diff = date_diff(date_create($date), date_create($today)); if($type === 'max'){ if($age >= $diff->format('%y')){ return true; } } if($type === 'min'){ if($age <= $diff->format('%y')){ return true; } } return false; } /** * International Bank Account Number verification * * @params string $iban * @param $iban * @return bool */ public function is_iban($iban){ // Normalize input (remove spaces and make upcase) $iban = strtoupper(str_replace(' ', '', $iban)); if (preg_match('/^[A-Z]{2}[0-9]{2}[A-Z0-9]{1,30}$/', $iban)) { $country = substr($iban, 0, 2); $check = intval(substr($iban, 2, 2)); $account = substr($iban, 4); // To numeric representation $search = range('A','Z'); foreach (range(10,35) as $tmp) $replace[]=strval($tmp); $numstr = str_replace($search, $replace, $account.$country.'00'); // Calculate checksum $checksum = intval(substr($numstr, 0, 1)); for ($pos = 1; $pos < strlen($numstr); $pos++) { $checksum *= 10; $checksum += intval(substr($numstr, $pos,1)); $checksum %= 97; } return ((98-$checksum) == $check); } else return false; } /** * ipv4 verification * * @params string $ip * @return bool */ public function is_ipv4($ip){ if (filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_IPV4)) { return true; } else { return false; } } /** * ipv6 verification * * @params string $ip * @return bool */ public function is_ipv6($ip){ if (filter_var($ip, FILTER_VALIDATE_IP, FILTER_FLAG_IPV6)) { return true; } else { return false; } } /** * Blood group verification * * @param $blood * @param string $donor * @return bool */ public function is_blood($blood, $donor = null){ $bloods = array( 'AB+'=> array( 'AB+', 'AB-', 'B+', 'B-', 'A+', 'A-', '0+', '0-' ), 'AB-'=> array( 'AB-', 'B-', 'A-', '0-' ), 'B+'=> array( 'B+', 'B2-', '0+', '0-' ), 'B-'=> array( 'B-', '0-' ), 'A+'=> array( 'A+', 'A-', '0+', '0-' ), 'A-'=> array( 'A-', '0-' ), '0+'=> array( '0+', '0-' ), '0-'=> array( '0-' ) ); $map = array_keys($bloods); // hasta ve varsa donör parametreleri filtreden geçirilir $blood = str_replace(array('RH', ' '), '', mb_strtoupper($blood)); if(!is_null($donor)) $donor = str_replace(array('RH', ' '), '', mb_strtoupper($donor)); // Kan grubu kontrolü if(in_array($blood, $map) AND is_null($donor)){ return true; } // Donör uyumu kontrolü if(in_array($blood, $map) AND in_array($donor, $bloods[$blood]) AND !is_null($donor)){ return true; } return false; } /** * Validates a given Latitude * @param float|int|string $latitude * @return bool */ public function is_latitude($latitude){ $lat_pattern = '/\A[+-]?(?:90(?:\.0{1,18})?|\d(?(?<=9)|\d?)\.\d{1,18})\z/x'; if (preg_match($lat_pattern, $latitude)) { return true; } else { return false; } } /** * Validates a given longitude * @param float|int|string $longitude * @return bool */ public function is_longitude($longitude){ $long_pattern = '/\A[+-]?(?:180(?:\.0{1,18})?|(?:1[0-7]\d|\d{1,2})\.\d{1,18})\z/x'; if (preg_match($long_pattern, $longitude)) { return true; } else { return false; } } /** * Validates a given coordinate * * @param float|int|string $lat Latitude * @param float|int|string $long Longitude * @return bool `true` if the coordinate is valid, `false` if not */ public function is_coordinate($lat, $long) { if ($this->is_latitude($lat) AND $this->is_longitude($long)) { return true; } else { return false; } } /** * Distance verification */ public function is_distance($point1, $point2, $options){ $symbols = array('m', 'km', 'mi', 'ft', 'yd'); // Option variable control if(empty($options)){ return false; } if(!strstr($options, ':')){ return false; } $options = explode(':', trim($options, ':')); if(count($options) != 2){ return false; } list($range, $symbol) = $options; if(!in_array(mb_strtolower($symbol), $symbols)){ return false; } // Points control if(empty($point1) OR empty($point2)){ return false; } if(!is_array($point1) OR !is_array($point2)){ return false; } if(count($point1) != 2 OR count($point2) != 2){ return false; } if(isset($point1[0]) AND isset($point1[1]) AND isset($point2[0]) AND isset($point2[1])){ $distance_range = $this->distanceMeter($point1[0], $point1[1], $point2[0], $point2[1], $symbol); if($distance_range <= $range){ return true; } } return false; } /** * md5 hash checking method. * * @param string $md5 * @return bool */ public function is_md5($md5 = ''){ return strlen($md5) == 32 && ctype_xdigit($md5); } /** * Determines if SSL is used. * @return bool True if SSL, otherwise false. */ public function is_ssl() { if ( isset( $_SERVER['HTTPS'] ) ) { if ( 'on' === strtolower( $_SERVER['HTTPS'] ) ) { return true; } if ( '1' == $_SERVER['HTTPS'] ) { return true; } } elseif ( isset( $_SERVER['SERVER_PORT'] ) && ( '443' == $_SERVER['SERVER_PORT'] ) ) { return true; } return false; } /** * html special characters control * @param $code * @return bool */ public function is_htmlspecialchars($code){ if(strpos($code, '&lt;') OR strpos($code, '&gt;') OR strpos($code, '&quot;') OR strpos($code, '&#39;') OR strpos($code, '&amp;')){ return true; } return false; } /** * Morse code verification * @param string $morse * @return bool */ public function is_morse($morse){ $data = $this->morse_decode($morse); if(strstr($data, '#')){ return false; } return true; } /** * Binary code verification * @param string|int $binary * @return bool */ public function is_binary($binary) { if (preg_match('~^[01]+$~', str_replace(' ', '', $binary))) { return true; } return false; } /** * Timecode verification * @param string * @return bool */ public function is_timecode($timecode){ if(preg_match('/^([00-59]{2}):([00-59]{2}):([00-59]{2})?$/', $timecode)){ return true; } return false; } /** * Browser verification * @param string|null $agent * @param string|array $browser * @return bool */ public function is_browser($browserName=null, $browsers=null){ $browser = $this->getBrowser($browserName); if($browser != 'Unknown') { if(is_null($browsers)){ return true; } else { $browsers = (!is_array($browsers)) ? array($browsers) : $browsers; if(in_array($browser, $browsers)){ return true; } } } return false; } /** * Decimal detection * @param string|int $decimal * @return bool */ public function is_decimal($decimal){ if(preg_match('/^\d*\.?\d*$/', $decimal)){ return true; } return false; } /** * ISBN validate * @param string $isbn * @param string|int|null $type * @return bool */ public function is_isbn($isbn, $type=null){ $regex = '/\b(?:ISBN(?:: ?| ))?((?:97[89])?\d{9}[\dx])\b/i'; if (preg_match($regex, str_replace('-', '', $isbn), $matches)) { if(in_array(mb_strlen($matches[1],'UTF-8'), [13,10]) and !isset($type)){ return true; } if(in_array(mb_strlen($matches[1],'UTF-8'), [13,10]) and isset($type)){ return ($type === mb_strlen($matches[1],'UTF-8')); } } return false; // No valid ISBN found } /** * timecodeCompare * @param string $duration * @param string $timecode * @return bool */ public function timecodeCompare($duration, $timecode){ if($this->toSeconds($duration) <= $this->toSeconds($timecode)){ return true; } return false; } /** * Validation * * @param array $rule * @param array $data * @param array $message * @return bool */ public function validate($rule, $data, $message = array()){ $extra = ''; $limit = ''; $rules = array(); foreach($rule as $name => $value){ if(strstr($value, '|')){ foreach(explode('|', trim($value, '|')) as $val){ $rules[$name][] = $val; } } else { $rules[$name][] = $value; } } foreach($rules as $column => $rule){ foreach($rule as $name){ if(strstr($name, ':')){ $ruleData = explode(':', trim($name, ':')); if(count($ruleData) == 2){ list($name, $extra) = $ruleData; } if(count($ruleData) == 3){ list($name, $extra, $limit) = $ruleData; } if(count($ruleData) == 4){ list($name, $extra, $knownuniqueColumn, $knownuniqueValue) = $ruleData; } // farkl? zaman damgalar? kontrolüne müsaade edildi. if(count($ruleData) > 2 AND strstr($name, ' ')){ $x = explode(' ', $name); list($left, $right) = explode(' ', $name); list($name, $date1) = explode(':', $left); $extra = $date1.' '.$right; } } $data[$column] = (isset($data[$column])) ? $data[$column] : ''; // ?lgili kural?n mesaj? yoksa kural ad? mesaj olarak belirtilir. if(empty($message[$column][$name])){ $message[$column][$name] = $name; } switch ($name) { // minimum say kural? case 'min-num': if(!is_numeric($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } else { if($data[$column]<$extra){ $this->errors[$column][$name] = $message[$column][$name]; } } break; // maksimum say? kural? case 'max-num': if(!is_numeric($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } else { if($data[$column]>$extra){ $this->errors[$column][$name] = $message[$column][$name]; } } break; // minimum karakter kural? case 'min-char': if(strlen($data[$column])<$extra){ $this->errors[$column][$name] = $message[$column][$name]; } break; // maksimum karakter kural? case 'max-char': if(strlen($data[$column])>$extra){ $this->errors[$column][$name] = $message[$column][$name]; } break; // E-Posta adresi kural? case 'email': if(!$this->is_email($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Zorunlu alan kural? case 'required': if(!isset($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } else { if($data[$column] === ''){ $this->errors[$column][$name] = $message[$column][$name]; } } break; // Telefon numaras? kural? case 'phone': if(!$this->is_phone($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Tarih kural? case 'date': if(empty($extra)){ $extra = 'Y-m-d'; } if(!$this->is_date($data[$column], $extra)){ $this->errors[$column][$name] = $message[$column][$name]; } break; // json kural? case 'json': if(!$this->is_json($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Renk kural? case 'color': if(!$this->is_color($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // URL kural? case 'url': if(!$this->is_url($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // https kural? case 'https': if(!$this->is_https($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // http kural? case 'http': if(!$this->is_http($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Numerik karakter kural? case 'numeric': if(!is_numeric($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Minumum ya? s?n?rlamas? kural? case 'min-age': if(!$this->is_age($data[$column], $extra)){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Maksimum ya? s?n?rlamas? kural? case 'max-age': if(!$this->is_age($data[$column], $extra, 'max')){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Benzersiz parametre kural? case 'unique': if(!$this->is_table($extra)){ $this->errors[$column][$name][] = 'Table not found.'; } if(!$this->is_column($extra, $column)){ $this->errors[$column][$name][] = 'Column not found.'; } if($this->do_have($extra, $data[$column], $column)){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Benzeri olan parametre kural? case 'available': $availableColumn = $column; if(isset($limit)){ $availableColumn = $limit; } if(!$this->is_table($extra)){ $this->errors[$column][$name][] = 'Table not found.'; } if(!$this->is_column($extra,$availableColumn)){ $this->errors[$column][$name][] = 'Column not found.'; } if(!$this->do_have($extra, $data[$column],$availableColumn)){ $this->errors[$column][$name] = $message[$column][$name]; } break; case 'knownunique': if(!$this->is_table($extra)){ $this->errors[$column][$name][] = 'Table not found.'; } if(!$this->is_column($extra, $column)){ $this->errors[$column][$name][] = 'Column not found.'; } if(!isset($knownuniqueColumn) AND !isset($knownuniqueValue) AND isset($limit)){ $knownuniqueColumn = $column; $knownuniqueValue = $limit; } if(!isset($limit)){ $this->errors[$column][$name] = $message[$column][$name]; } else { $item = $this->theodore($extra, array($knownuniqueColumn=>$knownuniqueValue)); if(isset($item[$column])){ if($data[$column] != $item[$column] AND $this->do_have($extra, array($column=>$data[$column]))){ $this->errors[$column][$name] = $message[$column][$name]; } } else { if($data[$column] != $knownuniqueValue AND $this->do_have($extra, array($column=>$data[$column]))){ $this->errors[$column][$name] = $message[$column][$name]; } } } break; // Do?rulama kural? case 'bool': // Geçerlilik kontrolü $acceptable = array(true, false, 'true', 'false', 0, 1, '0', '1'); $wrongTypeMessage = 'True, false, 0 or 1 must be specified.'; if(isset($extra)){ if($extra === ''){ unset($extra); } } if(isset($data[$column]) AND isset($extra)){ if(in_array($data[$column], $acceptable, true) AND in_array($extra, $acceptable, true)){ if($data[$column] === 'true' OR $data[$column] === '1' OR $data[$column] === 1){ $data[$column] = true; } if($data[$column] === 'false' OR $data[$column] === '0' OR $data[$column] === 0){ $data[$column] = false; } if($extra === 'true' OR $extra === '1' OR $extra === 1){ $extra = true; } if($extra === 'false' OR $extra === '0' OR $extra === 0){ $extra = false; } if($data[$column] !== $extra){ $this->errors[$column][$name] = $message[$column][$name]; } } else { $this->errors[$column][$name] = $message[$column][$name]; } } if(isset($data[$column]) AND !isset($extra)){ if(!in_array($data[$column], $acceptable, true)){ $this->errors[$column][$name] = $message[$column][$name]; } } if(!isset($data[$column]) AND isset($extra)){ if(!in_array($extra, $acceptable, true)){ $this->errors[$column][$name] = $message[$column][$name]; } } break; // IBAN do?rulama kural? case 'iban': if(!$this->is_iban($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // ipv4 do?rulama kural? case 'ipv4': if(!$this->is_ipv4($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // ipv6 do?rulama kural? case 'ipv6': if(!$this->is_ipv6($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // kan grubu ve uyumu kural? case 'blood': if(!empty($extra)){ if(!$this->is_blood($data[$column], $extra)){ $this->errors[$column][$name] = $message[$column][$name]; } } else { if(!$this->is_blood($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } } break; // Koordinat kural? case 'coordinate': if(!strstr($data[$column], ',')){ $this->errors[$column][$name] = $message[$column][$name]; } else { $coordinates = explode(',', $data[$column]); if(count($coordinates)==2){ list($lat, $long) = $coordinates; if(!$this->is_coordinate($lat, $long)){ $this->errors[$column][$name] = $message[$column][$name]; } } else { $this->errors[$column][$name] = $message[$column][$name]; } } break; case 'distance': if(strstr($data[$column], '@')){ $coordinates = explode('@', $data[$column]); if(count($coordinates) == 2){ list($p1, $p2) = $coordinates; $point1 = explode(',', $p1); $point2 = explode(',', $p2); if(strstr($extra, ' ')){ $options = str_replace(' ', ':', $extra); if(!$this->is_distance($point1, $point2, $options)){ $this->errors[$column][$name] = $message[$column][$name]; } } else { $this->errors[$column][$name] = $message[$column][$name]; } } else { $this->errors[$column][$name] = $message[$column][$name]; } } else { $this->errors[$column][$name] = $message[$column][$name]; } break; case 'languages': if(!in_array($data[$column], array_keys($this->languages()))){ $this->errors[$column][$name] = $message[$column][$name]; } break; case 'morse': if(!$this->is_morse($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; case 'binary': if(!$this->is_binary($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; case 'timecode': if(!$this->is_timecode($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; case 'currencies': if(!in_array($data[$column], array_keys($this->currencies()))){ $this->errors[$column][$name] = $message[$column][$name]; } break; case 'decimal': if(!$this->is_decimal($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; case 'isbn': if(!$this->is_isbn($data[$column])){ $this->errors[$column][$name] = $message[$column][$name]; } break; // Geçersiz kural engellendi. default: $this->errors[$column][$name] = 'Invalid rule has been blocked.'; break; } $extra = ''; } } if(empty($this->errors)){ return true; } else { return false; } } /** * Server policy maker */ public function policyMaker(){ $filename = ''; $public_content = ''; switch ($this->getSoftware()) { case ('Apache' || 'LiteSpeed'): $public_content = implode("\n", array( 'RewriteEngine On', 'RewriteCond %{REQUEST_FILENAME} -s [OR]', 'RewriteCond %{REQUEST_FILENAME} -l [OR]', 'RewriteCond %{REQUEST_FILENAME} -d', 'RewriteRule ^.*$ - [NC,L]', 'RewriteRule ^.*$ index.php [NC,L]' )); $filename = '.htaccess'; break; case 'Microsoft-IIS': $public_content = implode("\n", array( "<?xml version=\"1.0\" encoding=\"UTF-8\"?>", "<configuration>", "\t<system.webServer>", "\t\t<rewrite>", "\t\t\t<rules>", "\t\t\t\t<rule name=\"Imported Rule 1\" stopProcessing=\"true\">", "\t\t\t\t\t<match url=\"^(.*)$\" ignoreCase=\"false\" />", "\t\t\t\t\t<conditions>", "\t\t\t\t\t\t<add input=\"{REQUEST_FILENAME}\" matchType=\"IsFile\" ignoreCase=\"false\" negate=\"true\" />", "\t\t\t\t\t\t<add input=\"{REQUEST_FILENAME}\" matchType=\"IsDirectory\" ignoreCase=\"false\" negate=\"true\" />", "\t\t\t\t\t</conditions>", "\t\t\t\t\t<action type=\"Rewrite\" url=\"index.php\" appendQueryString=\"true\" />", "\t\t\t\t</rule>", "\t\t\t</rules>", "\t\t</rewrite>", "\t</system.webServer>", '</configuration>' )); $filename = 'web.config'; break; } if($this->getSoftware() != 'Nginx'){ if(!file_exists($filename)){ $this->write($public_content, $filename); } } } /** * Pretty Print * @param mixed $data * @return void */ public function print_pre($data){ if($this->is_json($data)){ $data = $this->json_encode($this->json_decode($data)); } echo '<pre>'; print_r($data); echo '</pre>'; } /** * Array sorting function * * @param mixed $data * @param string $sort * @param string|int $column * @return array|json */ public function arraySort($data, $sort='ASC', $key='') { $is_json = FALSE; if($this->is_json($data)){ $is_json = TRUE; $data = $this->json_decode($data); } $sort_name = SORT_DESC; if('ASC' === mb_strtoupper($sort, 'utf8')) $sort_name = SORT_ASC; if(!empty($key)){ $keys = array_column($data, $key); } else { $keys = array_keys($data); asort($data); } array_multisort($keys, $sort_name, SORT_STRING, $data); if($is_json === TRUE){ $data = $this->json_encode($data); } return $data; } /** * Path information * * @param string $fileName * @param string $type * @return bool|string */ public function info($fileName, $type){ if(empty($fileName) AND isset($type)){ return false; } $object = pathinfo($fileName); if($type == 'extension'){ return strtolower($object[$type]); } if($type == 'dirname'){ return $this->get_absolute_path($object[$type]); } return $object[$type]; } /** * Request collector * * @return mixed */ public function request(){ $jsonPOST = file_get_contents("php://input"); $jsonPOST = $this->is_json($jsonPOST) ? $this->json_decode($jsonPOST) : []; if(isset($_POST) OR isset($_GET) OR isset($_FILES) OR isset($jsonPOST)){ foreach (array_merge($_POST, $_GET, $_FILES, $jsonPOST) as $name => $value) { if(is_array($value)){ foreach($value as $key => $all ){ if(is_array($all)){ foreach($all as $i => $val ){ $this->post[$name][$i][$key] = $this->filter($val); } } else { $this->post[$name][$key] = $this->filter($all); } } } else { $this->post[$name] = $this->filter($value); } } } return $this->post; } /** * Filter * * @param string $str * @return string */ public function filter($str){ return htmlspecialchars($str); } /** * Firewall * * @param array $conf * @return string header() */ public function firewall($conf=array()){ if(empty($conf['firewall']['allow']['folder'])){ $conf['firewall']['allow']['folder'] = array('public'); } if(empty($_SERVER['HTTP_USER_AGENT'])){ $this->abort('400', 'User agent is required.'); } $noiframe = "X-Frame-Options: SAMEORIGIN"; $noxss = "X-XSS-Protection: 1; mode=block"; $nosniff = "X-Content-Type-Options: nosniff"; $ssl = "Set-Cookie: user=t=".$this->generateToken()."; path=/; Secure"; $hsts = "Strict-Transport-Security: max-age=16070400; includeSubDomains; preload"; $noiframe_status = (isset($conf['noiframe']) AND $conf['firewall']['noiframe'] == TRUE) ? TRUE : FALSE; $noxss_status = (isset($conf['firewall']['noxss']) AND $conf['firewall']['noxss'] == TRUE) ? TRUE : FALSE; $nosniff_status = (isset($conf['firewall']['nosniff']) AND $conf['firewall']['nosniff'] == TRUE) ? TRUE : FALSE; $ssl_status = (isset($conf['firewall']['ssl']) AND $conf['firewall']['ssl'] == TRUE) ? TRUE : FALSE; $hsts_status = (isset($conf['firewall']['hsts']) AND $conf['firewall']['hsts'] == TRUE) ? TRUE : FALSE; if($noiframe_status === TRUE){ header($noiframe); } if($noxss_status === TRUE){ header($noxss); } if($nosniff_status === TRUE){ header($nosniff); } if($ssl_status === TRUE){ header($ssl); } if($hsts_status === TRUE){ header($hsts); } if($ssl_status === TRUE AND $this->is_ssl() === FALSE){ $this->abort('400', 'SSL is required.'); } if($hsts_status === TRUE AND ($this->is_ssl() OR $ssl_status == FALSE)){ $this->abort('503', 'SSL is required for HSTS.'); } $limit = 200; $name = 'csrf_token'; $status = true; if(!empty($conf)){ if(isset($conf['firewall']['csrf'])){ if(!empty($conf['firewall']['csrf']['name'])){ $name = $conf['firewall']['csrf']['name']; } if(!empty($conf['firewall']['csrf']['limit'])){ $limit = $conf['firewall']['csrf']['limit']; } if(is_bool($conf['firewall']['csrf'])){ $status = $conf['firewall']['csrf']; } } } if($status){ if($_SERVER['REQUEST_METHOD'] === 'POST'){ if(isset($this->post[$name]) AND isset($_SESSION['csrf']['token'])){ if($this->post[$name] == $_SESSION['csrf']['token']){ unset($this->post[$name]); } else { $this->abort('401', 'A valid token could not be found.<br> <small style="font-size:12px;"> The paths of the troubled entities may have caused the token to change. </small>'); } } else { $this->abort('400', 'Token not found.'); } } if($_SERVER['REQUEST_METHOD'] === 'GET'){ $_SESSION['csrf'] = array( 'name' => $name, 'token' => $this->generateToken($limit) ); $_SESSION['csrf']['input'] = "<input type=\"hidden\" name=\"".$_SESSION['csrf']['name']."\" value=\"".$_SESSION['csrf']['token']."\">"; } } else { if(isset($_SESSION['csrf'])){ unset($_SESSION['csrf']); } } if( $_SERVER['REQUEST_METHOD'] === 'POST' AND isset($this->post['captcha']) AND isset($_SESSION['captcha']) AND ($_SESSION['captcha'] != $this->post['captcha'])) { $this->abort('401', 'Captcha validation failed.'); } $conf['firewall']['allow']['platform'] = (isset($conf['firewall']['allow']['platform']) ? $conf['firewall']['allow']['platform'] : []); $conf['firewall']['allow']['browser'] = (isset($conf['firewall']['allow']['browser']) ? $conf['firewall']['allow']['browser'] : []); $conf['firewall']['allow']['ip'] = (isset($conf['firewall']['allow']['ip']) ? $conf['firewall']['allow']['ip'] : []); $conf['firewall']['allow']['folder'] = (isset($conf['firewall']['allow']['folder']) ? $conf['firewall']['allow']['folder'] : []); $conf['firewall']['deny']['platform'] = (isset($conf['firewall']['deny']['platform']) ? $conf['firewall']['deny']['platform'] : []); $conf['firewall']['deny']['browser'] = (isset($conf['firewall']['deny']['browser']) ? $conf['firewall']['deny']['browser'] : []); $conf['firewall']['deny']['ip'] = (isset($conf['firewall']['deny']['ip']) ? $conf['firewall']['deny']['ip'] : []); $conf['firewall']['deny']['folder'] = (isset($conf['firewall']['deny']['folder']) ? $conf['firewall']['deny']['folder'] : []); $conf['firewall']['allow']['platform'] = (!is_array($conf['firewall']['allow']['platform']) ? [$conf['firewall']['allow']['platform']] : $conf['firewall']['allow']['platform']); $conf['firewall']['allow']['browser'] = (!is_array($conf['firewall']['allow']['browser']) ? [$conf['firewall']['allow']['browser']] : $conf['firewall']['allow']['browser']); $conf['firewall']['allow']['ip'] = (!is_array($conf['firewall']['allow']['ip']) ? [$conf['firewall']['allow']['ip']] : $conf['firewall']['allow']['ip']); $conf['firewall']['allow']['folder'] = (!is_array($conf['firewall']['allow']['folder']) ? [$conf['firewall']['allow']['folder']] : $conf['firewall']['allow']['folder']); $conf['firewall']['deny']['platform'] = (!is_array($conf['firewall']['deny']['platform']) ? [$conf['firewall']['deny']['platform']] : $conf['firewall']['deny']['platform']); $conf['firewall']['deny']['browser'] = (!is_array($conf['firewall']['deny']['browser']) ? [$conf['firewall']['deny']['browser']] : $conf['firewall']['deny']['browser']); $conf['firewall']['deny']['ip'] = (!is_array($conf['firewall']['deny']['ip']) ? [$conf['firewall']['deny']['ip']] : $conf['firewall']['deny']['ip']); $conf['firewall']['deny']['folder'] = (!is_array($conf['firewall']['deny']['folder']) ? [$conf['firewall']['deny']['folder']] : $conf['firewall']['deny']['folder']); $platform = $this->getOS(); if( !empty($conf['firewall']['deny']['platform']) AND in_array($platform, array_values($conf['firewall']['deny']['platform'])) OR !empty($conf['firewall']['allow']['platform']) AND !in_array($platform, array_values($conf['firewall']['allow']['platform'])) ){ $this->abort('401', 'Your operating system is not allowed.'); } $browser = $this->getBrowser(); if( !empty($conf['firewall']['deny']['browser']) AND in_array($browser, array_values($conf['firewall']['deny']['browser'])) OR !empty($conf['firewall']['allow']['browser']) AND !in_array($browser, array_values($conf['firewall']['allow']['browser'])) ){ $this->abort('401', 'Your browser is not allowed.'); } $ip = $this->getIPAddress(); if( !empty($conf['firewall']['deny']['ip']) AND in_array($ip, array_values($conf['firewall']['deny']['ip'])) OR !empty($conf['firewall']['allow']['ip']) AND !in_array($ip, array_values($conf['firewall']['allow']['ip'])) ){ $this->abort('401', 'Your IP address is not allowed.'); } $folders = array_filter(glob('*'), 'is_dir'); $filename = ''; $deny_content = ''; $allow_content = ''; switch ($this->getSoftware()) { case ('Apache' || 'LiteSpeed'): $deny_content = 'Deny from all'; $allow_content = 'Allow from all'; $filename = '.htaccess'; break; case 'Microsoft-IIS': $deny_content = implode("\n", array( "<authorization>", "\t<deny users=\"?\"/>", "</authorization>" )); $allow_content = implode("\n", array( "<configuration>", "\t<system.webServer>", "\t\t<directoryBrowse enabled=\"true\" showFlags=\"Date,Time,Extension,Size\" />", "\t\t\t</system.webServer>", "</configuration>" )); $filename = 'web.config'; break; } if($platform != 'Nginx'){ if(!empty($folders)){ foreach ($folders as $dir){ if(in_array($dir, $conf['firewall']['deny']['folder']) AND !file_exists($dir.'/'.$filename)){ $this->write($deny_content, $dir.'/'.$filename); } if(in_array($dir, $conf['firewall']['allow']['folder']) AND !file_exists($dir.'/'.$filename)){ $this->write($allow_content, $dir.'/'.$filename); } if(!file_exists($dir.'/'.$filename)){ $this->write($deny_content, $dir.'/'.$filename); } if(!file_exists($dir.'/index.html')){ $this->write(' ', $dir.'/index.html'); } } } } } /** * Redirect * * @param string $url * @param int $delay, * @param string $element */ public function redirect($url = '', $delay = 0, $element=''){ if(!$this->is_http($url) AND !$this->is_https($url) OR empty($url)){ $url = $this->base_url.$url; } if(0 !== $delay){ if(!empty($element)){ ?> <script> let wait = 1000, delay = <?=$delay;?>, element = "<?=$element;?>"; setInterval(function () { elements = document.querySelectorAll(element); if(delay !== 0){ if(elements.length >= 1){ elements.forEach(function(element) { if(element.value === undefined){ element.textContent = delay; } else { element.value = delay; } }); } } delay--; }, wait); </script> <?php } header('refresh:'.$delay.'; url='.$url); } else { header('Location: '.$url); } ob_end_flush(); } /** * Permanent connection. * * @param string $str * @param array $options * @return string */ public function permalink($str, $options = array()){ $plainText = $str; $defaults = array( 'delimiter' => '-', 'limit' => null, 'lowercase' => true, 'replacements' => array(), 'transliterate' => true, 'unique' => array( 'delimiter' => '-', 'linkColumn' => 'link', 'titleColumn' => 'title' ) ); $char_map = [ // Latin 'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Ä' => 'A', 'Å' => 'A', 'Æ' => 'AE', 'Ç' => 'C', 'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E', 'Ì' => 'I', 'Í' => 'I', 'Î' => 'I', 'Ï' => 'I', 'Ð' => 'D', 'Ñ' => 'N', 'Ò' => 'O', 'Ó' => 'O', 'Ô' => 'O', 'Õ' => 'O', 'Ö' => 'O', '?' => 'O', 'Ø' => 'O', 'Ù' => 'U', 'Ú' => 'U', 'Û' => 'U', 'Ü' => 'U', '?' => 'U', 'Ý' => 'Y', 'Þ' => 'TH', 'ß' => 'ss', 'à' => 'a', 'á' => 'a', 'â' => 'a', 'ã' => 'a', 'ä' => 'a', 'å' => 'a', 'æ' => 'ae', 'ç' => 'c', 'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ì' => 'i', 'í' => 'i', 'î' => 'i', 'ï' => 'i', 'ð' => 'd', 'ñ' => 'n', 'ò' => 'o', 'ó' => 'o', 'ô' => 'o', 'õ' => 'o', 'ö' => 'o', '?' => 'o', 'ø' => 'o', 'ù' => 'u', 'ú' => 'u', 'û' => 'u', 'ü' => 'u', '?' => 'u', 'ý' => 'y', 'þ' => 'th', 'ÿ' => 'y', // Latin symbols '©' => '(c)', // Greek '?' => 'A', '?' => 'B', '?' => 'G', '?' => 'D', '?' => 'E', '?' => 'Z', '?' => 'H', '?' => '8', '?' => 'I', '?' => 'K', '?' => 'L', '?' => 'M', '?' => 'N', '?' => '3', '?' => 'O', '?' => 'P', '?' => 'R', '?' => 'S', '?' => 'T', '?' => 'Y', '?' => 'F', '?' => 'X', '?' => 'PS', '?' => 'W', '?' => 'A', '?' => 'E', '?' => 'I', '?' => 'O', '?' => 'Y', '?' => 'H', '?' => 'W', '?' => 'I', '?' => 'Y', '?' => 'a', '?' => 'b', '?' => 'g', '?' => 'd', '?' => 'e', '?' => 'z', '?' => 'h', '?' => '8', '?' => 'i', '?' => 'k', '?' => 'l', '?' => 'm', '?' => 'n', '?' => '3', '?' => 'o', '?' => 'p', '?' => 'r', '?' => 's', '?' => 't', '?' => 'y', '?' => 'f', '?' => 'x', '?' => 'ps', '?' => 'w', '?' => 'a', '?' => 'e', '?' => 'i', '?' => 'o', '?' => 'y', '?' => 'h', '?' => 'w', '?' => 's', '?' => 'i', '?' => 'y', '?' => 'y', '?' => 'i', // Turkish '?' => 'S', '?' => 'I', '?' => 'G', '?' => 's', '?' => 'i', '?' => 'g', // Russian '?' => 'A', '?' => 'B', '?' => 'V', '?' => 'G', '?' => 'D', '?' => 'E', '?' => 'Yo', '?' => 'Zh', '?' => 'Z', '?' => 'I', '?' => 'J', '?' => 'K', '?' => 'L', '?' => 'M', '?' => 'N', '?' => 'O', '?' => 'P', '?' => 'R', '?' => 'S', '?' => 'T', '?' => 'U', '?' => 'F', '?' => 'H', '?' => 'C', '?' => 'Ch', '?' => 'Sh', '?' => 'Sh', '?' => '', '?' => 'Y', '?' => '', '?' => 'E', '?' => 'Yu', '?' => 'Ya', '?' => 'a', '?' => 'b', '?' => 'v', '?' => 'g', '?' => 'd', '?' => 'e', '?' => 'yo', '?' => 'zh', '?' => 'z', '?' => 'i', '?' => 'j', '?' => 'k', '?' => 'l', '?' => 'm', '?' => 'n', '?' => 'o', '?' => 'p', '?' => 'r', '?' => 's', '?' => 't', '?' => 'u', '?' => 'f', '?' => 'h', '?' => 'c', '?' => 'ch', '?' => 'sh', '?' => 'sh', '?' => '', '?' => 'y', '?' => '', '?' => 'e', '?' => 'yu', '?' => 'ya', // Ukrainian '?' => 'Ye', '?' => 'I', '?' => 'Yi', '?' => 'G', '?' => 'ye', '?' => 'i', '?' => 'yi', '?' => 'g', // Czech '?' => 'C', '?' => 'D', '?' => 'E', '?' => 'N', '?' => 'R', '?' => 'S', '?' => 'T', '?' => 'U', '?' => 'Z', '?' => 'c', '?' => 'd', '?' => 'e', '?' => 'n', '?' => 'r', '?' => 's', '?' => 't', '?' => 'u', '?' => 'z', // Polish '?' => 'A', '?' => 'C', '?' => 'e', '?' => 'L', '?' => 'N', '?' => 'S', '?' => 'Z', '?' => 'Z', '?' => 'a', '?' => 'c', '?' => 'e', '?' => 'l', '?' => 'n', '?' => 's', '?' => 'z', '?' => 'z', // Latvian '?' => 'A', '?' => 'E', '?' => 'G', '?' => 'i', '?' => 'k', '?' => 'L', '?' => 'N', '?' => 'u', '?' => 'a', '?' => 'e', '?' => 'g', '?' => 'i', '?' => 'k', '?' => 'l', '?' => 'n', '?' => 'u', ]; $replacements = array(); if(!empty($options['replacements']) AND is_array($options['replacements'])){ $replacements = $options['replacements']; } if(isset($options['transliterate']) AND !$options['transliterate']){ $char_map = array(); } $options['replacements'] = array_merge($replacements, $char_map); if(!empty($options['replacements']) AND is_array($options['replacements'])){ foreach ($options['replacements'] as $objName => $val) { $str = str_replace($objName, $val, $str); } } $options = array_merge($defaults, $options); $str = preg_replace('/[^\p{L}\p{Nd}_]+/u', $options['delimiter'], $str); $str = preg_replace('/(' . preg_quote($options['delimiter'], '/') . '){2,}/', '$1', $str); $str = mb_substr($str, 0, ($options['limit'] ? $options['limit'] : mb_strlen($str, 'UTF-8')), 'UTF-8'); $str = trim($str, $options['delimiter']); $link = $options['lowercase'] ? mb_strtolower($str, 'UTF-8') : $str; if(!empty($options['unique']['tableName'])){ $tableName = $options['unique']['tableName']; $delimiter = $defaults['unique']['delimiter']; $titleColumn = $defaults['unique']['titleColumn']; $linkColumn = $defaults['unique']['linkColumn']; if(!$this->is_table($options['unique']['tableName'])){ return $link; } else { if(!empty($options['unique']['delimiter'])){ $delimiter = $options['unique']['delimiter']; } if(!empty($options['unique']['titleColumn'])){ $titleColumn = $options['unique']['titleColumn']; } if(!empty($options['unique']['linkColumn'])){ $linkColumn = $options['unique']['linkColumn']; } $data = $this->samantha($tableName, array($titleColumn => $plainText)); if(!empty($data)){ $num = count($data)+1; } else { $num = 1; } for ($i = 1; $i<=$num; $i++){ if(!$this->do_have($tableName, $link, $linkColumn)){ return $link; } else { if(!$this->do_have($tableName, $link.$delimiter.$i, $linkColumn)){ return $link.$delimiter.$i; } } } return $link.$delimiter.$num; } } if(!empty($options['unique']['directory'])){ $param = $options['delimiter']; $list = glob($options['unique']['directory'].$link."*"); $totalFiles = count($list); if($totalFiles == 1){ $link = $link.$options['delimiter'].'1'; } else { if($totalFiles > 1){ $param .= count($list)+1; } if($totalFiles == 0 ){ $param = ''; } $link = $link.$param; } } return $link; } /** * timeAgo * Indicates the elapsed time. * @param string $datetime * @param array|null $translations * @return string */ public function timeAgo($datetime, $translations=[]) { $now = new DateTime(); $ago = new DateTime((string)$datetime); $diff = $now->diff($ago); $diff->w = floor($diff->d / 7); $diff->d -= $diff->w * 7; $translations['a'] = (isset($translations['a'])) ? $translations['a'] : 'ago'; $translations['p'] = (isset($translations['p'])) ? $translations['p'] : 's'; $translations['j'] = (isset($translations['j'])) ? $translations['j'] : 'just now'; $translations['f'] = (isset($translations['f'])) ? $translations['f'] : false; $string = array( 'y' => (!isset($translations['y'])) ? 'year' : $translations['y'], 'm' => (!isset($translations['m'])) ? 'month' : $translations['m'], 'w' => (!isset($translations['w'])) ? 'week' : $translations['w'], 'd' => (!isset($translations['d'])) ? 'day' : $translations['d'], 'h' => (!isset($translations['h'])) ? 'hour' : $translations['h'], 'i' => (!isset($translations['i'])) ? 'minute' : $translations['i'], 's' => (!isset($translations['s'])) ? 'second' : $translations['s'], ); foreach ($string as $key => $val) { if ($diff->$key) { $string[$key] = $diff->$key . ' ' . $val . ($diff->$key > 1 ? $translations['p'] : ''); } else { unset($string[$key]); } } if (!$translations['f']){ $string = array_slice($string, 0, 1); } return (!empty($string)) ? implode(', ', $string) . ' '.$translations['a'] : '-'; } /** * Time zones. * List of supported time zones. * @return array */ public function timezones(){ return timezone_identifiers_list(); } /** * Languages * Language abbreviations and country names (with local names) * @return array */ public function languages(){ return $this->json_decode(' {"AB":{"name":"Abkhaz","nativeName":"?????"},"AA":{"name":"Afar","nativeName":"Afaraf"},"AF":{"name":"Afrikaans","nativeName":"Afrikaans"},"AK":{"name":"Akan","nativeName":"Akan"},"SQ":{"name":"Albanian","nativeName":"Shqip"},"AM":{"name":"Amharic","nativeName":"????"},"AR":{"name":"Arabic","nativeName":"???????"},"AN":{"name":"Aragonese","nativeName":"Aragonés"},"HY":{"name":"Armenian","nativeName":"???????"},"AS":{"name":"Assamese","nativeName":"???????"},"AV":{"name":"Avaric","nativeName":"???? ????, ???????? ????"},"AE":{"name":"Avestan","nativeName":"avesta"},"AY":{"name":"Aymara","nativeName":"aymar aru"},"AZ":{"name":"Azerbaijani","nativeName":"az?rbaycan dili"},"BM":{"name":"Bambara","nativeName":"bamanankan"},"BA":{"name":"Bashkir","nativeName":"??????? ????"},"EU":{"name":"Basque","nativeName":"euskara, euskera"},"BE":{"name":"Belarusian","nativeName":"??????????"},"BN":{"name":"Bengali","nativeName":"?????"},"BH":{"name":"Bihari","nativeName":"???????"},"BI":{"name":"Bislama","nativeName":"Bislama"},"BS":{"name":"Bosnian","nativeName":"bosanski jezik"},"BR":{"name":"Breton","nativeName":"brezhoneg"},"BG":{"name":"Bulgarian","nativeName":"????????? ????"},"MY":{"name":"Burmese","nativeName":"?????"},"CA":{"name":"Catalan; Valencian","nativeName":"Català"},"CH":{"name":"Chamorro","nativeName":"Chamoru"},"CE":{"name":"Chechen","nativeName":"??????? ????"},"NY":{"name":"Chichewa; Chewa; Nyanja","nativeName":"chiChe?a, chinyanja"},"ZH":{"name":"Chinese","nativeName":"?? (Zh?ngwén), ??, ??"},"CV":{"name":"Chuvash","nativeName":"????? ?????"},"KW":{"name":"Cornish","nativeName":"Kernewek"},"CO":{"name":"Corsican","nativeName":"corsu, lingua corsa"},"CR":{"name":"Cree","nativeName":"???????"},"HR":{"name":"Croatian","nativeName":"hrvatski"},"CS":{"name":"Czech","nativeName":"?esky, ?e?tina"},"DA":{"name":"Danish","nativeName":"dansk"},"DV":{"name":"Divehi; Dhivehi; Maldivian;","nativeName":"??????"},"NL":{"name":"Dutch","nativeName":"Nederlands, Vlaams"},"EN":{"name":"English","nativeName":"English"},"EO":{"name":"Esperanto","nativeName":"Esperanto"},"ET":{"name":"Estonian","nativeName":"eesti, eesti keel"},"EE":{"name":"Ewe","nativeName":"E?egbe"},"FO":{"name":"Faroese","nativeName":"føroyskt"},"FJ":{"name":"Fijian","nativeName":"vosa Vakaviti"},"FI":{"name":"Finnish","nativeName":"suomi, suomen kieli"},"FR":{"name":"French","nativeName":"français, langue française"},"FF":{"name":"Fula; Fulah; Pulaar; Pular","nativeName":"Fulfulde, Pulaar, Pular"},"GL":{"name":"Galician","nativeName":"Galego"},"KA":{"name":"Georgian","nativeName":"???????"},"DE":{"name":"German","nativeName":"Deutsch"},"EL":{"name":"Greek, Modern","nativeName":"????????"},"GN":{"name":"Guaraní","nativeName":"Avañe?"},"GU":{"name":"Gujarati","nativeName":"???????"},"HT":{"name":"Haitian; Haitian Creole","nativeName":"Kreyòl ayisyen"},"HA":{"name":"Hausa","nativeName":"Hausa, ??????"},"HE":{"name":"Hebrew (modern)","nativeName":"?????"},"HZ":{"name":"Herero","nativeName":"Otjiherero"},"HI":{"name":"Hindi","nativeName":"??????, ?????"},"HO":{"name":"Hiri Motu","nativeName":"Hiri Motu"},"HU":{"name":"Hungarian","nativeName":"Magyar"},"IA":{"name":"Interlingua","nativeName":"Interlingua"},"ID":{"name":"Indonesian","nativeName":"Bahasa Indonesia"},"IE":{"name":"Interlingue","nativeName":"Originally called Occidental; then Interlingue after WWII"},"GA":{"name":"Irish","nativeName":"Gaeilge"},"IG":{"name":"Igbo","nativeName":"As?s? Igbo"},"IK":{"name":"Inupiaq","nativeName":"Iñupiaq, Iñupiatun"},"IO":{"name":"Ido","nativeName":"Ido"},"IS":{"name":"Icelandic","nativeName":"Íslenska"},"IT":{"name":"Italian","nativeName":"Italiano"},"IU":{"name":"Inuktitut","nativeName":"??????"},"JA":{"name":"Japanese","nativeName":"??? (??????????)"},"JV":{"name":"Javanese","nativeName":"basa Jawa"},"KL":{"name":"Kalaallisut, Greenlandic","nativeName":"kalaallisut, kalaallit oqaasii"},"KN":{"name":"Kannada","nativeName":"?????"},"KR":{"name":"Kanuri","nativeName":"Kanuri"},"KS":{"name":"Kashmiri","nativeName":"???????, ???????"},"KK":{"name":"Kazakh","nativeName":"????? ????"},"KM":{"name":"Khmer","nativeName":"?????????"},"KI":{"name":"Kikuyu, Gikuyu","nativeName":"G?k?y?"},"RW":{"name":"Kinyarwanda","nativeName":"Ikinyarwanda"},"KY":{"name":"Kirghiz, Kyrgyz","nativeName":"?????? ????"},"KV":{"name":"Komi","nativeName":"???? ???"},"KG":{"name":"Kongo","nativeName":"KiKongo"},"KO":{"name":"Korean","nativeName":"??? (???), ??? (???)"},"KU":{"name":"Kurdish","nativeName":"Kurdî, ??????"},"KJ":{"name":"Kwanyama, Kuanyama","nativeName":"Kuanyama"},"LA":{"name":"Latin","nativeName":"latine, lingua latina"},"LB":{"name":"Luxembourgish, Letzeburgesch","nativeName":"Lëtzebuergesch"},"LG":{"name":"Luganda","nativeName":"Luganda"},"LI":{"name":"Limburgish, Limburgan, Limburger","nativeName":"Limburgs"},"LN":{"name":"Lingala","nativeName":"Lingála"},"LO":{"name":"Lao","nativeName":"???????"},"LT":{"name":"Lithuanian","nativeName":"lietuvi? kalba"},"LU":{"name":"Luba-Katanga","nativeName":""},"LV":{"name":"Latvian","nativeName":"latvie?u valoda"},"GV":{"name":"Manx","nativeName":"Gaelg, Gailck"},"MK":{"name":"Macedonian","nativeName":"?????????? ?????"},"MG":{"name":"Malagasy","nativeName":"Malagasy fiteny"},"MS":{"name":"Malay","nativeName":"bahasa Melayu, ???? ??????"},"ML":{"name":"Malayalam","nativeName":"??????"},"MT":{"name":"Maltese","nativeName":"Malti"},"MI":{"name":"M?ori","nativeName":"te reo M?ori"},"MR":{"name":"Marathi (Mar??h?)","nativeName":"?????"},"MH":{"name":"Marshallese","nativeName":"Kajin M?aje?"},"MN":{"name":"Mongolian","nativeName":"??????"},"NA":{"name":"Nauru","nativeName":"Ekakair? Naoero"},"NV":{"name":"Navajo, Navaho","nativeName":"Diné bizaad, Dinék?eh?í"},"NB":{"name":"Norwegian Bokmål","nativeName":"Norsk bokmål"},"ND":{"name":"North Ndebele","nativeName":"isiNdebele"},"NE":{"name":"Nepali","nativeName":"??????"},"NG":{"name":"Ndonga","nativeName":"Owambo"},"NN":{"name":"Norwegian Nynorsk","nativeName":"Norsk nynorsk"},"NO":{"name":"Norwegian","nativeName":"Norsk"},"II":{"name":"Nuosu","nativeName":"??? Nuosuhxop"},"NR":{"name":"South Ndebele","nativeName":"isiNdebele"},"OC":{"name":"Occitan","nativeName":"Occitan"},"OJ":{"name":"Ojibwe, Ojibwa","nativeName":"????????"},"CU":{"name":"Old Church Slavonic, Church Slavic, Church Slavonic, Old Bulgarian, Old Slavonic","nativeName":"????? ??????????"},"OM":{"name":"Oromo","nativeName":"Afaan Oromoo"},"OR":{"name":"Oriya","nativeName":"?????"},"OS":{"name":"Ossetian, Ossetic","nativeName":"???? æ????"},"PA":{"name":"Panjabi, Punjabi","nativeName":"??????, ???????"},"PI":{"name":"P?li","nativeName":"????"},"FA":{"name":"Persian","nativeName":"?????"},"PL":{"name":"Polish","nativeName":"polski"},"PS":{"name":"Pashto, Pushto","nativeName":"????"},"PT":{"name":"Portuguese","nativeName":"Português"},"QU":{"name":"Quechua","nativeName":"Runa Simi, Kichwa"},"RM":{"name":"Romansh","nativeName":"rumantsch grischun"},"RN":{"name":"Kirundi","nativeName":"kiRundi"},"RO":{"name":"Romanian, Moldavian, Moldovan","nativeName":"român?"},"RU":{"name":"Russian","nativeName":"??????? ????"},"SA":{"name":"Sanskrit (Sa?sk?ta)","nativeName":"?????????"},"SC":{"name":"Sardinian","nativeName":"sardu"},"SD":{"name":"Sindhi","nativeName":"??????, ????? ??????"},"SE":{"name":"Northern Sami","nativeName":"Davvisámegiella"},"SM":{"name":"Samoan","nativeName":"gagana faa Samoa"},"SG":{"name":"Sango","nativeName":"yângâ tî sängö"},"SR":{"name":"Serbian","nativeName":"?????? ?????"},"GD":{"name":"Scottish Gaelic; Gaelic","nativeName":"Gàidhlig"},"SN":{"name":"Shona","nativeName":"chiShona"},"SI":{"name":"Sinhala, Sinhalese","nativeName":"?????"},"SK":{"name":"Slovak","nativeName":"sloven?ina"},"SL":{"name":"Slovene","nativeName":"sloven??ina"},"SO":{"name":"Somali","nativeName":"Soomaaliga, af Soomaali"},"ST":{"name":"Southern Sotho","nativeName":"Sesotho"},"ES":{"name":"Spanish; Castilian","nativeName":"español, castellano"},"SU":{"name":"Sundanese","nativeName":"Basa Sunda"},"SW":{"name":"Swahili","nativeName":"Kiswahili"},"SS":{"name":"Swati","nativeName":"SiSwati"},"SV":{"name":"Swedish","nativeName":"svenska"},"TA":{"name":"Tamil","nativeName":"?????"},"TE":{"name":"Telugu","nativeName":"??????"},"TG":{"name":"Tajik","nativeName":"??????, to?ik?, ???????"},"TH":{"name":"Thai","nativeName":"???"},"TI":{"name":"Tigrinya","nativeName":"????"},"BO":{"name":"Tibetan Standard, Tibetan, Central","nativeName":"???????"},"TK":{"name":"Turkmen","nativeName":"Türkmen, ???????"},"TL":{"name":"Tagalog","nativeName":"Wikang Tagalog, ????? ??????"},"TN":{"name":"Tswana","nativeName":"Setswana"},"TO":{"name":"Tonga (Tonga Islands)","nativeName":"faka Tonga"},"TR":{"name":"Turkish","nativeName":"Türkçe"},"TS":{"name":"Tsonga","nativeName":"Xitsonga"},"TT":{"name":"Tatar","nativeName":"???????, tatarça, ????????"},"TW":{"name":"Twi","nativeName":"Twi"},"TY":{"name":"Tahitian","nativeName":"Reo Tahiti"},"UG":{"name":"Uighur, Uyghur","nativeName":"Uy?urq?, ?????????"},"UK":{"name":"Ukrainian","nativeName":"??????????"},"UR":{"name":"Urdu","nativeName":"????"},"UZ":{"name":"Uzbek","nativeName":"zbek, ?????, ???????"},"VE":{"name":"Venda","nativeName":"Tshiven?a"},"VI":{"name":"Vietnamese","nativeName":"Ti?ng Vi?t"},"VO":{"name":"Volapük","nativeName":"Volapük"},"WA":{"name":"Walloon","nativeName":"Walon"},"CY":{"name":"Welsh","nativeName":"Cymraeg"},"WO":{"name":"Wolof","nativeName":"Wollof"},"FY":{"name":"Western Frisian","nativeName":"Frysk"},"XH":{"name":"Xhosa","nativeName":"isiXhosa"},"YI":{"name":"Yiddish","nativeName":"??????"},"YO":{"name":"Yoruba","nativeName":"Yorùbá"},"ZA":{"name":"Zhuang, Chuang","nativeName":"Sa? cue??, Saw cuengh"}}'); } /** * currencies * Currencies and country names * @return array */ public function currencies(){ return array("AED" => "United Arab Emirates dirham","AFN" => "Afghan afghani","ALL" => "Albanian lek","AMD" => "Armenian dram","ANG" => "Netherlands Antillean guilder","AOA" => "Angolan kwanza","ARS" => "Argentine peso","AUD" => "Australian dollar","AWG" => "Aruban florin","AZN" => "Azerbaijani manat","BAM" => "Bosnia and Herzegovina convertible mark","BBD" => "Barbados dollar","BDT" => "Bangladeshi taka","BGN" => "Bulgarian lev","BHD" => "Bahraini dinar","BIF" => "Burundian franc","BMD" => "Bermudian dollar","BND" => "Brunei dollar","BOB" => "Boliviano","BRL" => "Brazilian real","BSD" => "Bahamian dollar","BTN" => "Bhutanese ngultrum","BWP" => "Botswana pula","BYN" => "New Belarusian ruble","BYR" => "Belarusian ruble","BZD" => "Belize dollar","CAD" => "Canadian dollar","CDF" => "Congolese franc","CHF" => "Swiss franc","CLF" => "Unidad de Fomento","CLP" => "Chilean peso","CNY" => "Renminbi|Chinese yuan","COP" => "Colombian peso","CRC" => "Costa Rican colon","CUC" => "Cuban convertible peso","CUP" => "Cuban peso","CVE" => "Cape Verde escudo","CZK" => "Czech koruna","DJF" => "Djiboutian franc","DKK" => "Danish krone","DOP" => "Dominican peso","DZD" => "Algerian dinar","EGP" => "Egyptian pound","ERN" => "Eritrean nakfa","ETB" => "Ethiopian birr","EUR" => "Euro","FJD" => "Fiji dollar","FKP" => "Falkland Islands pound","GBP" => "Pound sterling","GEL" => "Georgian lari","GHS" => "Ghanaian cedi","GIP" => "Gibraltar pound","GMD" => "Gambian dalasi","GNF" => "Guinean franc","GTQ" => "Guatemalan quetzal","GYD" => "Guyanese dollar","HKD" => "Hong Kong dollar","HNL" => "Honduran lempira","HRK" => "Croatian kuna","HTG" => "Haitian gourde","HUF" => "Hungarian forint","IDR" => "Indonesian rupiah","ILS" => "Israeli new shekel","INR" => "Indian rupee","IQD" => "Iraqi dinar","IRR" => "Iranian rial","ISK" => "Icelandic króna","JMD" => "Jamaican dollar","JOD" => "Jordanian dinar","JPY" => "Japanese yen","KES" => "Kenyan shilling","KGS" => "Kyrgyzstani som","KHR" => "Cambodian riel","KMF" => "Comoro franc","KPW" => "North Korean won","KRW" => "South Korean won","KWD" => "Kuwaiti dinar","KYD" => "Cayman Islands dollar","KZT" => "Kazakhstani tenge","LAK" => "Lao kip","LBP" => "Lebanese pound","LKR" => "Sri Lankan rupee","LRD" => "Liberian dollar","LSL" => "Lesotho loti","LYD" => "Libyan dinar","MAD" => "Moroccan dirham","MDL" => "Moldovan leu","MGA" => "Malagasy ariary","MKD" => "Macedonian denar","MMK" => "Myanmar kyat","MNT" => "Mongolian tögrög","MOP" => "Macanese pataca","MRO" => "Mauritanian ouguiya","MUR" => "Mauritian rupee","MVR" => "Maldivian rufiyaa","MWK" => "Malawian kwacha","MXN" => "Mexican peso","MXV" => "Mexican Unidad de Inversion","MYR" => "Malaysian ringgit","MZN" => "Mozambican metical","NAD" => "Namibian dollar","NGN" => "Nigerian naira","NIO" => "Nicaraguan córdoba","NOK" => "Norwegian krone","NPR" => "Nepalese rupee","NZD" => "New Zealand dollar","OMR" => "Omani rial","PAB" => "Panamanian balboa","PEN" => "Peruvian Sol","PGK" => "Papua New Guinean kina","PHP" => "Philippine peso","PKR" => "Pakistani rupee","PLN" => "Polish z?oty","PYG" => "Paraguayan guaraní","QAR" => "Qatari riyal","RON" => "Romanian leu","RSD" => "Serbian dinar","RUB" => "Russian ruble","RWF" => "Rwandan franc","SAR" => "Saudi riyal","SBD" => "Solomon Islands dollar","SCR" => "Seychelles rupee","SDG" => "Sudanese pound","SEK" => "Swedish krona","SGD" => "Singapore dollar","SHP" => "Saint Helena pound","SLL" => "Sierra Leonean leone","SOS" => "Somali shilling","SRD" => "Surinamese dollar","SSP" => "South Sudanese pound","STD" => "São Tomé and Príncipe dobra","SVC" => "Salvadoran colón","SYP" => "Syrian pound","SZL" => "Swazi lilangeni","THB" => "Thai baht","TJS" => "Tajikistani somoni","TMT" => "Turkmenistani manat","TND" => "Tunisian dinar","TOP" => "Tongan pa?anga","TRY" => "Turkish lira","TTD" => "Trinidad and Tobago dollar","TWD" => "New Taiwan dollar","TZS" => "Tanzanian shilling","UAH" => "Ukrainian hryvnia","UGX" => "Ugandan shilling","USD" => "United States dollar","UYI" => "Uruguay Peso en Unidades Indexadas","UYU" => "Uruguayan peso","UZS" => "Uzbekistan som","VEF" => "Venezuelan bolívar","VND" => "Vietnamese ??ng","VUV" => "Vanuatu vatu","WST" => "Samoan tala","XAF" => "Central African CFA franc","XCD" => "East Caribbean dollar","XOF" => "West African CFA franc","XPF" => "CFP franc","XXX" => "No currency","YER" => "Yemeni rial","ZAR" => "South African rand","ZMW" => "Zambian kwacha","ZWL" => "Zimbabwean dollar" ); } /** * morsealphabet * @param array|null $morseDictionary * @return array */ public function morsealphabet($morseDictionary = array()){ if(!empty($morseDictionary)){ return $morseDictionary; } return array( 'a' => '.-', 'b' => '-...', 'c' => '-.-.', 'ç' => '-.-..', 'd' => '-..', 'e' => '.', 'f' => '..-.', 'g' => '--.', '?' => '--.-.', 'h' => '....', '?' => '..', 'i' => '.-..-', 'j' => '.---', 'k' => '-.-', 'l' => '.-..', 'm' => '--', 'n' => '-.', 'o' => '---', 'ö' => '---.', 'p' => '.--.', 'q' => '--.-', 'r' => '.-.', 's' => '...', '?' => '.--..', 't' => '-', 'u' => '..-', 'ü' => '..--', 'v' => '...-', 'w' => '.--', 'x' => '-..-', 'y' => '-.--', 'z' => '--..', '0' => '-----', '1' => '.----', '2' => '..---', '3' => '...--', '4' => '....-', '5' => '.....', '6' => '-....', '7' => '--...', '8' => '---..', '9' => '----.', '.' => '.-.-.-', ',' => '--..--', '?' => '..--..', '\'' => '.----.', '!'=> '-.-.--', '/'=> '-..-.', '(' => '-.--.', ')' => '-.--.-', '&' => '.-...', ':' => '---...', ';' => '-.-.-.', '=' => '-...-', '+' => '.-.-.', '-' => '-....-', '_' => '..--.-', '"' => '.-..-.', '$' => '...-..-', '@' => '.--.-.', '¿' => '..-.-', '¡' => '--...-', ' ' => '/', ); } /** * Session checking. * * @return array $_SESSSION */ public function session_check(){ if($this->sess_set['status_session']){ if($this->sess_set['path_status']){ if(!is_dir($this->sess_set['path'])){ mkdir($this->sess_set['path']); chmod($this->sess_set['path'], 755); $this->policyMaker(); } if(is_dir($this->sess_set['path'])){ ini_set( 'session.save_path', realpath( dirname(__FILE__) ).'/'.$this->sess_set['path'] ); } } if(!isset($_SESSION)){ session_start(); } } } /** * Learns the size of the remote file. * * @param string $url * @return int */ public function remoteFileSize($url){ $ch = curl_init($url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); curl_setopt($ch, CURLOPT_HEADER, TRUE); curl_setopt($ch, CURLOPT_NOBODY, TRUE); curl_exec($ch); $response_code = curl_getinfo($ch, CURLINFO_RESPONSE_CODE); $size = curl_getinfo($ch, CURLINFO_CONTENT_LENGTH_DOWNLOAD); curl_close($ch); if(!in_array($response_code, array('200'))){ return -1; } return $size; } /** * Layer installer * * @param string|array|null $file * @param string|array|null $cache */ public function addLayer($file = null, $cache = null){ // layer extension $ext = '.php'; // layer set $layers = []; // temporary layers $tempLayers = []; // Cache layers are taken into account if(!is_null($cache) AND !is_array($cache)) $layers[] = $cache; if(!is_null($cache) AND is_array($cache)) foreach($cache as $c) { $layers[] = $c; } // File layers are taken into account if(!is_null($file) AND !is_array($file)) $layers[] = $file; if(!is_null($file) AND is_array($file)) foreach($file as $f) { $layers[] = $f; } // All layers are run sequentially foreach ($layers as $key => $layer) { $tempLayers[$key] = $this->wayMaker($layer); } // Layers are being processed foreach ($tempLayers as $layer) { // Checking for layer existence if(file_exists($layer['way'].$ext)) require_once($layer['way'].$ext); // The class name is extracted from the layer path $className = basename($layer['way']); // If the class exists, it is assigned to the variable if(class_exists($className)){ $class = new $className(); // If the method exists, it is executed. if(isset($layer['params'])){ foreach ($layer['params'] as $param) { $class->$param(); } } } } } /** * Column sql syntax creator. * * @param array $scheme * @param string $funcName * @return array */ public function columnSqlMaker($scheme, $funcName=null){ $sql = []; $column = []; $primary_key = null; foreach (array_values($scheme) as $array_value) { $column = $this->wayMaker($array_value); $type = (isset($column['params'][0])) ? $column['params'][0] : 'small'; switch ($type) { case 'int': switch ($this->db['drive']) { case 'mysql': $value = (isset($column['params'][1])) ? $column['params'][1] : 11; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD `'.$column['way'].'` INT('.$value.') NULL DEFAULT NULL' : '`'.$column['way'].'` INT('.$value.') NULL DEFAULT NULL'; break; case 'sqlsrv': $value = (isset($column['params'][1])) ? $column['params'][1] : 11; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' INT NULL DEFAULT NULL' : $column['way'].' INT NULL DEFAULT NULL'; break; case 'sqlite': $value = (isset($column['params'][1])) ? $column['params'][1] : 11; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD COLUMN `'.$column['way'].'` INT('.$value.') NULL DEFAULT NULL' : '`'.$column['way'].'` INT('.$value.') NULL DEFAULT NULL'; break; } break; case 'decimal': switch ($this->db['drive']) { case 'mysql': $value = (isset($column['params'][1])) ? $column['params'][1] : '6,2'; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD `'.$column['way'].'` DECIMAL('.$value.') NULL DEFAULT NULL' : '`'.$column['way'].'` DECIMAL('.$value.') NULL DEFAULT NULL'; break; case 'sqlsrv': $value = (isset($column['params'][1])) ? $column['params'][1] : '6,2'; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' DECIMAL('.$value.') NULL DEFAULT NULL' : $column['way'].' DECIMAL('.$value.') NULL DEFAULT NULL'; break; case 'sqlite': $value = (isset($column['params'][1])) ? $column['params'][1] : '6,2'; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD COLUMN `'.$column['way'].'` DECIMAL('.$value.') NULL DEFAULT NULL' : '`'.$column['way'].'` DECIMAL('.$value.') NULL DEFAULT NULL'; break; } break; case 'string': switch ($this->db['drive']) { case 'mysql': $value = (isset($column['params'][1])) ? $column['params'][1] : 255; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD `'.$column['way'].'` VARCHAR('.$value.') NULL DEFAULT NULL' : '`'.$column['way'].'` VARCHAR('.$value.') NULL DEFAULT NULL'; break; case 'sqlsrv': $value = (isset($column['params'][1])) ? $column['params'][1] : 255; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' NVARCHAR('.$value.') NULL DEFAULT NULL' : $column['way'].' NVARCHAR('.$value.') NULL DEFAULT NULL'; break; case 'sqlite': $value = (isset($column['params'][1])) ? $column['params'][1] : 255; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD COLUMN `'.$column['way'].'` VARCHAR('.$value.') NULL DEFAULT NULL' : '`'.$column['way'].'` VARCHAR('.$value.') NULL DEFAULT NULL'; break; } break; case 'small': switch ($this->db['drive']) { case 'mysql': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD `'.$column['way'].'` TEXT NULL DEFAULT NULL' : '`'.$column['way'].'` TEXT NULL DEFAULT NULL'; break; case 'sqlsrv': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' NVARCHAR(MAX) NULL DEFAULT NULL' : $column['way'].' NVARCHAR(MAX) NULL DEFAULT NULL'; break; case 'sqlite': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD COLUMN `'.$column['way'].'` TEXT NULL DEFAULT NULL' : '`'.$column['way'].'` TEXT NULL DEFAULT NULL'; break; } break; case 'medium': switch ($this->db['drive']) { case 'mysql': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD `'.$column['way'].'` MEDIUMTEXT NULL DEFAULT NULL' : '`'.$column['way'].'` MEDIUMTEXT NULL DEFAULT NULL'; break; case 'sqlsrv': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' NTEXT NULL DEFAULT NULL' : $column['way'].' NTEXT NULL DEFAULT NULL'; break; case 'sqlite': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD COLUMN `'.$column['way'].'` MEDIUMTEXT NULL DEFAULT NULL' : '`'.$column['way'].'` MEDIUMTEXT NULL DEFAULT NULL'; break; } break; case 'large': switch ($this->db['drive']) { case 'mysql': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD `'.$column['way'].'` LONGTEXT NULL DEFAULT NULL' : '`'.$column['way'].'` LONGTEXT NULL DEFAULT NULL'; break; case 'sqlsrv': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' NTEXT NULL DEFAULT NULL' : $column['way'].' NTEXT NULL DEFAULT NULL'; break; case 'sqlite': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD COLUMN `'.$column['way'].'` LONGTEXT NULL DEFAULT NULL' : '`'.$column['way'].'` LONGTEXT NULL DEFAULT NULL'; break; } break; case 'increments': switch ($this->db['drive']) { case 'mysql': $value = (isset($column['params'][1])) ? $column['params'][1] : 11; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD `'.$column['way'].'` INT('.$value.') NOT NULL AUTO_INCREMENT FIRST' : '`'.$column['way'].'` INT('.$value.') NOT NULL AUTO_INCREMENT'; $primary_key = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD PRIMARY KEY (`'.$column['way'].'`)' : 'PRIMARY KEY (`'.$column['way'].'`)'; break; case 'sqlsrv': $value = (isset($column['params'][1])) ? $column['params'][1] : 11; $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' INT PRIMARY KEY IDENTITY(1,1) NOT NULL' : $column['way'].' INT IDENTITY(1,1) NOT NULL'; // $primary_key = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD '.$column['way'].' INT PRIMARY KEY IDENTITY(1,1) NOT NULL' : $column['way'].' INT IDENTITY(1,1) NOT NULL'; break; case 'sqlite': $sql[] = (!is_null($funcName) AND $funcName == 'columnCreate') ? 'ADD COLUMN `'.$column['way'].'` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL' : '`'.$column['way'].'` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL'; break; } break; } } // for mysql if(!is_null($primary_key)){ $sql[] = $primary_key; } return $sql; } /** * Layer and method parser. * * @param string $str * @return array */ public function wayMaker($str=''){ // The output variable is being created. $output = []; // The parameter variable is being created. $assets = []; // The layer and parameter are being parsed. if(strstr($str, ':')){ $assets = explode(':', trim($str, ':')); } else { $assets[] = $str; } // If there is no layer parameter, only the layer is defined if(count($assets) == 1){ $output['way'] = $assets[0]; } // If there is a layer and its parameter, it is assigned to the variable. if(count($assets) == 2){ list($output['way'], $output['params']) = $assets; } // Parameters are obtained if(isset($output['params'])){ $output['params'] = (strstr($output['params'], '@')) ? explode('@', trim($output['params'], '@')) : $output['params'] = [$output['params']]; } else { $output['params'] = []; } return $output; } /** * Token generator * * @param int $length * @return string */ public function generateToken($length=100){ $key = ''; $keys = array_merge(range('A', 'Z'), range(0, 9), range('a', 'z'), range(0, 9)); for ($i = 0; $i < $length; $i++) { $key .= $keys[array_rand($keys)]; } return $key; } /** * Coordinates marker * * @param string $element * @return string|null It interferes with html elements. */ public function coordinatesMaker($element='#coordinates'){ $element = $this->filter($element); ?> <script> function getLocation() { let = elements = document.querySelectorAll("<?=$element;?>"); if (navigator.geolocation) { navigator.geolocation.getCurrentPosition(redirectToPosition); } else { console.log("Geolocation is not supported by this browser."); elements.forEach(function(element) { element.value = null; }); } } function redirectToPosition(position) { let elements = document.querySelectorAll("<?=$element;?>"); let coordinates = position.coords.latitude+','+position.coords.longitude; if(elements.length >= 1){ elements.forEach(function(element) { if(element.value === undefined){ element.textContent = coordinates; } else { element.value = coordinates; } }); } else { console.log("The item was not found."); } } getLocation(); </script> <?php } /** * Convert size * @param string|int $size * @param string|int $precision * @return string|bool */ public function encodeSize($size, $precision = 2) { $sizeLibrary = array('B', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB'); if(isset($size['size'])){ $size = $size['size']; } $size = (isset($size['size'])) ? $size['size'] : $size; if(!is_numeric($size)){ return false; } if($size == 0){ return '0 B'; } if(!strstr($size, ' ')){ $exp = floor(log($size, 1024)) | 0; $exp = min($exp, count($sizeLibrary) - 1); return round($size / (pow(1024, $exp)), $precision).' '.$sizeLibrary[$exp]; } return false; } /** * Convert byte * @param string|int $size * @return int|bool */ public function decodeSize($size) { $sizeLibrary = array('B', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB'); if(!strstr($size, ' ')){ $key = mb_strlen($size) - 1; if($size[$key] == 'B'){ $size = mb_substr( $size, 0, $key).' B'; } else { $size = mb_substr( $size, 0, $key).' '.$size[$key].'B'; } } if(strstr($size, ' ')){ if(count(explode(' ', $size)) === 2){ list($number, $format) = explode(' ', $size); $id = array_search($format, $sizeLibrary); return $number*pow(1024, $id); } } return false; } /** * to seconds * @param string $time * @return int|bool */ public function toSeconds($time){ if(strstr($time, ':')){ $timeArr = explode(':', $time); if(count($timeArr) < 2){ return false; } list($hours, $mins, $secs) = (count($timeArr) === 3) ? $timeArr : [$timeArr[0], $timeArr[1], 00]; if(!is_numeric($hours) OR !is_numeric($mins) OR !is_numeric($secs)){ return false; } if($mins>59 OR $secs>59){ return false; } return ($hours * 3600 ) + ($mins * 60 ) + $secs; } return false; } /** * to time * @param int $seconds * @return string|bool */ public function toTime($seconds){ if(is_numeric($seconds)){ $hours = floor($seconds / 3600); $mins = floor(($seconds - ($hours * 3600)) / 60); $secs = $seconds - ($hours * 3600) - ($mins * 60); return sprintf('%02d:%02d:%02d', $hours, $mins, $secs); } return false; } /** * Summary * @param string $str * @param int $length * @param string $more * @return string */ public function summary($str, $length, $more = ''){ return mb_substr($str, 0, $length, 'utf-8').((mb_strlen($str, 'utf-8') > $length) ? $more : ''); } /** * @return string */ public function getIPAddress(){ if($_SERVER['REMOTE_ADDR'] === '::1'){ $_SERVER['REMOTE_ADDR'] = '127.0.0.1'; } return $_SERVER['REMOTE_ADDR']; } /** * @return string */ public function getLang(){ return mb_strtoupper(mb_substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2)); } /** * getAddressCode * * @param string|array $address * @param string|array|null $status * @return array */ public function getAddressCode($address, $status=null){ $result = array(); $statusList = array(); if(!is_array($address)){ $address = array($address); } if(!is_null($status)){ if(!is_array($status)){ $status = array($status); } foreach ($status as $key => $code) { if(!in_array($code, $this->addressCodeList())){ return $result; } else { $statusList[] = $code; } } } else { $statusList = $this->addressCodeList(); } $mh = curl_multi_init(); foreach($address as $key => $value){ $ch[$key] = curl_init($value); curl_setopt($ch[$key], CURLOPT_TIMEOUT, 1); curl_setopt($ch[$key], CURLOPT_HEADER, 0); curl_setopt($ch[$key], CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch[$key], CURLOPT_TIMEOUT, 1); curl_setopt($ch[$key], CURLOPT_VERBOSE, 0); curl_multi_add_handle($mh, $ch[$key]); } do { curl_multi_exec($mh, $running); curl_multi_select($mh); } while ($running > 0); foreach(array_keys($ch) as $key){ $httpcode = curl_getinfo($ch[$key], CURLINFO_HTTP_CODE); if(in_array($httpcode, $statusList)){ $result[$key] = array( 'code' => $httpcode, 'address' => $address[$key], 'timestamp' => $this->timestamp ); } curl_multi_remove_handle($mh, $ch[$key]); } curl_multi_close($mh); return $result; } /** * addressCodeList * @return array * */ public function addressCodeList(){ // Codes collected from http://en.wikipedia.org/wiki/List_of_HTTP_status_codes return array(0,100,101,102,200,201,202,203,204,205,206,207,208,226,300,301,302,303,304,305,306,307,308,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,422,423,424,425,426,428,429,431,444,449,450,451,494,495,496,497,499,500,501,502,503,504,505,506,507,508,509,510,511,598,599); } /** * Address Generator * */ public function addressGenerator($start, $end, $type="ipv4"){ $result = array(); if(empty($type)){ return $result; } switch ($type) { case 'ipv4': if(!$this->is_ipv4($start) OR !$this->is_ipv4($end)){ return $result; } if($start>$end){ $x = $start; $start = $end; $end = $x; unset($x); } list($aa, $bb, $cc, $dd) = explode('.', $start); for ($a=$aa; $a <= 255; $a++) { for ($b=$bb; $b <= 255; $b++) { for ($c=$cc; $c <= 255; $c++) { for ($d=$dd; $d <= 255; $d++) { if ($a.'.'.$b.'.'.$c.'.'.$d == $end) { $result[] = $a.'.'.$b.'.'.$c.'.'.$d; break; } $result[] = $a.'.'.$b.'.'.$c.'.'.$d; $dd = 0; } if ($a.'.'.$b.'.'.$c.'.'.$d == $end) { break; } $cc = 0; } if ($a.'.'.$b.'.'.$c.'.'.$d == $end) { break; } $bb = 0; } if ($a.'.'.$b.'.'.$c.'.'.$d == $end) { break; } $aa = 0; } break; } return $result; } /** * Detecting an operating system * @return string */ public function getOS(){ $os = PHP_OS; switch (true) { case stristr($os, 'dar'): return 'Darwin'; case stristr($os, 'win'): return 'Windows'; case stristr($os, 'lin'): return 'Linux'; default : return 'Unknown'; } } /** * Detecting an server software * @return string */ public function getSoftware(){ $software = $_SERVER['SERVER_SOFTWARE']; switch (true) { case stristr($software, 'apac'): return 'Apache'; case stristr($software, 'micr'): return 'Microsoft-IIS'; case stristr($software, 'lites'): return 'LiteSpeed'; case stristr($software, 'nginx'): return 'Nginx'; default : return 'Unknown'; } } /** * Client browser identifier. */ public function getBrowser($agent=null){ $browserName = 'Unknown'; $_SERVER['HTTP_USER_AGENT'] = empty($_SERVER['HTTP_USER_AGENT']) ? $browserName : $_SERVER['HTTP_USER_AGENT']; $agent = ($agent!=null) ? $agent : $_SERVER['HTTP_USER_AGENT']; if(preg_match('/Edg/i',$agent)) { $browserName = "Edge"; } elseif(preg_match('/OPR/i',$agent)) { $browserName = "Opera"; } elseif(preg_match('/Firefox/i',$agent)) { $browserName = "Firefox"; } elseif(preg_match('/Chrome/i',$agent)) { $browserName = "Chrome"; } elseif(preg_match('/Safari/i',$agent)) { $browserName = "Safari"; } return $browserName; } /** * Routing manager. * * @param string $uri * @param mixed $file * @param mixed $cache * @return bool */ public function route($uri, $file, $cache=null){ // Access directives are being created. $this->policyMaker(); if(empty($file)){ return false; } if($this->base_url != '/'){ $request = str_replace($this->base_url, '', rawurldecode($_SERVER['REQUEST_URI'])); } else { $request = trim(rawurldecode($_SERVER['REQUEST_URI']), '/'); } $fields = array(); if(!empty($uri)){ $uriData = $this->wayMaker($uri); if(!empty($uriData['way'])){ $uri = $uriData['way']; } if(!empty($uriData['params'])){ $fields = $uriData['params']; } } if($uri == '/'){ $uri = $this->base_url; } $params = array(); if($_SERVER['REQUEST_METHOD'] != 'POST'){ if(strstr($request, '/')){ $params = explode('/', $request); $UriParams = explode('/', $uri); if(count($params) >= count($UriParams)){ for ($key = 0; count($UriParams) > $key; $key++){ unset($params[$key]); } } $params = array_values($params); } $this->post = array(); if(!empty($fields) AND !empty($params)){ foreach ($fields as $key => $field) { if(isset($params[$key])){ if(!empty($params[$key]) OR $params[$key] == '0'){ $this->post[$field] = $params[$key]; } } } } else { $this->post = array_diff($params, array('', ' ')); } } if(!empty($request)){ if(!empty($params)){ $uri .= '/'.implode('/', $params); } if($request == $uri){ $this->error_status = false; $this->page_current = $uri; $this->addLayer($file, $cache); exit(); } $this->error_status = true; } else { if($uri == $this->base_url) { $this->error_status = false; $this->page_current = $uri; $this->addLayer($file, $cache); exit(); } } } /** * File writer. * * @param array $data * @param string $filePath * @param string $delimiter * @return bool */ public function write($data, $filePath, $delimiter = ':') { if(is_array($data)){ $content = implode($delimiter, $data); } else { $content = $data; } if(isset($content)){ $dirPath = $this->info($filePath, 'dirname'); if(!empty($dirPath)){ if(!is_dir($dirPath)){ mkdir($dirPath, 0777, true); } } if(!file_exists($filePath)){ touch($filePath); } if(file_exists($filePath)){ $fileName = fopen($filePath, "a+"); fwrite($fileName, $content."\r\n"); fclose($fileName); } return true; } return false; } /** * File uploader. * * @param array $files * @param string $path * @param bool $force * @return array */ public function upload($files, $path, $force=false){ $result = array(); if(isset($files['name'])){ $files = array($files);} if(!is_dir($path)){ mkdir($path, 0777, true); } foreach ($files as $file) { #Path syntax correction for Windows. $tmp_name = str_replace('\\\\', '\\', $file['tmp_name']); $file['tmp_name'] = $tmp_name; $xtime = gettimeofday(); $xdat = date('d-m-Y g:i:s').$xtime['usec']; $ext = $this->info($file['name'], 'extension'); if($force){ $newpath = $path.md5($xdat).'.'.$ext; } else { $options = array('unique'=>array('directory'=>$path)); $newpath = $path.$this->permalink($this->info($file['name'], 'filename'), $options).'.'.$ext; if(in_array($newpath, $result)){ $newpath = $path.$this->permalink($this->info($file['name'], 'filename'), $options).'_'.$this->generateToken(8).'.'.$ext; } } if(move_uploaded_file($file['tmp_name'], $newpath)){ $result[] = $newpath; } } return $result; } /** * File downloader. * * @param mixed $links * @param array $opt * @return array */ public function download($links, $opt = array()) { $result = array(); $nLinks = array(); if(empty($links)){ return $result; } if(!is_array($links)){ $links = array($links); } foreach($links as $link) { if($this->is_url($link)){ if($this->remoteFileSize($link)>1){ $nLinks[] = $link; } } if(!$this->is_url($link)){ if(!strstr($link, '://')){ if(file_exists($link)){ $nLinks[] = $link; } } } } if(count($nLinks) != count($links)){ return $result; } $path = ''; if(!empty($opt['path'])){ $path .= $opt['path']; if(!is_dir($path)){ mkdir($path, 0777, true); } } else { $path .= './download'; } foreach ($nLinks as $nLink) { $destination = $path; $other_path = $this->permalink($this->info($nLink, 'basename')); if(!is_dir($destination)){ mkdir($destination, 0777, true); } if(file_exists($destination.'/'.$other_path)){ $remote_file = $this->remoteFileSize($nLink); $local_file = filesize($destination.'/'.$other_path); if($remote_file != $local_file){ unlink($destination.'/'.$other_path); copy($nLink, $destination.'/'.$other_path); } } else { copy($nLink, $destination.'/'.$other_path); } $result[] = $destination.'/'.$other_path; } return $result; } /** * Content researcher. * * @param string $left * @param string $right * @param string $url * @param array $options * @return array|string */ public function get_contents($left, $right, $url, $options=array()){ $result = array(); if($this->is_url($url)) { $ch = curl_init(); curl_setopt($ch,CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HEADER, false); $defaultHeader = array( "Accept-Language" => $_SERVER['HTTP_ACCEPT_LANGUAGE'], "Connection" => "keep-alive" ); if(!empty($options['authorization'])){ curl_setopt($ch, CURLOPT_USERPWD, $options['authorization']['username'] . ":" . $options['authorization']['password']); } if(!empty($options['attachment'])){ $options['post']['file'] = new CURLFile($options['attachment']); $defaultHeader['Content-Type'] = 'multipart/form-data'; } if(isset($options['header'])){ foreach ($options['header'] as $column => $value) { $defaultHeader[] = $column.':'.$value; } } curl_setopt($ch, CURLOPT_HTTPHEADER, $defaultHeader); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE); curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); if($this->sess_set['status_session']){ if(!$this->sess_set['path_status']){ $this->sess_set['path'] = sys_get_temp_dir().'/'; } if(!stristr($this->getSoftware(), 'mic') AND strstr(dirname(__FILE__),'\\')){ curl_setopt($ch, CURLOPT_COOKIEJAR, dirname(__FILE__). '/'.$this->sess_set['path'].'cookie.txt'); curl_setopt($ch, CURLOPT_COOKIEFILE, dirname(__FILE__). '/'.$this->sess_set['path'].'cookie.txt'); }else{ curl_setopt($ch, CURLOPT_COOKIEJAR, $this->sess_set['path'].'cookie.txt'); curl_setopt($ch, CURLOPT_COOKIEFILE, $this->sess_set['path'].'cookie.txt'); } } if(!empty($options['post'])){ curl_setopt($ch, CURLOPT_POST, true); if(is_array($options['post']) AND !isset($options['attachment'])){ $options['post'] = http_build_query($options['post']); } curl_setopt($ch, CURLOPT_POSTFIELDS, $options['post']); } if(!empty($options['referer'])){ curl_setopt($ch, CURLOPT_REFERER, $options['referer']); } if(!isset($options['header']['User-Agent'])){ curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); } $data = curl_exec($ch); curl_close($ch); if(empty($data)){ $data = file_get_contents($url); } } else { $data = $url; } if($left === '' AND $right === ''){ return $data; } $content = str_replace(array("\n", "\r", "\t"), '', $data); if(preg_match_all('/'.preg_quote($left, '/').'(.*?)'.preg_quote($right, '/').'/i', $content, $result)){ if(!empty($result)){ return $result[1]; } else { return $result; } } if(is_array($result)){ if(empty($result[0]) AND empty($result[1])){ return []; } } return $result; } /** * Absolute path syntax * * @param string $path * @return string */ public function get_absolute_path($path) { $path = str_replace(array('/', '\\'), DIRECTORY_SEPARATOR, $path); $parts = array_filter(explode(DIRECTORY_SEPARATOR, $path), 'strlen'); $absolutes = array(); foreach ($parts as $part) { if ('.' == $part) continue; if ('..' == $part) { array_pop($absolutes); } else { $absolutes[] = $part; } } $outputdir = implode(DIRECTORY_SEPARATOR, $absolutes); if(strstr($outputdir, '\\')){ $outputdir = str_replace('\\', '/', $outputdir); } return $outputdir; } /** * * Calculates the distance between two points, given their * latitude and longitude, and returns an array of values * of the most common distance units * {m, km, mi, ft, yd} * * @param float|int|string $lat1 Latitude of the first point * @param float|int|string $lon1 Longitude of the first point * @param float|int|string $lat2 Latitude of the second point * @param float|int|string $lon2 Longitude of the second point * @return mixed {bool|array} */ public function distanceMeter($lat1, $lon1, $lat2, $lon2, $type = '') { $output = array(); // koordinat de?illerse false yan?t? döndürülür. if(!$this->is_coordinate($lat1, $lon1) OR !$this->is_coordinate($lat2, $lon2)){ return false; } // ayn? koordinatlar belirtilmi? ise false yan?t? döndürülür. if (($lat1 == $lat2) AND ($lon1 == $lon2)) { return false; } // dereceden radyana dönü?türme i?lemi $latFrom = deg2rad($lat1); $lonFrom = deg2rad($lon1); $latTo = deg2rad($lat2); $lonTo = deg2rad($lon2); $lonDelta = $lonTo - $lonFrom; $a = pow(cos($latTo) * sin($lonDelta), 2) + pow(cos($latFrom) * sin($latTo) - sin($latFrom) * cos($latTo) * cos($lonDelta), 2); $b = sin($latFrom) * sin($latTo) + cos($latFrom) * cos($latTo) * cos($lonDelta); $angle = atan2(sqrt($a), $b); $meters = $angle * 6371000; $kilometers = $meters / 1000; $miles = $meters * 0.00062137; $feet = $meters * 3.2808399; $yards = $meters * 1.0936; $data = array( 'm' => round($meters, 2), 'km' => round($kilometers, 2), 'mi' => round($miles, 2), 'ft' => round($feet, 2), 'yd' => round($yards, 2) ); // e?er ölçü birimi bo?sa tüm ölçülerle yan?t verilir if(empty($type)){ return $data; } // e?er ölçü birimi string ise ve müsaade edilen bir ölçüyse diziye eklenir if(!is_array($type) AND in_array($type, array_keys($data))){ $type = array($type); } // e?er ölçü birimi dizi de?ilse ve müsaade edilen bir ölçü de?ilse bo? dizi geri döndürülür if(!is_array($type) AND !in_array($type, array_keys($data))){ return $output; } // gönderilen tüm ölçü birimlerinin do?rulu?u kontrol edilir foreach ($type as $name){ if(!in_array($name, array_keys($data))){ return $output; } } // gönderilen ölçü birimlerinin yan?tlar? haz?rlan?r foreach ($type as $name){ $output[$name] = $data[$name]; } // tek bir ölçü birimi gönderilmi? ise sadece onun de?eri geri döndürülür if(count($type)==1){ $name = implode('', $type); return $output[$name]; } // birden çok ölçü birimi yan?tlar? geri döndürülür return $output; } /** * It is used to run Php codes. * * @param string $code * @return void */ public function evalContainer($code){ if($this->is_htmlspecialchars($code)){ $code = htmlspecialchars_decode($code); } ob_start(); eval('?>'. $code); $output = ob_get_contents(); ob_end_clean(); echo $output; } /** * safeContainer * * @param string $str * @param string|array|null $rule * @return string */ public function safeContainer($str, $rule=null){ if($this->is_htmlspecialchars($str)){ $str = htmlspecialchars_decode($str); } $rules = array(); $rulesList = array('inlinejs', 'inlinecss', 'tagjs', 'tagcss', 'iframe'); if(!is_null($rule)){ if(!is_array($rule)){ $rules = array($rule); } else { foreach($rule as $rul){ if(in_array($rul, $rulesList)){ $rules[] = $rul; } } } } if(!in_array('inlinejs', $rules)){ $str = preg_replace('/(<.+?)(?<=\s)on[a-z]+\s*=\s*(?:([\'"])(?!\2).+?\2|(?:\S+?\(.*?\)(?=[\s>])))(.*?>)/i', "$1$3", $str); } if(!in_array('inlinecss', $rules)){ $str = preg_replace('/(<[^>]*) style=("[^"]+"|\'[^\']+\')([^>]*>)/i', '$1$3', $str); } if(!in_array('tagjs', $rules)){ $str = preg_replace('/<script\b[^>]*>(.*?)<\/script>/is', '', $str); $str = preg_replace('/<link\b[^>]*.js(.*?)>/is', '', $str); } if(!in_array('tagcss', $rules)){ $str = preg_replace('/<\s*style.+?<\s*\/\s*style.*?>/si', '', $str); $str = preg_replace('/<link\b[^>]*.css(.*?)>/is', '', $str); } if(!in_array('iframe', $rules)){ $str = preg_replace('/<iframe.*?\/iframe>/i','', $str); } return $str; } /** * Morse encode * @param string $str * @param array|null $morseDictionary * @return string */ public function morse_encode($str, $morseDictionary=array()){ $output = ''; if(empty($morseDictionary)){ $morseDictionary = $this->morsealphabet(); } else { $morseDictionary = $this->morsealphabet($morseDictionary); } $str = mb_strtolower($str); for ($i = 0; $i < mb_strlen($str); $i++) { $key = mb_substr($str, $i, 1); if(isset($morseDictionary[$key])){ $output .= $morseDictionary[$key].' '; } else { $output .= '# '; } } return trim($output); } /** * Morse decode * @param string $morse * @param array|null $morseDictionary * @return string */ public function morse_decode($morse, $morseDictionary=array()){ $output = ''; if($morse === ' '){ return '/'; } if(empty($morseDictionary)){ $morseDictionary = array_flip($this->morsealphabet()); } else { $morseDictionary = array_flip($this->morsealphabet($morseDictionary)); } foreach (explode(' ', $morse) as $value) { if(isset($morseDictionary[$value])){ $output .= $morseDictionary[$value]; } else { $output .= '#'; } } return $output; } /** * String to Binary * @param string $string * @return int|string */ public function stringToBinary($string){ $characters = str_split($string); $binary = []; foreach ($characters as $character) { $data = unpack('H*', $character); $binary[] = base_convert($data[1], 16, 2); } return implode(' ', $binary); } /** * Binary to String * @param int|string * @return string */ public function binaryToString($binary){ $binaries = explode(' ', $binary); $string = null; foreach ($binaries as $binary) { $string .= pack('H*', dechex(bindec($binary))); } return $string; } /** * hexToBinary * @param string $hexstr * @return string */ public function hexToBinary($hexstr) { $n = strlen($hexstr); $sbin=""; $i=0; while($i<$n){ $a = substr($hexstr,$i,2); $c = pack("H*",$a); if ($i==0){ $sbin=$c; } else { $sbin.=$c; } $i+=2; } return $sbin; } /** * siyakat_encode * @param string $siyakat * @param array $miftah * @return string */ public function siyakat_encode($siyakat, $miftah){ if(empty($miftah)){ return ''; } for ($i=0; $i < count($miftah); $i++) { $siyakat = bin2hex($siyakat); // 1 $siyakat = $this->morse_encode($siyakat, $miftah[$i]); // 2 } return $siyakat; } /** * siyakat_decode * @param string $siyakat * @param array $miftah * @return string */ public function siyakat_decode($siyakat, $miftah){ if(empty($miftah)){ return ''; } $miftah = array_reverse($miftah); for ($i=0; $i < count($miftah); $i++) { $siyakat = $this->morse_decode($siyakat, $miftah[$i]); $siyakat = $this->hexToBinary($siyakat); } return $siyakat; } /** * Abort Page * @param string $code * @param string message * @return void */ public function abort($code, $message){ exit('<!DOCTYPE html><html lang="en"><head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>'.$code.'</title> <style>html, body{background-color: #fff; color: #636b6f; font-family: Arial, Helvetica, sans-serif; font-weight: 100; height: 100vh; margin: 0;}.full-height{height: 100vh;}.flex-center{align-items: center; display: flex; justify-content: center;}.position-ref{position: relative;}.code{border-right: 2px solid; font-size: 26px; padding: 0 15px 0 15px; text-align: center;}.message{font-size: 18px; text-align: center;}div.buttons{position:absolute;margin-top: 60px;}a{color: #333;font-size: 14px;text-decoration: underline;}a:hover{text-decoration:none;}</style></head><body><div class="flex-center position-ref full-height"> <div class="buttons"><a href="'.$this->page_back.'">Back to Page</a>&nbsp;|&nbsp;<a href="'.$this->base_url.'">Home</a></div><div class="code"> '.$code.' </div><div class="message" style="padding: 10px;"> '.$message.' </div></div></body></html>'); } /** * Captcha * @param string|int $level * @param string|int $length * @param string|int $width * @param string|int $height * @return void */ public function captcha($level=3, $length=8, $width=320, $height=60){ $_SESSION['captcha'] = $this->generateToken($length); $im=imagecreatetruecolor(ceil($width/2),ceil($height/2)); $navy=imagecolorAllocate($im,0,0,0); $white=imagecolorallocate($im,255,255,255); $pixelColorList = array( imagecolorallocate($im, 125, 204, 130), // green imagecolorallocate($im, 0, 0, 255), // blue imagecolorallocate($im, 179, 179, 0), // yellow ); $pixelColor = $pixelColorList[rand(0, count($pixelColorList)-1)]; $text_width = imagefontwidth(5) * strlen($_SESSION['captcha']); $center = ceil($width / 4); $x = $center - ceil($text_width / 2); imagestring($im, 5, $x, ceil($height/8), $_SESSION['captcha'], $white); if($level != null){ for($i=0;$i<$level*1000;$i++) { imagesetpixel($im,rand()%$width,rand()%$height,$pixelColor); } } ob_start(); imagepng($im); $image_data = ob_get_contents(); ob_end_clean(); if(!empty($im)){ imagedestroy($im); } ?> <div class="form-group"> <label for="captcha"><img style="height:<?=$height;?>px; min-width:<?=$width;?>px; object-fit: cover;image-rendering:high-quality;image-rendering: auto;image-rendering: crisp-edges;image-rendering: pixelated;" src="data:image/png;base64,<?=base64_encode($image_data);?>"></label><br> <input type="text" id="captcha" name="captcha" class="form-control"> </div> <?php } /** * Folder (including subfolders) and file eraser. * @param string $paths * @return bool */ public function rm_r($paths) { if(!is_array($paths)){ $paths = array($paths); } foreach ($paths as $path) { if(is_file($path)){ return unlink($path); } if(is_dir($path)){ $files = array_diff(scandir($path), array('.','..')); foreach ($files as $file) { $this->rm_r($path.'/'.$file); } return rmdir($path); } else { return false; } } return true; } /** * File and Folder searcher * @param string $dir * @param string $pattern * @param array $matches * @return array */ public function ffsearch($dir, $pattern, $matches=array()){ $dir_list = glob($dir . '*/'); $pattern_match = glob($dir . $pattern); $matches = array_merge($matches, $pattern_match); foreach($dir_list as $directory){ $matches = $this->ffsearch($directory, $pattern, $matches); } return $matches; } /** * json_encode * @param string $data * @return string */ public function json_encode($data, $min = true){ $data = ($min === true) ? json_encode($data, JSON_UNESCAPED_UNICODE) : json_encode($data, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT); return str_replace(['&#039;', '&quot;', '&amp;'], ['\'', '\"', '&'], $data); } /** * json_decode * @param string $data * @return array */ public function json_decode($data){ return json_decode($data, true); } /** * saveAs * It is the method that saves the file differently. * @param string $file_path * @param string|null $filename * @param bool|null $download */ public function saveAs($file_path, $filename=null, $download = true){ $file_path = str_replace('..', '', $file_path); if($this->remoteFileSize($file_path) === false){ $data = $this->get_contents('', '', $file_path); $data = ($data != $file_path) ? $data : file_get_contents($file_path); } else { $data = $file_path; } $mime_type = ($this->is_json($data)) ? 'application/json' : mime_content_type($file_path); $new_filename = (is_null($filename)) ? basename($file_path) : $filename; header('Access-Control-Allow-Origin: *'); header("Content-type: ".$mime_type."; charset=utf-8"); if($download === true){ header('Content-Disposition: attachment; filename="'.$new_filename.'"'); } if(file_exists($file_path) AND is_null($filename) AND $download === false){ $data = readfile($file_path); } echo $data; } }