如何使php post变量唯一 [英] How to make php post variable unique
问题描述
这是我的原始代码
<center>
<html>
<body>
<form method="post" name="AwardList" action="<?php echo $_SERVER['PHP_SELF']?>">
<table border=1>
<tr>
<th><b>Award</b></th>
<th><b>Issue ID</b></th>
<th><b>Sort #</b></th>
<th><b>Submit</b></th>
</tr>
<?php
$userid = ($vbulletin->userinfo['userid']);
$query = ("select a.*, userdisplayorder, issue_id from award a join award_user aw on a.award_id = aw.award_id where aw.userid = '$userid'");
if (isset($_POST['submit'])){
$userdisplayorder = mysql_real_escape_string($_POST['userdisplayorder']);
echo $_POST[issueid];
echo '<br>';
echo $userdisplayorder;
$sql = mysql_query("UPDATE award_user SET userdisplayorder='$userdisplayorder' WHERE issue_id='$_POST[issueid]'");
}
$result = mysql_query($query) or die(mysql_error());
$count = 1;
while ($row = mysql_fetch_array($result)){
$awardimgurl = $row['award_img_url'];
$ID = $row['issue_id'];
// don't get it from the database since its not unique in the database itself
// $userdisplayorder = $row['userdisplayorder'];
echo '<tr>';
echo '<th>';
echo "<img src='$awardimgurl'>"; echo '</th>';
echo '<th>';
echo '<input type="text" name="issueid" readonly="readonly" value="' . $ID . '" size="5">';
echo '</th>';
echo '<th>';
echo '<input type="text" name="userdisplayorder" value="' . $count . '" size="5">';
echo '</th>';
echo '<th>';
echo "<center><input type='submit' name='submit' value='Submit'></center>";
echo '</th>';
echo '</tr>';
$count ++;
}
?>
</table>
</html></center>
我还需要使userdisplayorder字段唯一.我已经拥有唯一的issueid.我怎样才能做到这一点?请通过提供代码来帮助我,我是PHP的新手,并且只了解基础知识.我还不知道PDO,我是视觉学习者 谢谢!
I need to make the userdisplayorder field unique as well. I already have the issueid unique. How can I do this? Please help me by providing code as well, I am new to PHP and only know basics. I do not know PDO yet and I am a visual learner Thank you!
推荐答案
您最好将项目分组为数组.
You'd do well to group your items into arrays.
for ($i = 0; $row = mysql_fetch_array($result); ++$i) {
// I took the liberty of adding HTML-encoding to the output.
// This prevents issues if a field contains quotes, etc.
$hrow = array_map('htmlentities', $row);
extract($hrow, EXTR_PREFIX_ALL, 'html');
$item_name = "items[$i]";
echo <<<ENDHTML
<tr>
<th><img src="{$html_award_img_url}"></th>
<th><input type="text" name="{$item_name}[issue_id]" readonly size="5"
value="{$html_issue_id}"></th>
<th><input type="text" name="{$item_name}[userdisplayorder]" size="5"
value="{$html_userdisplayorder}"></th>
<th><center><input type="submit" name="submitted[{$i}]" value="Submit"></center></th>
</tr>
ENDHTML;
}
在那时,由于PHP处理表单的方式,$_POST['items']
将是一个数组,并且它的每个条目本身将是一个包含每个item字段的数组.几乎就像您说的$_POST['items'] = array(0 => array('issue_id' => '3', 'userdisplayorder' => '0'), 1 => array('issue_id'
....并且submitted
将类似于array($index_of_row => 'Submit')
.您可以使用它来确定单击了提交"按钮的项目,如下所示:
At that point, because of how PHP processes forms, $_POST['items']
will be an array, and each entry of it will itself be an array containing each item field. It'd be almost like you said $_POST['items'] = array(0 => array('issue_id' => '3', 'userdisplayorder' => '0'), 1 => array('issue_id'
... . And submitted
will be like array($index_of_row => 'Submit')
. You can use it to determine which item had its submit button clicked, like so:
if (!empty($_POST['submitted'])) {
foreach ($_POST['submitted'] as $key => $unused) {
$row = $_POST['items'][$key];
# if you don't want to manually `mysql_real_escape_string` everything...
$srow = array_map('mysql_real_escape_string', $row);
... process $srow ... which now has its own unique userdisplayorder field
}
或者,如果您只是想每次都处理所有项目,则:
Or if you just want to process all the items each time:
if (!empty($_POST['items'])) {
foreach ($_POST['items'] as $row) {
$srow = array_map('mysql_real_escape_string', $row);
... process $srow ...
}
}
这篇关于如何使php post变量唯一的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!