Php And Mysql

Front 1

Before you can access and work with data in a database, you must create a connection to the database. In PHP, this is done with what function?

Back 1

mysql_connect()

Front 2

What is the syntax for mysql_connect()?

Note: There are more available parameters, but the three listed in this answer are the most important.

Back 2

mysql_connect(servername,username,password);

Hint 2

Note: There are more available parameters, but the three listed in this answer are the most important.

Front 3

Using this PHP command to connect to a database, which of the three parameters is mandatory?

mysql_connect(servername,username,password);

Back 3

None of the three are. Each is optional.

Front 4

Using the function mysql_connect(servername,username,password); to connect, what do the parameters do and what is the default should they not be specified?

Back 4

servername - Specifies the server to connect to. Default value is "localhost:3306"

username - Specifies the username to log in with. Default value is the name of the user that owns the server process

password - Specifies the password to log in with. Default is ""

Front 5

The connection to the database will be closed as soon as the active script ends. To close the connection before, use the ___________() function.

Back 5

mysql_close()

Front 6

To get PHP to execute a statement we must use the ___________() function. This function is used to send a query or command to a MySQL connection.

Back 6

mysql_query()

Front 7

Using the mysql_query() function, what command (what syntax) is used to create a new database?

Back 7

CREATE DATABASE database_name

Front 8

Using the mysql_query() function, what command (what syntax) is used to create a new table in a database?

Back 8

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
.......
)

Front 9

What are the 5 numeric data types associated with integers (non-decimal)?

Note: The maximum number of digits can be specified in the size parameter

Back 9

int(size)
smallint(size)
tinyint(size)
mediumint(size)
bigint(size)

Front 10

What are the 5 numeric data types associated with decimals?

Note: The maximum number of digits can be specified in the size parameter. The maximum number of digits to the right of the decimal is specified in the d parameter.

Back 10

decimal(size,d)
double(size,d)
float(size,d)

Front 11

What are the 6 textual data types?

Back 11

char(size) - Holds a fixed length string. The fixed size is specified in parenthesis

varchar(size) - Holds a variable length string. The max size is specified in parenthesis

tinytext - Holds a variable string with a max length of 255 characters

text or blob - Holds a variable string with a max length of 65535 characters

mediumtext/mediumblob - Holds a variable string with a max length of 16777215 characters

longtext/longblob - Holds a variable string with a max length of 4294967295 characters

Front 12

What is the syntax for one of the date data types?

Note: there are 4 date data types.

Back 12

date(yyyy-mm-dd)
datetime(yyyy-mm-dd hh:mm:ss)
timestamp(yyyymmddhhmmss)
time(hh:mm:ss)

Front 13

enum(value1,value2,ect)

ENUM is short for ENUMERATED list. Can store one of up to 65535 values listed within the ( ) brackets. What happens if you try and insert a value into the table column that is not in the list?

Back 13

If a value is inserted that is not in the list, a blank value will be inserted instead.

Front 14

True or False: The primary key field is never indexed.

Back 14

False. The primary key field is always indexed. There is no exception to this rule!

Front 15

What does the primary key do?

Back 15

A primary key is used to uniquely identify the rows in a table.

Each primary key value must be unique within the table.

Furthermore, the primary key field cannot be null because the database engine requires a value to locate the record.