StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POphp program download permission
primarykey
Id
9928750
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-03-29T15:38:41.900
FavoriteCount
0
LastActivityDate
2012-03-29T15:57:29.793
LastEditDate
LastEditorUserId
0
OwnerUserId
1287949
ParentId
0
PostTypeId
1
Score
1
ViewCount
101
LastEditorDisplayName
text
Body
<p>This is a page where a boss can enable or disable the download of a file for its employee. The boss should only be able to enable files for its employee that he (the boss) can already use. The programs that the employee already has access to must be green. The problem is that all programs turn green because the SQL is listening to the ID of the boss, not the ID of the employee. Any suggestions? <pre><code>require_once('databankverbinding.php'); if(empty($_SESSION['myusername'])) header('location: /request/login.php'); ?> <html> <head><title>Programs</title> <link href="css/search.css" rel="stylesheet" type="text/css"/> </head> <body> <?php if(!empty($_SESSION['myusername'])){ echo $_SESSION['myusername']; echo $_SESSION['userID'];} $user = $_SESSION['userID']; echo $_GET['UserID']; echo $user; $sqlq = "SELECT tblfile.FileID, tblfile.FileName, tblfile.FileDescription,tblfile.FileType,tblfile.FileSize,tblfile.FileDate,tblfile.FileActive, tbluser_file.User_FileID, tbluser_file.FileID, tbluser_file.UserID, tbluser_file.fldactief, tbluser.UserID, tbluser.Username, tbluser.Password, tbluser.BossID FROM tbluser INNER JOIN (tblfile INNER JOIN tbluser_file ON tblfile.FileID = tbluser_file.FileID) ON tbluser.UserID = tbluser_file.UserID WHERE tbluser_file.UserID = '".$user."' AND tblfile.FileActive = 1 AND tbluser_file.fldactief = 1 " ; // Alle mappen ophalen $sql = 'SELECT UserID, username FROM tbluser'; $sql .= ' WHERE UserID = '.$_GET['UserID']; $res = mysql_query($sql); $row = mysql_fetch_array($res); $sql3 = "SELECT tblfile.FileID, tblfile.FileName, tblfile.FileDescription,tblfile.FileType,tblfile.FileSize,tblfile.FileDate,tblfile.FileActive, tbluser_file.User_FileID, tbluser_file.FileID, tbluser_file.UserID, tbluser_file.fldactief, tbluser.UserID, tbluser.Username, tbluser.Password, tbluser.BossID FROM tbluser INNER JOIN (tblfile INNER JOIN tbluser_file ON tblfile.FileID = tbluser_file.FileID) ON tbluser.UserID = tbluser_file.UserID WHERE tbluser_file.UserID = '".$_GET['UserID']."' AND tblfile.FileActive = 1 AND tbluser_file.fldactief = 1 " ; // Alle mappen ophalen $res3 = mysql_query($sql3); $row3 = mysql_fetch_array($res3); $res = mysql_query($sqlq); echo ' <form action="category.php"> <fieldset> <legend>Catergory Edit/Delete:</legend> <table>'; echo $row['UserID']; while($row = mysql_fetch_array($res)){ if(($row3['fldactief']) == 0){ echo ' <tr> <td>'. $row['FileName'] . '</td> <td>&nbsp;&nbsp;<a href="controluser.php?action=enable&UserID='.$_GET['UserID'].'&FileID='.$row['FileID'].'"><img class="delete" src="images/enable.png" /></a></td> <td>&nbsp;&nbsp;<a href="controluser.php?action=disable&UserID='.$_GET['UserID'].'&FileID='.$row['FileID'].'" ><img class="delete" src="images/disable.png" /></a></td> </tr>';} else{ echo ' <tr> <td><h4 style="color:green;">'. $row['FileName'] . '</h4></td> <td>&nbsp;&nbsp;<a href="controluser.php?action=enable&UserID='.$_GET['UserID'].'&FileID='.$row['FileID'].'"><img class="delete" src="images/enable.png" /></a></td> <td>&nbsp;&nbsp;<a href="controluser.php?action=disable&UserID='.$_GET['UserID'].'&FileID='.$row['FileID'].'" ><img class="delete" src="images/disable.png" /></a></td> </tr>';} } echo ' </table> </fieldset> </form> '; ?> <a href="controluser.php">Go to Control Panel</a> </body> </html> </code></pre>
Tags
<php><mysql>
Title
php program download permission
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USuser1287949
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POphp program download permission
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTClose
2. VO
  singulars
  PostPostId
  POphp program download permission
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COThat's a lot of messy code for just a little bit of description. This seems like it needs a bit of application design applied before we get to coding, don't you think? What does your database look like, and does it properly represent the relationships you're trying to express?
  singulars
  PostPostId
  POphp program download permission
  UserUserId
  USghoti

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.