hook表单提交，如何增加数据库字段？

发布于 2024-12-12 06:59:53 字数 493 浏览 0 评论 0原文

我在 drupal 中使用钩子形式更改。

如果字段留空，我希望它获取为该字段提交的最后一个值，并将其增加 0.01

我已经尝试过，

function uc_pa_form_submit($form, &$form_state) {
  global $user;
$maxbid = db_result(db_query('SELECT MAX(amount) FROM {uc_auction_bids} WHERE nid = %d', $node->nid));
  $input01 = (($maxbid) ? $maxbid : 0) + .01;

drupal_write_record('table', $input01);

但它没有更新任何内容，我知道 $input01 可以工作，因为我在不同的函数中尝试过它。

如果我更改 drupal_write_record('table', $input01);提交的值是有效的。

原文

im using hook form alter in drupal.

If the fields left empty I want it to get the last value submitted for the field and increase it by .01

Ive tried

function uc_pa_form_submit($form, &$form_state) {
  global $user;
$maxbid = db_result(db_query('SELECT MAX(amount) FROM {uc_auction_bids} WHERE nid = %d', $node->nid));
  $input01 = (($maxbid) ? $maxbid : 0) + .01;

drupal_write_record('table', $input01);

but it isnt updating with anything, I know $input01 works as I tried it in a different function.

if i change drupal_write_record('table', $input01); to the value submitted it works.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

思慕 2024-12-19 06:59:53

drupal_write_record() 期望第二个参数是一个对象，此时您正在传递一个数字。此外，如果您尝试更新记录，则需要提供表的主键作为第三个参数。像这样的事情：

$sql = 'SELECT * FROM FROM {uc_auction_bids} WHERE nid = %d ORDER BY amount DESC LIMIT 1';
$obj = db_fetch_object(db_query($sql));
$obj->amount = (($obj->amount) ? $obj->amount: 0) + .01;

drupal_write_record('uc_auction_bids', $obj, array('bid'));

drupal_write_record() expects the second argument to be an object, at the moment you're passing a number. Also, if you're trying to update a record you'll need to provide the table's primary keys as the third argument. Something like this:

$sql = 'SELECT * FROM FROM {uc_auction_bids} WHERE nid = %d ORDER BY amount DESC LIMIT 1';
$obj = db_fetch_object(db_query($sql));
$obj->amount = (($obj->amount) ? $obj->amount: 0) + .01;

drupal_write_record('uc_auction_bids', $obj, array('bid'));

回复收藏 0 原文