Title: do_shortcode
Last modified: August 30, 2016

---

# do_shortcode

 *  [compass255](https://wordpress.org/support/users/compass255/)
 * (@compass255)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/do_shortcode-8/)
 * salut ,
 * je suis en train de développer un plugin wordpress et j’ai rencontré une problème:
 * j’ai écrire un shortcode qui est le suivant :
 *     ```
       <?php
   
       function AdproStatsUp_shortcode()
        {
   
       require( dirname( __FILE__ ) . '/geoip.inc' );
   
       $ip=$_SERVER['REMOTE_ADDR'];
   
       $gi=geoip_open(plugin_dir_path( __FILE__ ).'GeoIP.dat',GEOIP_STANDARD);
   
       $pays = geoip_country_name_by_addr($gi, $ip);
   
       geoip_close($gi);
   
           global $wpdb;
                       $tableau = array();
                       $tabwidth = array();
                       $tabheight = array();
                       $j = 0;
                       $k = 0;
                       $l = 0;
       $results = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}Popup ");
   
       foreach ($results as $result) {
           $multi_country  = $result->Pays_Traffic;
   
       $single_country = explode(",", $multi_country);
       if (in_array($pays, $single_country)) {
   
           $Quot = $result->Nb_Visite_Quotidien;
           $nouvQuot = $Quot + 1 ;
           $ide = $result->idPopUp;
   
           $prefix = $wpdb->prefix;
           $table_name =  $prefix.'Popup';
   
                   $wpdb->query("UPDATE  $table_name SET Nb_Visite_Quotidien = $nouvQuot WHERE idPopUp = $ide");
   
           }
       }
       }
   
        ?>
       ```
   
 * puis j’ai appeler ce shrotcode dans le footer de ma theme et et voici le code:
 *     ```
       <?php echo do_shortcode('[AdproStatsUp]'); ?>
       ```
   
 * le problème c’est que lorsque par exemple j’ai $Quot = 4 donc $nouvQuot ca va
   etre 5 et donc l’attribut Nb_Visite_Quotidien
    =5
 *  mais lorsque je consulte ma base je le trouve 9, c’est bizarre il incremente
   toujours par 5
 * quelqu’un m’aide svp

The topic ‘do_shortcode’ is closed to new replies.

## Tags

 * [do_shortcode](https://wordpress.org/support/topic-tag/do_shortcode/)
 * [footer](https://wordpress.org/support/topic-tag/footer/)

 * 0 replies
 * 1 participant
 * Last reply from: [compass255](https://wordpress.org/support/users/compass255/)
 * Last activity: [10 years, 9 months ago](https://wordpress.org/support/topic/do_shortcode-8/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics