while ($link = $db->fetch_array($query)) {
$j++;
echo '
<tr>
<td align="center">';
echo $j;
echo '</td>
<td>';
echo "<a href=\"?action=modify&link_id=" . $link['link_id'] . "\">" . $link['keywords'] . '</a>';
echo '</td>
<td><a target="_blank" href="../s?wd=';
echo urlencode($link['keywords']);
echo '">搜索</a></td>
<td> </td>
<td>';
echo get_qijia($link['keywords']);
echo ' 积分</td>
<td>';
echo $link['price'];
echo '</td>
<td> </td>
<td> </td>
<td>';
echo $link['stat_click'];
echo '</td>
<td> </td>
<td>';
echo $link['consumption'];
echo '</td>
</tr>
<tr>
<td align="center"><?php
echo $j;
?>
</td>
<td><?php
echo "<a href=\"?action=modify&link_id=" . $link["link_id"] . "\">" . $link["keywords"] . "</a>";
?>
</td>
<td><a target="_blank" href="../s?wd=<?php
echo urlencode($link["keywords"]);
?>
">搜索</a></td>
<td> </td>
<td><?php
echo get_qijia($link["keywords"]);
?>
积分</td>
<td><?php
echo $link["price"];
?>
</td>
<td> </td>
<td> </td>
<td><?php
echo $link["stat_click"];
?>
</td>
<td> </td>
<td><?php
echo $link["consumption"];
$price = trim(HtmlReplace($_POST["price"]));
if ($do_action == "savemodify") {
$link_id = intval($_POST["link_id"]);
$array = array('keywords' => $keywords, 'title' => $title, 'url' => $url, 'description' => $description, 'updatetime' => time());
$db->update("ve123_zz_open", $array, "link_id='" . $link_id . "'");
} else {
$array = array('keywords' => $keywords, 'title' => $title, 'url' => $url, 'description' => $description, 'price' => $price, 'user_id' => $user["user_id"], 'updatetime' => time());
$db->insert("ve123_zz_open", $array);
}
header("location:manage.php?");
break;
case "updateprice":
$arrPrice = $_POST["arrPrice"];
foreach ($arrPrice as $link_id => $price) {
$key = $db->get_one("select * from ve123_zz_open where link_id='" . $link_id . "'");
if (get_qijia($key["keywords"]) > $price) {
header("location:manage.php?msg=" . urlencode($key["keywords"] . " 出价不能低于起价！"));
exit;
}
$array = array('price' => $price, 'updatetime' => time());
$db->update("ve123_zz_open", $array, "link_id='" . $link_id . "' and user_id='" . $user["user_id"] . "'");
}
header("location:manage.php?msg=" . urlencode("更新成功！"));
break;
case "del":
$link_id = intval($_GET["link_id"]);
$db->query("delete from ve123_zz_open where link_id='" . $link_id . "' and user_id='" . $user["user_id"] . "'");
header("location:manage.php?msg=" . urlencode("删除成功！"));
break;
}
?>
$price = trim(HtmlReplace($_POST['price']));
if ($do_action == 'savemodify') {
$link_id = intval($_POST['link_id']);
$array = array('keywords' => $keywords, 'title' => $title, 'url' => $url, 'description' => $description, 'updatetime' => time());
$db->update('ve123_zz_tg_open', $array, "link_id='" . $link_id . "'");
} else {
$array = array('keywords' => $keywords, 'title' => $title, 'url' => $url, 'description' => $description, 'price' => $price, 'user_id' => $user['user_id'], 'updatetime' => time());
$db->insert('ve123_zz_tg_open', $array);
}
header('location:tg_open.php?');
break;
case 'updateprice':
$arrPrice = $_POST['arrPrice'];
foreach ($arrPrice as $link_id => $price) {
$key = $db->get_one("select * from ve123_zz_tg_open where link_id='" . $link_id . "'");
if (get_qijia($key['keywords']) > $price) {
header('location:tg_open.php?msg=' . urlencode($key['keywords'] . ' 出价不能低于起价！'));
exit;
}
$array = array('price' => $price, 'updatetime' => time());
$db->update('ve123_zz_tg_open', $array, "link_id='" . $link_id . "' and user_id='" . $user['user_id'] . "'");
}
header('location:tg_open.php?msg=' . urlencode('更新成功！'));
break;
case 'del':
$link_id = intval($_GET['link_id']);
$db->query("delete from ve123_zz_tg_open where link_id='" . $link_id . "' and user_id='" . $user['user_id'] . "'");
header('location:tg_open.php?msg=' . urlencode('删除成功！'));
break;
}
echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
echo $url;
?>
">
<input type="hidden" name="description" value="<?php
echo $description;
?>
">
<tr>
<th>关键词</th>
<th>起价</th>
<th>出价</th>
</tr>
<tr>
<td><?php
echo $keywords;
?>
</td>
<td><?php
echo get_qijia($keywords);
?>
</td>
<td><input type="text" name="price"></td>
</tr>
<tr>
<td> </td>
<td colspan="2"><input type="submit" name="Submit2" value="提交"></td>
</tr>
</form>
</table>
<?php
}
