PHP

Question 1

Assign variable using the HTML form data

Answer 1

$VariableName1 = $_POST/GET [‘FormFieldName’];
%VariableName2 = $_POST/GET [‘FormFieldName’]

Question 2

Connection Parameters

Answer 2

$dbserver = ‘ServerName’;
$dbuser = ‘Username’;
$dbpass = ‘Password’;
$dbname = ‘DatabaseName’;

Question 3

Selection of database

Answer 3

$connection = mysql_connect($dbserver, $dbuser, $dbpass);

mysql_select_db($dbname, $connection);

Question 4

Execute Query

Answer 4

$result = mysql_query(SELECT * FROM tableName WHERE $VariableName2 LIKE ‘%$$VariableName1%’)

Question 5

close connection

Answer 5

mysql_close(connection);