<?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