updated

zume2020 · Oct 15, 2018 · 21a2c09 · 21a2c09
1 parent 609d260
commit 21a2c09
Show file tree

Hide file tree

Showing 4 changed files with 24 additions and 15 deletions.
diff --git a/README.md b/README.md
@@ -1,2 +1,2 @@
 # CManager
-Helps in managing xerox copy distribution
+Helps in managing xerox copy distribution
diff --git a/checklogin.php b/checklogin.php
@@ -65,7 +65,7 @@
 
 				header("Location: index.php");
 			} else{
-				echo mysqli_error($link);	
+				echo mysqli_error($link);
 			} 
 			}
 
@@ -79,6 +79,6 @@
 	} 
 
 		//incorrect credentials
-		//header("Location: index");
+		header("Location: login.php?error");
 		echo $sql ." <br>count " .$count ."<br> userId>> ". $row['userId'] ."<br>usrepass>>".$row['psw'] ;
 ?>
diff --git a/process.php b/process.php
@@ -11,10 +11,8 @@
 
 
 
-if (!empty($cstat)) {
-//Insert query 
 
-if (isset($cstat AND !empty($cstat))) {
+if (isset($cstat)) {
 
 	if ($cstat=='ON') {
 		$sql = "UPDATE `task_reg` SET `payment`='1' WHERE (`top_id`='".$topid."' AND `use_id`='".$usrid."') ";
@@ -30,7 +28,7 @@
 			echo $sql." ". mysqli_error($link);
 		}
 
-}
+
 }
 
 // clossing connection

diff --git a/task.php b/task.php
@@ -51,6 +51,8 @@
 <body>
 
 <a href="logout.php?logout">Sign Out</a></li>
+<a href="users.php">Users</a></li>
+
 
 
     <div id="wrapper">
@@ -86,16 +88,25 @@
 
             <?php
 
-$sql =  "SELECT "
-      . " users.id, users.name, task_reg.payment"
-      . " FROM "
-      . " task_reg "
-      . " JOIN users ON users.id = task_reg.use_id "
-      . " JOIN topics ON topics.id = task_reg.top_id "
-      . " WHERE "
-      . " topics.id=". $id;
+// $sql =  "SELECT "
+//       . " users.id, users.name, task_reg.payment"
+//       . " FROM "
+//       . " task_reg "
+//       . " JOIN users ON users.id = task_reg.use_id "
+//       . " JOIN topics ON topics.id = task_reg.top_id "
+//       . " WHERE "
+//       . " topics.id=". $id;
+
+
+$sql =  "SELECT users.id, users.name, IFNULL(task_reg.payment, 0) AS payment  "
+      . "FROM users "
+      . "LEFT JOIN task_reg ON users.id = task_reg.use_id "
+      . "LEFT JOIN topics ON topics.id = task_reg.top_id AND topics.id =". $id ." "
+      . "ORDER BY `users`.`name` ASC ";
+
 
         echo($sql);
+
         $result = mysqli_query($link, $sql);
         $num_rows = mysqli_num_rows($result);