Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

manipulating MySQL database

memorize.ai (lvl 286)

(0)

20 cards

()

Section 1

Preview this deck

MySQL_free_result()

Front

1 / 20

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (20)

Section 1

(20 cards)

MySQL_free_result()

Front

close the resultset

Back

MySQL_select_db()

Front

to select a database MySQL_select_db(database[,connection]) returns true or false

Back

MySQL_drop_db

Front

deleting a database MySQL_drop_db("dbname" [, connection]);

Back

error control operator (@)

Front

suppress error and warning messages place before any expression

Back

why shouldn't you use die()

Front

exits script immediately

Back

MySQL_errorno

Front

returns the numeric code of the error

Back

MySQL_error

Front

returns a text string describing the error

Back

MySQL_create_db()

Front

create a database MySQL_create_db("dbname"[,connection]); returns TRUE or FALSE

Back

resultset

Front

list of records returned by mysql

Back

mysql_connect

Front

Opens a non-persistent MySQL connection $connection = MySQL_connect("host"[, "user, "password"])

Back

how to close a database connection

Front

MySQL_close()

Back

MySQL_num_rows()

Front

determine number of rows in a records

Back

result pointer

Front

special type of variable that refers to the currently selected row in the list of records returned by MYSQL

Back

MySQL_info()

Front

returns infor about the query returns the number of operations for various types of actions, depending on the type of query

Back

MySQL_insert_id()

Front

unction returns the id (generated with AUTO_INCREMENT) used in the last query.

Back

MySQL_query()

Front

send SQL statements to MySQL returns on of three values depending on type of query executed.

Back

MySQL_affected_rows()

Front

determins the number of affected rows

Back

MySQL_fetch_assoc()

Front

returns the fields in the current row of a resulset into an associative array and moves the result pointer to the next row

Back

MySQL_get_client_info() and MySQL_get_client_version()

Front

returns info about the musql package that PHP is using

Back

MySQL_fetch_row()

Front

returns the fields in the current row of a result set into an indexed array and moves the result pointer to the next row

Back