Databases
StackOverflow2013
Postsdbo
POhow to show selected user to view mysql data
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to show selected user to view mysql data
    primarykey
    data
    text
    <p>this code showing all MySQL table data to any users but i want only admin and user to show data of mysql query</p> <p>i have multiple users </p> <pre><code>1.admin 2.user123 3.xyz </code></pre> <p>so i want only admin and user to show MySQL table data how can i do this </p> <p>example if admin and user123 open the page then mysql data showing correct if xyz user open the page then it will not showing any data </p> <pre><code>user login name &lt;?php echo $_SESSION['SESS_FIRST_NAME']; ?&gt; </code></pre> <p>i want to add this one in to mysql query to showing result only admin and user</p> <pre><code> $query = "SELECT * FROM `follower` WHERE `followername` LIKE '".$letter."%' ORDER BY `followername` ASC LIMIT $from, $max_results"; </code></pre> <p>complete code</p> <pre><code>&lt;?php $max_results = 10; $from = (($page * $max_results) - $max_results); if(empty($_POST)) { $query = "SELECT * FROM `follower` WHERE `followername` LIKE '".$letter."%' ORDER BY `followername` ASC LIMIT $from, $max_results"; } $result = mysql_query("SET NAMES utf8"); //the main trick $result = mysql_query($query) or die(mysql_error()); $rows = mysql_num_rows($result); echo "&lt;table class='gridtable' border='1' cellpadding='0' cellspacing='0'&gt;"; echo "&lt;tr&gt;&lt;th&gt;Name&lt;/th&gt;&lt;th&gt;Company Name&lt;/th&gt;&lt;th&gt;Mobile No&lt;/th&gt;&lt;/tr&gt;"; if ($rows &gt; 0) { while($row = mysql_fetch_array($result)) { echo "&lt;tr&gt;&lt;td&gt;"; echo $row['followername']; echo "&lt;/td&gt;&lt;td&gt;"; echo $row['companyname']; echo "&lt;/td&gt;&lt;td&gt;"; echo $row['mobileno']; echo "&lt;/td&gt;&lt;td&gt;"; echo $row['contractdatee']; echo "&lt;/td&gt;&lt;/tr&gt;"; } } else { echo "&lt;tr&gt;&lt;td align=\"center\" colspan=\"4\"&gt;No results found!&lt;/td&gt;&lt;/tr&gt;"; } echo "&lt;/table&gt;"; // Figure out the total number of results in DB: $total_results = mysql_result(mysql_query("SELECT COUNT(*) as followername FROM follower ORDER BY followername ASC"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); // Build Page Number Hyperlinks echo "&lt;p class=\"style2\"&gt;Pages: "; // Build Previous Link if($page &gt; 1){ $prev = ($page - 1); echo "&lt;a href=\"".$_SERVER['php_SELF']."?page=$prev&amp;letter=$letter\" class=\"style2\"&gt;Previous&lt;/a&gt; "; } for($i = 1; $i &lt;= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo " "; } } // Build Next Link if($page &lt; $total_pages){ $next = ($page + 1); echo "&lt;a href=\"".$_SERVER['php_SELF']."?page=$next&amp;letter=$letter\" class=\"style2\"&gt;Next&lt;/a&gt;"; } echo "&lt;/p&gt;"; mysql_close(); ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser3000993
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COCheck if user is valid in your PHP code and then show data accordingly. Best is to use Database for user roles and permissions.
      singulars
      1. POhow to show selected user to view mysql data
      1. USsulmanpucit
    2. CObut how can i add user role and permissions in this code
      singulars
      1. POhow to show selected user to view mysql data
      1. USuser3000993
    3. COWhat's your problem here? Just check for the logged in user id and retrieve data accordingly.
      singulars
      1. POhow to show selected user to view mysql data
      1. USYatin Trivedi
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload