attempt to reboot the statistics project by recovering and updating.
I havent touched it for almost two years and it was already outdated when i started building it.
I am hopen to clean it up and revive it to use it until i have a new version.
It is worth mentioning that this is already the fourth version of statistics. Every version was designed and written from skratch.
all is manually written as i have learned it myself and done it several years ago.
using MySQL for the database, PHP and jQuery.
It is running on PHP 7 .
- revive project
- running on
PHP 7 - config file (auto setup db tables)
- misterious w (tag input today.php)
- Todo insert js issue
- Timeline insert ID issue
- about page with features
- release v1
- weather api
- daily graph
- remove unsued files and code
- clean ajax.php file
- clean javascript files
- clean/industrie compliant code
- get new weather API
- (using mapbox)
- auto setup
- create mysql tables
- register user
- make it public
- css check up
- encrypted data
- additional features
- dynamic timeline year
- outsource host and path variabel in js files
updating code to be compliant with PHP 7
# MySQL escaping
$mobile = mysql_real_escape_string($mobile);
# Compliant
$mobile = $mysqli->real_escape_string($mobile);
# Get Rows
$result = mysql_fetch_array(mysql_query("SELECT * FROM user ..."));
# Compliant
$result = mysqli_fetch_array(mysqli_query($mysqli, "SELECT * FROM user ..."));
# MySql Fetch Object
$data = mysql_fetch_object($result);
# Compliant
$data = mysqli_fetch_object($result);
#MySQL insert id
$id = mysql_insert_id();
# Compliant
$id = mysqli_insert_id($mysqli);
# MySQL error
mysql_error();
# Compliant
mysqli_error($mysqli);
# MySQL Single Result
mysql_result(mysqli_query(...),0);
# Compliant
mysqli_query(...)->fetch_row()[0] ?? false;
# MySQL Num Rows
mysql_num_rows($result);
# Compliant
mysqli_num_rows($result);
# Charset
mysql_set_charset("utf8");
# Compliant
mysqli_set_charset($mysqli, "utf8");