How to find a Good Laptop?

Having trouble on finding what Laptop suits your needs?
No worries, we have it covered for you.
Click the image below to get the full details.

By Request from Connor McGregor Fans

By Request from www.facebook.com/connortherealdeal
Courtesy of www.BJPenn.com

Deleting a record in PHP MySQL

Note that you need to have a table named "tbl_employees".

Creating a 2D Character for a Unity Game

You may download the softwares by clicking the links below

Crazy Talk
Texture Packer

Inserting data into a Table on PHP MySQL

Note that you need to create a table named "tbl_employees" for this to work

Creating a table in PHP Mysql

Basics in creating a table on PHP Mysql

Latest Gadgets of 2015

For the GADGET Savvy people
Here are some of the highlights on CES 2015

How to Format and Install Windows 7 PC / Laptop

View Full, Detailed and Step by Step Tutorial on how to Install Windows 7 on your PC / Laptop

CSS Text Shadows

Click HERE or the IMAGE to get the full tutorial.

Intel's "Make it Wearable" Grand Prize winner - Nixie

CSS Positioning

Click HERE to view the complete video

Viruses that hides your files on your Flashdrive or USB?

Problems with your USB flashdisk which keeps on hiding your files
when you insert it on someone's PC?

Here are some of the steps to help you solve your worries.
1. Click the Start Menu
2. Type Run (for Windows 7 and Windows 8/8.1 versions)
3. Type CMD
4. Once a new dialog window will appear, type the instructions as stated on the image below.

5. Add your drive letter after /d (e.g. attrib -s -h -r /s /d F:/*.*)
Where F:/*.* is your drive letter.
6. Hit your Enter key and you're done !!!

Unity 3D Game Tutorials Complete (Basic Roll-a-Ball)

Click HERE to view the full tutorials.

Boost your Internet Connection Speed and PC Performance!

If you wish to boost your internet connection and your pc's performance,
the steps below might be helpful

1. Click the Start Menu (for Windows 7) and Windows Logo (for Windows 8)
2. Type "Services.msc" (without the quotes)
3. Hit Enter

On the new Dialog Box,
Disable / Stop the following Services:
1. Windows Update
2. Windows Defender (if you have an Antivirus Software installed)
3. Windows Firewall
4. Background Intelligent Transfers

Hit Ok and Apply.

Make your PC or Laptop Start faster

Click the Start Menu > Run > MSConfig >

On the Startup Tab, Uncheck all the unnecessary Startup Items
Click Ok and Apply

Best Android Launcher replacement app ?

Ever wondered what's the best Android Launcher in the Market?
Well, one of them might be familiar to your ears.


Here are the "Big Three" on Android's Launcher Category based on Visuals

1. Buzz Launcher with Homepack Buzz - Ranked No.1 based on fluidity and designs.
2. SPB Shell 3D - The only 3D-based launcher among the three.
3. Go Launcher - The most popular android launcher replacement in google playstore.

Adobe Fireworks Basic Publishing Tutorial

Adobe Fireworks basic Publishing and Logo Making Tutorial Click on this Link or the Image below to view the tutorial.

Inserting data on tables

Inserting data on Tables
Be sure that you already have an Employee table as a sample before inserting this data

<?php $dbhost = 'localhost:3036'; $dbuser = 'root'; $dbpass = 'rootpassword'; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } $sql = 'INSERT INTO employee '. '(emp_name,emp_address, emp_salary, join_date) '. 'VALUES ( "guest", "XYZ", 2000, NOW() )'; mysql_select_db('test_db'); $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('Could not enter data: ' . mysql_error()); } echo "Entered data successfully\n"; mysql_close($conn); ?>

Dropping or Deleting Databases and Tables

To Drop / Delete a DATABASE or Table,  Use the following codes:

<?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully<br />'; $sql = 'DROP DATABASE my_database'; $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('Could not delete database: ' . mysql_error()); } echo "Database my_database deleted successfully\n"; mysql_close($conn); ?> - To Delete Tables in a Database Use the following codes: <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully<br />'; $sql = "DROP TABLE biodata"; mysql_select_db( 'my_database' ); $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('Could not delete table: ' . mysql_error()); } echo "Table deleted successfully\n"; mysql_close($conn); ?> -

Inserting SQL Queries in Xampp

The SQL tab in Xampp / PHPMyadmin can be used to write all the MYSQL supported queries.

 

Basic Logo Making in CorelDraw

Creating a Simple Vector Graphic Logo using CORELDRAW

Click on the image below to view the Step by Step Tutorial

Adobe Photoshop Basics

Click the image below or the text to view Basic PhotoshopTutorials

1. Basic Image Tracing
2. Basic Button-making

Creating a table in Xampp / PHPMyadmin

To create a table, click on the tab "Databases" and choose a database by clicking on it:

Then there will be a box titled "Create new table in database", where you type the name of the table and the number of columns and press the button "Go":

Then you can name the columns and set the data type, etc., as in the SQL example below:

Creating a Database in Xampp / PHPMyadmin

 Note: Be sure that you have your Xampp / Wamp Application Installed

1) Open your browser and enter http://localhost/phpmyadmin. This will bring you to the MySQL setup page:

2) Enter a name for the database, then click on the Create button. The name must be 64 characters or less and composed of letters, numbers and underscores. Avoid using numbers at the start of the name. A good name should indicate the purpose of the database. For example: joomla_database or database_for_drupal. There should be no need to change the other settings:

3) Ensure the database was successfully created:






















This database can now be used by any application that requires a MySQL database,

Sony Vegas vs Adobe Premiere

Depending upon the Video Editor's skills.

Comparison:

SONY VEGAS	ADOBE PREMIERE
User-Friendly Environment	Complex Environment
Good for Beginners	Great for Professional Video Editors
Can import Hitfilm, After Effects and Other VFX softwares	Dedicated on Adobe Creative Suite Softwares
Faster video renders for middle-class processors	Needs High-end processor with Dedicated Graphics Card

How to be a GOOD Graphic Artist

1. Know your Personality (www.tinyurl.com/birdtype).

2. Create a Concept

      a. Color
      b. Font
      c. Objects and Shapes
      d. Images

3. Design not based on your Mood but based on the concept of your graphic / client.

4. Use eye safe colors

5. Use the appropriate software for designing. (e.g. Adobe Photoshop for Images, Coreldraw / Illustrator for Logos)