khunjack

mac_gyver,Jacques1 Thanks to you both for your replies and help. Very appreciated (What a great board). Made me find a routine. I just checked and got - MySQL is installed. - MySQLi is installed. - libmysqlclient driver is being used. - PDO MySQLnd is enabled. Seems I will be ok using PDO I used :

Jacques1, Thank you very much for your fast reply. I understand the external server management company I use, (not my host/server company) explanation is misleading. Do you see a way for me to see, if it is disabled and to enable the native driver ? Thanks a lot. Jack PS: I wasn't sure if for new dev. I would use mysqli or PDO. I will go for PDO. PS: I'm a little bit reluctant to tell them. They just tried to upgrade to Easyapache 4 which didn't work with mod_php and all sites on this server where not accessible for nearly 24 hrs.

Hi, Using a new external script and I'm getting the following error: Fatal error: Call to undefined function mysqli_stmt_get_result() in /home/.... According to the script developer, an host issue. I asked my server management company and they came back with this answer: Note: o currently I need to stick with mod_php and php 5.4.45 o According to phpinfo: mysql, mysqli, mysqlnd is installed. If it is correct that "mysqli_stmt_get_result" is only avaialble till php 5.3? Any suggestion how to tackle this issue? Thanks a lot in advance Jack

Mchl, Thank you for your reply. $aRow = $this->getPicture($sPicId); . $src = @imagecreatefromstring ($aRow["Bin Data"]); $image = imagecreatetruecolor (...); imagecopyresampled (...); . . $rotate = imagerotate($image, $degrees, 0) ; imagejpeg($rotate, $imagename2) ; now I have the rotated pic in '$imagename2' in the server root Up to now could not manage to store the rotated image back into mysql. Tried a few things, honestly I don't have a glue, e.g. stored the $rotate, $imagename2 in the blob ["Bin Data"] field... etc... Thank you Jack

PS: The image is on the server root .... the issue is to store it back into mysql Thanks

Dears, I have images in mysql (blob). Some of the images need to be rotated (90 degrees). Not sure how to do it. Do I have to physical write the image? (I did that and was using 'imagerotate' -> image rotated, but couldn't manage to store the rotated images back into mysql.) Can the blob be rotated?? Any hints/suggestions are very welcome. Thanks a lot Jack