Ask Your Question
1

How can I change my code from pdo to mysqli code?

asked 2022-12-27 11:00:00 +0000

david gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2021-06-19 02:00:00 +0000

devzero gravatar image

Here are some of the basic PDO code that you can change to mysqli code:

  1. Opening a connection to the database: PDO:
$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');

Mysqli:

$mysqli = new mysqli('localhost', 'username', 'password', 'mydatabase');
  1. Executing a prepared statement: PDO:
$stmt = $pdo->prepare('SELECT * FROM users WHERE id = ?');
$stmt->execute([$id]);
$user = $stmt->fetch();

Mysqli:

$stmt = $mysqli->prepare('SELECT * FROM users WHERE id = ?');
$stmt->bind_param('i', $id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
  1. Inserting data into the database: PDO:
$stmt = $pdo->prepare('INSERT INTO users(name, email) VALUES(:name, :email)');
$stmt->execute(['name' => $name, 'email' => $email]);

Mysqli:

$stmt = $mysqli->prepare('INSERT INTO users(name, email) VALUES(?, ?)');
$stmt->bind_param('ss', $name, $email);
$stmt->execute();
  1. Retrieving the last inserted ID: PDO:
$id = $pdo->lastInsertId();

Mysqli:

$id = $mysqli->insert_id;
  1. Handling errors: PDO:
try {
    // Execute PDO code here
} catch(PDOException $e) {
    echo 'Error: ' . $e->getMessage();
}

Mysqli:

if(!$mysqli->query('SELECT * FROM users')) {
    echo 'Error: ' . $mysqli->error;
}
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2022-12-27 11:00:00 +0000

Seen: 13 times

Last updated: Jun 19 '21