php - 更新mysql记录

Question

您好，当值出现在数据库中两次或以上时，我想更新它。我有这段代码，但它不起作用。

这就是我如何添加记录。

global $wpdb;
 $prefix = $wpdb->prefix.searchmeter ;
 $search_terms = $_GET['s'];
 $query = "INSERT INTO  `$prefix`  (`terms`,`date`,`count`)
           VALUES ('$search_terms',CURDATE(),1) 
           ON DUPLICATE KEY UPDATE `count` = `count`+1 ";       
 $success = $wpdb->query($query);

这是我的显示方式

<?php 

              $results = $wpdb->get_results(
              "SELECT `terms`, `count`
              FROM `{$wpdb->prefix}searchmeter`
              WHERE DATE_SUB( CURDATE( ) , INTERVAL 30 DAY ) <= `date` AND count > 15                         
              GROUP BY `terms`
              ORDER BY count DESC, `terms` ASC");              


              echo "<ul class='wp-tag-cloud'>";                
              foreach ($results as $result) {
                echo '<li><a href="?s='.$result->terms.'">'. $result->terms .'</a></li>'."\n";
              }
              echo "</ul>";              
              ?>     

我有这个数据

terms | data | count
list    15.03   1

当我有重复的键时，计数应该是 2，但就像这样

terms | data | count
list    15.03   3

Answer 1

尝试一下

   global $wpdb;
 $prefix = $wpdb->prefix.searchmeter ;
 $search_terms = $_GET['s'];
 $query = "INSERT INTO  `$prefix`  (`terms`,`date`,`count`)
           VALUES ('$search_terms',CURDATE(),1)
           ON DUPLICATE KEY UPDATE `count` = `count`+1 ";       
 $success = $wpdb->query($query);