Admin Index

| Traffic Report

 

"; $query = "SELECT * FROM users WHERE (`id` LIKE \"%$var%\" OR `username` LIKE \"%$var%\" OR `password` LIKE \"%$var%\" OR `email` LIKE \"%$var%\" OR `lastname`LIKE \"%$var%\" OR `firstname`LIKE \"%$var%\") ORDER BY `id` desc"; $numresults=mysqli_query($db, $query); $numrows=mysqli_num_rows($numresults); // get results $result = mysqli_query($query) or die("Couldn't execute query"); // now you can display the results returned while ($row= mysqli_fetch_array($result)) { $id= $row["id"]; $username= $row["username"]; $password= $row["password"]; $lastname= $row["lastname"]; $firstname= $row["firstname"]; $phone= $row["phone"]; $email= $row["email"]; $permissions = $row["permissions"]; $email_sub = substr($email, 0, 50); $row_color = ($row_count % 2) ? $color1 : $color2; //DISPLAY DATA HERE_____________ echo " "; $row_count++; } echo""; ?>

 

$username $lastname, $firstname $phone $email_sub $permissions edit