Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.68 KB | None | 0 0
  1. <?php
  2. $db_host="localhost";
  3. $db_user="root";
  4. $db_pass="";
  5. $db_name="site";
  6. $tbl_name="pages";
  7.  
  8. $conn = mysql_connect($db_host, $db_user, $db_pass);
  9. if(!$conn) die("Could not connect to server<br />".mysql_error());
  10. mysql_select_db($db_name)or die("cannot select DB<br />".mysql_error());
  11.  
  12. $view = "main";
  13. $views = array("about", "contact", "services", "suppliers");
  14. if(in_array($_GET['page'], $views) $view = mysql_real_escape_string($_GET['page']);
  15.  
  16. $query = "SELECT name,content FROM $tbl_name WHERE name = '$view'";
  17. $result = mysql_query($query);
  18.  
  19. if ($result) {
  20.     $row = mysql_fetch_row($result);
  21.     $title = $row[0];
  22.     $body = $row[1];
  23.    
  24.     mysql_free_result($result);
  25. }
  26.  
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement