How to Convert HTML to WordPress Template - Learn

PDO and PHP OOPs Concept - Learn From Here by Vedio

Codeigniter Tutorial in Hindi Language - Learn from Here

PHP 5 MySQLi Functions - Useful for PHP Developer

Function	Description
mysqli_affected_rows()	Returns the number of affected rows in the previous MySQL operation
mysqli_autocommit()	Turns on or off auto-committing database modifications
mysqli_change_user()	Changes the user of the specified database connection
mysqli_character_set_name()	Returns the default character set for the database connection
mysqli_close()	Closes a previously opened database connection
mysqli_commit()	Commits the current transaction
mysqli_connect_errno()	Returns the error code from the last connection error
mysqli_connect_error()	Returns the error description from the last connection error
mysqli_connect()	Opens a new connection to the MySQL server
mysqli_data_seek()	Adjusts the result pointer to an arbitrary row in the result-set
mysqli_debug()	Performs debugging operations
mysqli_dump_debug_info()	Dumps debugging info into the log
mysqli_errno()	Returns the last error code for the most recent function call
mysqli_error_list()	Returns a list of errors for the most recent function call
mysqli_error()	Returns the last error description for the most recent function call
mysqli_fetch_all()	Fetches all result rows as an associative array, a numeric array, or both
mysqli_fetch_array()	Fetches a result row as an associative, a numeric array, or both
mysqli_fetch_assoc()	Fetches a result row as an associative array
mysqli_fetch_field_direct()	Returns meta-data for a single field in the result set, as an object
mysqli_fetch_field()	Returns the next field in the result set, as an object
mysqli_fetch_fields()	Returns an array of objects that represent the fields in a result set
mysqli_fetch_lengths()	Returns the lengths of the columns of the current row in the result set
mysqli_fetch_object()	Returns the current row of a result set, as an object
mysqli_fetch_row()	Fetches one row from a result-set and returns it as an enumerated array
mysqli_field_count()	Returns the number of columns for the most recent query
mysqli_field_seek()	Sets the field cursor to the given field offset
mysqli_field_tell()	Returns the position of the field cursor
mysqli_free_result()	Frees the memory associated with a result
mysqli_get_charset()	Returns a character set object
mysqli_get_client_info()	Returns the MySQL client library version
mysqli_get_client_stats()	Returns statistics about client per-process
mysqli_get_client_version()	Returns the MySQL client library version as an integer
mysqli_get_connection_stats()	Returns statistics about the client connection
mysqli_get_host_info()	Returns the MySQL server hostname and the connection type
mysqli_get_proto_info()	Returns the MySQL protocol version
mysqli_get_server_info()	Returns the MySQL server version
mysqli_get_server_version()	Returns the MySQL server version as an integer
mysqli_info()	Returns information about the most recently executed query
mysqli_init()	Initializes MySQLi and returns a resource for use with mysqli_real_connect()
mysqli_insert_id()	Returns the auto-generated id used in the last query
mysqli_kill()	Asks the server to kill a MySQL thread
mysqli_more_results()	Checks if there are more results from a multi query
mysqli_multi_query()	Performs one or more queries on the database
mysqli_next_result()	Prepares the next result set from mysqli_multi_query()
mysqli_num_fields()	Returns the number of fields in a result set
mysqli_num_rows()	Returns the number of rows in a result set
mysqli_options()	Sets extra connect options and affect behavior for a connection
mysqli_ping()	Pings a server connection, or tries to reconnect if the connection has gone down
mysqli_prepare()	Prepares an SQL statement for execution
mysqli_query()	Performs a query against the database
mysqli_real_connect()	Opens a new connection to the MySQL server
mysqli_real_escape_string()	Escapes special characters in a string for use in an SQL statement
mysqli_real_query()	Executes an SQL query
mysqli_reap_async_query()	Returns the result from async query
mysqli_refresh()	Refreshes tables or caches, or resets the replication server information
mysqli_rollback()	Rolls back the current transaction for the database
mysqli_select_db()	Changes the default database for the connection
mysqli_set_charset()	Sets the default client character set
mysqli_set_local_infile_default()	Unsets user defined handler for load local infile command
mysqli_set_local_infile_handler()	Set callback function for LOAD DATA LOCAL INFILE command
mysqli_sqlstate()	Returns the SQLSTATE error code for the last MySQL operation
mysqli_ssl_set()	Used to establish secure connections using SSL
mysqli_stat()	Returns the current system status
mysqli_stmt_init()	Initializes a statement and returns an object for use with mysqli_stmt_prepare()
mysqli_store_result()	Transfers a result set from the last query
mysqli_thread_id()	Returns the thread ID for the current connection
mysqli_thread_safe()	Returns whether the client library is compiled as thread-safe
mysqli_use_result()	Initiates the retrieval of a result set from the last query executed using the mysqli_real_query()
mysqli_warning_count()	Returns the number of warnings from the last query in the connection