kiad_198's Profile User Rating: -----

Reputation: 3 Apprentice
Group:
Active Members
Active Posts:
135 (0.05 per day)
Joined:
19-November 08
Profile Views:
6,315
Last Active:
User is offline Feb 21 2016 07:19 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0

Latest Visitors

Icon   kiad_198 has not set their status

Posts I've Made

  1. In Topic: Read and Delete SMS in GSM Modem AT Command

    Posted 20 Feb 2016

    Thanks for that. I found this code. It working now.

    $this->debugmsg("Reading inbox");
    		//Start sending of message
    		fputs($this->fp, "AT+CMGL=\"ALL\"\n\r");
    		//Wait for confirmation
    		$status = $this->wait_reply("OK\r\n", 5);
    		//print_r($this->buffer);die;
    		$arr = explode("+CMGL:", $this->buffer);
    		$inbox = null;	
    		for ($i = 1; $i < count($arr); $i++) {
    			$arrItem = explode("\n", $arr[$i], 2);
    			// Header
    			$headArr = explode(",", $arrItem[0]);
    			$fromTlfn = str_replace('"', null, $headArr[2]);
    			$id = $headArr[0];
    			$date = str_replace('"', null, $headArr[4])." ".str_replace('"', null, $headArr[5]);
    			//$hour = $headArr[5];
    			// txt
    			$txt = str_replace("'", null, $arrItem[1]);
    			$txt = str_replace("ERROR", null, $txt);
    			$inbox[] = array('id' => $id, 'sender' => $fromTlfn, 'text' => $txt, 'date' => $date);
    		}
    		return $inbox;
    
    
  2. In Topic: Read and Delete SMS in GSM Modem AT Command

    Posted 20 Feb 2016

    Thank you for your response.

    Yes, I understand.
    I have change the class file name.

    I have change Line #26 with this and its working now. It gives me result value of 1.
    $read = $gsm_send_sms->read();
    echo $read;
    
    


    How can I retrieve all message from this function.

    public function read(){
    
    		fputs($this->fp, "AT+CMGL=\"ALL\"\r");
    
    		//Wait for confirmation
    		 $status = $this->wait_reply("OK\r\n", 180);
    
    		  return $status;
    	}
    
    
  3. In Topic: Copy Worksheet from a workbook to another workbook

    Posted 11 Aug 2015

    Thanks Cal-cium and andrewsw for reply very much appreciated.

    I will look into it for enhancement. What I did is that I create the design through code a lot of it and seems working as expected right now.


    Thanks,

    Kiad
  4. In Topic: Query won't insert data problem

    Posted 11 Dec 2014

    thanks for the reply,

    I figured it out, seems working now. I just remove this code:
     Dim Trans = con.BeginTransaction
      'and Trans to sql statement.
     Trans.Dispose()
    
    


    Here's the code:

    Dim con As New MySqlConnection("server=" & server & ";database=" & database & ";user id=" & username & ";password=" & userpass & ";port=3306")
    
    
                con.Open()
    
                IdDate = MD5("01-0056" & crdate)
    
                Dim Cmd = New MySqlCommand("INSERT INTO local_attendance.employee_time_log (employee_id, log_date, keylog) SELECT * FROM (SELECT '01-0056' as empid, '" & crdate & "' as curdate, '" & IdDate & "' as keylogid) as tmp WHERE NOT EXISTS (SELECT keylog,employee_id,log_date FROM local_attendance.employee_time_log WHERE keylog = keylogid AND employee_id = empid AND log_date = curdate) LIMIT 1", con)
    
                Cmd.ExecuteNonQuery()
                Cmd.Dispose()
    
                con.Close()
    
    
    


    Thanks,

    kiad
  5. In Topic: Unable to Cast object of type 'TimeSpan'

    Posted 8 Jun 2014

    Thanks for the reply guys..
    Its working now...




    kiad

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

kiad_198 hasn't added any friends yet.

Comments

kiad_198 has no profile comments yet. Why not say hello?