• Questions? (908) 864-7283

Goodbye Google Authorship

Goodbye Google Authorship


Just a few months ago we bid farewell to Google's Authorship Images from the search results, and with the new month of September we now bid adieu to Google displaying any Authorship data within their search results. Google's authorship support page, ... read more

PHP NG Enabled On All Rapid Purple Hosting Servers

PHP NG Enabled On All Rapid Purple Hosting Servers


Since I was already working on the PHP configurations for Rapid Purple Hosting servers, and since PHP NG has shown some tremendous performance gains, It seemed appropriate to enable it for developer use across all Rapid Purple Hosting servers. If ... read more

PHP 5.6.0 Released & Installed on Rapid Purple Hosting Servers

PHP 5.6.0 Released & Installed on Rapid Purple Hosting Servers


Just before the weekend the PHP team announced the official release of PHP 5.6.0. The new version brings about a slew of awesome new features with it, and some of you have already taken advantage of them through the early ... read more

Twitter Analytics is Here for Everyone!

Twitter Analytics is Here for Everyone!


Its been a quiet weekend here at the Rapid Purple blog as we all celebrated Labor Day - however with that said these past few days have also been extremely busy in the tech world. For starters Twitter announced the ... read more

Invalid SSL Certificates Will Still Provide Google Ranking Boost

Invalid SSL Certificates Will Still Provide Google Ranking Boost


Earlier on this month Google announced that SSL-secured websites will receive a small ranking boost. Since then I have even converted the majority of Rapid Purple to run over an HTTPS connection. If you've been going through the conversion process yourself ... read more

Weekly Post Roundup 8/16/2014 - 8/22/2014

Weekly Post Roundup 8/16/2014 - 8/22/2014


Discounts & Coupons HostGator's Smoke The Competition Sale Is Live! Internet News Warning: Beware Of Fake GoDaddy Emails Introducing The Bing Image Widget Marketing News 2 Weeks Left To Make The Most Of Your eCig Related Google Adwords ... 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.