Reviews of the Well House Consultants web site

Graham Ellis said Thanks for that "404" feedback. I have fixed the old blog article; a bit of intelligent scripting added an unwanted change to that particular item. We have switched the log analysis software we use internally ... and that has meant that private images we break through in public are now "404"ing. Sorry about that; I would like to put up alternatives, but there are no direct replacements so I'll be simply putting in holding markers at the moment. Other suggestions ... on my list; the whole issue of the best way to navigate our data is quite an interesting one ;-)

Reviews for http://www.wellho.net/solutions/python-python-list-python-tuple-python-dictionary.html

Graham said Thanks for your comment, "Anon". This article is an overview comparison and not a definitive specification of lists, tuples and dictionaries. I never claimed it to be complete reference material ... so it's natural that it's incomplete. My suggested link includes an alternative description of Tuples, described on their own rather than based on a comparison.

Reviews for http://www.wellho.net/solutions/php-example-php-form-image-upload-store-in-mysql-database-retreive.html

phptechie said This is very usefull to me,its helps lot for my image uploading process.. Thank you!!

Jim Williams said Questions about the construct "<img src=?gim=1 width=144>" are all over the Internet. When I view the page source for http://www.wellho.net/demo/pic_up.php4, Firefox treats "?gim=1" as if it were a hyperlink. I gather that "?gim=1" is some sort of data URL, but every example of data URLs I can find uses the base64 encoding.

Rob said Terrific Graham, a script that actually works first time. Thanks. Are you available for support / consultancy?

Ramakrishnan said Well,it is working good,Thanks for your great work... Thanks Ramakrishnan t

Sanjay said Hy. The code that has been used to upload and display pictures from the mysql database is very good. The picture is saved in the database. Though i am having problems displaying the picture. I tried that gim=1 thing and i tried substituting the gim to pid. Nothiong seems to work. please if someone can assist me i would highly appreciate it. Sanjay

redRoger said I had made some changes to the script because when trying to import to a external Database for Example MyphpAdmin it will give some upload error. This is the new mod that works.... <?php // Connect to database $errmsg = ""; $db = mysql_connect($hostname,$username, $password) or die ("<html><script language='JavaScript'>alert('Unable to connect to database! Please try again later.'),history.go(-1)</script></html>"); mysql_select_db($dbname); // Insert any new image into database if ($_REQUEST[completed] == 1) { // Need to add - check for large upload. Otherwise the code // will just duplicate old file ;-) // ALSO - note that latest.img must be public write and in a // live appliaction should be in another (safe!) directory. $uploaded_dir = 'temporary'; $path = $uploaded_dir . $filename; $filename = $_FILES['imagefile']['tmp_name']; $instr = fopen($filename,'rb'); $image = addslashes(fread($instr,filesize($filename))); if (strlen($instr) < 200000) { mysql_query ("insert into pix (title, imgdata) values (\"". $_REQUEST[whatsit]. "\", \"". $image. "\")"); } else { $errmsg = "Too large!"; } } // Find out about latest image $gotten = @mysql_query("select * from pix order by pid desc limit 1"); if ($row = @mysql_fetch_assoc($gotten)) { $title = htmlspecialchars($row[title]); $bytes = $row[imgdata]; } else { $errmsg = "There is no image in the database yet"; $title = "no database image available"; // Put up a picture of our training centre $instr = fopen("assets/ctco.jpg","rb"); $bytes = fread($instr,filesize("assets/ctco.jpg")); } // If this is the image request, send out the image if ($_REQUEST[gim] == 1) { header("Content-type: image/jpeg"); print $bytes; exit (); } ?>

Alex said Nice work.Thank you.On web site user post item with image through post form.I need insert the data and image into SQL and every image suppose to belong to his data.This script works good.But i need insert image in the same table where is data in and after retreive it with data.Please help.Thanks a lot

Anon said This is an excellent tutorial, just what i have been searching for! well done!

said Please do not use the picture which I uploaded. I saw the message below after I uploaded the image.

Graham said I've provided a link to our help forum on this review - that is a far better vehicle for support that this comment section. There are many elements involved in an upload / store / retreive / download script and you need to know some PHP and MySQL to implement on your own server - things like account names need changing, and perhaps spurieous spaces from line wraps on your browser taking out.

bimbolera said to everyone who encountered the IMAGE DOES NOT SHOW the key to this is fine the <center><img src= width=144><br> part of the html, you will see there that the img src part is blank so paste this ?gim=1 after the src= and your problem is solved. now my new problem is i've made another page wherein i wish that all the images uploaded will be viewed. i hope i can get a comment over this.

sukanta said hey!!thanks for your script.. i am using it in my site.when i am using it within a page its working nice but when i am using it with another form then data and image is inserted but when i am selecting the pix table to show image and title it selecting title but not getting image..plz give a solution.. thanks sukanta

Greg said Here is the mysqli modification: <?php // Connect to database $link = mysqli_connect("localhost","user","password"); $errmsg = ""; if (! $link) { $errmsg = "Cannot connect to database"; } mysqli_select_db($link,"test"); // Create table if not already present $q="CREATE table pix ( pid int primary key not null auto_increment, title text, imgdata longblob)"; mysqli_query($link,$q); // Insert any new image into database if ($_REQUEST[completed] == 1) { move_uploaded_file("imagefile","latest.img"); $instr = fopen("latest.img","rb"); $image = addslashes(fread($instr,filesize("latest.img"))); if (strlen($instr) < 149000) { mysqli_query ($link,"insert into pix (title, imgdata) values (\"". $_REQUEST[whatsit]. "\", \"". $image. "\")"); } else { $errmsg = "Too large!"; } } // Find out about latest image $gotten = mysqli_query($link,"select * from pix order by pid desc limit 1"); if ($row = mysqli_fetch_assoc($gotten)) { $title = htmlspecialchars($row[title]); $bytes = $row[imgdata]; } else { $errmsg = "There is no image in the database yet"; $title = "no database image available"; } // If this is the image request, send out the image if ($_REQUEST[gim] == 1) { header("Content-type: image/jpeg"); print $bytes; exit (); } ?> <html><head> <title>Upload an image to a database</title> <body bgcolor=white><h2>Here's the latest picture</h2> <font color=red><?= $errmsg ?></font> <center><img src=?gim=1 width=144><br> <b><?= $title ?></center> <hr> <h2>Please upload a new picture and title</h2> <form enctype=multipart/form-data method=post> <input type=hidden name=MAX_FILE_SIZE value=150000> <input type=hidden name=completed value=1> Please choose an image to upload: <input type=file name=imagefile><br> Please enter the title of that picture: <input name=whatsit><br> then: <input type=submit></form><br> <hr> By Graham Ellis - graham@wellho.net modified for mysqli by Greg Gordon - cydoc@earthlink.net </body> </html>

Anon said HELP! I have the scrip working fine, except I'm having a hard time displaying the image. I'm using the following code to display the images. ************************************************** mysql_connect($db_host, $db_user, $db_pwd); mysql_select_db($db_name); $SQLgetImages = "SELECT * FROM pix ORDER BY pid"; $getImagesNow = mysql_query ($SQLgetImages); if (mysql_num_rows ($getImagesNow) == 0) { echo "There are no images."; } else { while ($row = mysql_fetch_array ($getImagesNow)) { echo "<br>Title:" . $row["title"] . "Image:<img src=upload/". isset($row['imagefile']) . "><br>"; } }

Jelle said Thanks for this script. However, I have a problem. The images don't seem to upload at all.. my database sais 0kb and they don't display after uploading. I sometimes get an error about these two lines: $instr = fopen("latest.img","rb"); $image = addslashes(fread($instr,filesize("latest.img"))); Everything else seems to work fine. I also have the mysql and php version required. A little help over here? Grtz PS I added the link to my website where I implemented the script.

frustrated said worked to a point, it put the images in the db, but it did'nt display them as shown! Mor significantly though, ho do i retrieve the images to a web page..?? left holing the baby

Peter J said Thanx a lot! worked directly even for me as beginner in php, mysql. A suggestion is that you make it even more obviuos that the whole code should be in one page and not as in the first example..

Anon said Thanks a lot man. It works great. Just as soon as I can understand it all I will be off to the races.

David Kadison said This worked perfectly for me - I changed, the database user, passwoord and name and it worked without a tweak... Thank you so much

Daniel Diaz said The code is really good. After a while i figured out the error. Just substitute "gim" for "pid". Trust me it will work. That was the whole bug. Lucky I found out. The funny thing is that I am not a programmer, I am just learning to do websites... Buena suerte amigos...

Jem Smith said Hello I'm Jem Smith devloper in infoseeksoftwaresystems.com I'm unable to use this script.hwo can this make helpfule to me.

Graham said Dorit, thanks for your comments. This script is very much a demonstration of how the various PHP and MySQL and HTML form elements fit together. You (and anyone else) are welcome to add in your own validation in the form of passwording, [further] error checking, etc. The matter of user validation for uploaded images is a very serious one indeed; at first glance, it could look as if we are leaving ourselves wide open on this site to image postings without any form of moderation. However, as users are only shown the latest images the system is self-correcting in that is someone posts an image that they should not, it will soon disappear as others get added on following.

Dorit said Quite interesting script, but I would want a password option and the filesize limit does not work - larger files plus title are still uploaded to the database (with no error message), but the pictures won't be able to show since they post with a size under the limit. However they don't seem to be resized, only somehow broken. I testet the script test page here, and here also my picture title ended up being shown together with the next last uploaded picture, the latest picture which was under the size limit, excactly as I experience it with my own implementation, so it seems the problem is with the script, not my implementation of it.

Graham said Albert, the source code of the other page may be handy there ... the coding to do it should be straightforward if you know some SQL (and if you don't, a question and answer session really isn't the best way to learn - click on the suggested link instead. We have chosen NOT to display more than 3 on the other page for security reasons - allowing just 3 images to be seen on a fastmoving site means that it is selfmoderating - any nasty images soon get lost in the depths of time ;-)

Albert said Great script, I only have one question. Is it possible to view all the images in the database? Can you also explain how you get up to three images on the other page where you can search through the db?

Graham said Bastler, the limit is simply to stop people flooding our server although PHP does have an upload limit (much higher, configurable via the php.ini file)

Bastler said just what I needed, thanks! I have one question though: The filesize limit you implement in the script, is this a "must have"-mySQL-Hardlimit or do you just want to prevent people from flooding your Database with DVD-ISOs? In other words: if I use this script and limit access to it to trustworthy people, can I allow 5MB images or will it crash the database?

Alan Hamlyn said I've seen this script for download elsewhere, i think its a possiblity it was taken...

Graham said Damu - I don't know which picture you saw. This page is open to anyone to test and, occasionally, unsuitable material gets posted. We do keep an eye on things, but because the page is so busy anything that's not suitable will only be seen for a few minutes before it's replaced by another image.

damu said it's very super code but pls change the picture for ur example sit if it's having means cant able to open publicaly

Graham said Dallas, the "gim=1" on the end of the URL is passing a parameter in as if it was a form that had been completed - the variable will get st in the $_GET and $_REQUEST superglobals. Our "Rank and Review" system isn't best suited for technical questions such as this - we've an interactive forum at http://www.opentalk.org.uk where we can (and do) help people with questions on scripts such as this one.

Dallas said Hi, I just have one question... I'm not familiar with using your method of inserting the image data into the page: if ($_REQUEST[gim] == 1) { header("Content-type: image/jpeg"); print $bytes; exit (); } and img src=?gim=1 width=144 Do you have any references to using this method for inserting variables? Is there another way to insert the image without checking? Say if I want to print it in the page every time it loads? Thanks, D!

Graham Ellis said Yes, Josh - there is a (very slight) chance of there being a problem with latest.img on a very high use site. The script is written as it is to keep it straightforward for most people / applications. On a very high use site ... (a) use a function such as uniqid to generate a unique file name for the temporary file, (b) put the temporary file into a directory that's away from the document room at web server writeable and (c) use the unlink function to delete the temporary file after you've written it to the database.

Josh said This is a great little script that I got successfully running with only a small amount of frustration. Only one question: Is there any chance that on a high traffic site, the latest.img file and database placement could display or store the wrong image?

XSwebbX said Excellent, this is a brilliant example and has pointed me in the right direction! Great one. I'm just going to make some scripts so users can upload pics on my own project/website.

Graham said Wow - this page is busy! I've just looked at the "stats" and it's had 274 hits in the last 24 hours. The database of images that I reset every couple of week has 900 images in it .... looks like it works for most people, even if it's failing for poor old 'Anon'

Graham said This script is dependant on you having PHP and MySQL available on your domain, and on you modifying the script to include your login details when you install in there. If it doesn't work for you, please read and check the list of pre-requisites and configurations carefully, and if that doesn't solve it for you please use our forum for help.

Anon said Aw gee, another non-working image uploader. 0 bytes in the image field. Gracias

Kerry said Brilliant! been trying to figure out how to upload images for ages! Massive thanks!!

Anonymous said Finally, a concise, bare-bones and easy to understand instruction on how to get an image into and out of a blob. Thank you!

Jesus said Excellent example, for somebody that is learning PHP and Mysql like me...this script has saved me a lot of time. I've been for a week working in how to save pictures in a Mysql database, and this program works great. I already modify the size of the pictures and is working fine.

Anon said Quick question on your coding. Im trying to make it add another value into another field in the PIX table.. ive been trying to code for many hours and just cant understand where it gets the information fromthe form into the database.. if you could just explain quickly.. thank you

Adam Best said Great script - I've been looking for ages for one that works like this. Is it possible to edit the script so I can upload PDF's? That would be the ultimate solution for me! Thanks for your help

tim0fee said Hiya & thanks for sharing this knowledge! Just found this tutorial - but I can't get the code to work on my local Apache/MySQL set up (even when I insert my correct login details for the database etc.) All I am doing is copy/pasting the above code into a new file (foo.php) and dropping it into my server root folder. All I get is a blank page returned! :( Any hints available please ? - I'd love to get it working

Jo said I would just like to say a big thank you for this code. I have been trying to add images to mysql for the last few days and this is the first one I have found that works! Thanks.

Reviews for http://www.wellho.net/solutions/perl-parrot-perl-s-new-virtual-machine.html

Reviews for http://www.wellho.net/solutions/mysql-left-joins-to-link-three-or-more-tables.html

David Bernard said I really appreciated your article. I'm using a MySQL database to run the queries for my master's thesis. I didn't exactly use your technique, but you pointed me in the right direction (as is often the case with Internet articles).

Peter said Thanks for a very clear and to the point article. Just what I needed. Great

Aditya Menon said Many thanks for the article Ellis, like others said, it has helped me add to my repository of MySQL Awesomeness. I have a suggestion to make - could you please edit the column names so they make more sense? building_id is better than bid, for example... I know that might make it bit more tedious to type and maintain, and I also realize you can't complain when you're eating it free, but I'm sure you'd give it a thought :)

David Ryder said Thanks! This piece taught me how to do a 3+ table join. Actually pretty easy after you write a couple queries. On to more advanced topics! :)

Graham said On "three letter acronymns" ... there's something of a compromise between keeping the code reasonably short so that you can see the structure, and including very long and descripting names to help those who's mother tongue perhaps isn't English. As we train in English, my target market for articles here has to be people who are fluent in that language, and I'm not going to obfurscate the pattern of the code by pumping up the comments to help a wider market that we can't practically service.

Anon said The guide itself is pretty straight forward but really, these three letter abbreviations are slightly hard to follow.

fandhie said very helpful.. after I tried many tutorial to joining 3 tables from several website I finally found this one and it solves my problem :) so many thank you

Anon delivers said This article finally made me understand SQL Joins! Thanks a lot :)

Reviews for http://www.wellho.net/solutions/java-regular-expressions-in-java.html

Anon said Thank you! Very straigth to the point and with usefull and real examples.

Robin Hodson said Trainwest now runs in mid April, from 2010 to (in theory) 2015 (at least). This is to avoid clashes with other Shows (so now it clashes with different other Shows).

cheryldecarteret@hotmail.co.uk said have just had good meal at west end,BUT my friend had the biggest hair on her meal.When she complained,the waitress took it away,and brought the same steak back,when my friend commented,the waitress said ""its ok we took the hair off"" I must say although i do like the west end,the kitchen staff have long hair ,no hats,and there whites are not always that white,sorry

Anon said just come back from a meal at the west end,meal was first class, But ladies was out of order AGAIN,gents was out of order AGAIN, and every one male ond femail had to use the disabilty toilet,not good,and this is not a one off,

Anon said I am a regular at the hungry horse "west end" melksham wilts,along with my friends.The food is very good,The staff are first class.BUT it is in need of a up date badly,And the heating,or lack of it is a big issue,The radiators are always cold,people are always complaining to no avail,This could be a first class hungry horse, with a bit of T.L.C'/

Graham Ellis said Yes, this is a page on PHP so it doesn't say much about Javascript ;-). Actually, we specialise in server side languages so we don't heva much Javascript here and we're too thinly spread to add another quiz and do all that would go with that. But my suggested link will take you to a few other Javascript resources that we have!

shobha said I found their was no word on JavaScript;which is used for validation and also for client side process of work.pls do new link on javascript and also set a quiz on javascript

Graham said All our friends ask us how the "Well House Manor" project is going; I've started this section in our resources index to pull together all the posts on this topic, to one side from all the information that future customers will want to see.

Graham said Should we use a geographic number, or a special number such as one that starts 0845 (locall) or 0870 (national rate) in our publicity / to get customers to call us? We've chosen to offer both the geographic number and the locall numbers to web site visitors from the UK so that they can select the rate that's best for them. We are NOT offering an 0870 number even though many businesses do so. Originally described as "National Rate" numbers with the intent that callers would pay the same as a long distance call within the UK, they're often more expensive to call now if you've got a BT discount package or if you're with another telephone company - accoring to the Daily Telegraph of yesterday, it costs an extra 36% on the BT OptionOne tarriff, for example. The other reason that we don't offer 0870 numbers is that they're like premium rate numbers in some ways - if you call them, part of the cost of your call is paid to the company you're calling. We have no wish to take part in a scheme where we would actually make money if have to put you on hold ....

Stupidscript said Nice. I appreciate Apache Rewrite, but I needed more flexibility in the resource name being requested, and this fits the bill perfectly. Thanks.

Anon said i think it would be great if you use the google search engine with curl because some link can be reach with that script because the connection from our dns will forward to ISP link :(

Anon said I was really struggling with overloading operators. Your source code example was clear and easy to follow and cleared things up for me. Thanks.

Tom said Thanks for all of the great information on the BMI Calculator. I have been using an online <a href="http://www.fitclick.com/BMI_calculator">BMI calculator</a> from a weight loss website called http://www.FitClick.com. The BMI calculator is a great way to calculate your body mass and percentage of fat and jump start your workouts to lower your body fat and/or increase your muscle size. Breaking it down for people looking to enhance their weight loss is a great idea; it helps me comprehend the topic a little better (which is good right?) Thanks for your community contribution, I appreciate it :D Tom

Christian said it would be nice to give more good examples at the bottom, which special characters would cause the least problems (unwanted side effects), which you might want to use instead of /, I guess e.g. ! ~ = : < > , thanks

Rig said could you please explain the difference between: [[:space:]] [[.space.]] [[=space=]] [[space]] Many Thanks!! -Rig

Yahya Abdal-Aziz said Mostly excellent; however, I see these potential problems for new regex users: 1. Is space a literal character i.e. matching "[ ]" or some special character e.g. "\x" ? 2. What do you mean by "a word boundary"? 3. If counts "apply to previous element", what defines, bounds or marks an element? 4. You write: "Add a ? after any count to turn it sparse". Would that be, e.g., "{4,8?}" or "{4,8}?" ?

Anon said helouuuu, php is not a programing language, have u ever heard of server-side scripts?

Graham said Yes - because I have no element preceeding the quoted regular expression on that particular question, the 2 or 3 letters could be preceeded by other letters as you state, thus making it "2 or more letters". Noted, question updated. Thanks for the inputs

Anon said This is true, the proper answer would be the one chosen. If the question stated [a-z]{2,3,}$ then the said correct answer would be the choice.

curtis said Thorough, well-planned PHP quizes! I found one question in the intermediate quiz which said I was wrong, when, indeed, I was not: The regular expression [a-z]{2,3}$ will only match YOU WERE INCORRECT The answer you gave: any string that ends with 2 or 3 lower case letters Correct Answer: any string that ends with 2 or more lower case letters [a-z]{2,3} will match only 2 or 3 lower case letters at the end of a string, not 2 or more.

Drakosha said You've probably put 2 and 2 together already (a couple of 404 errors and a visit to this wonderful feedback form from the same IP within a minute), but in case the analysis doesn't go that deep, I'll point out that the statistics picture here, as well as its mates on http://www.wellho.net/resources/accesspie.html, are 404-ed. The Copyscape logo on http://www.wellho.net/mouth/1970_Plagarism-who-is-copying-my-pages-.html doesn't show up either, but with an image address of http://www.wellho.net/mouth/%5C%22http://www.wellho.net/images/cs-gy-88x31.gif%5C%22 I would be surprised if it would ;) Since I'am here anyway, a bit of fan-lettering is in order. It's an incredibly nice website you have made, one that makes me wish there was a "No related articles" switch to stop the endless wandering over the categories =)

Anon said I spent two days having some one on one training from Graham and it was revolutionary to my work. You could probably hear the metaphorical pennies dropping! Brilliant stuff, really well delivered at the right pace in wonderful settings. I would recommend Well House for Perl training (and accommodation/meeting facilities) wholeheartedly.

Graham said Emil, thanks for your comment - but I do not agree. In most code, $_[0] and @_[0] will work equally well - but @_[0] is a list slice of one element and $_[0] is the specific scalar member so using @ is a little less efficient and also - on occasions - can lead to a different context being used and the results changing to the NUMBER of elements in a slice ... "1" !!

Emil Stanchev said In the second example, $_ should be @_. Like $_[0] -> @_[0] $_[1] -> $_[1].

Reviews for http://www.wellho.net/mouth/959_It-s-the-1st-not-the-1nd-1rd-or-1th-.html

Graham Ellis said I re-tested the code (which, as even, was copied and pasted from a working example) and it worked fine for me. If the inputs are floats, then the division won't give a zero remainder, and I suspect that's what happened. Perhaps you have highlighted a problem in Ironpython or Jython, but without a name (just "anon"), I can't help sort it out with you

Anon said It does not work correctly. See below: >>> somehow(12) 'nd' >>> somehow(13) 'rd' >>> somehow(33) 'rd' >>> somehow(2) 'nd' >>> somehow(2) 'nd' >>> somehow(1) 'st' >>> somehow(10) 'th' >>> somehow(11) 'st' >>>

Reviews for http://www.wellho.net/mouth/937_Display-an-image-from-a-MySQL-database-in-a-web-page-via-PHP.html

Reviews for http://www.wellho.net/mouth/802_undefined-reference-to-typeinfo-C-error-message.html

Jonas Baeklund said Had exactly the same problem, with an abstract class, one method missed the =0

Anon said You just saved me a lot of time with this page! It was indeed an obscure error message and I appreciate your clear and helpful explanation about what I needed to fix. [Also, your mentioning how weird the error message itself seems made me feel less foolish about having no idea what it was trying to tell me!] Many thanks.

Reviews for http://www.wellho.net/mouth/5_Driving-in-the-UK-for-new-arrivals-from-the-USA.html

Reviews for http://www.wellho.net/mouth/588_Changing-INC-where-Perl-loads-its-modules.html

Lael Daire said I wanted to have my main program in a base directory, and the modules in a subdir. Based off your example, I ended up making this: BEGIN { @cmd = split(/\//,$0); # gets the program path pop @cmd; # strips the program name $libpath = join("\/",@cmd)."/modulelib"; # appends module subdirectory unshift(@INC,$libpath); # puts modulelib as the first directory to search } It worked nicely in my ActivePerl environment and AIX environment.

Reviews for http://www.wellho.net/mouth/477_Class-static-and-unbound-variables.html

Anon said I suppose that the sentence "Type B methods, then, may be known as Object methods as they apply to an individual object, ..." should in fact be "Type A methods, then, may be known as Object methods as they apply to an individual object, ..."

Reviews for http://www.wellho.net/mouth/3309_Tipping-Policy-Well-House-Manor.html

Anon said I've found a good tipping policy for hotel rooms is to tip daily - in the US a few dollars left in the bathroom sink with a note "TIP" works - as the maids often change and don't clean the same room daily. This way is fair, and also obvious to the staff.

Reviews for http://www.wellho.net/mouth/3047_What-is-a-universal-superclass-Java-Perl-Python-Other-OO-languages.html

Graham Ellis said Yes ... my error. I said "all" when I should not have done so, as the interitance from a standard base class does not apply in C++. C++ is rather different to the other OO languages we run courses on, as it's what I would describe as a low level language with an OO layer added on top of it.

Anon said "In any object oriented language, all objects will ultimately inherit from a base class supplied with the language, whether it's explicitly stated or not." Wrong. C++ does not do this.

Reviews for http://www.wellho.net/mouth/2933_Bath-Melksham-Devizes-buses-from-September.html

Anon said Hello ! Just to let you know that Faresaver originally split the X72 Bath- Devizes and the X71 'Lavington loop', partly so as to understand how poorly used the loop is (according to Firstbus). However, after 2 days of operation, it became apparent that, what with the roadworks in Bath(London Road) and Melksham (Market Place) the connections between buses were becoming alomst impossible to guarantee. It also became apparent that loadings were higher than expected, even on the loop. Therefore since Wednesday 8th Sept 2010, the buses have reverted to a through service combining the X72 and X71, utilising full size single deck low floor vehicles as opposed the 'midibus' originally intended for the loop. Hope this is of interest.

Reviews for http://www.wellho.net/mouth/2903_Bath-to-Devizes-bus-via-Melksham-changing-again-in-September.html

Anon said Faresaver have an X72 timeable effective 5th september 2010 on their web page. Extra service in the morning and evening competing with current first timebale.note that the last bus to Devizes appear a request only past Bowerhill.

Reviews for http://www.wellho.net/mouth/2895_Global-Computer-Maintenance-Department.html

Anon said HAHAHA. I've been called twice by them. This time I let them off easy. Last time I groomed the lady by calling her flirty names, like baby and honeymuffin, and eventually kept telling her that I love her, but alas, our love could never be. This went on for about 30 minutes. I did record some of the quack hackery for lulz.

Anon said They had called me and said the same stuff but also told me they weren't selling a product, etc. But when they asked me what kind of operating system I had, and I Mac OX S, they were caught off guard. Then I got this whole "well we are so sorry, wrong reporting, blah blah." Thank you for your post, I was able to see what you had said while I was talking to them.

Anon said In Australia and these people call me at least once a week and i have told them to Stick it in their A**

Jo said I just got a call today (one a couple of weeks ago but fobbed it off) this time i thought i would have a game, asked him to call back in an hour as i was "worried" but had to deal with children at present. Knew it would have to be a scam and thought I would get as many of HIS personal details as i could before letting on I knew what it was all about. Funny though, I was saying ahuh etc while pretending to follow instructions as we have a MAC HAH! So then I told him.

Brenda Davison said Yes, they have tried this on with me too, in the UK. Three calls this week and the first time they really had me believing they were Microsoft, but I'm not daft enough to hand over personal details, let alone money to some person who phones me up out of the blue.

Reviews for http://www.wellho.net/mouth/279_Getting-a-list-of-unique-values-from-a-MySQL-column.html

Colin said Havent seen your site crop up in sql searches for years. I this page found searching for a solution to a slightly different problem: I need a list of unique values AND an id. Any id will do. First or last. So how from your table: How to return the distinct destination along with a `tid` Pick a tid, any tid? stackoverflow has a similar prob. I give link. My col I want unique has some heavy calcs so am trying to avoid multi selects and joins as far as poss.

Reviews for http://www.wellho.net/mouth/2765_Running-operating-system-commands-from-your-Python-program.html

from India said Your website and articles are one of the best I have seen in on the internet. Thank you so much for putting forth these write-ups of so many complex Python topics in a very easy to understand manner.

Jackie said For more information about Melksham Scouts visit www.Melksham-scouts.org.uk

Reviews for http://www.wellho.net/mouth/2690_The-World-Company-Register-is-it-another-scam-.html

Atit said Ive already registered with dem & yes they are sending me letters requesting payments. Wat shud i do?

Patrick Nolan said World Business Guide aka World Company Register is now Europe Business Guide, with a site "Ebg-2011.net". They sent me a .PDF from a "email5@3ebg2011.net" with reference to email "register@ebg-2011.com" and a fax number listed as "+31 (20) 524-8107" - here's a copy of the text: From: "Sophie Grand" <email5@3ebg2011.net> To: <recipient> Subject: World Company Register 2011-2012 Date: Wed, 23 Mar 2011 09:49:48 -0400 Ladies and Gentlemen. In order to have your company inserted in the registry of World Businesses for 2011/2012 edition, please print, complete and submit the attached form (PDF file) to the following address: Europe Business Guide P.O. BOX 2021 3500 GA, UTRECHT THE NETHERLANDS

Julia said Thank you very much for information! received precise this letter with blue form you show, started to read the text, but it was all in CAPS, dropped on the 3rd line, but sensed something fishy and went to google, fund your site, read, went back to read the whole text in CAPS and Yes! there is price there 995 euro/year instead of advertised "free of charge". Best luck to you in your honorable work!

sal said yaa becareful of using such a company, it charges 1500. its all in the small print. Also recently there has been lots of scams from china about domain name

David said Those guys aren't registered in AGPD (www.agpd.es) where every electronic file in Spain must to be registered. Otherly, their domains are used only for 1 year. Nobody buys a dotcom domain for only twelve months... if they aren't using it for scams, fake pharmacies, phishings, etc etc etc Domain Name.......... worldcompanyregister.com Registration Date.... 2010-03-03 12:47:29 Expiry Date.......... 2011-03-03 12:47:29 Domain Name: THEWCR.COM Created on: 19-JUL-10 Expires on: 19-JUL-11

Anon said Hehe...i actually sent them an email and asked them to forward me 995 euros and in return i'd put a link to their page on mine...didn't recieve any reply nor money yet tho...still waiting=)

Prestige Car Hire said dont use the work company register they are a conn, when you sign and dont pay they will start to send you legal letter requesting payment etc.

Camilla said Here we are talking about criminals, they now use World Company Directory, previously known under the following names.: World Business Guide, World Business Directory and many more. So beware to join this directory

Anon said The application has to be programmed for a cluster as well: All your session attributes must implement java.io.Serializable Make sure your web.xml has the <distributable/> element or set at your <Context distributable="true" />

Reviews for http://www.wellho.net/mouth/2398_Websitemediasolution-and-a-goldfish-called-Carl-Johnson.html

Anon said "Carl Johnson" also advertised Island Designs for a period of time. It was a pseudonym used by the owner for "marketing" his company. The actual name of the company was Designer Island and is now known as Peanut Media. The owner of the company used to outsource what he called "lead generation" (otherwise known as unsolicited emails). I have had experience with these companies and was extremely unimpressed (or in other words, completely ripped off), as I believe many others have been. Just thought I'd post a little warning in the hope that anyone thinking of going with this company, know to avoid at all costs!

Reviews for http://www.wellho.net/mouth/1878_Pascals-Triangle-in-Python-and-Java.html

Reviews for http://www.wellho.net/mouth/1690_Conversion-of-c-r-line-ends-to-l-f-line-ends.html

Anon said AFAIK line ends are terminated with both CR AND LF on win platforms :)

Reviews for http://www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html

Ilan said It is a common mistake to think that there is no difference putting the conditions in the ON clause and the WHERE clause. well, there is a big difference. The following post explains it with examples: http://www.mysqldiary.com/mysql-left-join/

v said Thanks, I learned here after review of many different reference else ware... simple but solid, I will use this in my site... thanks

happy_visitor said Thanks for this. I've been to a few pages trying to wrap my mind around joins and you finally cleared up the one thing that was confusing me. In less words too. Short and simple. Much appreciation.

Demon said Excellent work guys. There also another good website about the select statement http://apachejava.blogspot.com/2010/09/select-second-highest-3rd-4th-highest.html visit it.

Nafees said I have got what i have been looking for...very well explained...thanks

varunkumar said Its very good data which makes things clear about LEFT & RIGHT Join..But only one thing that reduced my rating from 5 to 4 is missing of enough detail regarding INNER & OUTER Joins.

Dhawal said thanks a lot sir, for posting this article.... you does a great job ....

Rahul Dhawan said This is the best example that i have ever read, now joins are really clear in my mind,,thank you very much

sachin negi said hey!! thanks , for the information. now LEFT AND RIGHT join is clear in my mind. this is really very helpful .

Andy said Oh, thank you, thank you. I've been struggling with a left join for... like forever, and your clear example just cracked it!

Yogesh said this is very simple and it cleared all doubts about joins like difference left and left outer join. It's simply gr8 example.

Sunny said I really got helped. These are pure basics of joining which are base of database.

Chaitra Yale said Very nice examples and explanation of Mysql joins. "An INNER JOIN does a full join, just like the first example" regarding your above statement I'm not sure if inner join is same as full join. If you do a full join on the 2 tables the result set will have all the rows from the first table and all the rows from the second table. If there are rows in "demo_people" that do not have matches in "demo_property", or if there are rows in "demo_property" that do not have matches in "demo_people", those rows will be listed as well. However, I also think that the missing feature of FULL OUTER JOIN is a real drawback to MySQL. but from MySQL 4 on you can use a workaround using the UNION. for example if you take the left and right joins examples above and do a UNION on the 2 select statements you will get a FULL JOIN. mysql> select name, phone, selling from demo_people left join demo_property on demo_people.pid = demo_property.pid UNION select name, phone, selling from demo_people right join demo_property on demo_people.pid = demo_property.pid; Thanks Chaitra Yale

saptarshi said Very commendable work . Excellent. Should there be a little more discussion on outer join and inner join, it would had been better .

Sean said Exactly what I was looking for! Saved me pulling the rest of my hair out. Many many thanks!

Nadia said you have made me clear the concepts of join which i never understood during database studies ... thanks a lot and you have saved me from many embarrasing moments to come

Anon said i appreciate the way it has been specified the diference between the left join and right join

Sev said You covered most of the stuff correctly, but you messed up around the bottom. You oversimplify techniques that could cause someone to confuse things going forward.

rea said this is a great tutorial. It's not that complicated but very useful. Amazing.

manu said simple but effective .thanx a lot ,with a single glance i understood about joins..

Manju said Can u give any example where i can retrieve all the records of a table "users" where there are no corresponding records in other table "user_role"

Ankur said good tips are given.it can be more better if there is an example that consider all column in both the table

Suchi said Great and powerful article that explains joins in a simple but easy manner.

Matt said I believe your comment, "An INNER JOIN does a full join" is incorrect. FULL JOIN is short for FULL OUTER JOIN which is not the same as INNER JOIN.

RAjesh said There are no words also in english to praise. It was simply superb and extraordinary.

Anon said I'm glad it's not just me that has struggled understanding join vs left vs right join, even more glad you have written such a simple explanation for us all! :)

Narendra said But my question is "where is the use of left and right join .........any scenario"

Chris Hayes said This is the first article I have read that explains joins clearly! Short and concise, great article! -Chris

Anon said This should be in the MySQL comments section of the handbook. I knew joins should be easy, but most of the examples I saw were more complicated than they need to be. Please add this to the mysql handbook comments.

Atomic AlienZ said The best explanation of JOINs I've ever seen. Thank you it was most helpful=)

Anon said Is the outer join really needed. I mean we can get better results by using " NOT IN".

Saidul Islam said I've read many article but i cudn't understand the SQL JOIN. But this article takes 2 minute to teach me that. Nice article... Thanks to author.

Mohiuddin Khan Inamdar said Nice One ...... good effort to help out others.. just landed here because of exclusion queries.. from google have a look at this page too. http://r937.com/list.cfm?page=sql-articles regards Mohnkhan

Rashid Ali said ITs just a great artical to uderstand the JOINS in SQL ... great work ... keep it up

Sameer said Nobody can clear JOINS as this manual has done. It is SUPERB.. Thanks. It helped me a lot to understand. I will appreciate if you can make much clear to the INNER AND SELF JOINS.

kj said No one can explain with more simplicity than this. Any one who doesn't understands after reading this simple example can't ever understand. Really thanx a LOT

edw said I'm very pleased with your clear explanation. I'v seen some other examples but this one just hits it all. Directly! It made me understand.

Veejay said Its excellent, to the point and very clear. thanx a lot for this buddy.

Priya Saini said This is 'Simply' the best explaination. Concept of join always confused me... nw not any more

vellaidurai said this is one of best and very simple explanations and examples.do keep this..

Roman said Very good article which clears the things which were not clearly described in the manual. So it's a good example when developers can make something seem much more difficult than it actually is. I'm good in SQL, I've known about LEFT and RIGTH joins, but seeing INNER and OUTER JOINs I thought that there was still something that I didn't know! :-) So, there are actually just TWO types of join (having in mind that RIGHT JOIN is the same as LEFT, but with different table order): So we have ordinary JOIN, which is THE SAME as joining tables without JOIN keyword, but delimiting tables with commas and putting condition in WHERE clause (you can call it "implicit join"), so the example from the article will look this way: select name, phone, selling from demo_people, demo_property WHERE demo_people.pid = demo_property.pid; which returns only matching rows combinations from both tables, and we have LEFT JOIN, which always returns ALL rows from the first table, and if a row from the first table doesn't have any matching rows in the second, we get single resulting row with null values for all columns of second table. I prefer to use "implicit joins" instead of JOIN keyword when I need only matching rows, and to use LEFT JOINs when I need "NULL rows" to present in the result (if they exist of course), as it helps me to immediately see what type of query it is (as the difference is really important!) - completely different syntax does not give you a chance to confuse.

suresh said Simple and easy understandable examples. Thanks a lot. give examples for inner and outer joins also.

shawn said WOW THANKS FOR MAKING THIS SO SIMPLE. A lot of articles on these subjects are often overcomplicated.

justGrayWind said Просто и доступно :) Ура! Спасибо! Simple and to the point :) Hurray! Thanks!

Manish Jain said Very well defined clear and short description of Inner, Left and Right joins

Graham said The Accessibility link on the right of every page lets you select a larger or smaller font size, and it also lets you change the page colours. Regrettably, there is no single size / combinations that's ideal for everyone.

Chris said Thanks for all the information, I was quited puzzled about the differences before. Now it's all clear. :) One small tip: font-size is a little too small, it's hard to read sometimes.

Graham said Sasha, I'm aware that left joins are widely supported by databases, and right join is much less common. Indeed, right join was added after left join to MySQL and people running an ancient versions may find left words and right doesn't. I don't see that this makes any difference as far as the text on this page is concerned, though - it's a broad overview and helps a lot of people start to understand the difference - it creates "lighbulb moments" and if people need a lot more they can go on and read more in the thousands-of-pages long manual.

Sasha said Hi! In the MySQL reference written following: "RIGHT JOIN works analogously to LEFT JOIN. To keep code portable across databases, it is recommended that you use LEFT JOIN instead of RIGHT JOIN. " so, your examples are incorrect.

Grateful Anon said This is absolutely perfect - I was puzzling over joins today, not completely understanding what the difference was between INNER, LEFT and RIGHT. This page explained things so that a light bulb went on over my head the very first time I read it. Thank you!

Gert Cuppens said This was the page I've been looking for. It gave me the wanted information in a very brief manner, just what I needed.

Graham said Left, Right, Inner and outer joins in MySQL (and joins that don't use any of those words at all - and perhaps not even the word join) seem to be a cause of endless confusion. This page is one of the most visited on our website! "People who visit this page also visit our page on using LEFT JOIN to connect 3 or more tables" and you can get to that page through my suggested link on this comment

Reviews for http://www.wellho.net/mouth/1360_Asda-in-Melksham-Welcome-or-not-.html

Anon said most definitely welcome we need asda to come to melksham waitrose is a lovely new store which i shop in regulary better class of shopping but asda would be most welcome yes please asda

Reviews for http://www.wellho.net/mouth/1239_End-of-File-on-a-Java-BufferedReader.html

himJ said //another way to do it import java.io.*; class bufferedDemoInput{ public static void main(String arg[]){ int ch=0; //opens a file from the given unabsolute address; File tempFile=new File("/HIMANSHUJ/myFile.txt"); try{ BufferedReader filer=new BufferedReader(new FileReader(tempFile)); //create an inputstream to the opened file //detects end of file while( (ch=filer.read())!= -1) System.out.printf("%c",ch); } catch(FileNotFoundException e){ e.printStackTrace(System.err); } catch(IOException e){ e.printStackTrace(System.err); } } }

Bathroom Store said Hi, I was looking for current happenings in bathtubs industry whilst I came to know about your site, Horse Mouth has had impressive content to read that I spent nearly an hour and kept reading, informative posts and very useful blog and sweet horse mouth :) Regards, Jasmine

Sandu said Helped me in converting date format very easily.Thanks for providing simple and useful date conversion function.

Rutishauser said I agree with John. The bulk of time is spent on design and debugging, rather than on pressing keys on the keyboard. So, no matter what you are writing, a big complicated program or a couple of simple lines, strict typification is certainly of great help.

Reviews for http://www.wellho.net/forum/Writing-PHP/resize-image-before-saving-to-mysql-as-blob.html

Reviews for http://www.wellho.net/forum/Writing-PHP/removing-carriage-returns-line-feeds-line-breaks.html

Graham Ellis said I agree that ereg should be replaced by preg functions. Note that this page is a blog archive dating from six years ago .... I'm adding this note as an alert to people reading the page, rather than going back and altering history.

Interesting Articles said Avoid this at all costs. ereg() is depreciated and is being removed from php, use preg_match instead.

Reviews for http://www.wellho.net/forum/Writing-PHP/PHP-Form-Processing-Template.html

Reviews for http://www.wellho.net/forum/Writing-PHP/php-counter-for-web-pages.html

Reviews for http://www.wellho.net/forum/Writing-PHP/Passing-variables-from-page-to-page.html

Monica M. said I have put in my page this: include "client_proiect.php?idpers=".$row['id_persoana']; and I get this error: Warning: include(client_proiect.php?idpers=3) [function.include]: failed to open stream: No error in C:\wamp\www\linea-directa\indexx.php on line 34 Warning: include() [function.include]: Failed opening 'client_proiect.php?idpers=3' for inclusion (include_path='.;C:\php5\pear') in C:\wamp\www\linea-directa\indexx.php on line 34 That can I do? That I do wrong??

satheesh said good! i need a help on this topic! i have two tables, and i want to fetch the data like travel(2),sports(3),weather(0 ) like that in while condition i cant form a proper query to do that travel,sports are category_name from category table well values inside (num) is comes from tab2 which contains category_id if two records having category id 1 means i have to print category_name(count(category_id))

Reviews for http://www.wellho.net/forum/The-Tcl-programming-language/to-send-a-quot-enter-command-quot-to-the-device-through-Ex.html

Reviews for http://www.wellho.net/forum/The-Tcl-programming-language/sending-ctrl-z.html

Anon said You may need to entry CTRL-Z in your expect script using this combination: CTRL-V + CTRL-Z ,

Reviews for http://www.wellho.net/forum/The-Tcl-programming-language/invalid-command-name-else-error.html

Reviews for http://www.wellho.net/forum/The-Tcl-programming-language/help-with-redirectioning-output.html

Reviews for http://www.wellho.net/forum/The-Tcl-programming-language/expect-log-file.html

Reviews for http://www.wellho.net/forum/The-Tcl-programming-language/code-coverage-tool-for-tcl-tk.html

Miyur said Try coverity for coverage...alenatively you could use nagelfar for debugging tcl scripts.

Reviews for http://www.wellho.net/forum/Perl-Programming/Testing-if-a-variable-is-numeric.html

dpminusa said For a little more complete test for integers it may be a best to use: /^[+-]?\d+$/ otherwise values like 123abc test as numeric.

Reviews for http://www.wellho.net/forum/Perl-Programming/return-part-of-a-string-that-matches-a-pattern.html

Reviews for http://www.wellho.net/forum/Perl-Programming/New-line-characters-beware.html

Anon said some files i was working with had the new line return, other did not. this worked for both, thanks.

Reviews for http://www.wellho.net/forum/Perl-Programming/How-to-create-a-file-with-specific-date-and-time.html

Dhaval said I like it very much. And i have one problem in coding in PERL language. I want to display dat and time dynamically. 1) Tue: 1:00 PM to 2:00 PM EST 2) Fri 11:00AM to 12:00PM EST every month recurring. So for that what i have to do??

Reviews for http://www.wellho.net/forum/Perl-Programming/How-to-clean-up-week-old-log-files-using-perl.html

hari said Top quality stuff....conscise yet just easy to understand....hats off to the tutorial team. My request wuld be adding even more comments to the scripts you provide for download..it would be useful for begineers like me who cant afford a course such as this.

Alvise Valsecchi said The free download PDFs that you offer are top quality. I wish I could have downloaded more. If I were living in the UK I'd signed for your Java courses. In fact these days I am switching from Perl/CGI to J2EE. I have bought a few books, I am studying documentation from Sun, but I have found no as clear words as in your PDFs. Thanks. Regards.

Graham Ellis said James, Google is a somewhat blunt tool in looking for information and will often send you to a series of pages that don't match your exact requirement. In this case, our Java courses do include some coverage / mention of Ant but they're not fully BASED on Ant, and I'm sorry we can't offer you what you were looking for.

James Migue said I am interested in taking a Java course with a focus on ANT. Google sent me here but now that I'm here I have been frustrated in the extreme trying to find the information I am after I have given up

Graham Ellis said February 2005 - Currently training on Perl 5, but listening to the "bigwigs" talking Perl 6 so that we have no shocks when that comes along. Plans are in place for Perl 6 conversion training at the appropriate time

Graham Ellis said Feb 2005 - next week I'll be in Munich. I always enjoy training in Germany; please forllow the link with this message for a private on site course quite

Reviews for http://www.wellho.co.uk/mouth/3111_TransWilts-Link-Days-out-from-Swindon-to-Weymouth-.html

Mike said Graham, don't understand above, hopefully you can reply to my Query? Interested in booking 10 seats or more, from Melksham to Weymouth on 14th August return by Train, can you help me with price????

Teresa said My company also recently received an email from Suresh saying that "we typically integrate with new platforms very fast and is usually completed in a couple of weeks. We would like to partner with your company and explore the possibility of adding our product to your recommendations/offerings to your customer for mutual benefit. We quote a competitive price and you can add your own margins and offer it as an add-on product thus increasing revenue." Fortunately we saw where this was going!

Reviews for http://assethost01b.iterasi.net/93eb8c641fa6/43903a5e1b6e/71a356afdf53/5b10747fcce5/fd11378b-de57-41bb-9900-27ac2943ab80/71252338-0c60-49c1-8abf-3dc60d6faa4d-default.html

Satheesh kumar.C said From: satheesh i upload one image using the below coding....... also its uploaded in specified directory correctly.......But my doubt is after clicking the submit button the file should be upload as well as its path should store in database......After that we have to display the fields which is stored in database...... At that time the image should display....... Then put edit button.... if we click that button the image or fields should be edited....... how can i do this .... explain this and send the correct coding........ <form action="upload.php" method="post" enctype="multipart/form-data" > <label for="file"> File Name:</label> <input type="file" name="file" > <p> <input type="submit" name="submit" value="Submit"> </p> <p> <br> </p> </form> <?php if ((($_FILES["file"]["type"] == "image/gif") || ($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/png")) && ($_FILES["file"]["size"] < 200000)) { if ($_FILES["file"]["error"] > 0) { echo "Return Code: " . $_FILES["file"]["error"] . "<br />"; } else { echo "Upload: " . $_FILES["file"]["name"] . "<br />"; echo "Type: " . $_FILES["file"]["type"] . "<br />"; echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />"; echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />"; if (file_exists("upload/" . $_FILES["file"]["name"])) { echo $_FILES["file"]["name"] . " already exists. "; } else { move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . $_FILES["file"]["name"]); echo "Stored in: " . "upload/" . $_FILES["file"]["name"]; } } } ?> <form method="post"> <input type="submit" value="save"></form> <?php @extract($_POST); $con=mysql_connect("localhost","root",""); if(!$con) { die('could not connect:'.mysql_error()); } mysql_select_db("s1",$con); if(!mysql_query("INSERT INTO sathish VALUES ('$id','$file')",$con)) { die("not inserted".mysql_error()); } else echo "--"; mysql_close($con); ?>

Anon said Thank goodness for websites and links to this! You just saved me tears.

Training sample © 2012, WELL HOUSE CONSULTANTS LTD
This is http://www.wellho.net/demo/revinf.php
See source code here • More examples - same topic here
Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
Phone: +44 (0) 1225 708 225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net

Reviews of web pages ...