TIS/index.php at master · Spidyhog/TIS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<!DOCTYPE html>
<head>
<title>My Website</title>
<link href="css/stylesheet.css" rel="stylesheet" type="text/css"/>
<style>
a:hover
{
color: black;
    background-color: red;
}
</style>
</head>
<body>
<?php
require_once('connect.php');
//Connect to MYSQL Server
$con=mysqli_connect($servername,$username,$passwword,$databaseName) or die("Could not connect to server");
?>
<header class="header">
<img src="images/ico.jpg" height="5%" width="5%" class="i"/>
The Indian Store
</header>
<nav class="b">
<a class="s flip" href="Register.php"> Register </a>
<a class="s flip" href="signin.php"> Sign In </a>
</nav>
<nav class="r">
<a class="t flip" href="index.php"> Home</a>
<a class="t flip" href="aboutus.html">About Us</a>
<a class="t flip" href="#">Services</a>
<a class="t flip" href="#">Products</a>
<a class="t flip" href="#">Contact Us</a>
</nav>
<section class="main">
<div class="banner"><img src="images/bnr.jpg" width="100%" height="200"/></div>
<section class="column">
<p class="r"><b><i><u>New Arrivals</u></i></b></p>
<?php
require_once('connect.php');
//Connect to MYSQL Server
$con=mysqli_connect($servername,$username,$passwword,$databaseName) or die("Could not connect to server");
//Create Query for operation on database table
$query="select distinct category,subcategory, ImagePath from newarrivals LIMIT 3";

//Execute Query
$res=mysqli_query($con,$query) or die('Error in fetching records'.mysqli_error($con));
while($newarr=mysqli_fetch_array($res))
{
?>
<div><a href="viewproducts.php?subcat=<?php echo $newarr[1];?>"><img src="<?php echo $newarr[2];?>" width="300px" height="400px"/></a>
<p><span class="text"><a href="viewproducts.php?subcat=<?php echo $newarr[1];?>"><?php echo $newarr[1];?></a></span></p></div>
<?php
}
?>
</section>
<section  class="column">
 <p>We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all.  We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all.</p>
</section>
<section class="column">
 <p>We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all.  We provide latest fashion for all. We provide latest fashion for all. We provide latest fashion for all.</p>
<section>
</section>
<footer class="r">
<p>Shop more! Save more! Stay Happy!</p>
</footer>
</body>
</html>