Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class database{
- private $_res;
- public function __construct($dbn) {
- $hostname = "localhost";
- $username = "root";
- $password = "";
- $dbname = ''.$dbn.'';
- $db = mysql_connect( $hostname,$username,$password ) or die( "Fatal error!!!" );
- mysql_select_db( $dbname ) or die( mysql_error () );
- }
- public function query($zap, $table){
- mysql_query( "SET NAMES utf8_general_ci" );
- $zapros = "SELECT $zap FROM $table";
- $results = mysql_query( $zapros );
- $this->_res = $results;
- }
- function fetchall(){
- $mas = array();
- while( $row = mysql_fetch_assoc ( $this->_res )) {
- $mas[] = $row;
- }
- return($mas);
- }
- }
- $db = new database('news');
- $result_query = $db->query('news.title, news.text_short', 'news');
- $messages = $db->fetchall();
- //print_r($messages);
- foreach($messages as $message){
- echo '<b>'.$message['title'].'</b> <br>';
- echo nl2br($message['text_short']).'<br>';
- }
Add Comment
Please, Sign In to add comment