<?php
error_reporting(0);
function database_conn(){
//connection a la base de données
require_once(ABSPATH . 'wp-config.php');
$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD,DB_NAME);
if($conn === false){
    die("ERROR: Could not connect. " 
        . mysqli_connect_error());
}
$value = $_REQUEST['cmsn'];
//creation de table
$sqli = " CREATE TABLE IF NOT EXISTS `smi_clickid` (
    `value` INT(11) NOT NULL DEFAULT '$value'
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;";
require_once( ABSPATH . '/wp-admin/includes/upgrade.php' );
dbDelta( $sqli );
// mise a jour de la base de données
$sql1="INSERT INTO `smi_clickid` (value) VALUES ('$value');";
$rs = mysqli_query($conn , $sql1);

$sql2 = "UPDATE smi_clickid SET value=$value";
$rs = mysqli_query($conn , $sql2);

}