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

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.

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

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,