AH PHP/HTML

Question 1

When asked about an HTML form input, what two things methods are there?

Answer 1

POST

GET

Question 2

When using the form tag, what 3 pieces of info do you need?

Answer 2

method (post/get)
action (php file)
name (filename)

Question 3

When using the input tag with input boxes, what 2 pieces of info do you need?

Answer 3

Type (text/password/date)

Name (what the box is called)

Question 4

When using the input tag with a submit button what 3 pieces of info do you need?

Answer 4

Type (submit)
Value (Submit Form)
Name (what it’s called (submit))

Question 5

To connect to a database server what 3 connection parameter do you need?

Answer 5

$dbserver = ...
$dbuser = ...
$dbpass = ...

Question 6

To connect and select a database what 2 lines do you need?

Answer 6

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

mysql_select_db($database, $connection);

Question 7

What 2 lines of code do you need when assigning HTML user and pass to server side-variables?

Answer 7

$user = $_POST['username'];
$userpassword = $_POST['userpassword'];

Question 8

What 2 lines of code would you need to add data to a table?

Answer 8

$sql = “INSERT INTO … VALUES(‘…’)”;

mysql_query($sql);

Question 9

What 1 line of code would you need to close a database connection?

Answer 9

mysql_close($connection)

Question 10

What line of code would you need to update a piece of data in a database? Use pseudocode

Answer 10

SET query TO “UPDATE tablename SET field1 = … where field2 = …