please I need help here ....insert() function

nawar youssef · #1 (**permalink**) October 25th, 2011, 01:27 AM

hello everbody
I got an error like this :

Code:

Query Failed / insert() function: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

and I am using the same code but I didn't understand what does the error mean, where i have to fix or how to ????
this is my function

PHP Code:


			
 public function insert(){

            $conn = parent::connect();

            $sql = "insert into " . TBL_MEMBERS . " ( 

                username, 

                password, 

                firstName, 

                lastName, 

                joinDate,

                gender, 

                favoriteGenre, 

                eamilAddress, 

                otherInterests                

            ) values ( 

                :username, 

                :password(: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 / insert() function: " .$e->getmessage() );

             }

          }

    }

I am using $member instead of $Member, is not a mistake.
and if you need to see all my member class here it is :

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! / getMembers() function : " . $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! / getMember() function: " . $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 /getByUsername() function : " . $e->getmessage() );

            }

            

        }

        

        public static function getByEmailAddress($emailAddress){

            $conn = parent::connect();

            $sql = "select * from " . TBL_MEMBERS . " where emailAddress = :emailAddress";

            

            try{

            $st = $conn->prepare($sql);

            $st->bindValue(":emailAddress", $emailAddress, PDO::PARAM_STR);

            $st->execute();

            $row = $st->fetch();

            parent::disconnect($conn);

            if($row) return new member($row);

            }catch (PDOException $e){

                echo "Query Faild /getByEmailAddress() function: " . $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                

            ) values ( 

                :username, 

                :password(: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 / insert() function: " .$e->getmessage() );

             }

          }

    }

    

?>

thank you so much, I know its hard to read other people's codes.

UseLess · #2 (**permalink**) October 25th, 2011, 03:41 AM

Greetings,

I am guessing here but your problem could be due to this:

Code:

:password(:password),

try changing it to:

Code:

password(:password),

that way it'll use the PASSWORD function to encrypt the supplied password.

nawar youssef · #3 (**permalink**) October 25th, 2011, 10:05 PM

thank you I change it and it was a mistak but I had another error its the same code number but it tells me this time that the parameter was not found:

Code:

SQLSTATE[HY093]:Invalid parameter number: parameter was not defined

I hope you know what does that mean, and do you know if there any php validator like html and css, it will vary useful for me.
thank you

Need to download code?

Navigation