I am very new to OOP in PHP, I have mysite running with the conventional procedure, such as displaying my site menu in this way in a php file, menu.php
Code: Select all
<?php
$sql = "
SELECT *
FROM menu
ORDER BY order ASC";
$result = mysql_query($sql);
?>
<ul>
<?php
while($row = mysql_fetch_assoc($result))
{
?>
<li><a href="<?php echo $row['link'];?>"><?php echo $row['name'];?></a></li>
<?php
}
?>
</ul>this is what I would put in class_lib.php,
Code: Select all
$mysqli= new MySQLi('localhost', 'root', 'xxx', 'my_db');
Class menu
{
public function get_menu()
{
$mysqli = new mysqli();
$sql = "
SELECT *
FROM menu
ORDER BY order ASC";
$result = $mysqli->query($sql);
}
}Code: Select all
<ul>
<?php
$menu = new menu();
$menu->get_menu();
while($row = $menu->fetch_assoc())
{
?>
<li><a href="<?php echo $row['link'];?>"><?php echo $row['name'];?></a></li>
<?php
}
?>
</ul>will be grateful if u know how to correct this.
many thanks,
Lau