我想使用get方法更新mysql中的数据 [英] I want to update data in mysql using the get method
问题描述
早上好，我正在寻求关于我的PHP代码的帮助。我在使用get方法更新数据库中的值时遇到问题。
这是函数我有一个表单方法，它是GET，我有一个forloop里面的那个循环现在计算具有相同跟踪代码的数据的数量。例如，我有一个3相同的跟踪代码，所以我有一个3文本框，我也有一个3提交按钮。现在我想更新文本框1并点击提交它会自动更新。
这里有参考我的代码：
< form method =getaction =view-reservation.php>
< table class =table table-striped>
< tr>
< td> 1月< / td>
< td> 2月< / td>
< ; td>三月< / td>
< td>四月< / td>
< td>五月< / td>
< td>六月< / td>
< td>七月< / td>
< td>八月< / td>
< td>九月< / td>
< td>十月< / td>
< td>十一月< / td>
< td> 12月< / td>
< td>< / td>
< / tr>
< ;？php foreach（$ view as $ key => $ data）：？>
< tr>
< td>< input type =隐藏name =tracksize =1va lue =<？php echo $ data-> track？>>
< input type =hiddenname =pidsize =1value =< ;？php echo $ data-> pid？>>
< input type =textname =jansize =1value =<？php echo $ data-> jan？>>< / td>
< td>< input type =textname =febsize =1value = <？php echo $ data-> feb？>>< / td>
< td>< input type =textname =marsize = 1value =<？php echo $ data-> mar？>>< / td>
< td>< input type =textname = aprsize =1value =<？php echo $ data-> apr？>>< / td>
< td>< input type = textname =maysize =1value =<？php echo $ data-> may？>>< / td>
< td>< ; input type =textname =junsize =1value =<？php echo $ data-> jun？>>< / td>
< td>< input type =textname =julsize =1value =<？php echo $ data-> jul？>>< / td>
< ; td>< input type =textname =augsize =1value =<？php echo $ data-> aug？>>< / td>
< td>< input type =textname =sepsize =1value =<？php echo $ data-> sept？>>< / td> ;
< td>< input type =textname =octsize =1value =<？php echo $ data-> oct？>> ;< / td>
< td>< input type =textname =novsize =1value =<？php echo $ data-> nov ？>>< / td>
< td>< input type =textname =decsize =1value =<？php echo $ data-> dec？>>< / td>
< td>
< a href = view-reservation.php？track =<？php echo $ data-> track？>&& pid =<？php echo $ data-> pid？>&& jan =< ？php echo $ data-> jan？>
class =label label-danger>更新付款< / a>< / td>
< / tr>
<？php endforeach;？>
<？php endif？>
< / form>
< / table> ;
这是我执行时的查询：
if（isset（$ _ GET ['track']）&& isset （$ _GET ['pid']）&& isset（$ _ GET ['jan']））
{
//
$ jan = filter（$ _ GET ['jan']）;
$ track = filter（$ _ GET ['track']）;
$ pid = filter（ $ _GET ['pid']）;
$ query = $ con> query（update payment set jan ='500'其中track ='$ track'和pid ='$ pid' ）或死（mysqli_errno（））;
if（$ query）
{
echo'updated';
}
}
查看为
key =>
数据）：？>
< tr>
< td>< input type =hiddenna me =tracksize =1value =<？php echo
Good morning I am seeking for a help regarding on my php code. I have a problem updating a value in database using get method.
Here is the function I have a form method which is GET and i have a forloop where in inside that loop counts the number of data with the same tracking code now. for example i have a 3 same tracking code so i have a 3 textbox and also i have a 3 submit button. Now i want to update the textbox 1 and click submit it will automatically updated.
For reference here is my code:
<form method="get" action="view-reservation.php">
<table class="table table-striped">
<tr>
<td>January</td>
<td>February</td>
<td>March</td>
<td>April</td>
<td>May</td>
<td>June</td>
<td>July</td>
<td>August</td>
<td>September</td>
<td>October</td>
<td>November</td>
<td>December</td>
<td></td>
</tr>
<?php foreach ($view as $key => $data):?>
<tr>
<td><input type="hidden" name="track" size="1" value="<?php echo $data->track?>">
<input type="hidden" name="pid" size="1" value="<?php echo $data->pid?>">
<input type="text" name="jan" size="1" value="<?php echo $data->jan?>"></td>
<td><input type="text" name="feb" size="1" value="<?php echo $data->feb?>"></td>
<td><input type="text" name="mar" size="1" value="<?php echo $data->mar?>"></td>
<td><input type="text" name="apr" size="1" value="<?php echo $data->apr?>"></td>
<td><input type="text" name="may" size="1" value="<?php echo $data->may?>"></td>
<td><input type="text" name="jun" size="1" value="<?php echo $data->jun?>"></td>
<td><input type="text" name="jul" size="1" value="<?php echo $data->jul?>"></td>
<td><input type="text" name="aug" size="1" value="<?php echo $data->aug?>"></td>
<td><input type="text" name="sep" size="1" value="<?php echo $data->sept?>"></td>
<td><input type="text" name="oct" size="1" value="<?php echo $data->oct?>"></td>
<td><input type="text" name="nov" size="1" value="<?php echo $data->nov?>"></td>
<td><input type="text" name="dec" size="1" value="<?php echo $data->dec?>"></td>
<td>
<a href="view-reservation.php?track=<?php echo $data->track?>&&pid=<?php echo $data->pid?>&&jan=<?php echo $data->jan?>"
class="label label-danger">Update Payment</a></td>
</tr>
<?php endforeach;?>
<?php endif?>
</form>
</table>
Here is my query when i execute:
if(isset($_GET['track']) && isset($_GET['pid']) && isset($_GET['jan']))
{
//
$jan = filter($_GET['jan']);
$track = filter($_GET['track']);
$pid = filter($_GET['pid']);
$query = $con->query("update payment set jan = '500' where track = '$track' and pid='$pid'") or die(mysqli_errno());
if($query)
{
echo'updated';
}
}
view as
key =>
data):?>
<tr>
<td><input type="hidden" name="track" size="1" value="<?php echo
这篇关于我想使用get方法更新mysql中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
