PHP Model::getQuery Examples

Example #1

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

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: router.php Project: nadiaborisova/php-mysql-course-softacad

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 
}
$id = $_GET['id'];
$selectComp = new Model();
$selectComp->selectOne($id, 'routers');
$rowsNum = $selectComp->getRowsNum();
$rows = $selectComp->getRows();
$query = $selectComp->getQuery();
$row = mysqli_fetch_array($query);
?>
<div id="content">
	<div align="center">
		<img src="images/<?php 
echo $row['image'];
?>
.jpg"/>
		<h2><?php 
echo $row['make'];
?>
</h2>
		<h2><?php 
echo $row['model'];
?>

Example #3

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

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 
}
$selectProduct = new Model();
$id = $_GET['id'];
$products = $_GET['products'];
$selectProduct->selectOne($id, $products);
$rows = mysqli_fetch_array($selectProduct->getQuery());
?>
<div id="content" align="center">
	<br/>
	<h1>UPDATE PRODUCT</h1>
	<h2><?php 
echo $rows['make'] . "," . $rows['model'];
?>
</h2>
	<form action="update.php" method="post">
		<input type="hidden" name="id" value="<?php 
echo $rows['id'];
?>
"/>
		<input type="hidden" name="products" value="<?php 
echo $products;

Example #4

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

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>
			<th width="30px;">ID</th>
			<th width="400px;">Make and Model</th>
			<th width="100px;">Operations</th>

Example #5

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

<?php

include 'header.php';
include 'model.php';
$updateNews = new Model();
$id = $_GET['id'];
$updateNews->selectOneNews($id);
$rows = mysqli_fetch_array($updateNews->getQuery());
?>

<form action="update.php" method="post">
		<table>
			<tr>
				<th><span>ID:</span></th>
				<td><input type="text" name="id" value="<?php 
echo $rows['id'];
?>
"/></td>
			</tr>	
			<tr>
				<th><span>Title:</span></th>
				<td><input type="text" name="title" value="<?php 
echo $rows['title'];
?>
"/></td>
			</tr>			
			<tr>
				<th><span>Description:</span></th>
				<td><textarea name="description" cols="30" rows="10"><?php 
echo $rows['description'];
?>

Example #6

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

<?php 
include 'header.php';
include 'model.php';
$selectNews = new Model();
$selectNews->selectAllNews();
$rowsNum = $selectNews->getRowsNum();
$rows = $selectNews->getRows();
$query = $selectNews->getQuery();
?>
<div align="center">
	<h1>All news</h1>
	
	<table border=1>
		<tr>
			<th>News ID</th>
			<th>Title</th>
			<th>Date of publishing</th>
			<th>Operations</th>
		</tr>
		<?php 
for ($i = 0; $i < $rowsNum; $i++) {
    $rows = mysqli_fetch_array($query);
    ?>
		<tr>
			<td>
				<p><?php 
    echo $rows['id'];
    ?>
</p>
			</td>
			<td width="400px">

Example #7

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

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 #8

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

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 
}
if (isset($_GET['submit'])) {
    $id = $_GET['id'];
    $products = $_GET['products'];
    $selectProduct = new Model();
    $selectProduct->selectOne($id, $products);
    $rows = $selectProduct->getRows();
    $query = $selectProduct->getQuery();
    $row = mysqli_fetch_array($query);
    $make = $row['make'];
    $model = $row['model'];
    $price = $row['price'];
    switch ($products) {
        case 'computers':
            $_SESSION['cart_item']['computers'] = array($id => array('make' => $make, 'model' => $model, 'price' => $price));
            break;
        case 'printers':
            $_SESSION['cart_item']['printers'] = array($id => array('make' => $make, 'model' => $model, 'price' => $price));
            break;
        case 'routers':
            $_SESSION['cart_item']['routers'] = array($id => array('make' => $make, 'model' => $model, 'price' => $price));
            break;
        default:

Example #9

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

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 #10

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

<?php

include '../templates/header.php';
include '../db/model.php';
if (isset($_POST['submit'])) {
    $username = trim($_POST['username']);
    $password = trim(md5($_POST['password']));
    if (empty($username) || empty($password)) {
        echo "Please enter your username and password!";
    } else {
        $users = new Model();
        $users->selectUser('user1', 'user1');
        $rows = $users->getRowsNum();
        $query = $users->getQuery();
        $row = mysqli_fetch_array($query);
        if ($rows == 1) {
            $_SESSION['login_user'] = $username;
            $_SESSION['cart_item'] = array();
            header("Location: ../admin.php");
        } else {
            echo "Login failed!";
        }
    }
}
?>

Example #11

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';