PHP helper_getInsertSQL Exemples

Exemple #1

Fichier : send_payuser_mail.php Projet : letmefly/tools_script

function insertMessage($ip, $data = array())
{
    $connect = mysql_connect($ip, "ofdpuser", "ofdp_onefigure");
    mysql_select_db("ofdp");
    $gift = array();
    if (isset($data['GIFT_TYPE'])) {
        $gift = array('TYPE' => $data['GIFT_TYPE'], 'ITEM_ID' => empty($data['ITEM_ID']) ? null : $data['ITEM_ID'], 'AMOUNT' => empty($data['AMOUNT']) ? null : $data['AMOUNT']);
    }
    $insert = array('SEND_USER_ID' => $data['SEND_USER_ID'], 'RECIEVE_USER_ID' => $data['RECEIVE_USER_ID'], 'EVENT_ID' => empty($data['EVENT_ID']) ? null : $data['EVENT_ID'], 'TEXT_ID' => empty($data['TEXT_ID']) ? null : $data['TEXT_ID'], 'GIFT' => json_encode($gift), 'CREATE_DATE' => date('Y-m-d H:i:s'), 'CREATE_IP' => "127.0.0.1", 'IS_DELETE' => 0);
    $sql = helper_getInsertSQL("op_messages", $insert);
    print_r($sql . "\r\n");
    $result = mysql_query($sql);
    mysql_close($connect);
}

Exemple #2

Fichier : db.php Projet : letmefly/php_ramb

 public function insertUser($userInfo)
 {
     if (!$this->connect) {
         helper_log("connect invalid");
         return false;
     }
     $sql = helper_getInsertSQL("op_user", $userInfo);
     helper_log($sql);
     if (!mysql_query($sql, $this->connect)) {
         helper_log("insertUser failed");
         return false;
     }
     return true;
 }