Products Archive

"; $html .= ""; } else { // For input types other than select $html .= "

"; $html .= " $value) { if ($key != 'options' && $key != 'selected') { // Skip options and selected key for regular inputs $attribute = $key == 'required' ? 'required' : "$key='$value'"; $html .= " $attribute"; } } $html .= ">

"; } return $html; } }connect_error) { die('Connection failed: ' . self::$conn->connect_error); } } return self::$conn; } /** * Close the database connection. */ public static function closeConn() { if (self::$conn != null) { self::$conn->close(); self::$conn = null; } } /** * Execute a query on the database and return result as an array of associative arrays. * * @param string $sql The SQL query string. * @return array|false Returns an array of associative arrays representing the rows * returned by the query, or false on failure. */ public static function query($sql) { $conn = self::getConn(); $result = $conn->query($sql); if ($result === false) { // Query failed: handle error appropriately return false; } if ($result instanceof mysqli_result) { $data = []; while ($row = $result->fetch_assoc()) { $data[] = $row; } $result->free(); // Free the memory associated with the result return $data; } else { // The query was probably an INSERT/UPDATE/DELETE which does not produce a result set return []; } } /** * Prepare a query. */ public static function prepare($sql) { $conn = self::getConn(); return $conn->prepare($sql); } } Products Archive - J. Lee Salon Suites