Creating, Returning & Using Objects in PHP

Question

I have a set of functions:

One creates the connection, the others do different kinds of database interaction using that function.

I am retrieving the error;

Call to undefined method mysqli::execute()

this is telling me that I am failing to send the object through correctly, I have done some research but failed to find examples;

<?php
function con(){

$mysqli = new Mysqli("localhost","user","pass","image_blog");

if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}else{
    return $mysqli;
}};

function getAll(){

$mysqli = con();

$stmt = $mysqli->prepare("SELECT * FROM posts");
$stmt = $mysqli->execute();     <--- ERROR HERE
$stmt = $mysqli->get_result();
$stmt = $mysqli->close();

while($row = mysqli_fetch_array($stmt, MYSQL_ASSOC)) {
  echo "Username: " . $row["image"];
  echo "Username: " . $row["title"];
  echo "Username: " . $row["text"];
  echo "Username: " . $row["up"];
  echo "Username: " . $row["date"];
}
};
function anotherFunction(){

 }
 function yetAnotherFunction(){

 }

Yassine Moustarham · Accepted Answer · 2014-09-11 14:43:36Z

1

you should execute the statement ($stmt) it self not the $mysqli

$stmt->execute();

also consider using PDO class in the futur as it makes things mush easier

answered Sep 11, 2014 at 14:43

Yassine Moustarham

564 bronze badges

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

Comments

bashleigh · Accepted Answer · 2014-09-11 14:45:48Z

I see what that you're trying to achieve a connection function with your mysqli. Rather than connecting from each function individually. As Mr. Smith has mentioned, you've declared the variable $stmt like:

$stmt = $mysqli->prepare('SELECT * FROM posts');

This is incorrect as a prepared statement doesn't return data to be used in the variable, hence your error.

Another method would be to use classes, and yet another more advanced method would be to extend the mySQLi class.

Class myClass{
    protected $dbh;
    public function __construct(){
        $this->dbh=new mysqli('','','','');
    }
    public function getAll(){
        $this->dbh->prepare('SELECT * FROM posts');
        $this->dbh->execute();
        $this->dbh->bind_result($image,$title,$text,$up,$date);
        while($this->dbh->fetch()){
            echo"Username:".$image;
            //and so on
        }
        $this->dbh->close();
    }
    public function anotherFunction(){
    }
    public function yetAnotherFunction(){
    }
}

If you haven't used classes before you now need to create an instance of the class:

$databaseUser = myClass();

And to start your function:

$databaseUser->getAll();

Lkopo · Accepted Answer · 2014-09-11 14:37:14Z

0

It should be

$stmt->execute();
$result = $stmt->get_result();
$stmt->close();
$mysqli->close();

Instead of

$stmt = $mysqli->execute();
$stmt = $mysqli->get_result();
$stmt = $mysqli->close();

See official docs (examples too).

edited Sep 11, 2014 at 14:37

answered Sep 11, 2014 at 14:30

Lkopo

4,8538 gold badges37 silver badges60 bronze badges

Collectives™ on Stack Overflow

Creating, Returning & Using Objects in PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest