PHP Article::getTableName Examples

Example #1

File: Comment.php Project: zhizunbaonie/blog-2

 public static function getAll()
 {
     $db = static::prepareDatabase();
     //        $sql = "SELECT * FROM " . static::$table . " ORDER BY id DESC";
     $artTbl = Article::getTableName();
     $sql = "SELECT com.*, art.title FROM" . " " . static::$table . " com LEFT JOIN " . $artTbl . " art" . " ON art.id=com.article_id" . " ORDER BY com.id DESC";
     return $db->makeSqlQuery($sql);
 }