nnsnodnb · August 29, 2015 14:26
diff --git a/checker_php_mysql.php b/checker_php_mysql.php
 <?php
 $dsn = 'mysql:dbname=mysql;host=127.0.0.1';
 $user = 'root';
 $password = 'PASSWORD';

 $dbh = new PDO($dsn, $user, $password);
 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

 $sql = "SELECT COUNT(*) as cnt FROM user";
 foreach ($dbh->query($sql) as $row)
 {
    echo $row['cnt'] ."\n";
 }
 ?>
	<?php
	$dsn = 'mysql:dbname=mysql;host=127.0.0.1';
	$user = 'root';
	$password = 'PASSWORD';

	$dbh = new PDO($dsn, $user, $password);
	$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

	$sql = "SELECT COUNT(*) as cnt FROM user";
	foreach ($dbh->query($sql) as $row)
	{
	echo $row['cnt'] ."\n";
	}
	?>
No results found