Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $response = array();
- $send_status = 0;
- $seller_id = 1275;
- $re1 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id','$uid','1','mysql_real_escape_string($email_start_message)','$start_time');");
- if (!$re1 == 'false') {
- $response['start_email_alert'] = '1';
- } else {
- $response['start_email_alert'] = '0';
- }
- $re2 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id','$uid','2','mysql_real_escape_string($sms_start_message)','$start_time');");
- if (!$re2 == 'false') {
- $response['start_sms_alert'] = '1';
- } else {
- $response['start_sms_alert'] = '0';
- }
- $re3 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id','$uid','3','mysql_real_escape_string($email_end_message)','$end_time');");
- if (!$re3 == 'false') {
- $response['end_email_alert'] = '1';
- } else {
- $response['end_email_alert'] = '0';
- }
- $re4 = mysql_query("INSERT INTO pos_msg_que(send_status, sid, uid, alert_type, alert_data, send_time) VALUES ('$send_status','$seller_id', '$uid','4','mysql_real_escape_string($sms_end_message)','$end_time');");
- if (!$re4 == 'false') {
- $response['end_sms_alert'] = '1';
- } else {
- $response['end_sms_alert'] = '0';
- }
- echo json_encode($response);
- +-----------------+------------+------+-----+-------------------+-----------------------------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------------+------------+------+-----+-------------------+-----------------------------+
- | id | int(8) | NO | PRI | NULL | auto_increment |
- | send_status | int(11) | NO | | NULL | |
- | sid | int(8) | NO | | NULL | |
- | uid | int(8) | NO | | NULL | |
- | alert_type | tinyint(2) | NO | | NULL | |
- | alert_data | blob | NO | | NULL | |
- | send_time | datetime | NO | | NULL | |
- | advance_time | int(3) | NO | | NULL | |
- | last_attempt_at | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
- +-----------------+------------+------+-----+-------------------+-----------------------------+
- function cleanStr($str){
- $str = trim($str);
- if($str == "") return;
- $str = stripslashes($str);//STRIP slashes
- if (function_exists(mysqli_real_escape_string)){
- $str = mysqli_real_escape_string($str);
- }else{
- $str = mysql_real_escape_string($str);
- }
- //CONVERT TO HTML
- $str = htmlspecialchars($str);
- //LAST CLEAN UP
- $str = preg_replace("#'#","",$str);
- return $str;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement