} else {
        echo "false";
    }
}
if (isset($_POST["update"])) {
    $promise = $_POST[\Backend\Database\Tables\Promises::PROMISE];
    $id = $_POST[\Backend\Database\Tables\Promises::ROW_ID];
    $obj = new \Backend\Database\Schemas\Promise($id, $promise);
    $obj->setSynced(null);
    $table = new \Backend\Database\Tables\Promises();
    if ($table->update($obj)) {
        echo "true";
    } else {
        echo "false";
    }
}
if (isset($_POST["delete"])) {
    $id = $_POST[\Backend\Database\Tables\Promises::ROW_ID];
    $table = new \Backend\Database\Tables\Promises();
    if ($table->delete($id)) {
        echo "true";
    } else {
        echo "false";
    }
}
// fetch total rows
if (isset($_GET["total"])) {
    $table = new Promises();
    $total = $table->totalRows();
    echo $total . " promise";
}
Exemple #2
0
    <!-- 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">
            <div class="col-md-6 col-sm-6 col-lg-3">
                <div class="mini-stat clearfix bx-shadow">
                    <div class="mini-stat-info text-center text-muted">
                        <span class="counter"><?php 
echo $totalPoems;
?>