Etwas

<?php

$con = mysqli_connect('localhost', 'root');

mysqli_select_db($con, 'test');

$query = "INSERT INTO foo VALUES ('asdasdsadsa'),('asdasdsadsa'),('asdasdsadsa'),('asdasdsadsa')";
var_dump(mysqli_query($con, $query));

$query = "SELECT * FROM foo";
$result = mysqli_query($con, $query);

while (($row = mysqli_fetch_assoc($result))) {
	var_dump($row);
}

$query = "SET AUTOCOMMIT = 0";
$query = "START TRANSACTION";
var_dump(mysqli_query($con, $query));

$query = "DELETE FROM foo WHERE 1=1";
var_dump(mysqli_query($con, $query));

//$query = "ROLLBACK";
//var_dump(mysqli_query($con, $query));

die();

?>