How can insert this into the databse after checking with fopen

[eluser]Sumon[/eluser]
Use a model

Code:

class url_model extends Model{
function insert_links($url)
{
  $data = array('submitted_url' => $url);
  $this->db->insert('links', $data);
  return true;
}
}

and use this model in your controller

Code:

function submit()
    {
        // Get the submit url
        $submission_url = $this->input->post('url');
        //check if it a real url
        $check_url = @fopen($submission_url,'r');
        @fclose($check_url); //close it now
//was the url valid?
        if($check_url !== false){
        $data['message'] = "Success!";
        $this->load->model('url_model');
        $this->url_model->insert_links($submission_url);
        $this->load->view('message_form', $data);
    }else{
    //nice try
      $data['message'] = "That Url doesn't exist!";
      $this->load->view('message_form', $data);
     }
  }