php oop and mysql query

Question

I am trying to make a function that queries an array, and then I will be able to call the separate values. Here, I think you will understand what I am trying to do. Except I am a complete beginner to this.

class Posts{

  var $title;
  var $author;

  public function querySinglePost($value){

    $post = mysql_fetch_array(mysql_query("select * from posts where id=$value"));  
    $this->title = $post['title'];
    $this->author = $post['author'];

  } 


}

How can I assign the array values to variables in the class, and then call them in my normal php script/view? Thanks

Community · Accepted Answer · 2023-11-17 20:24:09Z

5

Take a look at mysql_fetch_object. I'd also suggest to make that function static which will just return created object. Like this:

class Posts{

  var $title;
  var $author;

  public static function querySinglePost($value){

    return mysql_fetch_object(
       mysql_query("select * from posts where id=$value"),
       __CLASS__);

  } 

}

$post = Posts::querySinglePost($value);
$a = $post->title;
//...

edited Nov 17, 2023 at 20:24

CommunityBot

11 silver badge

answered Mar 18, 2011 at 14:56

Slava

2,05015 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Phil Over a year ago

If you're refactoring the whole thing, might as well throw in some error / empty resultset handling. +1 for "getting" what the OP is after (I think)

Chris Over a year ago

I love you Slava... You know that right? This worked perfectly. thank you!

Phil · Accepted Answer · 2011-03-18 14:52:38Z

1

Apart from the lack of any error handling, wouldn't you just do something like

$posts = new Posts;
$posts->querySinglePost(1);
echo $posts->title;
echo $posts->author;

answered Mar 18, 2011 at 14:52

Phil

166k25 gold badges265 silver badges269 bronze badges

1 Comment

Phil Over a year ago

Also, PHP 4 died a long, long time ago.

Artur Marnik · Accepted Answer · 2011-03-18 14:53:13Z

1

$posts = new Posts();
$posts->querySinglePost($id);

echo "return values: \n";
echo $posts->title . "\n";
echo $posts->author . "\n";

answered Mar 18, 2011 at 14:53

Artur Marnik

1162 bronze badges

Comments

miqbal · Accepted Answer · 2011-03-18 15:02:07Z

0

class Posts{

  public $post = array();

  public function querySinglePost($value){

    // fetch... $results

    $this->post['title']  = $results['title'];
    $this->post['author'] = $results['author'];
    // ...
    return $this->post;
  } 
}

$mySweetPost = new Posts();
print_r($mySweetPost->querySinglePost(1));

answered Mar 18, 2011 at 15:02

miqbal

2,2373 gold badges28 silver badges35 bronze badges

Comments

Shameer · Accepted Answer · 2011-03-18 15:11:58Z

0

You can be bit more organized in this case. Consider this class as a model which will extend a base model class. Instead of directly using mysql_query, use a database class and using which u can DO database operations like querying the database. insert into database, etc. set this as the db object in your base model class. As a simple demo

class model{
  public function __construct()
  {
    $this->db = new Database(HOST,USER,PASS,DB);
  }
}

class Post extends model{    
public $post;
public function querySinglePost($value){
       $this->post = $this->db->query("select query");
       return $this->post;
    }
}

You will be calling like

$ObjPost = new Post();
$post = $ObjPost->querySinglePost(1);

answered Mar 18, 2011 at 15:11

Shameer

3,0861 gold badge23 silver badges27 bronze badges

Collectives™ on Stack Overflow

php oop and mysql query

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related