How can you set a property of a class equal to a value from a MySQL table in PHP?

To set a property of a class equal to a value from a MySQL table in PHP, you can use a database connection to retrieve the value from the table and then assign it to the property. You can achieve this by executing a SELECT query to fetch the value from the table and then assigning it to the property within the class constructor. 

// Establish a connection to the MySQL database
$connection = new mysqli("localhost", "username", "password", "database");

// Define your class
class MyClass {
    public $property;

    public function __construct() {
        global $connection;
        
        // Retrieve the value from the MySQL table
        $result = $connection->query("SELECT column_name FROM table_name WHERE condition");
        
        // Assign the retrieved value to the property
        $row = $result->fetch_assoc();
        $this->property = $row['column_name'];
    }
}

// Create an instance of the class
$myObject = new MyClass();

// Access the property value
echo $myObject->property;

Keywords

PHP class property MySQL table set value object-oriented programming

Related Questions