Position

Clear

Height

List Style

Border

Background

Font

Font-Family

Color

• color name – example:(red, black…)
• hexadecimal number – example:(#ff0000, #000000)
• RGB color code – example:(rgb(255, 0, 0), rgb(0, 0, 0))

Divsions

Internal Stylesheet

1. PHPMailer
2. Swift Mailer

Characters outside the 7-bit printable ASCII range are encoded into a 7-bit format making them incapable of affecting the header structure.

Email injection or mail form spamming

$to = 'recipient@somedomain.xxx';
$from = 'sender@anotherdomain.xxx';
$fromname = 'Dilbert';
$subject = 'HTML Email';
$headers = "Date: ".date('r')."\n";
$headers .= "Return-Path: ".$from."\n";
$headers .= "From: ".$fromname."\n";
$headers .= "Message-ID: <".md5(uniqid(time()))."@anotherdomain.xxx>\n";
$headers .= "X-Priority: 3\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Transfer-Encoding: 8bit\n";
$headers .= 'Content-Type: text/html; charset="iso-8859-1"'."\n";
$body ='

HTML Email Body

';
mail($to, $subject, $body, $headers);

$from = "sender@anotherdomain.xxx
Cc:victim@domain2.xxx";

Protection against email injections and mail form spamming

function heal($str) {
 $injections = array('/(\n+)/i',
 '/(\r+)/i',
 '/(\t+)/i',
 '/(%0A+)/i',
 '/(%0D+)/i',
 '/(%08+)/i',
 '/(%09+)/i'
 );
 $str= preg_replace($injections,'',$str);
 return $str;
}

function isInjected($str) {
 $injections = array('(\n+)',
 '(\r+)',
 '(\t+)',
 '(%0A+)',
 '(%0D+)',
 '(%08+)',
 '(%09+)'
 );
 $inject = join('|', $injections);
 $inject = "/$inject/i";
 if(preg_match($inject,$str)) {
  return true;
 }
 else {
  return false;
 }
}

Connecting to MySQL through PHP

$link = mysql_connect($hostname, $username, $password, $newlink);

$link1 = mysql_connect("localhost", "user1", "secret");
$link2 = mysql_connect("localhost", "user1", "secret");
$link3 = mysql_connect("localhost", "user1", "secret");
//The three calls to mysql_connect above will return a link identifier to the same connection

$link4 = mysql_connect("localhost", "user2", "secret");
//A new connection will be returned since we have changed the username in the argume

Selecting Database

//Open a connection to the mysql server
$link = mysql_connect('localhost', 'user', 'secret');
if(!$link) {
 print('Failed to establish connection to mysql server!');
 exit();
}

//Select the database
$status = mysql_select_db('mydatabase');

Running Queries

//Open a connection to the mysql server
$link = mysql_connect("localhost", "user1", "secret");
if(!$link) {
 print("Failed to establish connection to mysql server!");
 exit();
}

//Select the database
$status = mysql_select_db("mydatabase");

//Run query
$query = "SELECT first_name,last_name FROM customers WHERE cust_id=23";
$rs = mysql_query($query);
if(!$rs) {
 print("Query Error: ".mysql_error());
}
$numrows = mysql_num_rows($rs);
print("Number of rows returned: $numrows");

Using the result set

$query = "SELECT first_name,last_name FROM customers WHERE cust_id=23";
$rs = mysql_query($query);
if(!$rs) {
 print("Query Error: ".mysql_error());
}

//Number of rows reqturned by the query
$numrows = mysql_num_rows($rs);
print("Number of rows returned: $numrows");

//Fetch result set as an associative array
$customer = mysql_fetch_assoc($rs);
print($customer['first_name']);
print($customer['last_name']);

$customer['first_name'] = 'Jatinder';
$customer['last_name'] = 'Thind';

1. mysql_unbuffered_query – This uses less memory than mysql_query. The downside is that you can not use mysql_num_rows if you use mysql_unbuffered_query
2. mysql_real_escape_string – Escapes the special characters. Only available on PHP-4.3.0 and above
3. addslashes – Similar to mysql_real_escape_string above. This is available in all PHP versions.
4. mysql_error – Returns the error text from the previously called mysql function.

Step 1

Preparation

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 10

Step 11

Step 12

Step 13

Step 14

Step 15

Step 16

Step 17

Step 18

Step 19

Step 20

Step 21

Step 22

Step 23

Step 24

Step 25

Step 26

• Image > Adjustments > Hue/Saturation
• Image > Adjustments > Brightness/Contrast
• Image > Adjustments > Selective Color
• Image > Adjustments > Levels

Step 27

• Image > Adjustments > Hue/Saturation
• Image > Adjustments > Selective Color
• Image > Adjustments > Brightness/Contrast

Step 28

Step 29

Step 30

Step 31

Step 32

• In second image below, I made this line fit the back of balloon.
• In third image below, I created a new shape using the same technique.

Step 33

Step 34

Step 35

Step 36

Step 37

Step 38

Conclusion