//1.連接數據庫
include_once?“MySQL.php“;
//2.防止中文亂碼
$pdo->query（“SET?NAMES?‘UTF8‘“）;

//3.通過action的值進行對應操作
switch?（$_GET[‘action‘]）?{
?????case?“login“:{//1.驗證登錄
????????$worker_id?=?$_POST[‘worker_id‘];
????????$password?=?$_POST[‘password‘];
????????$sql_in?=?“SELECT?*?FROM?workers?WHERE?worker_id=‘{$worker_id}‘?and?password=‘{$password}‘“;
????????$stmt?=?$pdo->query（$sql_in）;//返回預處理對象
????????if（$stmt->rowCount（）>0）{
????????????$sql?=?“SELECT?*?FROM?workers?WHERE?worker_id=‘{$worker_id}‘?and?password=‘{$password}‘“;
????????????foreach?（$pdo->query（$sql）?as?$row）{
????????????if（$row[‘job‘]==“manager“）
????????????{
????????????????echo?“ript>?alert（‘登錄成功‘）;
????????????????????????????????window.location=‘index.php‘;?//跳轉到首頁
?????????????????????ript>“;
?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-14?22:08??grocery\
?????文件????????8474??2017-06-14?22:15??grocery\action.php
?????文件???????32525??2017-05-28?15:28??grocery\bgp.jpg
?????文件???????15903??2017-05-28?15:28??grocery\bgp3.jpg
?????文件???????24272??2017-05-28?15:28??grocery\bgp7.jpg
?????文件????????5331??2017-06-14?17:39??grocery\echarts.html
?????文件??????640759??2017-06-14?15:50??grocery\echarts.min.js
?????文件????????2131??2017-06-12?15:27??grocery\edit_commodity.php
?????文件????????2116??2017-06-12?14:52??grocery\edit_vendor.php
?????文件???????21532??2017-06-14?18:00??grocery\grocery.jpg
?????文件????????2016??2017-06-12?15:29??grocery\index.php
?????文件????????1479??2017-06-14?21:36??grocery\insert_commodity.php
?????文件????????1752??2017-06-14?21:37??grocery\insert_vendor.php
?????文件????????1117??2017-06-11?11:54??grocery\inventory_table.php
?????文件???????92629??2017-06-14?16:00??grocery\jquery-1.9.1.min.js
?????文件????????1098??2017-06-14?21:01??grocery\login.html
?????文件????????1561??2017-06-14?18:26??grocery\manager_menu.php
?????文件?????????122??2017-06-10?19:59??grocery\menu.php
?????文件????????1760??2017-06-14?18:23??grocery\month_purchase.php
?????文件?????????187??2017-06-10?16:19??grocery\MySQL.php
?????文件????????2267??2017-06-11?12:03??grocery\purchase.php
?????文件?????????389??2017-06-14?18:25??grocery\query_menu.php
?????文件?????????740??2017-06-10?19:20??grocery\random_number.php
?????文件????????3114??2017-06-14?18:22??grocery\report_menu.php
?????文件????????2225??2017-06-12?11:34??grocery\sale.php
?????文件?????????401??2017-06-14?21:41??grocery\sale_purchase.php
?????文件????????1791??2017-06-14?17:17??grocery\sql.php
?????文件??????????72??2017-06-13?18:33??grocery\table.php
?????文件?????????438??2017-06-12?11:34??grocery\time.php
?????文件????????1713??2017-06-12?12:52??grocery\today_sale.php
?????文件????????2020??2017-06-12?13:51??grocery\vendors.php
............此處省略1個文件信息