diff options
Diffstat (limited to 'get_users.php')
| -rw-r--r-- | get_users.php | 40 |
1 files changed, 40 insertions, 0 deletions
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++;
+ }
+}
+
+?>
|