PHP

PHP PDO

Connection


$options = [
	PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
];
$pdo = new PDO('mysql:host=localhost;port=3306;dbname=Store;', 'root', '', $options);
unset($pdo);

Query


$stmt = $pdo->query('SELECT * FROM Animal');
if($stmt){
	$arr = $stmt->fetchAll();
	$stmt->closeCursor();
}

Prepare Execute


$stmt = $pdo->prepare('INSERT INTO Animal (AnimalName) VALUES(?)');
if($stmt){
	$arr = ['Cat'];
	if($stmt->execute($arr)){
		$ret = $stmt->rowCount();
	}
	$stmt->closeCursor();
}

Last Insert Id


if($stmt->rowCount() > 0){
	$id = $pdo->lastInsertId();
}

Fetch One Row


$stmt = $pdo->prepare('SELECT * FROM Animal WHERE AnimalId = :id');
if($stmt){
	if($stmt->execute(['id'=>1]) && $stmt->rowCount() > 0){
		$row = $stmt->fetch();
	}
	$stmt->closeCursor();
}