• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/10

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

10 Cards in this Set

  • Front
  • Back
FUNCTION SYNTAX:

connect to a mysql server
mysqli_connect($host,$user,$passwd)

OR

$connect = new mysqli($host,$user,$passwd)
FUNCTION SYNTAX:

return the last error code for the most recent MySQLi function call...(if no errors, it will return 0(
mysqli_errno($connect)

OR

$connect->errno
FUNCTION SYNTAX

Returns a string description of the last error (if no error, return empty string)
mysqli_error($connect)

OR

$connect->error
FUNCTION SYNTAX:

Fetch a result row as an associative, a numeric array, or both.
mysqli_fetch_array($result)

OR

$result->fetch_array()

NOTE: ( i ) can also store the data in associative indices, using the field names of the result set as keys.
FUNCTION SYNTAX:

used to return an associative array representing the next row in the result set for the result represented by the result parameter, where each key in the array represents the name of one of the result set's columns.
mysqli_fetch_assoc ( $result)

OR

$result->fetch_assoc()
FUNCTION SYNTAX:

function will return the next row within the result set, or FALSE if there are no more rows.
mysqli_fetch_row ( $result)

OR

$result ->fetch_row()
FUNCTION SYNTAX:

returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute.
mysqli_insert_id($connection)

OR

$connect->insert_id
FUNCTION SYNTAX:

Gets the number of rows in a result
mysqli_num_rows ($result)

OR

$result->num_rows()
FUNCTION SYNTAX:

Performs a query on the database
mysqli_query ($connect, $sql)

OR

$connect->query($sql)
FUNCTION SYNTAX:

Selects the default database for database queries
mysqli_select_db ($connect)

OR

$connect->select_db($dbname)