Created
November 26, 2016 13:26
-
-
Save tsux89/989082f2601ee96c521b9afba58245b4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- ヘッダー部分 --> | |
<html> | |
<body> | |
<form action = "goodsResult.php" method="POST"> | |
商品名:<input type="text" name="GoodsName"> | |
<input type="submit" name="exec" value="検索"> | |
</form> | |
</body> | |
</html> | |
<?php | |
session_start(); | |
// ていぎ | |
$db['host'] = "localhost"; // DBサーバのURL | |
$db['user'] = "root"; // ユーザー名 | |
$db['pass'] = ""; // ユーザー名のパスワード | |
$db['dbname'] = "スーパー商品取扱"; // データベース名 | |
$search = $_GET['search']; | |
if ( $search !== null ) { // $searchに何か格納されている場合は、POST送信されたものを優先させる。 | |
//ホームページからの検索を表示 | |
$dsn = sprintf('mysql: host=%s; dbname=%s; charset=utf8', $db['host'], $db['dbname']); | |
$pdo = new PDO($dsn, $db['user'], $db['pass'], array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); | |
$search = isset($_REQUEST['search']); | |
$sql="SELECT * FROM goods WHERE GoodsName LIKE BINARY '{$search}%'"; | |
$sql="SELECT * FROM goods WHERE GoodsName LIKE BINARY '%{$search}'"; | |
$stmt = $pdo->query($sql); | |
foreach ($stmt as $row) { | |
echo $row["GoodsName"] . "<br>" ; | |
echo $row["Price"] . "<br>" ; | |
echo $row["Maker"] . "<br>" ; | |
echo "<br />"; | |
} | |
} else { // そうでなければ、下記の実行分は実行しない。 | |
$GN = $_POST["GoodsName"]; | |
$dsn = sprintf('mysql: host=%s; dbname=%s; charset=utf8', $db['host'], $db['dbname']); | |
$pdo = new PDO($dsn, $db['user'], $db['pass'], array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); | |
//このページ内のボックスからの検索 | |
$sql="SELECT * FROM goods WHERE GoodsName LIKE BINARY '{$GN}%'"; | |
$sql="SELECT * FROM goods WHERE GoodsName LIKE BINARY '%{$GN}'"; | |
$stmt = $pdo->query($sql); | |
foreach ($stmt as $row) { | |
echo $row["GoodsName"]."<br>"; | |
echo $row["Price"]."<br>"; | |
echo $row["Maker"]."<br>"; | |
echo "<br />"; | |
} | |
} | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php // ここからPHP | |
session_start(); | |
$db['host'] = "localhost"; // DBサーバのURL | |
$db['user'] = "root"; // ユーザー名 | |
$db['pass'] = ""; // ユーザー名のパスワード | |
$db['dbname'] = "スーパー商品取扱"; // データベース名 | |
if (!empty($_SESSION['NUMBER'])) { | |
$number = $_SESSION["NUMBER"]; | |
$dsn = sprintf('mysql: host=%s; dbname=%s; charset=utf8', $db['host'], $db['dbname']); | |
$pdo = new PDO($dsn, $db['user'], $db['pass'], array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); | |
$sql = "SELECT * FROM member WHERE MemberNumber = '$number'"; | |
$stmt = $pdo->query($sql); | |
foreach ($stmt as $row) { | |
$nam = $row['Name']; | |
} | |
} | |
?> | |
<!DOCTYPE html> | |
<html lang="ja"> | |
<head> | |
<meta charset="utf-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
<meta name="viewport" content="width=device-width, initial-scale=1"> | |
<title>Bootstrap Sample</title> | |
<!-- BootstrapのCSS読み込み --> | |
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet"> | |
<!-- jQuery読み込み --> | |
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> | |
<!-- BootstrapのJS読み込み --> | |
<script src="bootstrap/js/bootstrap.min.js"></script> | |
<!-- cssのJS読み込み --> | |
<link href="index.css" rel="stylesheet" type = "text/css"/> | |
<!-- jQuery.jsの読み込み --> | |
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> | |
<!-- スムーズスクロール部分の記述 --> | |
<script> | |
$(function(){ | |
// #で始まるアンカーをクリックした場合に処理 | |
$('a[href^=#]').click(function() { | |
// スクロールの速度 | |
var speed = 400; // ミリ秒 | |
// アンカーの値取得 | |
var href= $(this).attr("href"); | |
// 移動先を取得 | |
var target = $(href == "#" || href == "" ? 'html' : href); | |
// 移動先を数値で取得 | |
var position = target.offset().top + 60; | |
// スムーススクロール | |
$('body,html').animate({scrollTop:position}, speed, 'swing'); | |
return false; | |
}); | |
}); | |
</script> | |
</head> | |
<body> | |
<!--bootstrapの使い方 | |
<div class="container-fluid"> | |
<div class="row"> | |
<div class="col-sm-2" style="background-color:red;">Red</div> | |
<div class="col-sm-8" style="background-color:blue;">Blue</div> | |
<div class="col-sm-2" style="background-color:yellow;">Yellow</div> | |
</div> | |
</div> | |
--> | |
<!-----------header------------> | |
<div class = "header"> | |
<div class = "menu"> | |
<?php | |
if ( !isset($_SESSION['NUMBER']) ) { | |
echo "ようこそ、ゲスト さん<br>"; | |
echo '<a href= "user/reg.php"><p class = "touroku">新規登録</p></a><a href= "user/login.php"><p class = "login">ログイン</p></a>'; | |
} else { | |
echo "ようこそ、<span class ='name'>$nam</span> さん<br>"; | |
echo '<a href= "user/mypage.php"><p class = "touroku">マイページ</p></a><a href= "logout.php"><p class = "login">ログアウト</p></a>'; | |
} | |
?> | |
</div> | |
</div> | |
<!-----------contents------------> | |
<div class ="contents clearfix"> | |
<img src="../design_image/logo.png" alt="" class = "logo"> | |
<div class= "kensaku"> | |
<form action = "goods/goodsResult.php" method = "GET"> | |
<input type= "text" name = "search" placeholder="検索ワードを入力" size = "40" class = "form"> | |
<input type = "submit" value ="検索" class ="form2"> | |
</form> | |
<p class="left"><input type = "radio" name = "kensaku" value="0"> 商品を検索 | |
<input type = "radio" name = "kensaku" value="1"> 店舗を検索</p> | |
<a href = "#scroll"><p class = "tiiki">地域から検索</p></a> | |
</div> | |
</div> | |
<div class = "contents2" id="scroll"> | |
<img src="../design_image/map_hai.png" alt="" width="800px"> | |
<a href ="location.php"><img src="../design_image/osaka-02.png" alt="" width="75px" class ="ab"></a> | |
</div> | |
<!-----------footer------------> | |
<div class = "footer"> | |
<div class ="gazou clearfix"> | |
<img src="../design_image/machi.png" alt="" class = "foot1" > | |
</div> | |
<?php // PHPでセッションがあれば、店舗ログインを非表示 | |
if ( !isset($_SESSION['NUMBER'])){ | |
echo '<a href ="../store/login.php"><p class ="tenpo">店舗ログイン</p></a>'; | |
} | |
else{ | |
echo '<p class ="tenpo"></p>'; | |
} | |
?> | |
</div> | |
</body> | |
</html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment