} } if (isset($_POST["update"])) { $name = $_POST[Poems::NAME]; $poem = $_POST[Poems::POEM]; $author = $_POST[Poems::AUTHOR]; $id = $_POST[Poems::ROW_ID]; $obj = new Poem($id, $author, $name, $poem, null, null, "true", "true"); $obj->setSynced(null); $table = new Poems(); if ($table->update($obj)) { echo "true"; } else { echo "false"; } } if (isset($_POST["delete"])) { $id = $_POST[Poems::ROW_ID]; $table = new Poems(); if ($table->delete($id)) { echo "true"; } else { echo "false"; } } // fetch total rows if (isset($_GET["total"])) { $table = new Poems(); $total = $table->totalRows(); echo $total . " poem"; }
</h4> </div> </div> <!-- Fetch Total Records from the relevant table --> <?php use Backend\Database\Tables\ILove; use Backend\Database\Tables\Memory; use Backend\Database\Tables\Poems; use Backend\Database\Tables\Promises; use Backend\Database\Tables\Quotes; use Backend\Database\Tables\Reassurance; $poems = new Poems(); $totalPoems = (int) $poems->totalRows(); $iloves = new ILove($poems->getConnection()); $totalIloves = (int) $iloves->totalRows(); $assure = new Reassurance($poems->getConnection()); $totalAssure = (int) $assure->totalRows(); $promise = new Promises($poems->getConnection()); $totalPromise = (int) $promise->totalRows(); $memory = new Memory($poems->getConnection()); $totalMemory = (int) $memory->totalRows(); $quote = new Quotes($poems->getConnection()); $totalQuotes = (int) $quote->totalRows(); $total = $totalPoems + $totalIloves + $totalAssure + $totalPromise + $totalMemory + $totalQuotes; ?> <!--Widget-4 --> <div class="row"> <div class="col-lg-7">