· 7 years ago · Dec 07, 2018, 02:26 PM
1## class.php
2<?php
3class MyClass { // set of methods and properties
4
5 private function sqlConnect { // private method (only available inside of class
6 var $sql_hostname;
7 var $sql_username;
8 var $sql_password;
9 }
10
11 private function buildTable() {
12 $sql = <<<MySQL_QUERY
13 CREATE TABLE IF NOT EXISTS posts (
14 title VARCHAR(150),
15 bodytext TEXT,
16 created VARCHAR(100)
17 )
18MySQL_QUERY;
19
20 return mysql_query($sql);
21 }
22
23 public function connectToDB { // public method (available outside of class)
24 var $database;
25 mysql_connect($this->sql_hostname, $this->sql_username, $this->sql_password);
26 mysql_select_db($database);
27
28 return $this->buildTable();
29 }
30}
31?>
32
33## page.php
34<?php
35include_once('class.php'); // include class
36
37$obj = new Class(); // create object from class
38
39$obj->connectToDB(); // use methods from the class
40?>