<?php
include_once 'header.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);
<p>
<div class="row">
<div class="col-lg-8 col-lg-offset-2">
<label for="aboutid">About me:</label><br>
<textarea class="form-control input-lg" name="about" placeholder="140-character limit" maxlength="140" rows="2" id="aboutid"><?php
echo isset($data) ? $data[0]["about"] : '';
?>
</textarea>
</div>
</div>
<p>
<div class="row">
<div class="col-lg-8 col-lg-offset-2">
<label for="selectjob">Перегляд</label>
<?php
$row = sqlQuerySelect("SELECT * FROM jobs");
?>
<select name="job" required="required" class="form-control input-lg" id="selectjob">
<?php
foreach ($row as $value) {
?>
<?php
$selectForEdit = isset($data) && $data[0]['job_id'] == $row[$key]['id'] ? 'selected="selected"' : "";
?>
<option <?php
echo $selectForEdit;
?>
value=<?php
echo $value['id'];
?>
><?php
