/
vievDoc.php
28 lines (25 loc) · 1.3 KB
/
vievDoc.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?php include_once('header.php'); ?>
<?php
/**
* Created by PhpStorm.
* User: admin
* Date: 07.10.2015
* Time: 14:06
*/
$selectdb = sqlQuerySelect('SELECT n.id, n.name, n.email, n.sex, n.date, n.about, j.workplace FROM names AS n JOIN jobs AS j ON n.job_id = j.id');
echo '<div class="table-responsive"><table class="table">';
foreach($selectdb as $value){
echo '<tr class="success"><td>' . $value['name'] . '</td><td>' . $value['email'] . '</td><td>' . $value['sex'] . '</td><td>' . $value['date'] . '</td><td>' . $value['about'] . '</td><td>' . $value['workplace'] . '</td><td><a href="index.php?id=' . $value['id'] . '" class="btn btn-warning btn-sm" >Edit</a></td><td><form action="createDoc.php" method="get"><a href="createDoc.php?id=' . $value['id'] . '" class="btn btn-danger btn-sm" >Delete</a></form></td></tr>';
}
echo '</table></div>';
include_once('footer.php');
//$analituka = sqlQuerySelect('SELECT name FROM names JOIN jobs ON names.job_id = jobs.id WHERE names.sex="male" AND jobs.workplace="Аналітика"');
//var_dump($analituka);
//SELECT column_name(s)
//FROM table1
//RIGHT JOIN table2
//ON table1.column_name=table2.column_name;
//
//$selectdb = sqlQuerySelect('SELECT workplace FROM names RIGHT JOIN jobs ON names.job_id = jobs.id WHERE job_id IS NULL');
//
//var_dump($selectdb);