Re: Workbench 8.0 Utilities - copy as PHP code

[Philip Burness]

Hi Peter,
when copying as PHP code from the tools -> Utilities menu and pasting the subsequent copy into an editor you get something along the lines of :-

$query = "SELECT * FROM mydb.table";


if ($stmt = $con->prepare($query)) {
$stmt->execute();
$stmt->bind_result($field1, $field2);
while ($stmt->fetch()) {
//printf("%s, %s\n", $field1, $field2);
}
$stmt->close();
}

The $con, $query $field etc variables must be defined somewhere - so is this editable within the workbench config files somewhere and if so where?

Phil