網頁文章 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-1.php" method="post" enctype="multipart/form-data">

<table border=0>

自動新增表單資料
</tr><tr><td>種類編號:</td>
   <td><input type="text" name="mycategory" size="20" value=""></td>
</tr><tr><td>產品名稱:</td>
   <td><input type="text" name="myname" size="20"  value=""></td>
</tr><tr><td>製造商:</td>
   <td><input type="text" name="mymanufacture" size="20" value=""></td>
</tr><tr><td>價錢:</td>
   <td><input type="text" name="myprice" size="20" value=""></td></tr>
</table><br>

選擇上傳檔案: <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","10079505","10079505");
   mysqli_select_db($link, "10079505");
   $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>