Guest User

Untitled

a guest
Apr 7th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. <?php
  2. class database{
  3. private $_res;
  4. public function __construct($dbn) {
  5. $hostname = "localhost";
  6. $username = "root";
  7. $password = "";
  8. $dbname = ''.$dbn.'';
  9. $db = mysql_connect( $hostname,$username,$password ) or die( "Fatal error!!!" );
  10. mysql_select_db( $dbname ) or die( mysql_error () );
  11. }
  12. public function query($zap, $table){
  13. mysql_query( "SET NAMES utf8_general_ci" );
  14. $zapros = "SELECT $zap FROM $table";
  15. $results = mysql_query( $zapros );
  16. $this->_res = $results;
  17. }
  18. function fetchall(){
  19. $mas = array();
  20. while( $row = mysql_fetch_assoc ( $this->_res )) {
  21. $mas[] = $row;
  22.  
  23. }
  24. return($mas);
  25. }
  26.  
  27. }
  28.  
  29. $db = new database('news');
  30.  
  31. $result_query = $db->query('news.title, news.text_short', 'news');
  32.  
  33. $messages = $db->fetchall();
  34.  
  35. //print_r($messages);
  36. foreach($messages as $message){
  37. echo '<b>'.$message['title'].'</b> <br>';
  38. echo nl2br($message['text_short']).'<br>';
  39. }
Add Comment
Please, Sign In to add comment