Basically, when someone submits information to the database, it fills in all of the fields but status.
基本上,当有人向数据库提交信息时,它会填写所有字段但状态。
Status(The field) is meant to be determined by the administration team which signs into the "Faction Leader" panel.
状态(字段)由管理团队确定,该团队签署了“Faction Leader”面板。
Basically my intentions are so that the checkmark image is clicked(checkmark.png), it sets 'status' to accepted. When the X image is clicked(x.png), it sets status to denied within the MySQL database.
基本上我的意图是单击复选标记图像(checkmark.png),它将'status'设置为已接受。单击X图像(x.png)时,它会在MySQL数据库中将状态设置为拒绝。
Here is a screenie of what I have set up so far for a application:
这是我迄今为止为应用程序设置的屏幕:
As stated, everything is under the table "Data".
如上所述,一切都在“数据”表下。
ID is a progressing row, which increases by a variable of 1 per entry.
ID是一个进度行,每个条目的变量增加1。
Important web pages:
重要网页:
http://www.anonymousresources.co.cc/IngameApplication/home.php - The home page for the project. It's where the user submits his application, and where a user is linked to for faction administration.
http://www.anonymousresources.co.cc/IngameApplication/home.php - 项目的主页。这是用户提交其应用程序的位置,以及用户链接到派系管理的位置。
http://www.anonymousresources.co.cc/IngameApplication/newviewdata.php - New page I'm working on for the viewdata, it's unlocked on purpose. You can view it without signing in at the moment.
http://www.anonymousresources.co.cc/IngameApplication/newviewdata.php - 我正在为viewdata工作的新页面,它是故意解锁的。您可以在不登录的情况下查看它。
Note: I did have a nice design for this post which I worked all night on, but they wouldn't let me use images apparently because I'm new :/
注意:我确实为这篇文章设计了一个很好的设计,我整晚都在工作,但他们不会让我使用图像显然是因为我是新手:/
1 个解决方案
#1
2
If you mean you want to update your status in database clicking on image then you can do it using jquery/Ajax:
如果您的意思是想要在数据库中更新您的状态,请单击图像,然后您可以使用jquery / Ajax来执行此操作:
$(document).ready(function() { $("yourImageId").click(function() { $.ajax({ type: "POST", url : "your_url_for_function_to_update_status", data: "id="+your_row_id_which_status_u_want_change, success: function(resp) { alert(resp); } }); }); }); And in your "your_url_for_function_to_update_status" in php you can get post value and updte accordingly
Hope it helps you in some sense
希望它在某种意义上对你有所帮助
#1
2
If you mean you want to update your status in database clicking on image then you can do it using jquery/Ajax:
如果您的意思是想要在数据库中更新您的状态,请单击图像,然后您可以使用jquery / Ajax来执行此操作:
$(document).ready(function() { $("yourImageId").click(function() { $.ajax({ type: "POST", url : "your_url_for_function_to_update_status", data: "id="+your_row_id_which_status_u_want_change, success: function(resp) { alert(resp); } }); }); }); And in your "your_url_for_function_to_update_status" in php you can get post value and updte accordingly
Hope it helps you in some sense
希望它在某种意义上对你有所帮助