sql\MysqlPDO PHP代码示例

示例#1

0

显示文件

文件： add_craft.php 项目： ab300819/CraftManage

<?php

/**
 * Created by PhpStorm.
 * User: Think
 * Date: 2015/10/19
 * Time: 13:28
 */
require_once dirname(__FILE__) . '/../sql/mysql.php';
require_once dirname(__FILE__) . '/../sql/table_config.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
$db = new \sql\MysqlPDO($level);
$id = $_GET['id'];
$head = array('craft_num', 'material_num', 'belong', 'craft_type');
//$nuclear = array(
//    '机加工' => 'add_machine.php',
//    '铸造' => 'add_foundry.php',
//    '焊接' => 'add_welding.php',
//    '锻造' => 'add_forging.php',
//    '热处理' => 'add_heat.php',
//    '装配' => 'add_assembly.php',
//
//);
//$metallurgy = array(
//    '机加工' => 'add_metallurgy.php'
//);
$list = $db->get_choice_select(PRODUCT, $head, "id={$id}");
if ($list == null) {
    echo "<script>\n            alert('没有相关产品！');\n            window.history.back();\n          </script>";

示例#2

0

显示文件

文件： edit_product.php 项目： ab300819/CraftManage

<?php

require_once dirname(__FILE__) . '/../sql/mysql.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
$db = new \sql\MysqlPDO($level);
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>产品信息</title>
<<<<<<< HEAD
    <link href="../res/css/custom/editList.css" rel="stylesheet" type="text/css">
    <link href="../res/css/custom/button.css" rel="stylesheet" type="text/css">
=======
    <link type="text/css" rel="stylesheet" href="../res/css/custom/panel.css">
    <link type="text/css" rel="stylesheet" href="../res/libs/jquery-ui-themes/themes/base/jquery-ui.min.css">
>>>>>>> dev

    <script>
        function selectValue(select, value) {
            var sel = document.getElementById(select);
            var op = sel.options;
            for (var i = 0; i < op.length; i++) {
                var tempValue = op[i].value;
                if (tempValue == value) {
                    op[i].selected = true;
                }
            }

示例#3

0

显示文件

文件： login.php 项目： ab300819/CraftManage

<?php

require_once 'sql/mysql.php';
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
if (!empty($username) && !empty($password)) {
    $db = new \sql\MysqlPDO(0);
    $list = $db->get_select(USER, "username='******'");
    if ($list['password'] != $password) {
        echo "<script>\n                  alert('密码错误！');\n                  window.location='index.html';\n          </script>";
    } elseif ($list['level'] == 3) {
        $_SESSION[$username] = $list['level'];
        $_SESSION['user'] = $list['username'];
        header("Location:main.html");
    } elseif ($username == 'admin') {
        $_SESSION[$username] = $list['level'];
        $_SESSION['user'] = $list['username'];
        echo "<script>window.location='admin/manage_panel.php'</script>";
    } else {
        $_SESSION[$username] = $list['level'];
        $_SESSION['user'] = $list['username'];
        header("Location:main.html");
    }
} else {
    echo "<script>\n                  alert('用户名或密码不为空！');\n                  window.location='index.html';\n          </script>";
}

示例#4

0

显示文件

文件： list_product.php 项目： ab300819/CraftManage

<?php

/**
 * Created by PhpStorm.
 * User: Think
 * Date: 2015/10/18
 * Time: 14:46
 */
require_once 'sql/mysql.php';
require_once 'sql/operate.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
$db = new \sql\MysqlPDO($level);
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>产品列表</title>
    <link type="text/css" rel="stylesheet" href="res/css/custom/list.css">
    <link type="text/css" rel="stylesheet" href="res/css/custom/button.css">
    <script type="text/javascript" src="res/libs/jquery/jquery-2.2.0.min.js"></script>
    <script>
        function addCol() {
            $col = $("<td>删除</td>");
            $("#product>tbody>tr").append($col);
        }
        function edit() {
            var line = document.getElementById("product").getElementsByTagName("tr");
            for (var i = 0; i < line.length - 2; i++) {

示例#5

0

显示文件

文件： manage_panel.php 项目： ab300819/CraftManage

<?php

require_once dirname(__FILE__) . '/../sql/mysql.php';
require_once dirname(__FILE__) . '/../sql/operate.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
if ($user != 'admin') {
    echo "<script>\n    confirm('你不是管理员！');\n    window.location='../index.html';\n          </script>";
} else {
    $db = new \sql\MysqlPDO($level);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>账号管理</title>
<<<<<<< HEAD
    <link href="../res/css/custom/editList.css" rel="stylesheet" type="text/css">
=======
    <link href="../res/css/custom/list.css" rel="stylesheet" type="text/css">
>>>>>>> dev
    <link href="../res/css/custom/button.css" rel="stylesheet" type="text/css">

    <script>
        function delUser(id) {
            if (confirm("确定删除此用户？")) {
                window.location = '../admin/manage_user.php?action=del&id=' + id;
            }
        }

示例#6

0

显示文件

文件： craft.php 项目： ab300819/CraftManage

<?php

/**
 * Created by PhpStorm.
 * User: Paradise
 * Date: 2016/3/27
 * Time: 17:08
 */
require_once 'sql/mysql.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
$db = new \sql\MysqlPDO();
$head = array('id', 'material_num', 'craft_num', 'name', 'model', 'belong', 'craft_type');
$title = array('id', '物料代码', '工艺代码', '名称', '模型', '类别', '工艺类型');
$result = $db->select($head, PRODUCT);
$table = "<tr>";
foreach ($title as $cell) {
    $table = $table . "<th>{$cell}</th>";
}
$table = $table . "</tr>";
foreach ($result as $line) {
    $table = $table . "<tr>";
    foreach ($line as $key => $value) {
        $table = $table . "<td>{$value}</td>";
    }
    $table = $table . "</tr>";
}
echo $table;

示例#7

0

显示文件

文件： panel_metallurgy.php 项目： ab300819/CraftManage

<?php

/**
 * Created by PhpStorm.
 * User: Think
 * Date: 2015/10/11
 * Time: 22:17
 */
require_once dirname(__FILE__) . '/../sql/mysql.php';
require_once dirname(__FILE__) . '/../sql/operate.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
$db = new \sql\MysqlPDO($level);
$product_id = $_GET['id'];
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>冶金机加工工艺管理</title>
    <link href="../res/css/custom/list.css" type="text/css" rel="stylesheet">
    <script type="text/javascript">
        function doDel(id, product) {
            if (confirm("确定要删除吗？")) {
                window.location = 'data/action_metallurgy.php?action=del&id=' + id + '&product=' + product;
            }
        }
    </script>
</head>
<body>

示例#8

0

显示文件

文件： edit_metallurgy.php 项目： ab300819/CraftManage

<?php

/**
 * Created by PhpStorm.
 * User: Think
 * Date: 2015/10/10
 * Time: 15:41
 * 冶金
 */
require_once dirname(__FILE__) . '/../sql/mysql.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
$db = new \sql\MysqlPDO($level);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title></title>
<<<<<<< HEAD
    <link href="res/css/style.css" rel="stylesheet" type="text/css">
=======
    <link type="text/css" rel="stylesheet" href="../res/css/custom/panel.css">
    <link type="text/css" rel="stylesheet" href="../res/libs/jquery-ui-themes/themes/base/jquery-ui.min.css">
>>>>>>> dev
</head>
<body>
<?php 
include "edit_menu.php";
$id = $_GET['id'];

示例#9

0

显示文件

文件： test.php 项目： ab300819/CraftManage

<?php

/**
 * Created by PhpStorm.
 * User: Think
 * Date: 2015/8/31
 * Time: 15:51
 */
require_once './sql/mysql.php';
require_once './sql/user_config.php';
$db = new \sql\MysqlPDO(0);
$id = 12;
$data['cr_num'] = '15';
$data['cr_name'] = '333333';
$data['cr_content'] = '334';
$data['cr_room'] = '444444';
$data['cr_machine'] = '678';
$update = $db->updateData(CRAFT_CONTENT, $data, "id='{$id}'");
$insert = $db->insert_data(CRAFT_CONTENT, $data);
$delete = $db->delData(CRAFT_CONTENT, $data);
$id = 12;
$cr_num = '15';
$cr_name = '333333';
$cr_content = '334';
$cr_room = '444444';
$cr_machine = '678';
$sq = "UPDATE craft_test SET cr_num='{$cr_num}',cr_name='{$cr_name}',cr_content='{$cr_content}',cr_room='{$cr_room}',cr_machine='{$cr_machine}' WHERE id='{$id}'";
echo $insert . '<br>' . $update . '<br>';

示例#10

0

显示文件

文件： edit_assembly.php 项目： ab300819/CraftManage

<?php

/**
 * Created by PhpStorm.
 * User: Think
 * Date: 2015/10/10
 * Time: 15:29
 * 装配
 */
require_once dirname(__FILE__) . '/../sql/mysql.php';
session_start();
$user = $_SESSION['user'];
$level = $_SESSION[$user];
$db = new \sql\MysqlPDO(0);
?>
<!DOCTYPE html>
<<<<<<< HEAD
<html>
<head>
    <meta charset="UTF-8">
    <title>装配工艺编辑</title>
    <link rel="stylesheet" type="text/css" href="../res/css/custom/editList.css">
=======
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>装配工艺编辑</title>
    <link type="text/css" rel="stylesheet" href="../res/css/custom/panel.css"/>
    <link type="text/css" rel="stylesheet" href="../res/libs/jquery-ui-themes/themes/base/jquery-ui.min.css">

>>>>>>> dev

PHP sql\MysqlPDO示例