CCS0043 Module 7

What does mysql_result() do?

mysql_result() retrieves the contents of one cell from a MySQL result set.

What is the syntax for mysql_result()?

mysql_result($result_query, row, field)

What does mysql_affected_rows() return?

It returns the number of affected rows by the last SELECT, INSERT, UPDATE, REPLACE or DELETE query.

What is the syntax for mysql_affected_rows()?

mysql_affected_rows()

What does mysql_num_rows() do?

It retrieves the number of rows from a result set.

What is the syntax for mysql_num_rows()?

mysql_num_rows()

What is the purpose of $_FILES in PHP?

It is used to upload files from a client computer to the remote server.

What is the syntax for accessing uploaded files in $_FILES?

$_FILES["file"]["index"]

What does move_uploaded_file() do?

It saves the uploaded file permanently and returns TRUE on success, or FALSE on failure.

What is the syntax for move_uploaded_file()?

move_uploaded_file(file, new location)

What does file_exists() check?

It checks for file existence.

What does is_file() check?

It checks if the specified path is a file.

What does is_dir() check?

It checks if the specified path is a directory.

What does is_readable() check?

It checks if the specified file is readable.

What does is_writable() check?

It checks if the specified file is writable.

What does is_executable() check?

It checks if the specified file is executable.

What does filesize() return?

It returns the size of the specified file in bytes.

What does fopen() do?

It opens a file for reading, writing, or appending content.

What is the syntax for fopen()?

fopen("file", "mode")

What does fgets() do?

It reads a line from a file.

What does fread() do?

It reads a specified set of characters from a file.

What does fgetc() do?

It reads a file one character at a time.

What does fwrite() do?

It writes a string to a file.

What does fputs() do?

It works the same way as fwrite() to write a string to a file.

What does touch() do?

It attempts to create an empty file or update the modification date of an existing file.

What does unlink() do?

It removes an existing file.