• Questions? (908) 864-7283

Bing Explains How They Deal With Keyword Stuffing URLs

Bing Explains How They Deal With Keyword Stuffing URLs


In a post on the Bing Webmaster Blog Bing has dug into how exactly they deal with keyword stuffing URLs. There are a few main signals that Bing looks out for when determining whether URL keyword stuffing tactics are in-use ... read more

HostDime Partners With BitPay to Accept Bitcoin Payments

HostDime Partners With BitPay to Accept Bitcoin Payments


Bitcoin continues to make quiet the splash in the hosting and technology community as yet another hosting company, HostDime, announces their acceptance of Bitcoins as payment for their cloud hosting and datacenter services. HostDime is kicking things off with their ... read more

IBM Brings Data Analysts To Small Businesses

IBM Brings Data Analysts To Small Businesses


Being able to truly analyze your businesses data was something that most small businesses simply never had the ability to do. Chances are you, the business owner, simply has no time left to sit there and draw out graphs and plot ... read more

123-Reg & Minds + Machines Join Forces to Promote .LONDON

123-Reg & Minds + Machines Join Forces to Promote .LONDON


UK domain registrars 123-reg.co.uk and Minds + Machines announced a collaborative effort to increase awareness and adoption of the new .london TLD late last week. The collaboration will include a range of on and offline marketing initiatives. According to 123-reg.co-uk, registrations of .london surged on ... read more

Yelp Wins Court Ruling To Move Up Negative Reviews

Yelp Wins Court Ruling To Move Up Negative Reviews


There's always been talk among business owners of the "grey-area" around Yelp purposely placing negative reviews on non-paying merchant profiles. Unfortunately this did actually happen, and some business owners did actually sue Yelp - and in the end the court ... read more

Please Stop Panicking, Your Internet Is Fine - It's Simply Internet Slowdown Day

Please Stop Panicking, Your Internet Is Fine - It's Simply Internet Slowdown Day


A wide array of your favorite sites have come together today to participate in Internet Slowdown Day - an internet protest against net neutrality's proposed changes. According ... read more



PHP/MySQL File Upload – Error Checking

Posted on by Michael Boguslavskiy in | 2 Comments
Tags: , ,

A while back I had written a PHP/MySQL tutorial discussing how to upload an image to your server, and store the information about that uploaded image into your MySQL database. That tutorial covered really only the basics, and I knew that eventually someone would post a comment asking about some more advanced features – such as limiting the file size of uploaded images, as requested by Evaleen Tan. So this tutorial aims to expand upon the basic file upload functionality that was discussed previously and introduce various error checking features for file size, and file types, etc.

Now, let’s quickly recap where we left off in the last tutorial. We have built our basic HTML form, which requests for the users username, password, and provides an avatar upload field. This information then gets stored into a MySQL directory. So here is our final submit.php file:

 $dbuser = "mysql_username";
 $dbpass = "mysql_password";
 $dbhost = "localhost";
 $db = "db_name";
 mysql_connect($dbhost, $dbuser, $dbpass);
 mysql_select_db($db);
 $username= trim($_POST['username']);
 $password= trim($_POST['password']);
 $avatar=($_FILES['avatar']['name']);
 $target = "avatars/";
 $target = $target . basename( $_FILES['avatar']['name']);
$results = mysql_query("INSERT INTO `users` VALUES ('','$username', '$password', '$avatar')");
if(move_uploaded_file($_FILES['avatar']['tmp_name'], $target))
 {
  echo "The image ". basename( $_FILES['uploadedfile']['name']). " has been uploaded.";
  echo "<center><img alt="" src="avatars/$avatar" /></center>"
 } 
else 
 { 
echo "Sorry, there was a problem uploading your venue photo file."; 
 } 
if ($results) { 
echo "New User Has Been Added!"; 
} 
mysql_close();

So the first thing we want to add to our submit.php file are a few setting options to limit what types of files we want uploaded, and how large we want them to be. We do this by an array of extensions for our file types, and a variable  that stores the maximum allowed size of any uploaded file (in bytes).

  
$allowed_filetypes = array('.jpg','.gif','.bmp','.png'); // These will be the types of file that will pass the validation.
$max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB).

(more…)

1&1 Discontinues MySQL 4 Databases

Posted on by Michael Boguslavskiy in | Leave a comment
Tags: , , ,

Hosting provider 1&1 is “deactivating” MySQL 4 databases starting on May 1st, 2013. All WordPress sites hosted with 1&1 that have not migrated their databases from the old database to the new MySQL 5 databases may have their sites go offline, however 1&1 doesn’t explicitly say the sites will go down. If you host a database driven site on 1and1.com, log in, go to MySQL Administration and check what version of MySQL your site is using.

To quote directly from the 1&1 announcement:

The information below applies only to Linux Hosting packages with MySQL 4 databases. MySQL 4 is being phased out and therefore any data held within a MySQL 4 database must be migrated into a new MySQL 5 database.

Why is the migration not done automatically?
The migration can not be carried out automatically because of some features of MySQL 4 are not supported in MySQL 5 and in order to minimize the amount of transmission and handling of your private data. Because of this we are allowing customers to carry out the migration on their own, at their leisure.

How do I know if my databases are affected?
Any database created in the 1&1 Control Panel that says MySQL 4 as the version, will need to be migrated to a newly created MySQL 5 database. You can check what version of MySQL your databases are by logging into your 1&1 Control Panel and clicking on MySQL Administration from the Domains & Web Space section.

Full instructions on upgrading your MySQL version on your 1&1 hosting account can be found here: http://faq.1and1.com/web_space__access/mysql/20.html

SQL Injections – A Powerpoint Presentation

Posted on by Michael Boguslavskiy in | Leave a comment
Tags: , ,

If you haven’t noticed more and more web-related services have been getting hacked lately – and these aren’t small websites either. Infragard – an FBI affiliate, the CIA website and the FBI’s Detroit phone network, the threats and attacks on Unveillance, and ofcourse who can forget the Sony hacking that has went on. What the news fails to mention is how often hacking attemps happen for the little guys as-well. Your local pizzeria’s website that has a mailing list, your photography website that has a backend of clients information. I was thinking about this on my drive in to work this morning – well to be honest while I was standing in traffic and I remembered a presentation a friend of mine sent me a short while back about SQL Injections. It was originally a school project but it has some great information that everyone developing or managing a website should be aware of.

SQL Injection by Vadim Gellerman

Sign Up To Our Newsletter

  • Stay Updated With All The Latest Webmaster News
  • Be The First To Hear Of New Hosting & Domain Name Coupons & Sales
  • Get Exclusive Webmaster Freebies

Sign up today and I'll send you a free gift!

Stay Connected With Us

Stay in touch with us by following us on Facebook, Twitter, and Google+. There's always plenty of new articles being shared that you won't find within the Rapid Purple blog.