Getter Setter in PHP Class

class MyClass {
    private $firstField;
    private $secondField;

    public function getFirstField() {
        return $this->firstField;
    }
    public function setFirstField($x) {
        $this->firstField = $x;
    }
    public function getSecondField() {
        return $this->secondField;
    }
    public function setSecondField($x) {
        $this->secondField = $x;
    }
}

php magic methods __get and __set

class MyClass {
  private $firstField;
  private $secondField;

  public function __get($property) {
    if (property_exists($this, $property)) {
      return $this->$property;
    }
  }

  public function __set($property, $value) {
    if (property_exists($this, $property)) {
      $this->$property = $value;
    }

    return $this;
  }
}

MYSQLI Crud Example

CREATE DATABASE `database_name`;

 

// create table

CREATE TABLE `table_name`.`members` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`fname` varchar(255) NOT NULL,

`lname` varchar(255) NOT NULL,

`contact` varchar(255) NOT NULL,

`age` varchar(255) NOT NULL,

`active` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;










$localhost = "127.0.0.1";

$username = "root";

$password = "";

$dbname = "database_name";

 

// create connection

$connect = new mysqli($localhost, $username, $password, $dbname);

// check connection

if($connect->connect_error) {

    die("connection failed : " . $connect->connect_error);

} else {

    // echo "Successfully Connected";

}













$sql = "INSERT INTO members (fname, lname, contact, age, active) VALUES ('$fname', '$lname', '$contact', '$age', 1)"; if($connect->query($sql) === TRUE) { } else { } $connect->close();










$sql = "SELECT * FROM members WHERE active = 1"; $result = $connect->query($sql); if($result->num_rows > 0) { while($row = $result->fetch_assoc()) { } } else { }













$sql = "SELECT * FROM members WHERE id = {$id}"; $result = $connect->query($sql); $data = $result->fetch_assoc(); $connect->close();













$sql = "UPDATE members SET fname = '$fname', lname = '$lname', age = '$age', contact = '$contact' WHERE id = {$id}"; if($connect->query($sql) === TRUE) { } else { } $connect->close();