From 628c97aaf508bbd615ef3a500f22fcdd1ca00f4d Mon Sep 17 00:00:00 2001
From: AlisaLinUwU <alisalinuwu@gmail.com>
Date: Sun, 26 Jan 2025 11:49:02 +0500
Subject: Initialize

---
 get_users.php | 40 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 get_users.php

(limited to 'get_users.php')

diff --git a/get_users.php b/get_users.php
new file mode 100644
index 0000000..32d2801
--- /dev/null
+++ b/get_users.php
@@ -0,0 +1,40 @@
+<?php
+
+include "connect_database.php";
+
+$sql;
+
+if (isset($ism) && $ism != null) {
+	$sql = "SELECT * FROM qarzdorlar WHERE ism = $ism";
+} else {
+	$sql = "SELECT * FROM qarzdorlar";
+}
+
+$result = $conn->query($sql);
+
+$users;
+$min_user;
+$max_user;
+
+$sum_duty = 0;
+$min_duty = 99999999999;
+$max_duty = 0;
+
+for ($i = 0, $j = 0; $i < $result->field_count; $i++) {
+	while ($row = $result->fetch_assoc()) {
+		$users[$j] = $row;
+		$sum_duty += $row["miqdor"];
+
+		if ($row["miqdor"] < $min_duty) {
+			$min_user = $row;
+			$min_duty = $row["miqdor"];
+		}
+		if ($row["miqdor"] > $max_duty) {
+			$max_user = $row;
+			$max_duty = $row["miqdor"];
+		}
+		$j++;
+	}
+}
+
+?>
-- 
cgit v1.2.3