WEB-DEV Flashcards
The PHP MySQL connect function is used to connect to a_________
MySQL database server.
It has the following syntax.
<?php;
$con = mysql connect ($db_server_name, $db_username, $db);
?>
Is the database connection resource variable.
“$con”
Is the function for php database connection
“mysql _connect (…)”
Is the name or IP address of the server hosting Mysql server.
“$server_name”
Is a valid user name in MySQL server.
“$username”
Is a valid associated with a user name in MySQL server.
”$”
The ________ function is used to select a database
mysqli_select_db
It has the following syntax.
<?php
mysqli_select_db ($con, $database_name);
?>
Is the database selection function that returns either true or false
“mysqli_select_db (…)”
Is the name of the database
“$database_name”
Is optional, it is used to pass in the server connection link
“$link_identifier”
MySQLi CREATE DATABASE
TINGIN KA NALANG SA MODULE (MODULE 7)
Is a field attribute and it is being used because we do not want this Field to be NULL.
NOT NULL
Tells MySQLi to go ahead and add the next available number to the id field.
AUTO_INCREMENT
Is used to define a column as______
You can use multiple columns separated by comma to define a ________
PRIMARY KEY
MySQLi _______ statement is used to insert data into MySQLi table.
INSERT INTO
Below the syntax of INSERT INTO command
INSERT INTO table_name
Statement is used to fetch data from the one or more tables.
MySQLi Select record
We can retrieve records of all Fields or specified Fields.
MySQLi SELECT
Statement is used to update existing records in a table.
MySQLi UPDATE RECORD
Statement is used to delete existing records in a table.
MySQLi DELETE RECORD
Statement is used to sort the results -set in ascending or descending order.
MySQLi ORDER By
Statement is used with aggregate function as COUNT , MAX , MIN, SUM etc to group the result-set by one or more columns…
MySQLi GROUP By
