I am new to mysqli object oriented procedure. Here I have made a php class for inserting data into database:
class main{
private $con;
function __construct(){
$this->db_connect();
}
private function db_connect(){
$this->con = new mysqli('localhost', 'user_name', 'password');
if ($this->con->connect_error) {
echo '<br />Failed to connect database! Please try again later';
}else{
echo '<br />Connected Successfully!';
}
}
private function db_select($db){
$this->con->select_db('prefix_'.$db);
}
public function post_data($value2,$value3,$value4,$value5,$value6){
$this->db_select('database_name');
$result = $this->con->query("INSERT INTO table_name (column2,column3,column4,column5,column6) VALUES('$value2','$value3','$value4','$value5','$value6')");
if($result->affected_rows>=1){
echo 'Data inserted successfully';
}else{
echo 'Data could not be inserted';
}
}
}
if I include the class in a php page and trying to insert data, then this error message is showing:
Trying to get property of non-object in C:\zpanel\hostdata\dir\public_html\folder\phppage.php on line 43
There Line 43 is:
if($result->affected_rows>=1){