Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <pre><code>$department_id = 4; $result = mysql_query(' select l.* from leave as l join employee as e on l.emp_id = e.emp_id where e.dept_id = '.mysql_real_escape_string($department_id)); $department_name = 'this one'; $result = mysql_query(" select l.* from leave as l join employee as e on l.emp_id = e.emp_id join department as e on d.dept_id = e.dept_id where d.dept_name like '%".mysql_real_escape_string($department_name))."%'"); </code></pre> <hr> <p><strong>edit</strong></p> <p>After reading the first comment down there, I think you're saying that you essentially have an <code>employee_id</code> and you want to filter the query by that employee's department. So... here's some code to do that: </p> <p><a href="http://sqlfiddle.com/#!2/41bf7/1/0" rel="nofollow">http://sqlfiddle.com/#!2/41bf7/1/0</a></p> <p>There are two queries there... they're about the same so I would just choose which ever is easier for you to understand. You would add them to the PHP like this (using the first query from the sql fiddle): </p> <pre><code>$logged_in_employee_id = 1; $result = mysql_query('select e.emp_id, e.emp_name, l.date_apply, l.leave_type, l.status, d.dept_name, d.dept_desc from `leave` as l join employee as e on l.emp_id = e.emp_id join department as d on d.dept_id = e.dept_id where d.dept_id in ( select dd.dept_id from employee as ee join department as dd on dd.dept_id = ee.dept_id where ee.emp_id = '.mysql_real_escape_string($logged_in_employee_id)).' )'); </code></pre> <p>I'm not sure where you're getting the <code>employee_id</code> or the <code>department_id</code> but make sure you <strong>sanitize and validate</strong> anything you put into a query like this. I am using <a href="http://php.net/manual/en/function.mysql-real-escape-string.php" rel="nofollow"><code>mysql_real_escape_string</code></a> which helps but that query will still break if someone hijacks your <code>POST</code> data (or something) and uses a string instead of an integer value. There are some great posts on StackOverflow about how to do this; just search for sanitizing input, sql injection with PHP, and how to do prepared statements or use PDO. </p>
    singulars
    1. This table or related slice is empty.
    1. POTo display employee's leave which is same department
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USgloomy.penguin
    1. USgloomy.penguin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POTo display employee's leave which is same department
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COSo, is it possible to write a mysql_query statement or anything to see the staff in my department only without initiate the value like "$department = 4" because if I log in as another user with different department it will still going to display the same department as I had give a value to $department_id as shown at above.
      singulars
      1. PO
      1. USJJ___
    2. COI edited my answer up there. Let me know if that's what you need. If not, tell me _what value you do have_ that you want to use as a filter for the query.
      singulars
      1. PO
      1. USgloomy.penguin
    3. COYea that's what I'm searching. I have solve the problem. Thank you so much.
      singulars
      1. PO
      1. USJJ___
 

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