| Server IP : 147.93.80.58 / Your IP : 216.73.216.188 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/aakashsolution.in/public_html/action/ |
Upload File : |
<?php
$db_host='localhost';
$db_name='u939086737_aakash_sol';
$db_user='u939086737_aakash_sol';
$db_pass='T|a1>U6999Z2';
$con = $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
if (mysqli_connect_error()) {
echo 'connect to database failed';
}
class database
{
private $host='localhost';
private $db='u939086737_aakash_sol';
private $username='u939086737_aakash_sol';
private $password='T|a1>U6999Z2';
private $link;
function __construct()
{
date_default_timezone_set('Asia/Kolkata');
$this->link = new mysqli($this->host, $this->username, $this->password, $this->db);
}
function get_sum($table, $column, $condition) {
$query = "SELECT SUM($column) as total FROM $table WHERE $condition";
$result = mysqli_query($this->link, $query);
$row = mysqli_fetch_assoc($result);
return $row['total'] ?? 0;
}
function insert($table, $columns, $values)
{
$query = "INSERT INTO ";
$query .= $table;
$query .= $columns;
$query .= " VALUES " . $values;
if ($this->link->query($query)) {
return true;
} else {
return mysqli_error($this->link);
}
}
function update($table, $col_values, $where)
{
$query = "UPDATE " . $table . " set ";
$query .= $col_values . " where " . $where;
if ($this->link->query($query)) {
return true;
} else {
return mysqli_error($this->link);
}
}
function delete($table, $where = '')
{
$query = "DELETE from" . $table;
$query .= " where " . $where;
if ($this->link->query($query)) {
return true;
} else {
return mysqli_error($this->link);
}
}
function get_details($table, $column = '', $where = '')
{
$query = "SELECT ";
if ($column != '') {
$query .= $column . " from ";
} else {
$query .= "* from ";
}
$query .= $table;
if ($where != '') {
$query .= " where " . $where;
} else {
$query .= " ";
}
//echo $query;
$run = $this->link->query($query);
if ($run) {
if ($run->num_rows == 1) {
return $run->fetch_assoc();
} else {
return false;
}
} else {
return mysqli_error($this->link);
}
}
function get_count($table, $where = '', $field = '')
{
$query = "SELECT count(";
if ($field != '') {
$query .= $field;
} else {
$query .= "id";
}
$query .= ") as count from " . $table;
if ($where != '') {
$query .= " where " . $where;
} //echo $query;
$run = $this->link->query($query);
if ($run) {
$array = $run->fetch_assoc();
return $array['count'];
} else {
return mysqli_error($this->link);
}
}
function get_rows($table, $column = '', $where = '', $order = '', $limit = '')
{
$query = "SELECT ";
if ($column != '') {
$query .= $column . " from ";
} else {
$query .= "* from ";
}
$query .= $table;
if ($where != '') {
$query .= " where " . $where;
} else {
$query .= " ";
}
if ($order != '') {
$query .= " order by " . $order;
} else {
$query .= " ";
}
if ($limit != '') {
$query .= " limit " . $limit;
} else {
$query .= " ";
}
//echo $query;
$run = $this->link->query($query);
$result = array();
if ($run) {
if ($run->num_rows > 0) {
while ($rows = $run->fetch_assoc()) {
$result[] = $rows;
}
return $result;
} else {
return false;
}
} else {
return mysqli_error($this->link);
}
}
function login($table, $username, $password)
{
$query = "SELECT * from ";
$query .= $table . " where ";
$query .= "`username`='" . $username . "' and `password`='" . $password . "' and `active`='1'";
//$query.="(`username` = '".$username."' or `email` = '".$username."') and `password` = '".md5($password)."' and `active` = '1'";
$run = $this->link->query($query);
if ($run) {
if ($run->num_rows == 1) {
$array = $run->fetch_assoc();
return $array;
} else {
return "Username or Password wrong!!";
}
} else {
return mysqli_error($this->link);
}
}
function get_last_row($table, $column = '', $where = '')
{
$query = "SELECT ";
if ($column != '') {
$query .= $column . " from ";
} else {
$query .= "* from ";
}
$query .= $table;
if ($where != '') {
$query .= " where " . $where;
} else {
$query .= " ";
}
$query .= "order by id desc limit 1";
$run = $this->link->query($query);
if ($run) {
return $array = $run->fetch_assoc();
} else {
return mysqli_error($this->link);
}
}
function getDBConnect()
{
return $this->link;
}
}
class notowords
{
private $ones = array(
"", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten",
"Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen",
"Eighteen", "Nineteen"
);
private $tens = array(
2 => "Twenty", 3 => "Thirty", 4 => "Forty", 5 => "Fifty", 6 => "Sixty", 7 => "Seventy",
8 => "Eighty", 9 => "Ninety"
);
private $words = "";
private $toreturn = "";
private $inwords = "";
private $inhundred = "";
function get_hundred($number)
{
$rem = $number % 100;
$value = $number / 100;
if ($number >= 100) {
if ($value < 10) {
$this->inhundred .= " " . $this->ones[$value] . " Hundred";
}
}
if ($rem != 0 && $rem < 20) {
$this->inhundred .= " " . $this->ones[$rem];
}
if ($rem == 20) {
$this->inhundred .= " " . $this->tens[2];
}
if ($rem != 0 && $rem > 20) {
$rem2 = $rem % 10;
$value2 = $rem / 10;
$return = " " . $this->tens[$value2];
if ($rem2 != 0) {
$return .= " " . $this->ones[$rem2];
}
$this->inhundred .= $return;
}
return $this->inhundred;
}
function get_thousand($number)
{
$rem = $number % 1000;
$value = $number / 1000;
if ($number >= 1000) {
if ($value < 20) {
$this->inwords = " " . $this->ones[$value] . " Thousand";
} elseif ($value >= 20 && $value < 100) {
$rem2 = $value % 10;
$value2 = $value / 10;
$return = $this->tens[$value2];
if ($rem2 != 0) {
$return .= " " . $this->ones[$rem2] . " Thousand";
} else {
$return .= " Thousand";
}
$this->inwords = $return;
}
} else {
$this->inwords = '';
}
return $this->inwords;
}
function get_lakhs($number)
{
$rem = $number % 100000;
$value = $number / 100000;
if ($number >= 100000) {
if ($value < 20) {
$this->inwords = " " . $this->ones[$value] . " Lakh";
} elseif ($value >= 20 && $value < 100) {
$rem2 = $value % 10;
$value2 = $value / 10;
$return = $this->tens[$value2];
if ($rem2 != 0) {
$return .= " " . $this->ones[$rem2] . " Lakh";
} else {
$return .= " Lakh";
}
$this->inwords = $return;
}
} else {
$this->inwords = '';
}
return $this->inwords;
}
function get_crore($number)
{
$rem = $number % 10000000;
$value = $number / 10000000;
if ($number >= 10000000) {
if ($value < 20) {
$this->inwords = " " . $this->ones[$value] . " Crore";
} elseif ($value >= 20 && $value < 100) {
$rem2 = $value % 10;
$value2 = $value / 10;
$return = $this->tens[$value2];
if ($rem2 != 0) {
$return .= " " . $this->ones[$rem2] . " Crore";
} else {
$return .= " Crore";
}
$this->inwords = $return;
}
}
return $this->inwords;
}
function to_words($number)
{
if ($number < 1000000000) {
$this->words .= $this->get_crore($number) . " " . $this->get_lakhs($number % 10000000) . " ";
$this->words .= $this->get_thousand($number % 100000) . " " . $this->get_hundred($number % 1000);
}
$this->toreturn = $this->words;
$this->words = "";
$this->inwords = "";
$this->inhundred = "";
return $this->toreturn;
}
}
function toDecimal($number)
{
$sign = "";
if ($number < 0) {
$number = 0 - $number;
$sign = "-";
}
$amount = number_format((float)$number, 2, '.', '');
$array = explode('.', $amount);
$arr = str_split($array[0], 1);
$length = sizeof($arr);
$amt = "";
if ($length > 3) {
if ($length % 2 == 0) {
for ($i = 0; $i < $length; $i++) {
$amt .= $arr[$i];
if ($i % 2 == 0) {
if ($length - $i == 2) {
continue;
}
$amt .= ",";
}
}
} else {
for ($i = 0; $i < $length; $i++) {
$amt .= $arr[$i];
if ($i % 2 != 0) {
if ($length - $i == 2) {
continue;
}
$amt .= ",";
}
}
}
} else {
$amt = $array[0];
}
return $sign . $amt . '.' . $array[1];
}
function twoDigits($number)
{
return number_format((float)$number, 2, '.', '');
}
function returnZero($variable)
{
if ($variable == '') {
return 0;
} else {
return $variable;
}
}
/*
$in=new database();
$query="select * from invoice";
$table="`faculty`"; $columns="*"; $where="`id`='2'"; $order="id"; $limit="6,10";
//$run=$in->selLimit("`invoice_temp`","`id`='2'");
//if($run!==true){echo $run;}
//print_r($in->get_details($table,$columns,$where));
//echo $in->get_count($table);
if($run=$in->login("`users`","admin","12345"))
print_r($run);
else
echo "no";
*/