PHP Tutorial MySQLi

MySQLi

1. Change the default database for the connection: in PHP
2. Change the user of the specified database connection in PHP
3. Create an SSL connection in PHP
4. Delete Data In a Database in PHP
5. Dump debug info into the log in PHP
6. Escape special characters in a string in PHP
7. Execute multi query and print result in PHP
8. Fetch a result row as a numeric array and as an associative array in PHP
9. Fetch a result row as an associative array in PHP
10. Fetch all rows and return the result-set as an associative array in PHP
11. Fetch rows from a result-set, then free the memory associated with the result in PHP
12. Get MySQL protocol version in PHP
13. Get a character set object, with its properties in PHP
14. Get a list of errors for the most recent function call, if any in PHP
15. Get auto-generated id in the last query in PHP
16. Get default character set for the database connection in PHP
17. Get info for all fields, and print each column ' s name, table, and max length in PHP
18. Get information about the most recently executed query in PHP
19. Get meta-data for a column, then print the field ' s name, table, and max length in PHP
20. Get stats about client per-process in PHP
21. Get stats about the client connection in PHP
22. Get the MySQL server hostname and connection type in PHP
23. Get the MySQL server version in PHP
24. Get the SQLSTATE error code for the last MySQL operation in PHP
25. Get the current configuration setting of magic_quotes_gpc in PHP
26. Get the current row of a result set, then print each field ' s value in PHP
27. Get the last error code for the most recent function call, if any in PHP
28. Get the last error description for the most recent function call, if any in PHP
29. Get the length of the fields in the result set in PHP
30. Get the number of columns for the most recent query in PHP
31. Get the number of fields (columns) in a result set in PHP
32. Get the number of rows in a result set in PHP
33. Get the thread ID for the current connection, then kill the connection in PHP
34. Get thread ID for the current connection, then kill the connection in PHP
35. Initialize a statement and return an object to use with mysqli_stmt_prepare() in PHP
36. Modify data in a table in PHP
37. Open a new connection to the MySQL server in PHP
38. Perform multiple queries against the database with mysqli_next_result() in PHP
39. Perform queries against the database in PHP
40. Ping a mysql server connection in PHP
41. Print out affected rows from different queries in PHP
42. Return an array of objects that represent the columns in a result set in PHP
43. Return the MySQL client library version in PHP
44. Return the next field (column) in the result set, then print each field ' s name, table, and max length in PHP
45. Seek to row number 15 in the result-set in PHP
46. Set cursor to the first column, print the field ' s name, table, and max length in PHP
47. Set the default client character set in PHP
48. Sort the data in a recordset with ORDER BY keyword in PHP
49. Turn off auto-committing, make some queries, commit the queries, then roll back the current transaction in PHP
50. Use WHERE clause to filter records in PHP