Re: How do I block user viewing out DB tables?
Posted: Thu Aug 29, 2013 2:41 pm
No error codes, no nothing. The code literally stops.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
include "dbconn.php";Code: Select all
$query = "SELECT email FROM admin WHERE type = 'admin'";
$result = $pdo->query($query);
while ($row = $result->fetch(PDO::FETCH_OBJ)) {
echo "$row->email<br/>";
}
$result = $db->query('SELECT id, catid, catname, uk_catname FROM products');
while ($row = $result->fetch(PDO::FETCH_OBJ)) {
$categ = "$row->catname";
$findcateg ="/ /";
$replacecateg ="-";
$categreplace = preg_replace ($findcateg, $replacecateg, $categ);
echo "<div class='submenu'><a href='/categ/$row->catid/$categreplace'>$row->catname</a></div>";
}