Home > Backend Development > PHP Tutorial > php-process management (php+Ajax)

php-process management (php+Ajax)

大家讲道理
Release: 2023-03-07 22:36:01
Original
1691 people have browsed it

php+AJAX new process

1: Need to clarify which processes need to be operated?

2: What personnel are needed to execute each process?

3: What is the order of people performing this process?

1. The three tables required for database construction are: users table; liucheng table; flowpath table (the data has been displayed in the table)

2. Create a new process page

(1) Use Drop-down listDisplays the list of people and adds an add button


<h1>新建流程</h1>
<p>
请选择节点人员:
	<select id="user">
    <?php
	session_start();
	require"../DBDA.class.php";
	$db = new DBDA();
	$sql = "select * from users";
	$arr = $db->query($sql,1);
	foreach($arr as $v)
	{
		echo"<option value=&#39;{$v[0]}&#39;>{$v[2]}</option>";  //输出单选按钮,数组中的索引2,也就是用户名,但是它的值是代号
	}
	?>
    </select>
    
<input type="button" value="添加节点" id="addjd" />
</p>
<br />
Copy after login


(2) Add a click event to the Add Node button

##

$("#addjd").click(function(){
		var uid = $("#user").val();
		$.ajax({
				url:"add.php",
				data:{uid:uid},
				type:"POST",
				dataType:"TEXT",
				success: function(data){
						window.location.href="xinjian.php";//执行处理页面成功后会刷新页面
					}
			}) 
	})
Copy after login


(3) Add a node The processing page add.php

<?php
session_start();
$uid = $_POST["uid"]; //接收传过来的值if(empty($_SESSION["jiedian"]))
{
	$arr = array($uid);//定义一个数组放用户
	$_SESSION["jiedian"] = $arr; //将第一个用户放入数组中}
else
{
	$arr = $_SESSION["jiedian"];//数组中有值
	$arr[] = $uid; //放入数组中值
	$_SESSION["jiedian"] = $arr; //将值再交给session}
Copy after login


(4) Display the added node

# in the new process page

##
<p>
<?php
if(empty($_SESSION["jiedian"]))
{
	echo"还未添加节点人员!";
}
else
{
	$arr = $_SESSION["jiedian"];
	foreach($arr as $k=>$v)
	{
		$sql ="select name from users where uid=&#39;{$v}&#39;";
		$name =$db->strquery($sql);
		echo"<p>{$k}--{$name}--<input type=&#39;button&#39; value=&#39;移除&#39; class=&#39;yichu&#39; sy=&#39;{$k}&#39;/></p>";
	}
}
?>
</p>
<br />
Copy after login


After completing this step, the effect is as follows:

(5) Add the remove button Click event

$(".yichu").click(function(){
		var sy = $(this).attr("sy"); //点击这个按钮,选中这个的索引号
		$.ajax({
			url:"yichu.php",
			data:{sy:sy},
			type:"POST",
			dataType:"TEXT",
			success: function(data){
				window.location.href="xinjian.php";//执行处理页面成功后会刷新页面
			}
		});
	})
Copy after login


(6) Remove the processing page yichu.php

<?php
session_start();

$sy =$_POST["sy"]; //接收穿过来的索引号$arr = $_SESSION["jiedian"];//节点的数组unset($arr[$sy]); //删除数据$arr = array_values($arr);//重新索引$_SESSION["jiedian"] = $arr;
Copy after login


(7) After the node problem is solved, then there is the name of the process. The text box for writing the name: The important thing is to save the process, so there must be a save button.

<p>
请输入流程名称:<input type="text" id="mingcheng" />
</p>
<br />
<input type="button" value="保存" id="baocun" />
Copy after login



(8) Add a click event to the save button

$("#baocun").click(function(){
	var name = $("#mingcheng").val();
	$.ajax({
		url:"baocun.php",
		data:{name:name},
		type:"POST",
		dataType:"TEXT",
		success: function(data){
			alert("保存成功!");
		}
	});
})	
Copy after login


(9) Finally, there is the processing page to save the process

<?php
session_start();
require "../DBDA.class.php";
$db = new DBDA();

$name = $_POST["name"];
$code = time();

$sql ="insert into liucheng values(&#39;{$code}&#39;,&#39;{$name}&#39;)";
$db->query($sql);

$arr = $_SESSION["jiedian"];

foreach($arr as $k=>$v)
{
	$sql ="insert into flowpath values(&#39;&#39;,&#39;{$code}&#39;,&#39;{$v}&#39;,{$k})"; //注意建表的类型,这里的orders项用的是int型,所以{$k}不用加&#39;&#39;,而且建表主键要勾选自增长
	$db->query($sql);
}
Copy after login



##Of course, the content is also stored in the database accordingly. The effect can be seen in the top data table

The following code is used for

copy

:

1.xinjian.php

##
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title><script src="../jquery-3.2.0.min.js"></script></head>

<body>
<h1>新建流程</h1>
<p>请选择节点人员:    <select id="user">
    <?php    session_start();    require"../DBDA.class.php";    $db = new DBDA();    $sql = "select * from users";    $arr = $db->query($sql,1);    foreach($arr as $v)
    {        echo"<option value=&#39;{$v[0]}&#39;>{$v[2]}</option>";
    }    ?>
    </select>
    
<input type="button" value="添加节点" id="addjd" />
</p>
<br />
<p>
<?phpif(empty($_SESSION["jiedian"]))
{    echo"还未添加节点人员!";
}else{    $arr = $_SESSION["jiedian"];    foreach($arr as $k=>$v)
    {        $sql ="select name from users where uid=&#39;{$v}&#39;";        $name =$db->strquery($sql);        echo"<p>{$k}--{$name}--<input type=&#39;button&#39; value=&#39;移除&#39; class=&#39;yichu&#39; sy=&#39;{$k}&#39;/></p>";
    }
}?>
</p>
<br />
<p>请输入流程名称:<input type="text" id="mingcheng" />
</p>
<br />
<input type="button" value="保存" id="baocun" />

</body>

<script type="text/javascript">$("#addjd").click(function(){        var uid = $("#user").val();
        $.ajax({
                url:"add.php",
                data:{uid:uid},
                type:"POST",
                dataType:"TEXT",
                success: function(data){
                        window.location.href="xinjian.php";
                    }
            }) 
    })

$(".yichu").click(function(){        var sy = $(this).attr("sy");
        $.ajax({
            url:"yichu.php",
            data:{sy:sy},
            type:"POST",
            dataType:"TEXT",
            success: function(data){
                window.location.href="xinjian.php";
            }
        });
    })
    
$("#baocun").click(function(){    var name = $("#mingcheng").val();
    $.ajax({
        url:"baocun.php",
        data:{name:name},
        type:"POST",
        dataType:"TEXT",
        success: function(data){
            alert("保存成功!");
        }
    });
})    
</script>
</html>
Copy after login


2.add.php


<?phpsession_start();$uid = $_POST["uid"];if(empty($_SESSION["jiedian"]))
{    $arr = array($uid);    $_SESSION["jiedian"] = $arr;
}else{    $arr = $_SESSION["jiedian"];    $arr[] = $uid;    $_SESSION["jiedian"] = $arr;
}
Copy after login


3.yichu.php


##

<?phpsession_start();$sy =$_POST["sy"];$arr = $_SESSION["jiedian"];unset($arr[$sy]);$arr = array_values($arr);$_SESSION["jiedian"] = $arr;
Copy after login

4.baocun.php


<?phpsession_start();require "../DBDA.class.php";$db = new DBDA();$name = $_POST["name"];$code = time();$sql ="insert into liucheng values(&#39;{$code}&#39;,&#39;{$name}&#39;)";$db->query($sql);$arr = $_SESSION["jiedian"];foreach($arr as $k=>$v)
{    $sql ="insert into flowpath values(&#39;&#39;,&#39;{$code}&#39;,&#39;{$v}&#39;,{$k})";    $db->query($sql);
}
Copy after login


//输出单选按钮,数组中的索引2,也就是用户名,但是它的值是代号
Copy after login

The above is the detailed content of php-process management (php+Ajax). For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template