fork download

copy

<?php 
require_once(ROOT_PATH.'/Models/Db.php');
 
class Player extends Db{
    private $table = 'players';
    public function __construct($dbh = null){
        parent::__construct($dbh);
    }
    /**
     * playersテーブルからすべてのデータを取得
     * 
     * @param integer $id 選手ID
     * @return Array $result 指定の選手データ
     */
    public function findById($id = 0):Array {
        $sql = 'SELECT * FROM '.$this->table;
        $sql .= 'WHERE id = :id';
        $sth = $this->dbh->prepare($sql);
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
        $sth->execute();
        $result = $sth->fetch(PDO::FETCH_ASSOC);
        return $result;
    }
    /**
     * playersテーブルからすべてのデータを取得
     * 
     * @param integer $page ページ番号
     * @return Array $result 全選手データ
     */
    public function findAll():Array {
        $sql = 'SELECT * FROM '.$this->table;
        $sth = $this->dbh->prepare($sql);
        $sth->execute();
        $result = $sth->fetchAll(PDO::FETCH_ASSOC);
        return $result;
    }
}
?>

Main.java:1: error: class, interface, or enum expected
<?php 
^
Main.java:2: error: unclosed character literal
require_once(ROOT_PATH.'/Models/Db.php');
                       ^
Main.java:2: error: unclosed character literal
require_once(ROOT_PATH.'/Models/Db.php');
                                      ^
Main.java:5: error: <identifier> expected
    private $table = 'players';
                  ^
Main.java:5: error: unclosed character literal
    private $table = 'players';
                     ^
Main.java:5: error: unclosed character literal
    private $table = 'players';
                             ^
Main.java:6: error: <identifier> expected
    public function __construct($dbh = null){
                                    ^
Main.java:7: error: not a statement
        parent::__construct($dbh);
        ^
Main.java:7: error: ';' expected
        parent::__construct($dbh);
                           ^
Main.java:7: error: not a statement
        parent::__construct($dbh);
                            ^
Main.java:7: error: ';' expected
        parent::__construct($dbh);
                                ^
Main.java:15: error: <identifier> expected
    public function findById($id = 0):Array {
                                ^
Main.java:16: error: unclosed character literal
        $sql = 'SELECT * FROM '.$this->table;
               ^
Main.java:16: error: unclosed character literal
        $sql = 'SELECT * FROM '.$this->table;
                              ^
Main.java:16: error: not a statement
        $sql = 'SELECT * FROM '.$this->table;
                       ^
Main.java:16: error: not a statement
        $sql = 'SELECT * FROM '.$this->table;
                                ^
Main.java:17: error: <identifier> expected
        $sql .= 'WHERE id = :id';
              ^
Main.java:17: error: unclosed character literal
        $sql .= 'WHERE id = :id';
                ^
Main.java:17: error: illegal start of expression
        $sql .= 'WHERE id = :id';
                            ^
Main.java:17: error: unclosed character literal
        $sql .= 'WHERE id = :id';
                               ^
Main.java:17: error: not a statement
        $sql .= 'WHERE id = :id';
                             ^
Main.java:19: error: unclosed character literal
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
                        ^
Main.java:19: error: not a statement
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
        ^
Main.java:19: error: unclosed character literal
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
                            ^
Main.java:19: error: not a statement
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
                          ^
Main.java:19: error: not a statement
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
                              ^
Main.java:19: error: ';' expected
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
                                 ^
Main.java:19: error: not a statement
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
                                  ^
Main.java:19: error: ';' expected
        $sth->bindParam(':id',$id,PDO::PARAM_INT);
                                                ^
Main.java:20: error: not a statement
        $sth->execute();
        ^
Main.java:30: error: ';' expected
    public function findAll():Array {
                             ^
Main.java:31: error: unclosed character literal
        $sql = 'SELECT * FROM '.$this->table;
               ^
Main.java:31: error: unclosed character literal
        $sql = 'SELECT * FROM '.$this->table;
                              ^
Main.java:31: error: not a statement
        $sql = 'SELECT * FROM '.$this->table;
                       ^
Main.java:31: error: not a statement
        $sql = 'SELECT * FROM '.$this->table;
                                ^
Main.java:33: error: not a statement
        $sth->execute();
        ^
Main.java:38: error: class, interface, or enum expected
?>
^
37 errors

Standard output is empty