因此,我有一个wp mysql db列,如下所示:
`update_number` = int(11) Null:No, default:0
然后我有以下PHP:
$RSS_UPDATE = $wpdb->get_results("SELECT update_number FROM $table WHERE sub_id = $post_id");
if ( $RSS_UPDATE )
{
foreach ( $RSS_UPDATE as $RSS_SINGLE )
{
$RSS_ROW_NEW = $RSS_SINGLE + 1;
$wpdb->update($table, array('update_number' => $RSS_ROW_NEW),array( 'sub_id' => $post_id ));
}
}
因此,想法是,对于
sub_id = $post_id
的任何结果,然后获取所有update_number
。 (即可能是“ 0,2,1,4,2,2”)然后,对于每个值,我想将整数值增加+1并更新它。
但是,我正在获取
Object of class stdClass could not be converted to int
。我究竟做错了什么?
最佳答案
我认为您需要确保$ RSS_SINGLE是字符串或整数
var_dump($ RSS_SINGLE);退出;
$RSS_UPDATE = $wpdb->get_results("SELECT update_number FROM $table WHERE sub_id = $post_id");
if ( $RSS_UPDATE )
{
foreach ( $RSS_UPDATE as $RSS_SINGLE )
{
$RSS_ROW_NEW = $RSS_SINGLE->update_number + 1;
$wpdb->update($table, array('update_number' => $RSS_ROW_NEW),array( 'sub_id' => $post_id ));
}
}