網頁文章 javax.portlet.title.56
<html>

<head>
<title>查詢資料表的記錄資料</title>
<meta charset="utf-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>

<body>
<form action="20150511-2.php" method="post" enctype="multipart/form-data">

<table border=1>
<tr><td>產品編號:</td>
<td>自動新增ID</td>
</tr><tr><td>種類編號:</td>
<td><input type="text" name="mycategory" size="12" value="2"></td>
</tr><tr><td>產品名稱:</td>
<td><input type="text" name="myname" size="25" value="Miss"></td>
</tr><tr><td>製造商:</td>
<td><input type="text" name="mymanufacture" size="10" value="宏達電"></td>
</tr><tr><td>價錢:</td>
<td><input type="text" name="myprice"
size="10" value="500"></td></tr>
</table><hr>

選擇上傳檔案: <input type="file" name="Filename">
<br><br>
<input type="submit" name="Insert" value="送出">

</form>
</body>
</html>

 

網頁文章 javax.portlet.title.56

 <html>
<head><title>查詢資料表的記錄資料</title>
<meta charset="utf-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Ch7_5_2.htm</title>
<link rel="stylesheet" href="jquery.mobile.min.css">
<script src="jquery-1.6.4.min.js"></script>
<script src="jquery.mobile.min.js"></script>
</head>
<body>
<div data-role="page" id="home">
<div data-role="header">
<h1>Ch7_5_2</h1>
</div>
<div data-role="content">
<ul data-role="listview" data-inset="false" data-theme="c" >

<?

$php_id=$_POST["myid"];
$php_cate=$_POST["mycategory"];
$php_name=$_POST["myname"];
$php_manuf=$_POST["mymanufacture"];
$php_price=$_POST["myprice"];

$link = @mysqli_connect("localhost","10079537","10079537");
mysqli_select_db($link, "10079537");
$sql ="INSERT INTO jqm_products (category, name, manufacturer,price) value ($php_cate,'$php_name','$php_manuf',$php_price)";

if ( mysqli_query($link, $sql) ) // 執行SQL指令
echo "新增一筆資料成功 ". "<br>";
else
die("新增資料失敗<br>");


echo "上傳檔案資訊: <hr>";
echo "檔案名稱: ".$_FILES["Filename"]["name"]."<br>";
echo "暫存檔名: ".$_FILES["Filename"]["tmp_name"]."<br>";
echo "檔案尺寸: ".$_FILES["Filename"]["size"]."<br>";
echo "檔案種類: ".$_FILES["Filename"]["type"]."<br><hr>";

$sql ="select max(id) from jqm_products";
$result = mysqli_query($link, $sql);
$row = mysqli_fetch_row($result);

if ( copy($_FILES["Filename"]["tmp_name"],
$row[0]."."."png")) {
echo "檔案上傳成功<br>";
unlink($_FILES["Filename"]["tmp_name"]);
mysqli_free_result($result);
}
else
echo "檔案上傳失敗<br>";


$sql = "SELECT * FROM jqm_products";
if ( $result = mysqli_query($link, $sql) ) {
while( $row = mysqli_fetch_assoc($result) )
{
echo "<li>". "<img src=".$row["id"].".png height=80 width=80>".$row["name"]."<span class=\"ui-li-aside\">"."NT$".$row["price"]."</span></li>";
}
mysqli_free_result($result);
}
mysqli_close($link);

?>
</ul>
</div>
</body>
</html>