Find date and datetime fields with invalid values

find-0000

<?php

function cmd_db_find_0000(): void
{
	global $App;
	$key = "Tables_in_bulundum_com";
	$tables = field2array($App->RDB->run("SHOW TABLES"), $key);
	foreach ($tables as $tablename)
	{
		$fields = $App->RDB->run("SHOW COLUMNS FROM `$tablename`");
		foreach ($fields as $field)
		{
			if ($field['Type'] === 'datetime' || $field['Type'] === 'date')
			{
				$fieldname = $field['Field'];
				$qstr = "SELECT Id FROM `$tablename` WHERE $fieldname LIKE '0000%'";
				$rows = field2array($App->RDB->run($qstr));
				if ($rows)
				{
					pp("$tablename: $fieldname");
					pp($qstr);
					ppj($rows);
				}
			}
		}
	}
}