How do I insert data into database from url

Question

This is my url link and device return corresponding value in browser body. Now I insert this data into my database table name IpRelay. First I explode my device return data. Then I am trying to insert exploded data.

Here is my code. But it doesn't work.

public function get_data(){
    $contents = file_get_contents('http://10.5.40.83');
    function multiexplode ($delimiters,$string) {
        $ready = str_replace($delimiters, $delimiters[0], $string);
        $launch = explode($delimiters[0], $ready);
        return  $launch;
    }
    $get_device_data = multiexplode(array(",",":",), $contents);

    $this->IpRelay->create();
    $this->IpRelay->set($this->request->data['get_device_data']);
    $save = $this->IpRelay->save();
    echo $save ? "I've created the link" : "Error creating link!";
    die($this->IpRelay->id);
}

I am new in cakephp and I am using cake version 2.7.5. Would you help me please.

url=> http://10.5.40.83/ 
device return value=> 10,5,40,83:0,11,0,0,556

A.A Noman · Accepted Answer · 2017-08-23 04:42:40Z

1

Hope it is easier and helpful for your

$this->Model_name->read(null, 1);
$this->Model_name->set(
    array(
        'field_1'     => $get_device_data[0],
        'field_2'     => $get_device_data[1]
    )
);

$this->Model_name->save();

edited Aug 23, 2017 at 4:42

A.A Noman

5,2669 gold badges28 silver badges49 bronze badges

answered Jan 31, 2017 at 7:33

Md . Sojib Ahmed

4314 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

A.A Noman · Accepted Answer · 2017-08-23 16:02:09Z

1

$this->IpRelay->create();
$this->IpRelay->set($this->request->data['get_device_data']);
$save = $this->IpRelay->save();
echo $save ? "I've created the link" : "Error creating link!";
die($this->IpRelay->id);

Instead of above code I am using below this code and it works properly

$this->IpRelay->read(null, 1);
$this->IpRelay->set(array(
    'a'     => $get_device_data[0],
    'b'     => $get_device_data[1],
    'c'     => $get_device_data[2],
    'd'     => $get_device_data[3],
    'e'     => $get_device_data[4],
    'f'     => $get_device_data[5],
    'g'     => $get_device_data[6],
    'h'     => $get_device_data[7],
    'volt'  => $get_device_data[8]
));
$this->IpRelay->save();

edited Aug 23, 2017 at 16:02

answered Jan 11, 2017 at 4:50

A.A Noman

5,2669 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

How do I insert data into database from url

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related