andyhajime

Used the print_r() and it returns: #Array ( [0] => 10336 [OCTET_LENGTH(imageraw)] => 10336 ) Database recorded: [bLOB - 10.1 KiB] So complete formula would be: $LENGTH = mysql_query("SELECT OCTET_LENGTH(blobdata) FROM thedatabase WHERE id = 'selected_id'"); $FOUND = mysql_fetch_array($LENGTH); $RESULTS = $FOUND['0'] / 1024; echo round($RESULTS, 1).'KiB'; // Results: 10.1KiB Thanks Pikachu2000 & PFMaBiSmAd! AWESOME! I'm so going to write down this snippet so people can use it. There's barely any tutorial online!

I tried this, still not working. Sorry, my php knowledge is very limited in this. $LENGTH = mysql_query("SELECT OCTET_LENGTH(blobdata) FROM thedatabase WHERE id = 'selected_id'"); $FOUND = mysql_fetch_array($LENGTH); echo $FOUND;

I've told the client and the webhoster about the problem they might facing, they gave me the green light, and they wanted this method... as long as there's black and white stating I'm not going to be responsible, fine by me. anyone know how to get blob size? please help dearly me.

Try saving the image name as a timestamp. eg: 200110112312 / YYYYMMDDHHMM. Unless you can use CRONJOB, suggest maybe each time a person visited the captcha page, do the clean up as well.

<?PHP $FIND = mysql_query("SELECT * FROM imagedata WHERE imagecode = '$DO' && imagemodel = '$WHAT'") or die(mysql_error()); $FOUND = mysql_fetch_array($FIND); header("Content-type: image/".$FOUND['imagemime']); echo $FOUND['imageraw']; ?> This is mine and it's working nicely. Try use the example.

The images stored are less then 10kb. Hardly 'stress' mysql. The guy attending the sever said it's so far so good. That's why I need this to work. So I can control the store data. you know how to make it work?

Hey there, need some help badly. I'm trying to get the size of the BLOB data in mysql. Did a search and there are like no tutorial on this. Only relevant info was from this page, at the far bottom, it just wrote this (below code). But the writer did not explain how to use it. SELECT OCTET_LENGTH(content) FROM BloBTest WHERE filename='myimage.png' I just give it a trial an error, wrote this, but did not work. $LENGTH = mysql_query("SELECT OCTET_LENGTH(blobdata) FROM thedatabase WHERE id = 'selected_id'"); echo $LENGTH; Please help....

Thanks Papaface, code works lovely.

Hello all, I'm currently doing this Facebook connect module for my website. With the FBconnect, it creates a user profile on my mysql, which stores only the Facebook userid, the full name, and the thumbnail url of this user. Currently the code works well except for this 'image url checking'. this is my fb profile image url: http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs349.snc4/41540_772137439_5612219_q.jpg when I've added a 'XXX' at the back ( http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs349.snc4/41540_772137439_5612219_qXXX.jpg ). It returns a blank instead. On Facebook, some accounts are not genuine and they might the deleted sooner or later. So I'm trying to figure out a php script or functions which detect if the image is not the 'XXX' version. I've tried using getimagesize() or file_get_contents() but still won't work. any ideas?

Can you paste out the codes instead?... thanks.

If you mean you want to limit the number of characters on the content, you can use my function. Enjoy. Usage: <td valign='top'>".TEXTCUT($a[content],"80")."</td> Function: function TEXTCUT($text, $words) { //<!-- code by iDexigns--!> $text = strip_tags($text); $matches= preg_split("/\s+/", $text, $words + 1); $sz = count($matches); if ($sz > $words) { unset($matches[$sz-1]); return implode(' ',$matches)."..."; } return $text; }

Guys, I've just find out the problem. Apparently one of the 'uename' in the database is EMPTY/Blank. When I've replace the 0 with nothing, then it works. It's no wonder it say "Empty delimiter" in strstr, the strsrt is getting an 'empty' value. lols $FIND = mysql_query("SELECT * FROM userdata WHERE uename != ''") ZachMEdwards: Thanks man... the 'do nothing' part is normally there for checking only like the sample below. I usually don't use the 'do nothing' method unless I encounter errors it the code. But thanks yeah for responding. Appreciate it. if(strstr($email, "@")) { echo 'found'; //...and do something } else { echo 'not found'; // do nothing }

Thanks everyone for helping, especially to Foxsoup for writing it out. You're the man!

Hi all, What the coding does is suppose to do is run a sql_query on the database, fetch the id of the names in the $TEXT (if exist) and replace it with the <a> tag linking to their profile... but I couldn't quit understand why I keep receiving an "strstr(): Empty delimiter". Please help. $TEXT = "There you see andy walks on the road to that azy house"; $FIND = mysql_query("SELECT * FROM userdata WHERE uename != '0'"); while($FOUND = mysql_fetch_array($FIND)) { $UENAME = $FOUND['uename']; // note: first result is 'andy' (id: 1) followed by 'misa' (id: 2) then 'azy' (id: 3) if(strstr($TEXT, $UENAME)) //<--- ERROR: Warning: strstr() [function.strstr]: Empty delimiter in /home/public_html/ajax.php on line 59 { $TAGNAME = ' <a href="profile.php?id='.$FOUND['id'].'">' . $UENAME . '</a> '; $TEXT = str_replace($UENAME, $TAGNAME, $TEXT); } else { // do nothing } } // result: There you see <a href="profile.php?id=1">andy</a> walks on the road to that <a href="profile.php?id=3">azy</a> house

Hi everyone, I need some pointers on how I can do this... This is the content: Notice there's this "[[" & "]]" in the names... I want a write a function that replace whatever in between the [[]] into a url link to their profile. But I having difficulty getting these value out so I can do a SQLquery stuff - eg Azrael, HarryEx, ect. At first I figure looking at Preg_replace and Ereg_replace but I can't find a good proper tutorial to guide me with. Please help this poor soul and direct me to which php function I should use for such task.