PHP Model::selectOne Examples

Example #1

File: model_user.php Project: anton-phpcurs/mvc

 public function getUserInfo($id)
 {
     $model = new Model();
     $query = 'SELECT * FROM user WHERE id=' . $id;
     $result['user'] = $model->selectOne($query);
     return $result;
 }

Example #2

File: model_lot.php Project: anton-phpcurs/mvc

 public function getInfo($id)
 {
     $model = new Model();
     $query = 'SELECT l.*,c.name,u.id user_id,u.first_name,u.last_name
             FROM lot l
             JOIN category c
             ON l.category_id=c.id
             JOIN `user` u
             ON u.id=l.user_id
             WHERE l.id=' . $id;
     $result['description'] = $model->selectOne($query);
     if (empty($result['description'])) {
         return $result;
     }
     $query = 'SELECT id, front_img FROM lot WHERE category_id=' . $result['description']['category_id'] . ' AND id NOT IN (' . $id . ') LIMIT 5';
     $result['similar'] = $model->select($query);
     return $result;
 }

Example #3

File: router.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 
}
$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>

Example #4

File: updateProductInDb.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 
}
$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 

Example #5

File: computer.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 
}
$id = $_GET['id'];
$selectComp = new Model();
$selectComp->selectOne($id, 'computers');
$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>

Example #6

File: printer.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 
}
$id = $_GET['id'];
$selectComp = new Model();
$selectComp->selectOne($id, 'printers');
$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>