Update image & write image size and height to database

Hi
I am using MySqli update SB and the WA File Manipulation.
Question:
How do I capture the image height and width on upload and write this info to the database?
At the moment, the image uploads (updates) okay, but the new height and width values are not captured nor are the old values overwritten.
Thanks

I'd need to look at the page to see why they aren't getting set. The new width and height should be available in the bindings, and those values should be set when an image is uploaded.

Next time please attach the actual page so I can open it in dreamweaver.

It looks like you are setting the width and height with:
<?php echo((isset($_POST["width"]))?$_POST["width"]:""); ?>
<?php echo((isset($_POST["height"]))?$_POST["height"]:""); ?>

and you should be using:
<?php echo($WA_DFP_UploadStatus["WA_UploadResult1"]["imageWidth"]); ?>
<?php echo($WA_DFP_UploadStatus["WA_UploadResult1"]["imageHeight"]); ?>

Originally Said By: Ray Borduin

  Next time please attach the actual page so I can open it in dreamweaver.

It looks like you are setting the width and height with:
<?php echo((isset($_POST["width"]))?$_POST["width"]:""); ?>
<?php echo((isset($_POST["height"]))?$_POST["height"]:""); ?>

and you should be using:
<?php echo($WA_DFP_UploadStatus["WA_UploadResult1"]["imageWidth"]); ?>
<?php echo($WA_DFP_UploadStatus["WA_UploadResult1"]["imageHeight"]); ?>  

Dear Ray,
Attached is my PHP page.

I am still not sure what I should do or change.

I assume the MySQLi update code block would be the place to modify the code?

$UpdateQuery->bindColumn("height", "s", "".((isset($_POST["height"]))?$_POST["height"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("width", "s", "".((isset($_POST["width"]))?$_POST["width"]:"") ."", "WA_DEFAULT");


Question:
Wouldn't this code be generated by either the MySqli SB Update or by the File Manipulation function? I can't seem to make it work.

Yes you should update the mysqli update server behavior and use the values I posted to update the height and width fields. It will update the lines of code you have referenced.

Thanks Ray,
Based on your information, I could do it by hand coding the update code block. And it works!

Keep up the good work at Webassist.