My PHP Note
December 16th
mysqli_num_rows()
// Result is required. Specifies a result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result()
mysqli_num_rows(result);The mysqli_num_rows() function returns the number of rows in a result set.
mysqli connect()
// Object oriented style
$mysqli -> new mysqli(host, username, password, dbname, port, socket)
// Procedural style
mysqli_connect(host, username, password, dbname, port, socket)The connect() / mysqli_connect() function opens a new connection to the MySQL server.
mysqli query()
$mysqli -> query(query, resultmode)
// Example
$result = $sql->query("INSERT INTO users(name, messages) VALUES ('$name', '$message')");The query() / mysqli_query() function performs a query against a database.
December 17th
fetch_assoc()
$mysqli_result -> fetch_assoc()
// Example
$row = $result->fetch_assoc();The fetch_assoc() / mysqli_fetch_assoc() function fetches a result row as an associative array.