Re: Tool to Update .ibd files

[Peter Brawley]

> I am very new to the syntax of PHP.

Um, hadn't you said "I am familiar with using PHP and SQL to update my tables"?

Start the page with ...

ini_set( "display_errors", "1" );

... so it shows errors.

> $img = "file_get_contents( 'c:\TriCounty01.JPG' )"

Every such statement needs a terminating semicolon.

Backslash is an escape character in most computer languages (a reason Microsoft's use of it as a directory separator is excrescently dumb). In MySQL and PHP use forward slashes in paths, the runtimes will translate them appropriately.

Then you need something like ...

$sql = "update advert04b set graphic01 = '$img' where serialno = 1";
$res = mysqli_query( $conn, $qry ) or exit( mysqli_error($conn );
echo mysqli_affacted_rows( $conn ), " rows affected";