Sql

Question 1

How to start a PHP session

Answer 1

session.start();

Question 2

How to stop a PHP session

Answer 2

session.destroy();

Question 3

How do you create a SQL connection

Answer 3

$con = mysqli_connect($server,$username,$password,$database);

Question 4

How do you stop a PHP script

Answer 4

die();

Question 5

How do you display text

Answer 5

echo

Question 6

How do you terminate a SQL connection

Answer 6

Mysqli_close($con);

Question 7

How do you get the results from an SQL query

Answer 7

$result = mysqli_query($con,$sql);

Question 8

How do you get the number of rows in the result

Answer 8

$row = mysqli_num_rows($results);

Question 9

How do you get the results as an array

Answer 9

$row = mysqli_fetch_array($results);

Question 10

How is an if statement written

Answer 10

If (condition) { code to be executed}

Question 11

How is a if elif else statement written

Answer 11

if(condition) {code} 
else if(condition) {code}
else {code}

Question 12

While loops

Answer 12

while(condition){code}

Question 13

For loop

Answer 13

for($x = 0, $x<=10, $x++){code}

Question 14

Return X then increment

Answer 14

$x++

Question 15

Increment then return x

Answer 15

++$x

Question 16

Return X then decrement

Answer 16

$x–

Question 17

Decrement X then return

Answer 17

–$x

Question 18

How do you define a function

Answer 18

Function name(variables) {code}

Question 19

How do you call a function called test

Answer 19

test();

Question 20

How to create an array

Answer 20

$a = array(values);