function findPublisher()
{
$ooClass = new OOClass();
$dbc = $ooClass->dbConnect();
static $num2 = 1;
$query = "Select * from paintings where painting_id= '{$num2}'";
$num2 = $num2 + 1;
$data = mysqli_query($dbc, $query);
if (mysqli_num_rows($data) == 1) {
$row = mysqli_fetch_array($data);
$publisher = $row['publisher'];
return $publisher;
}
}
function findImagePriceCategoryLandscapes($num2)
{
$ooClass = new OOClass();
$dbc = $ooClass->dbConnect();
// static $num2 = 1;
$query = "Select * from paintings where painting_id= '{$num2}' AND paintingtype = 'landscapes'";
// $num2 = $num2 + 1;
$data = mysqli_query($dbc, $query);
if (mysqli_num_rows($data) == 1) {
$row = mysqli_fetch_array($data);
$price = $row['price'];
if (!empty($price)) {
//return $price;
?>
<div class="col-sm-3">
<div class="product-image-wrapper">
<div class="single-products">
<div class="productinfo text-center">
<?php
//findImageCategory();
$result = $ooClass->callingImageCategoryLandscapes($num2);
if (!empty($result)) {
echo '<img src="collection/' . $result . '" alt="" />';
//echo "string ".$result;
}
echo '<h2>Price: $' . $price . '</h2>';
//echo '<a href="#" class="btn btn-default add-to-cart"><i class="fa fa-shopping-cart"></i>Add to cart</a>';
?>
</div>
</div>
</div>
</div>
<?php
}
}
}
<?php
// Insert the page header
$page_title = 'Registration Form';
require_once 'header.php';
require_once 'OOClass.php';
require_once 'appvars.php';
define('GW_UPLOADPATH', 'image/');
// Connect to the database
$ooClass = new OOClass();
$dbc = $ooClass->dbConnect();
if (isset($_POST['submit'])) {
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$password1 = $_POST['password1'];
$password2 = $_POST['password2'];
$phone = $_POST['phone'];
$photo = $_FILES['photo']['name'];
$category = $_POST['category'];
if (!empty($email) && !empty($password1) && !empty($password2) && $password1 == $password2) {
// Make sure someone isn't already registered using this username
$target = GW_UPLOADPATH . $photo;
move_uploaded_file($_FILES['photo']['tmp_name'], $target);
$query = "SELECT * FROM allusers WHERE email = '{$email}'";
$data = mysqli_query($dbc, $query);
if (mysqli_num_rows($data) == 0) {
// The username is unique, so insert the data into the database
$query = "INSERT INTO allusers (firstname, lastname, email, password, phone, photo, category) VALUES ('{$firstname}', '{$lastname}', '{$email}', SHA('{$password1}'), '{$phone}', '{$photo}', '{$category}')";
mysqli_query($dbc, $query);
//echo "Query: ".$query;
