 |
BOOK: Beginning PHP 5.3  | This is the forum to discuss the Wrox book Beginning PHP 5.3 by Matt Doyle; ISBN: 978-0-470-41396-8 |
|
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Beginning PHP 5.3 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
October 22nd, 2011, 10:29 PM
|
|
Authorized User
|
|
Join Date: Jun 2011
Posts: 51
Thanks: 9
Thanked 0 Times in 0 Posts
|
|
unexpected T_PUBLIC in line ...
I got these errors for each one of the new functions we add to the member.class.php on chapter 4.
which say kind of : Parse error: syntax error, unexpected T_PUBLIC in /member.class.php on line 85 which the 85 is the number line where each function starts at. so anybody can help. thanks
PHP Code:
<?php
require_once "dataObject.class.php";
class member extends dataObject {
protected $data = array(
"id" => "",
"username" => "",
"password" => "",
"firstName" => "",
"lastName" => "",
"joinDate" => "",
"gender" => "",
"favoriteGenre" => "",
"emailAddress" => "",
"otherInterests" => ""
);
protected $_genres = array (
"herror" => "Herror",
"thriller" => "Thriller",
"romance" => "Romance",
"sciFi" => "Sci-Fi",
"nonFiction" => "Non-Finction",
"crime" => "Crime"
);
public static function getMembers($startRow, $numRows, $order, $interest="") {
$conn = parent::connect();
$interestFound = $interest ? " WHERE otherInterests LIKE :interest " : "";
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM " . TBL_MEMBERS . "
$interestsFound ORDER BY $order LIMIT :startRow, :numRows";
try {
$st = $conn->prepare($sql);
$st->bindValue(":startRow", $startRow, PDO::PARAM_INT);
$st->bindValue(":numRows", $numRows, PDO::PARAM_INT);
if ($interest) $st->bindValue(":interest", "%$interest%", PDO::PARAM_STR);
$st->execute();
$members = array();
foreach ($st->fetchAll() as $row) {
$members[] = new member($row);
}
$st = $conn->query("SELECT found_rows() AS totalRows");
$row = $st->fetch();
parent::disconnect($conn);
return array( $members, $row["totalRows"] );
}catch (PDOException $e) {
parent::disconnect($conn);
die( "Query Failed! -1 : " . $e->getmessage() );
}
}
public static function getMember( $id) {
$conn = parent::connect();
$sql = "SELECT * FROM " . TBL_MEMBERS . " WHERE id = :id";
try {
$st = $conn->prepare($sql);
$st->bindValue(":id", $id, PDO::PARAM_INT);
$st->execute();
$row = $st->fetch();
parent::disconnect($conn);
if ($row)
return new member($row);
}catch (PDOException $e) {
parent::disconnect($conn);
die("Query Faild! -2: " . $e->getmessage() );
}
}
public function getGenderString() {
return ($this->data["gender"] == "f") ? "Female" : "Male" ;
}
public function getFavoriteGenreString() {
return ($this->_genres[$this->data["favoriteGenre"]] );
}
}
public static function getByUsername($username){
$conn = parent::connect();
$sql= "Select * from " . TBL_MEMBERS . " where username = :username";
try {
$st = $conn->prepare($sql);
$st->bindValue(":username", $username, PDO::PARAM_STR);
$st->execute();
$row = $st->fetch();
parent::disconnect($conn);
if ($row) return new member($row);
}catch (PDOException $e){
parent::disconnect($conn);
die ("Query Failed : " . $e->getmessage() );
}
}
public static function getByEmailAddress($emailAddress){
$conn = parent::connect();
$sql = "select * from " . TBL_MEMBER . " where emailAddress = :emailAddress";
try{
$st = $conn->prepare($sql);
$st->bindValue(":emailAddress", $emailAddress, PDO::PARA_STR);
$st->execute();
$row = $st->fetch();
parent::disconnect($conn);
if($row) return new member($row);
}catch (PDOException $e){
echo "Query Faild : " . $e->getmessage();
}
}
public function getGenres() {
return $this->_genres;
}
public function insert(){
$conn = parent::connect();
$sql = "insert into " . TBL_MEMBERS . " (
username,
password,
firstName,
lastName,
joinDate,
gender,
favoriteGenre,
eamilAddress,
otherInterests
) value (
:username,
:password,
:firstName,
:lastName,
:joinDate,
:gender,
:favoriteGenre,
:emailAddress,
:otherInterests
)";
try {
$st = $conn->prepare($sql);
$st->bindValue(":username", $this->data["username"], PDO::PARAM_STR);
$st->bindValue(":password", $this->data["password"], PDO::PARAM_STR);
$st->bindValue(":firstName", $this->data["firstName"], PDO::PARAM_STR);
$st->bindValue(":lastName", $this->data["lastName"], PDO::PARAM_STR);
$st->bindValue(":joinDate", $this->data["joinDate"], PDO::PARAM_STR);
$st->bindValue(":gender", $this->data["gender"], PDO::PARAM_STR);
$st->bindValue(":favoriteGenre", $this->data["favoriteGenre"], PDO::PARAM_STR);
$st->bindValue(":emailAddress", $this->data["emailAddress"], PDO::PARAM_STR);
$st->bindValue(":otherInrerests", $this->data["otherInterests"], PDO::PARAM_STR);
$st->execute();
parent::disconnect($conn);
}catch (PDOException $e){
parent::disconnect($conn);
die("Query Failed : " .$e->getmessage();
}
}
?>
|
|
|
