Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host="localhost";
- $db_user="root";
- $db_pass="";
- $db_name="site";
- $tbl_name="pages";
- $conn = mysql_connect($db_host, $db_user, $db_pass);
- if(!$conn) die("Could not connect to server<br />".mysql_error());
- mysql_select_db($db_name)or die("cannot select DB<br />".mysql_error());
- $view = "main";
- $views = array("about", "contact", "services", "suppliers");
- if(in_array($_GET['page'], $views) $view = mysql_real_escape_string($_GET['page']);
- $query = "SELECT name,content FROM $tbl_name WHERE name = '$view'";
- $result = mysql_query($query);
- if ($result) {
- $row = mysql_fetch_row($result);
- $title = $row[0];
- $body = $row[1];
- mysql_free_result($result);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement