Gfrktyl

I know that OOP is ubiquitous nowadays. Nonetheless I still write procedural PHP. It now seems to me that I had fallen into a spaghetti code trap, because my code starts to seem meaningless even to me (it's author :)

Can you please tell me how bad is this?

<?php

/**

 * Created by PhpStorm.

 * User: Taras

 * Date: 23.01.2019

 * Time: 20:01

 */



include "db_conn.php";

$currentPage = "list";

include "header.php";



// Quantity of results per page

$limit = 10;



// Check if page has been clicked

if (!isset($_GET['page'])) {

    $page = 1;

} else{

    $page = $_GET['page'];

}



// Initial offset, if page number wasn't specified than start from the very beginning

$starting_limit = ($page-1)*$limit;



// Check if search form has been submitted

if (isset($_GET['search'])) {

    $searchTerm = $_GET['search'];



    $sql = "SELECT company.id, company.name, inn, ceo, city, phone

          FROM company

          LEFT JOIN address ON company.id = address.company_id

          LEFT JOIN contact ON company.id = contact.company_id

          WHERE

            MATCH (company.name, inn, ceo) AGAINST (:searchTerm)

            OR MATCH (city, street) AGAINST (:searchTerm)

            OR MATCH(contact.name, phone, email) AGAINST (:searchTerm)";

    $stmt = $pdo->prepare($sql);

    $stmt->execute(array(':searchTerm' => $searchTerm));



    $total_results_without_limit = $stmt->rowCount();

    $total_pages = ceil($total_results_without_limit/$limit);



    $sql = "SELECT company.id, company.name, inn, ceo, city, phone

              FROM company

              LEFT JOIN address ON company.id = address.company_id

              LEFT JOIN contact ON company.id = contact.company_id

              WHERE

                MATCH (company.name, inn, ceo) AGAINST (:searchTerm)

                OR MATCH (city, street) AGAINST (:searchTerm)

                OR MATCH(contact.name, phone, email) AGAINST (:searchTerm)

                ORDER BY id DESC LIMIT $starting_limit, $limit";

    $stmt = $pdo->prepare($sql);

    $stmt->execute(array(':searchTerm' => $searchTerm));

    // Count number of rows to make proper number of pages



} else { // Basically else clause is similar to the search block except no search is being made

    $sql = "SELECT * FROM company";

    $stmt = $pdo->prepare($sql);

    $stmt->execute();



    // Again count number of rows

    $total_results = $stmt->rowCount();

    $total_pages = ceil($total_results/$limit);

    // And then make a query

    $stmt = $pdo->prepare("

      SELECT company.id, company.name, company.inn,

            company.ceo, address.city, contact.phone

          FROM company

          LEFT JOIN address

          ON company.id = address.company_id

          LEFT JOIN contact

          ON company.id = contact.company_id

          ORDER BY id ASC LIMIT $starting_limit, $limit");

    $stmt->execute();

}

?>



<main class="container">

    <section class="section-search">

        <div class="row col-auto">

            <h2>Найти компанию</h2>

        </div>

        <form action="list.php" method="get">

            <div class="row">

                <div class="form-group col-lg-6 col-md-6 col-sm-12 row">

                    <label class="col-sm-4 col-form-label" for="searchTerm">

                        Поиск

                    </label>

                    <input type="text" class="form-control col-sm-8"

                           id="companyTerm" name="search">

                </div>

                <div class="float-right">

                    <input type="submit" class="btn btn-primary mb-2" value="Поиск">

                </div>

            </div>

        </form>

    </section>





    <section class="section-companies">

        <table class="table table-sm">

            <thead>

            <tr>

                <th scope="col">ИНН</th>

                <th scope="col">Название</th>

                <th scope="col">Генеральный директор</th>

                <th scope="col">Город</th>

                <th scope="col">Контактный телефон</th>

            </tr>

            </thead>

            <tbody>

            <?php

            // Filling the result table with results

            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

                echo "<tr><td scope='row'>" . $row['inn'] . "</td>";

                echo "<td><a href='company.php?id=" . $row["id"] . "'>" . $row['name'] . "</a>" . "</td>";

                echo "<td>" . $row['ceo'] . "</td>";

                echo "<td>" . $row['city'] . "</td>";

                echo "<td>" . $row['phone'] . "</td></tr>";

            }

            ?>



            </tbody>

        </table>

    </section>

    <?php



    // Paginating part itself

    for ($page=1; $page <= $total_pages ; $page++):?>



    <a href='<?php

        if (isset($searchTerm)) {

            echo "list.php?search=$searchTerm&page=$page";

        } else {

            echo "list.php?page=$page";

        } ?>' class="links"><?php  echo $page; ?>

    </a>



    <?php endfor; ?>

</main>