Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **users**
- user_id | user_email | user_role | dashboard_id
- 1 | admin@admin.com | 0 | 1
- 1 | user@user.com | 1 | 2
- ---------------------------------------------------
- **dashboards**
- dashboard_id | dashboard_name |
- 1 | dashboard 1
- 1 | dashboard 2
- ---------------------------------------------------
- **roles**
- role_id | role_name |
- 0 | super_admin
- 1 | user
- ---------------------------------------------------
- function clientReportName() {
- global $conn;
- global $dashboardIdNew;
- global $user_dash_id;
- $sql = "SELECT * FROM dashboards WHERE dashboard_id = $user_dash_id";
- $result = $conn->query($sql);
- if($result->num_rows > 0){
- while($row = $result->fetch_assoc()){
- echo $row["dashboard_name"];
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement