1. 云栖社区>
  2. PHP教程>
  3. 正文

创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表

作者:用户 来源:互联网 时间:2017-12-01 17:13:19

公司浏览出入口产品查询

创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表 - 摘要: 本文讲的是创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表, 看到网络上流行用户角色管理代码,不管是java 或php,都是十分复杂和烦闷的。笔者认为一定有些更简单方法来处理差不多的问题。角色管理主要是提供适当的功能给不同的用户使用而已。其实很简单的,用虚拟数码方式来控制网页上的功能。以下是介绍虚拟

看到网络上流行用户角色管理代码,不管是java 或php,都是十分复杂和烦闷的。笔者认为一定有些更简单方法来处理差不多的问题。角色管理主要是提供适当的功能给不同的用户使用而已。其实很简单的,用虚拟数码方式来控制网页上的功能。以下是介绍虚拟数码方式应用,希望对那些有兴趣的读者增添新方向。


出入口公司产品查询浏览表制作:

亮点:

1.        出入口公司适用,内容是英文的,当然可以改成中文。

2.        原创虚拟数码技术来控制页面的按钮功能。简单易用。可以应用其他领域。

3.        全MySql PDO运作。

4.        分页及前端可采用最新EasyUI。

5.        本页任何资料快速查询,不作连接远程服务器。

6.        适用萍果系统(Mac)和Windows 7/8

 

适用者须懂得基本开发Php+Mysql+EasyUI步骤。

首页面

 创新实用<a href=PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表">

除了取消以外,按其他任何一个按钮都出现popup,用户必须输入其姓名及密码才可以使用该功能。

页面上有4个功能:新增(1),编辑(2),删除(4),保存(8)。例如使用者A可以使用新增和

保存而没有删除和编辑,他的使用权数是1+8=9;使用者B可以使用新增,编辑,删除和保存,他的

使用权数是1+2+4+8=15。可见储存逻辑简明维护容易。结果资料库(t_db.member.sql)显示如下:

 创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表

当然可以用后台角色等来处理,但那有这样清晰简单,适用于简单页面功能分配。测试可输usera 或userb的密码。

 创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表

按所需功能纽再输入用户姓名及密码(usera, 123):

 创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表

以下是按下了“新增“功能纽,输入了正确用户姓名及密码后出现新增一行,就可以填写产品资料。填好后按保存纽便完成。 Usera功能使用权含新增和保存(1+8)。如果没有该功能权是不能启动的。

创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表

快速搜索:任何文字资料都可以查询。

创新实用PHP5.2.9+MySQL5.6.26+Easyui 1.41出入口公司产品查询浏览表

有关上术运作功能,请参考http://jeasyui.com/。

测试和使用环境:

OS X Yosemite, mamp pro

Win7/8 xampp 1.8.2, phpmyadmin4.05

解压后把该目录 (nproducts)放到htdocs内或其他相对应目录里,安装资料库后就可在浏览器运行。注意使用这两系统的启动URL不同。( http://localhost/nproducts/ 和 http://localhost:8888/nproducts/  ), 看你的系统设置而已。

每测试一个用户后,必须清除浏览记录及刷新该网页才进行。如果安装了迅雷的系统,要注意迅雷自动为你的浏览器添加了代码,而不能正常运作。用QQ, EE 或搜狗浏览器比较安全。

 

以下是主要代码:

Index.php

 

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

       <metahttp-equiv="Content-Type" content="text/html;charset=UTF-8">

       <metaname="keywords" content="jquery,ui,easy,easyui,web">

       <metaname="description" content="easyui help you build your web pageeasily!">

    <METAHTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">

   <META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">

       <title>出入口公司产品浏览和查询</title>

  

    <linkrel="stylesheet" type="text/css"href="themes/default/easyui.css">

       <linkrel="stylesheet" type="text/css"href="themes/icon.css">

       <linkrel="stylesheet" type="text/css"href="demo.css">

  

  

   <script type="text/javascript"src="jquery.min.js"></script>

 

       <scripttype="text/javascript"src="jquery.easyui.min.js"></script>

   <scripttype="text/javascript"src="http://www.jeasyui.com/easyui/jquery.edatagrid.js"></script>

      <script type="text/javascript"src="permits_in_array.js"></script>

      

</head>

<body>

      

       <tableid="dg" title="出入口公司产品"style="width:1060px;height:425px; font-size:16px"

                     toolbar="#toolbar"pagination="true" idField="id"

                     rownumbers="true"fitColumns="true" singleSelect="true">

       

              <thead>

                     <tr>

               <th field="id" width:120px hidden="yes">

              <span style="font-weight: 400">ID</th>

                            <thfield="category" width:120px editor="text"align="center">

                            <spanstyle="font-weight: 400">Category</th>

              <th field="picture" width:120px hidden="yes">

                            <thfield="product_code" width:120pxeditor="{type:'validatebox',options:{required:true}}"align="center">

                            <spanstyle="font-weight: 400">Product <br />Code</span></th>

               <th field="product_name" width:95pxeditor="text">

                            <spanstyle="font-weight: 400">Product Name</span></th>

                            <thfield="material" width:65px editor="text">

                         <span style="font-weight:400">Material</span></th>

                            <thfield="product_size" width:60px editor="text">

                            <spanstyle="font-weight: 400">Product Size</span></th>

                            <thfield="moq" width:150px align="center"  editor="numberbox">

                            <spanstyle="font-weight: 400">MOQ (pcs)</span></th>

                            <thfield="product_price" width:70px align="center"editor="{type:'numberbox',options:{precision:2}}">

                            <spanstyle="font-weight: 400">Price (RMB)</span></th>

                            <thfield="fob" width:60px align="center"editor="{type:'numberbox',options:{precision:2}}">

                            <spanstyle="font-weight: 400">FOB (USD)</span></th>

                            <thfield="certification" width:70px editor="text">

                            <spanstyle="font-weight: 400">Certification</span></th>

                            <thfield="logo_price" width:95px align="right"editor="{type:'numberbox',options:{precision:2}}">

                            <spanstyle="font-weight: 400">Logo<br/>Price</span></th>

                            <thfield="delivery_time" width:70px align="center"editor="numberbox">

                            <spanstyle="font-weight: 400">Delivery <br />

                                                                                            Time</span></th>

                            <thfield="setup_fee" width:70px align="right"editor="{type:'numberbox',options:{precision:2}}">

                            <spanstyle="font-weight: 400">Set-Up <br />

                                                                                            Charge</span></th>

               <th field="sample_price" width:80px align="right"editor="{type:'numberbox',options:{precision:2}}">

                            <spanstyle="font-weight: 400">Sample <br/>Fee</span></th>                                        

                            <thfield="sample_time" width:80px align="center"editor="numberbox">

                            <spanstyle="font-weight: 400">Sample <br/>Time</span></th>

               <th field="shipping_fee" width:70pxalign="center" editor="{type:'numberbox',options:{precision:2}}">

                            <spanstyle="font-weight: 400">Shipping <br/>Fee</span></th>

               <th field="export_document" width:120pxhidden="yes">

               <th field="qty_ctn" width:70px align="center"editor="text">

                            <span style="font-weight:400">QTY/CTN</span></th>

               <th field="ctn_size" width:70px align="center"editor="text">

                            <spanstyle="font-weight: 400">CTN Size</span></th>

                            <thfield="gw" width:50px editor="numberbox">

                            <spanstyle="font-weight: 400">GW</span></th>

               <th field="nw" width:50px editor="numberbox">

                            <spanstyle="font-weight: 400">NW</span></th>

                            <thfield="package" width:150px editor="text">

                            <spanstyle="font-weight: 400">Package</span></th>

               

               <th field="description" fixed:true width:75pxeditor="text">

                            <spanstyle="font-weight: 400">ProductDescription</span></th>

                            <thfield="qverall_bulk" width:50px align="center"editor="numberbox">

                            <spanstyle="font-weight: 400">Overall Bulk<br/>CBM</span></th>

              <th field="ton" width:120px hidden="yes">

                            <thfield="manufacturer" width:100px editor="text">

                            <spanstyle="font-weight: 400">Manufacturer</span></th>

                            <thfield="remark" width:170px editor="text">

                            <spanstyle="font-weight: 400">Remark</span></th>

                            <thfield="sales" width:75px align="center"editor="text">

                            <spanstyle="font-weight: 400">Sales</span></th>

                            <thfield="time" width:65px align="center">

                            <spanstyle="font-weight: 400">Date</span></th>

                     </tr>

              </thead>

       </table>

       <divid="toolbar">

   <div>

        <ahref="#" class="easyui-linkbutton"iconCls="icon-add" plain="true" onclick="passWord(add_function)">新增</a>

        <ahref="#" class="easyui-linkbutton"iconCls="icon-edit" plain="true"onclick="passWord(edit_function)">编辑</a>

              <ahref="#" class="easyui-linkbutton"iconCls="icon-remove" plain="true"onclick="passWord(destroy_function)">删除</a>

              <ahref="#" class="easyui-linkbutton"iconCls="icon-save" plain="true"onclick="passWord(save_function)">保存</a>

              <ahref="#" class="easyui-linkbutton"iconCls="icon-undo" plain="true"onclick="javascript:$('#dg').edatagrid('cancelRow')">取消</a>

       </div>

 

  <divid='tb' style='padding:5px 8px;'>

            本页快速搜索:<INPUT id='ss' class='easyui-searchbox' searcher="doSearch"style='width:250px'

                                        data-options="prompt:'请输入查询内容.'"/>

              <ahref="#" class="easyui-linkbutton" plain="true"onClick="reset()">重置</a>     

       </div>

 </div>

 

  

 <divid="dlg" class="easyui-dialog"style="width:400px;height:200px;padding:10px 20px"

                     closed="true"buttons="#dlg-buttons">

              <divclass="ftitle">用户登录资料</div>

      

              <formid="fm" method="post" novalidate> 

    <table width="309" border="0"align="center" cellpadding="2"cellspacing="5">

  

                     <divclass="fitem">

                            <label>用户姓名:</label>

                            <inputname="username" class="easyui-validatebox" required>

                     </div>

                     <divclass="fitem">

                            <label>密   码:</label>

                            <inputtype="password" name="password"class="easyui-validatebox" required>

                     </div>

    </table>

              </form>

       </div>

       <divid="dlg-buttons">

              <ahref="#" class="easyui-linkbutton"iconCls="icon-ok" onclick="login()">登入</a>

              <ahref="#" class="easyui-linkbutton"iconCls="icon-cancel"onclick="javascript:$('#dlg').dialog('close')">取消</a>

       </div>

   

  <scripttype="text/javascript">

       varadd_function = 1;

       varedit_function = 2;

       vardestroy_function = 4;

       varsave_function = 8;

       varurl;

       varlog_in = 0;

       varpermit = 0;

       varrequest = 0;

      

       functionpassWord(f){

              request= f;

             

              if(log_in){

                     if(permits_in_array(f, permit))

              {  sim_digital(f);

                              }else {

                                     $.messager.show({

                       title: '使用权错误',

                        msg: "该功能你没有使用权!"

                    });

                            }

              }else{

                     $('#dlg').dialog('open').dialog('setTitle','功能使用权!');

                     $('#fm').form('clear');

                     url= 'login.php';

              }

   }

    

function login(){

 

       $('#fm').form('submit',{

           url: url,

           onSubmit: function(){

               return $(this).form('validate');

           },

           success: function(result){

              var result = eval('('+result+')');

               if (result.success){

                   $('#dlg').dialog('close');         //close the dialog

                                log_in = result.login;

                                   permit=result.msg;

                               if (permits_in_array(request,Number(result.msg))) {

                                      sim_digital(request);

                               }else{

                                      $.messager.show({

                        title: '登录错误',

                        msg: "密码错误或没有该使用权!"

                    });

                 }

               } else {

                   $.messager.show({

                        title: '登录错误',

                        msg: "密码错误或没有该使用权"

                   });

               }

            }

        })

             

    }

 

       functionsim_digital(f) {

             

              switch(f){

                     caseadd_function: $('#dg').edatagrid('addRow');

                            break;

                     caseedit_function: $.messager.show({

                        title: '编辑资料',

                        msg: '滑鼠选该行及按一下进行编辑所需资料。'

                   });

                            break;

                     casedestroy_function: $('#dg').edatagrid('destroyRow');

                            break;

                     casesave_function: $('#dg').edatagrid('saveRow');

                            break;

              }

       }

      

       functionreset(){

                     $('#dg').datagrid('reload');

                     $('#ss').searchbox('reset');

              }

              functiondoSearch(q){

         varrows = [];

         vardata = $('#dg').datagrid('getRows');

        $.map(data, function(row){

           for(var p in row){

               var v = row[p];

              var regExp = new RegExp(q, 'i'); // i - makes the searchcase-insensitive.

              if(regExp.test(String(v))) {

                 rows.push(row);

                 break;

              }

            }

         });

        $('#dg').datagrid('loadData', rows);

      }

       $(function(){

                     $('#dg').edatagrid({

                            url:'get_products.php',

                            saveUrl:'save_products.php',

                            updateUrl:'update_products.php',

                            destroyUrl:'destroy_products.php'

                     });

              });

       </script>

   

    <style type="text/css">

              #fm{

                     margin:0;

                     padding:10px30px;

              }

              .ftitle{

                     font-size:14px;

                     font-weight:bold;

                     color:#666;

                     padding:5px0;

                     margin-bottom:10px;

                     border-bottom:1pxsolid #ccc;

              }

              .fitem{

                     margin-bottom:5px;

              }

              .fitemlabel{

                     display:inline-block;

                     width:80px;

              }

       </style>

</body>

</html>

 

Login.php

 

<?php

 

//插入连接数据库的相关信息

$dsn= "mysql:host=localhost;dbname=t_db";

 try {

       $db = new PDO($dsn, 'root', '');

       $db->exec("SET CHARACTER SETutf8");

 

       //Array to store validation errors

       $user_username = ($_POST['username']);

       $user_password = ($_POST['password']);

 

//判断用户是否已经设置cookie,如果未设置$_COOKIE['user_id']时,执行以下代码

if(!isset($_COOKIE['mem_id'])){     

       if(!empty($user_username)&&!empty($user_password)){

            //MySql中的SHA()函数用于对字符串进行单向加密

          //$query = "SELECT mem_id,username FROM member WHERE username = '$user_username' AND"."password = SHA('$user_password')";

            //用用户名和密码进行查询

            //若查到的记录正好为一条,则设置COOKIE,同时进行页面重定向

                     $sql="SELECT * FROMmember WHERE username='".$user_username."'";

                     $rs=$db->prepare($sql);

                     $rs->execute();

                 $result= $rs->fetch(PDO::FETCH_OBJ);

                     $dbPwd=$result->password;

                     $dbUsername=$result->username;

                     $dbMem_id=$result->mem_id;

                     $db_permit=$result->permit;

            if($result){

                     if($rs->rowcount() >0) {

                                   if(password_verification($user_password,$dbPwd) & $user_username ==$dbUsername)

                                   {

            setcookie('mem_id',$dbMem_id);

            setcookie('username',$dbUsername);

          echojson_encode(array('success'=>true, 'msg'=>$db_permit, 'login'=>1));

                            exit();

                             

                      }else{//若查到的记录不对,则设置错误信息

                //Login failed

                            $errmsg_arr[] ='user name and password not found';

                            $errflag = true;

                            if($errflag) {

                                   //$_SESSION['ERRMSG_ARR']= $errmsg_arr;

                                   //session_write_close();

                            echojson_encode(array('msg'=>'Incorrect user name or password!'));

                            exit();

                            }

                     }

                            }

        }

    }

 // }else{//如果用户已经登录,则直接跳转到已经登录页面

    //$home_url = 'index.php';

    //header('Location: '.$home_url);

 //}

}

 $db = null;        // Disconnect

}

       catch(PDOException $e) {

      echo$e->getMessage();

       }

      

functionpassword_verification($a, $b){

       if ($a==$b){

       return true;}else{

       return false;} 

}

 

?>

 

 

Permit_in_Array.js

 

 

function in_array(needle, haystack){

       if(typeofneedle=='string' || typeof needle =='number') {

              for(vari in haystack) {

                     if(haystack[i]==needle){

                            returntrue;

                     }

              }

       }

       returnfalse;

}

 

$assign1 = 1;

$assign2 = 2;

$assign3 = new Array(1, 2);

$assign4 = 4;

$assign5 = new Array(1, 4);

$assign6 = new Array(2, 4);

$assign7 = new Array(1, 2, 4);

$assign8 = 8;

$assign9 = new Array(1, 8);

$assign10 = new Array(2, 8);

$assign11 = new Array(1, 2, 8);

$assign12 = new Array(4, 8);

$assign13 = new Array(1, 4, 8);

$assign14 = new Array(2, 4, 8);

$assign15 = new Array(1, 2, 4, 8);

//request represents push functions as 1, 2, 4, 8;assign_array as the user has the assigned value for control of the pushfunctions. Let say assigned value is 3, it means the user is able to click onfunction1 and function2; 5=>1 and 4;

 

 

function permits_in_array(request, assign_array){

      

       switch(assign_array){

             

              case1: assign=$assign1;

                            break;

              case2: assign=$assign2;

                            break;

              case3: assign=$assign3;

                            break;

              case4: assign=$assign4;

                            break;

              case5: assign=$assign5;

                            break;

              case6: assign=$assign6;

                            break;

              case7: assign=$assign7;

                            break;

              case8: assign=$assign8;

                            break;

              case9: assign=$assign9;

                            break;

              case10: assign=$assign10;

                            break;

              case11: assign=$assign11;

                            break;

              case12: assign=$assign12;

                            break;

              case13: assign=$assign13;

                            break;

              case14: assign=$assign14;

                            break;

              case15: assign=$assign15;

                            break;

              default:break;              

       }

       if (request== assign_array) {

              switch(request){

                     case1: return(1);

                            break;

                     case2: return(1);

                            break;

                     case4: return(1);

                            break;

                     case8: return(1);

                            break;

                     default:break;

                     }

                    

              }else{

                    

       //     if (in_array(request, assign)) {

                     switch(request) {

                           

                            case1: if (in_array(request, assign)) return(1);

                                   break;

                            case2:     if (in_array(request, assign))return(1);

                                   break;

                            case4:     if (in_array(request, assign))return(1);

                                   break;

                            case8: if (in_array(request, assign)) return(1);

                                   break;

                                  

                     default:$.messager.show({

                        title: 'PermissionError',

                        msg: "You are notpermitted to activate this function!"

                   });

              }

             

       /*    }

             

              else$.messager.show({

                        title: 'PermissionError',

                        msg: "You are notpermitted to activate this function!"

                   });*/

       };

      

}

      

 

Get_products.php

 

<?php

       $page =isset($_POST['page']) ? intval($_POST['page']) : 1;

       $rows =isset($_POST['rows']) ? intval($_POST['rows']) : 10;

      

       $category= isset($_POST['category']) ? mysql_real_escape_string($_POST['category']) :'';

       $product_code= isset($_POST['product_code']) ? mysql_real_escape_string($_POST['product_code']): '';

       $product_name= isset($_POST['product_name']) ?mysql_real_escape_string($_POST['product_name']) : '';

      

       $offset= ($page-1)*$rows;

       $results= array();

       $crud =array();

 

       $dsn ="mysql:host=localhost;dbname=t_db";

try {

       $db =new PDO($dsn, 'root', 'root');

       $db->exec("SETCHARACTER SET utf8");

 

       //$rs =$db->prepare("SELECT COUNT(*) FROM clients");

       $where= "category like '$category%' and product_code like '$product_code%' andproduct_name like '$product_name%'";

 

       $rs =$db->prepare("SELECT COUNT(*) FROM products where " . $where);

       $rs->execute();

      

       $row =$rs->fetch();

       $results["total"]= $row[0];

       //$rs =$db->prepare("SELECT * from clients limit $offset,$rows");

       $rs =$db->prepare("select * from products where " . $where . "limit $offset,$rows");

       $rs->execute();

       $rows=$rs->fetchAll(PDO::FETCH_ASSOC);

 

       foreach($rowsas $row){

      

              array_push($crud,$row); 

       } 

       $results["rows"]=$crud;

       echojson_encode($results); 

        

        $db = null;        // Disconnect

}

       catch(PDOException$e) {

      echo $e->getMessage();

}

?>

 

其他代码大同小异,不再贴上。请参考本慱客的下载。

原创,如有转载,请注明出处。




 


以上是云栖社区小编为您精心准备的的内容,在云栖社区的博客、问答、公众号、人物、课程等栏目也有的相关内容,欢迎继续使用右上角搜索按钮进行搜索公司 , 浏览 , 出入口 产品查询 ,以便于您获取更多的相关知识。