Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- index.php
- <!doctype html>
- <html>
- <?php
- session_start();
- include("func.php");
- include("login.php");
- $link = mysqli_connect('127.0.0.1:3306', '971030', '971030');
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- mysqli_select_db($link, "db971030");
- if(isset($_GET['customerID'])){
- echo "hej";
- $customerID = $_GET['customerID'];
- $customerName = $_GET['customerName'];
- }
- else{
- $customerID = NULL;
- }
- ?>
- <script src="script.js"></script>
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
- <link rel="stylesheet" href="style.css">
- <head> <title>Spelbutik Norra</title> </head>
- <body>
- <H1 class="head">Spelbutik Norra</H1> <br>
- <div class="dropdown">
- <button class="dropbutton" onclick="toggleLoginDropDown()">
- Logga in
- </button>
- <div class="dropdown-content" id="loginDropdown" >
- <form id="loginForm" action="index.php?action=add&id=0" method="post">
- Användarnamn:<br> <input type="text" id="username"><br>
- Lösenord:<br> <input type="password" id="password"><br>
- <button type="button" onclick="login();">Logga in</button>
- </form>
- </div>
- <button class="dropbuttonVaru" onclick="toggleSignUpDropDown()">
- Registrera
- </button>
- <div class="dropdown-content-varu" id="signUpDropdown" >
- <form id="signUpForm" action="index.php?action=signUp" method="post">
- Användarnamn:<br> <input type="text" id="newuser"><br>
- Lösenord:<br> <input type="password" id ="newpwd"><br>
- <button type="button" onclick="signup();" > Registrera dig</button>
- </form>
- </div>
- </div>
- <!-- <div class="grid-container">-->
- <div id="base">
- <?php
- $prodResult = mysqli_query($link, "SELECT * FROM Products");
- if (mysqli_num_rows($prodResult) > 0) {
- $count = 0;
- $prodId[] = array();
- $Price[] = array();
- $Name[] = array();
- $picture[] = array();
- while($row = mysqli_fetch_assoc($prodResult)) {
- /*echo "id: " . $row["idProducts"];*/
- $Price[$count] = $row["Price"];
- $Name[$count] = $row["Name"];
- $Picture[$count] = $row["Picture"];
- $prodId[$count] = $row["idProducts"];
- $count = $count + 1;
- }
- ?>
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[0]?>">
- <img src=" <?php echo $Picture[0]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[0]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[0] ;?> :- </h3>
- <input type ="hidden" id="hidden_product" value=" <?php echo $prodId[0] ;?>"/>
- <input type ="hidden" id="hidden_customer" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[0]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[1]?>">
- <img src=" <?php echo $Picture[1]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[1]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[1] ;?> :- </h3>
- <input type ="hidden" id="hidden_product1" value=" <?php echo $prodId[1] ;?>"/>
- <input type ="hidden" id="hidden_customer1" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[1]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form1();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[2]?>">
- <img src=" <?php echo $Picture[2]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[2]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[2] ;?> :- </h3>
- <input type ="hidden" id="hidden_product2" value=" <?php echo $prodId[2] ;?>"/>
- <input type ="hidden" id="hidden_customer2" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[2]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form2();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[3]?>">
- <img src=" <?php echo $Picture[3]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[3]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[3] ;?> :- </h3>
- <input type ="hidden" id="hidden_product3" value=" <?php echo $prodId[3] ;?>"/>
- <input type ="hidden" id="hidden_customer3" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[3]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form3();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[4]?>">
- <img src=" <?php echo $Picture[4]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[4]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[4] ;?> :- </h3>
- <input type ="hidden" id="hidden_product4" value=" <?php echo $prodId[4] ;?>"/>
- <input type ="hidden" id="hidden_customer4" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[4]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form4();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <?php
- }
- ?>
- </div>
- <!--</div> -->
- <div id="footer"> <h3>Spelbutik Norra </h3> </div>
- </body>
- </html>
- func.php
- <?php
- /*$username = $_POST["username"];
- $userpassword = $_POST["userpassword"];
- */
- if(isset($_GET['Customer_id'])){
- $customerID = $_GET["Customer_id"];
- $productsID = $_GET["Products_id"];
- addToCart($customerID,$productsID);
- }
- else{
- }
- function addToCart($cust, $prod){
- $link = mysqli_connect('127.0.0.1:3306', '971030', '971030');
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- mysqli_select_db($link, "db971030");
- mysqli_query($link,"INSERT INTO Cart (Customer_id,Products_id)
- VALUES (".$cust.",".$prod.")");
- }
- ?>
- login.php
- <?php
- if(isset($_GET["Username"]) and isset($_GET["Password"])){
- $username = $_GET["Username"];
- $userpassword = $_GET["Password"];
- loginUser($username,$userpassword);
- }
- else{
- }
- function loginUser($username, $password){
- $link = mysqli_connect('127.0.0.1:3306', '971030', '971030');
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- mysqli_select_db($link, "db971030");
- $result = mysqli_query($link,"SELECT * FROM `Customer`
- WHERE `Username` LIKE '$username' AND `Password` LIKE '$password'");
- if(mysqli_num_rows($result) == 0){
- echo "Username/password incorrect";
- }
- else{
- echo "Du är nu inloggad!";
- $customer = mysqli_fetch_assoc($result);
- $_SESSION['customerID'] = $customer["idCustomer"];
- $_SESSION['customerName'] = $username;
- }
- }
- ?>
- signup.php
- <?php
- if(isset($_GET["Username"]) and isset($_GET["Password"])){
- $userupname = $_GET["Username"];
- $useruppassword = $_GET["Password"];
- registerUser($userupname,$useruppassword);
- }
- else{
- }
- function registerUser($name, $password){
- $link = mysqli_connect('127.0.0.1:3306', '971030', '971030');
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- mysqli_select_db($link, "db971030");
- mysqli_query($link,"INSERT INTO Customer (Username, Password)
- VALUES ('$name','$password')");
- }
- ?>
- loggedin.php
- <!doctype html>
- <html>
- <?php
- session_start();
- $link = mysqli_connect('127.0.0.1:3306', '971030', '971030');
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- mysqli_select_db($link, "db971030");
- ?>
- <script src="script.js"></script>
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
- <link rel="stylesheet" href="style.css">
- <head> <title>Spelbutik Norra</title> </head>
- <body>
- <H1 class="head">Spelbutik Norra</H1> <br>
- <div class="dropdown">
- <button class="dropbutton" onclick="mypage()"> Min sida</button>
- <!--<p> Användare: <?php $_SESSION['username']?> </p>-->
- <button class="dropbuttonVaru" onclick="toggleCartDropDown()">Varukorg</button>
- <div class="dropdown-content-varu" id="cartDropdown" >
- <?php
- $cartResult = mysqli_query($link, 'SELECT Products_id FROM Cart WHERE Customer_id = "1"');
- $rowID = mysqli_fetch_assoc($cartResult);
- $cartProdResult = mysqli_query($link, 'SELECT * FROM Products WHERE '.$rowID["Products_id"].'=idProducts');
- if (mysqli_num_rows($cartProdResult) > 0) {
- while($cartRow = mysqli_fetch_assoc($cartProdResult)) {
- echo 'Name: '.$cartRow["Name"].' Price: '.$cartRow["Price"].'';
- }
- }
- ?>
- </div>
- </div>
- <!-- <div class="grid-container">-->
- <div id="base">
- <?php
- $prodResult = mysqli_query($link, "SELECT * FROM Products");
- if (mysqli_num_rows($prodResult) > 0) {
- $count = 0;
- $prodId[] = array();
- $Price[] = array();
- $Name[] = array();
- $picture[] = array();
- while($row = mysqli_fetch_assoc($prodResult)) {
- /*echo "id: " . $row["idProducts"];*/
- $Price[$count] = $row["Price"];
- $Name[$count] = $row["Name"];
- $Picture[$count] = $row["Picture"];
- $prodId[$count] = $row["idProducts"];
- $count = $count + 1;
- }
- ?>
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[0]?>">
- <img src=" <?php echo $Picture[0]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[0]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[0] ;?> :- </h3>
- <input type ="hidden" id="hidden_product" value=" <?php echo $prodId[0] ;?>"/>
- <input type ="hidden" id="hidden_customer" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[0]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[1]?>">
- <img src=" <?php echo $Picture[1]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[1]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[1] ;?> :- </h3>
- <input type ="hidden" id="hidden_product1" value=" <?php echo $prodId[1] ;?>"/>
- <input type ="hidden" id="hidden_customer1" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[1]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form1();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[2]?>">
- <img src=" <?php echo $Picture[2]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[2]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[2] ;?> :- </h3>
- <input type ="hidden" id="hidden_product2" value=" <?php echo $prodId[2] ;?>"/>
- <input type ="hidden" id="hidden_customer2" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[2]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form2();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[3]?>">
- <img src=" <?php echo $Picture[3]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[3]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[3] ;?> :- </h3>
- <input type ="hidden" id="hidden_product3" value=" <?php echo $prodId[3] ;?>"/>
- <input type ="hidden" id="hidden_customer3" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[3]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form3();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <div id="Prod">
- <form method="post" action="index.php?action=add&id=<?php echo $prodId[4]?>">
- <img src=" <?php echo $Picture[4]; ?>" height ="200px" width="200px" id="icon" >
- <div id="info">
- <H4> <?php echo $Name[4]; ?></H4> </br>
- </div>
- <div id="prodbuy">
- <h3 id="price"> <?php echo $Price[4] ;?> :- </h3>
- <input type ="hidden" id="hidden_product4" value=" <?php echo $prodId[4] ;?>"/>
- <input type ="hidden" id="hidden_customer4" value=" 1"/>
- <input type ="hidden" id="hidden_price" value ="<?php echo $Price[4]; ?>"/>
- <button type ="button" name="add_to_cart" id="Buy" onclick="submit_form4();"> Lägg till i varukorg </button>
- </form>
- </div>
- </div>;
- <?php
- }
- ?>
- </div>
- <!--</div> -->
- <div id="footer"> <h3>Spelbutik Norra </h3> </div>
- </body>
- </html>
- style.css
- body {
- background-color: #FAF8F8;
- padding: 0px 80px 80px 90px;
- }
- .head{ float: left;
- width: 100%;
- border-radius: 4px;
- text-align: Left;
- text-decoration: underline;
- color: black;
- opacity: 0.6;
- padding: 2px;
- }
- #base{
- margin-top: 25px;
- width: 97%;
- text-align: center;
- border-radius: 6px;
- border: 1px #404040 solid;
- padding: 25px 25px 25px 25px;
- }
- #footer{
- margin-top: 50px;
- float: left;
- z-index: 1;
- width: 100%;
- height: 50px;
- color: #404040;
- text-align: center;
- bottom: 20px;
- border-radius: 6px;
- border: 1px solid #404040;
- display: block;
- background-color: #DADADA;
- }
- #nav{
- width: 95%;
- padding: 6px;
- marign-top: 90px;
- border-radius: 2px;
- height: 100 px;
- overflow: hidden;
- list-style-type: none;
- background-color: #404040;
- top: 0;
- position: sticky;
- }
- #Login{
- color: black;
- border-radius: 2px;
- cursor: pointer;
- transition: 0.3s ease;
- text-decoration: none;
- float: left;
- padding: 15px 15px;
- display: block;
- background-color:#DADADA;
- text-align: center;
- }
- #Varukorg{
- color: black;
- border-radius: 4px;
- cursor: pointer;
- float: right;
- transition: 0.3s ease;
- text-decoration: none;
- padding: 15px 15px;
- display: inline-block;
- background-color:#DADADA;
- text-align: center;
- }
- #product{
- width: 95%;
- height: 200px;
- text-align: center;
- padding: 10px 10px 10px 10px;
- border-radius: 2px;
- border: #404040 solid;
- }
- .dropdown{
- border-radius: 6px;
- border: 1px solid #404040;
- height: 60px;
- width: 97.3%;
- padding-left: 25px;
- padding-right: 25px;
- display: block;
- position: relative;
- margin-bottom: 25px;
- margin-top: 60px;
- z-index: 1;
- background-color: #DADADA;
- }
- .dropbutton {
- color: black;
- border-radius: 4px;
- cursor: pointer;
- transition: 0.3s ease;
- text-decoration: none;
- padding: 15px 15px;
- display: inline-block;
- background-color: #FAF8F8;
- text-align: center;
- position: static;
- }
- .dropbuttonVaru {
- color: black;
- float: right;
- border-radius: 4px;
- cursor: pointer;
- transition: 0.3s ease;
- text-decoration: none;
- padding: 15px 15px;
- display: inline-block;
- background-color: #FAF8F8;
- text-align: center;
- position: static;
- }
- .dropbutton:hover{
- opacity: 0.9;
- }
- .dropbuttonVaru:hover{
- opacity: 0.9;
- }
- .dropdown-content {
- border-radius: 10px;
- padding: 10px;
- display: none;
- position: absolute;
- background-color: #f1f1f1;
- max-width: 250px;
- overflow: auto;
- box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
- z-index: 1;
- }
- .dropdown-content-varu {
- text-align: left;
- border-radius: 10px;
- padding: 10px;
- display: none;
- top:54px;
- right: 27px;
- position: absolute;
- background-color: #f1f1f1;
- max-width:300px;
- min-width: 150px;
- overflow: auto;
- box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
- z-index: 1;
- }
- .show {
- display: block;
- }
- #Prod{
- margin-Bottom: 10px;
- padding: 25px 25px 25px 25px;
- height: 200px;
- border-radius: 6px;
- border: 1px solid #404040;
- background-color: #DADADA;
- overflow: hidden;
- }
- #icon{
- float: left;
- position: static;
- border-radius: 2px;
- border: 1px solid black;
- box-shadow: 1px 1px 1px 1px;
- }
- #info{
- font-size: 20px;
- width: 700px;
- text-decoration: underline;
- position: static;
- float: left;
- margin: auto;
- }
- #prodbuy{
- position: static;
- float: right;
- }
- #price{
- position: static;
- font-size: 46px;
- color: Green;
- }
- #Buy{
- position: static;
- color: black;
- border-radius: 4px;
- cursor: pointer;
- transition: 0.3s ease;
- text-decoration: none;
- padding: 15px 15px;
- display: inline-block;
- background-color: #FAF8F8;
- text-align: center;;
- }
- #UserName{
- text-decoration: underline;
- float: left;
- position: absolute;
- }
- #UserMenu{
- position: relative;
- }
- #UserMenuButton{
- float: left;
- width: 120px;
- position: absolute;
- }
- #MenuBase{
- width: 12.5%;
- margin-top: 25px;
- border-radius: 2px;
- border: #404040 solid;
- padding: 25px 25px 25px 25px;
- }
- #myPage{
- color: black;
- float: left;
- border-radius: 4px;
- cursor: pointer;
- transition: 0.3s ease;
- text-decoration: none;
- padding: 15px 15px;
- display: inline-block;
- background-color: #FAF8F8;
- text-align: center;
- position: relative;
- }
- javascript
- function toggleLoginDropDown(){
- document.getElementById("loginDropdown").classList.toggle("show")
- }
- function toggleCartDropDown() {
- document.getElementById("cartDropdown").classList.toggle("show")
- }
- function toggleSignUpDropDown(){
- document.getElementById("signUpDropdown").classList.toggle("show")
- }
- function signup(){
- var data1=$('#newuser').val();
- var data2=$('#newpwd').val();
- var dataTosend='Username='+data1+'&Password='+data2;
- $.ajax({
- url: 'signup.php',
- data:dataTosend,
- async: true,
- success: function (data) {
- alert("Du är nu registrerad");
- document.getElementById("signUpForm").reset();
- toggleSignUpDropDown();
- },
- }
- );
- }
- function mypage(){
- window.location = "myPage.php";
- }
- function login(){
- var data1=$('#username').val();
- var data2=$('#password').val();
- var dataTosend='Username='+data1+'&Password='+data2;
- $.ajax({
- url: 'login.php',
- data:dataTosend,
- async: true,
- success: function (data) {
- document.getElementById("loginForm").reset();
- toggleLoginDropDown();
- },
- }
- );
- window.location = "loggedin.php";
- }
- function submit_form(){
- var data1=$('#hidden_customer').val();
- var data2=$('#hidden_product').val();
- var dataTosend='Customer_id='+data1+'&Products_id='+data2;
- $.ajax({
- url: 'func.php',
- data:dataTosend,
- async: true,
- success: function (data) {},
- }
- );
- }
- function submit_form1(){
- var data1=$('#hidden_customer1').val();
- var data2=$('#hidden_product1').val();
- var dataTosend='Customer_id='+data1+'&Products_id='+data2;
- $.ajax({
- url: 'func.php',
- data:dataTosend,
- async: true,
- success: function (data) {},
- }
- );
- }
- function submit_form2(){
- var data1=$('#hidden_customer2').val();
- var data2=$('#hidden_product2').val();
- var dataTosend='Customer_id='+data1+'&Products_id='+data2;
- $.ajax({
- url: 'func.php',
- data: dataTosend,
- async: true,
- success: function (data) {},
- }
- );
- }
- function submit_form3(){
- var data1=$('#hidden_customer3').val();
- var data2=$('#hidden_product3').val();
- var dataTosend='Customer_id='+data1+'&Products_id='+data2;
- $.ajax({
- url: 'func.php',
- data: dataTosend ,
- async: true,
- success: function (data) {},
- }
- );
- }
- function submit_form4(){
- var data1=$('#hidden_customer4').val();
- var data2=$('#hidden_product4').val();
- var dataTosend='Customer_id='+data1+'&Products_id='+data2;
- $.ajax({
- url: 'func.php',
- data: dataTosend,
- async: true,
- success: function (data) {},
- }
- );
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement