Monday, 20 January 2020

data insert incodeigniter

public function savecardform(){



     
$sql=$this->db->query("INSERT INTO `card` (`location`,`category`,`business`, `name`, `mobile`,`mobile1`, `mobilew`,`landline`,`email`, `tagline`, `gstno`, `landmark`,`address`,`village`,`city`,`pincode`,`state`,`businesspet`,`service`,`timetable`,`about`, `created_dt`, `updated_dt`, `isactive`)
VALUES (
'".$this->db->escape_str($this->input->post('location'))."',
'".$this->db->escape_str($this->input->post('category'))."',
'".$this->db->escape_str($this->input->post('business'))."',
'".$this->db->escape_str($this->input->post('name'))."',
'".$this->db->escape_str($this->input->post('mobile'))."',
'".$this->db->escape_str($this->input->post('mobile1'))."',
'".$this->db->escape_str($this->input->post('mobilew'))."',
'".$this->db->escape_str($this->input->post('landline'))."',
'".$this->db->escape_str($this->input->post('email'))."',
'".$this->db->escape_str($this->input->post('tagline'))."',
'".$this->db->escape_str($this->input->post('gstno'))."',
'".$this->db->escape_str($this->input->post('landmark'))."',
'".$this->db->escape_str($this->input->post('address'))."',
'".$this->db->escape_str($this->input->post('village'))."',
'".$this->db->escape_str($this->input->post('city'))."',
'".$this->db->escape_str($this->input->post('pincode'))."',
'".$this->db->escape_str($this->input->post('state'))."',
'".$this->db->escape_str($this->input->post('businesspet'))."',
'".$this->db->escape_str($this->input->post('service'))."',
'".$this->db->escape_str($this->input->post('timetable'))."',
'".$this->db->escape_str($this->input->post('about'))."',
            Now(),
            Now(),
'0'
)");
return $sql;



}

No comments: