PHP Model::selectAll Examples

Example #1

File: printers.php Project: nadiaborisova/php-mysql-course-softacad

  <?php 
include 'templates/header.php';
include 'templates/menu.php';
include 'db/model.php';
if (isset($_SESSION['login_user'])) {
    ?>
		<div align="left">Hello, <?php 
    echo $_SESSION['login_user'];
    ?>
 ||| <a href="login/logout.php"> Logout</a></div>
	<?php 
}
$queriesPrinters = new Model();
$queriesPrinters->selectAll('printers');
$rowsNum = $queriesPrinters->getRowsNum();
$rows = $queriesPrinters->getRows();
$result = $queriesPrinters->getQuery();
?>
<div id="content">
	<div class="content-header-basket">
		<a href="basket.php">
			<span>My basket</span><br/>
			<img src="images/basket-img.jpg"/>
		</a>
	</div>
		<h1>PRINTERS</h1>
	<div class="clear-float"></div>
	<?php 
for ($i = 0; $i < $rowsNum; $i++) {
    $rowPrinters = mysqli_fetch_array($result);
    $_SESSION['rowPrinters'] = $rowPrinters;

Example #2

File: admin.php Project: nadiaborisova/php-mysql-course-softacad

?>
<div id="content" align="center">
<?php 
if (isset($_SESSION['login_user'])) {
    $getComp = new Model();
    $getComp->selectAll('computers');
    $rowsNumComp = $getComp->getRowsNum();
    $rowsComp = $getComp->getRows();
    $resultComp = $getComp->getQuery();
    $getPrinters = new Model();
    $getPrinters->selectAll('printers');
    $rowsNumPrinters = $getPrinters->getRowsNum();
    $rowsPrinters = $getPrinters->getRows();
    $resultPrinters = $getPrinters->getQuery();
    $getRouters = new Model();
    $getRouters->selectAll('routers');
    $rowsNumRouters = $getRouters->getRowsNum();
    $rowsRouters = $getRouters->getRows();
    $resultRouters = $getRouters->getQuery();
    ?>
	<div align="left">Hello, <?php 
    echo $_SESSION['login_user'];
    ?>
 ||| <a href="login/logout.php"> Logout</a></div>
	

	<h1>ADMIN PANEL</h1>
	<a href="addProduct.php"> Add product </a>
	<h2>Computers</h2>
	<table border=1>
		<tr>

Example #3

File: routers.php Project: nadiaborisova/php-mysql-course-softacad

  <?php 
include 'templates/header.php';
include 'templates/menu.php';
include 'db/model.php';
if (isset($_SESSION['login_user'])) {
    ?>
		<div align="left">Hello, <?php 
    echo $_SESSION['login_user'];
    ?>
 ||| <a href="login/logout.php"> Logout</a></div>
	<?php 
}
$queriesRouters = new Model();
$queriesRouters->selectAll('routers');
$rowsNum = $queriesRouters->getRowsNum();
$rows = $queriesRouters->getRows();
$result = $queriesRouters->getQuery();
?>
<div id="content">
	<div class="content-header-basket">
		<a href="basket.php">
			<span>My basket</span><br/>
			<img src="images/basket-img.jpg"/>
		</a>
	</div>
		<h1>ROUTERS</h1>
	<div class="clear-float"></div>
	<?php 
for ($i = 0; $i < $rowsNum; $i++) {
    $rowRouters = mysqli_fetch_array($result);
    $_SESSION['rowRouters'] = $rowRouters;

Example #4

File: computers.php Project: nadiaborisova/php-mysql-course-softacad

  <?php 
include 'templates/header.php';
include 'templates/menu.php';
include 'db/model.php';
if (isset($_SESSION['login_user'])) {
    ?>
		<div align="left">Hello, <?php 
    echo $_SESSION['login_user'];
    ?>
 ||| <a href="login/logout.php"> Logout</a></div>
	<?php 
}
$queriesComp = new Model();
$queriesComp->selectAll('computers');
$rowsNum = $queriesComp->getRowsNum();
$rows = $queriesComp->getRows();
$result = $queriesComp->getQuery();
?>
<div id="content">
	<div class="content-header-basket">
		<a href="basket.php">
			<span>My basket</span><br/>
			<img src="images/basket-img.jpg"/>
		</a>
	</div>
		<h1>COMPUTERS</h1>
	<div class="clear-float"></div>
	<?php 
for ($i = 0; $i < $rowsNum; $i++) {
    $rowComp = mysqli_fetch_array($result);
    $_SESSION['rowComp'] = $rowComp;

Example #5

File: index.php Project: nadiaborisova/php-mysql-course-softacad

<?php 
require 'templates/header.php';
require 'db/model.php';
if (isset($_SESSION['login'])) {
    $username = $_SESSION['login'];
    $selectAnimals = new Model();
    $selectAnimals->selectAll();
    $rowsNum = $selectAnimals->getRowsNum();
    $rows = $selectAnimals->getRows();
    $query = $selectAnimals->getQuery();
    ?>
	<script>
		function getTiger (){
			document.getElementById('animalHidden').value = 'tiger'; 
			document.getElementById('animal').innerHTML = 'tiger'; 
			document.getElementById('tigerImg').style.border = '2px solid red'; 
			document.getElementById('zebraImg').style.border = '0';
			document.getElementById('lionImg').style.border = '0';
		}
		function getZebra (){
			document.getElementById('animalHidden').value = 'zebra'; 
			document.getElementById('animal').innerHTML = 'zebra'; 
			document.getElementById('tigerImg').style.border = '0'; 
			document.getElementById('zebraImg').style.border = '2px solid red';
			document.getElementById('lionImg').style.border = '0';
		}
		function getLion (){
			document.getElementById('animalHidden').value = 'lion'; 
			document.getElementById('animal').innerHTML = 'lion';
			document.getElementById('tigerImg').style.border = '0'; 
			document.getElementById('zebraImg').style.border = '0';