Classes of Justin Eldracher
| Recommend this page to a friend! |
| All class groups | > | All authors | > | Classes of Justin Eldracher (1) | > | Mission progress status | > | Reputation |
|
||||||||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
| ||||
| This class can access MySQL databases and execute common queries. Currently it can: - Connect to a given MySQL host and access a given database - List all tables in the accessible databases - Get the columns of a given table - Compose and execute SELECT queries to a given table getting specific fields by a given sorting order returning the results into a single array - Search for given table records that match given conditions - Insert table records with given field values - Update table records with given field values and conditions - Delete table records that match a condition - Create table records for a new user with a password - Authenticate a given user with a password in the users table - Change a given user password in the users table - Update or delete given user records in the users table - Read the text contents of files in the format CSV, PDF or Microsoft Word - Write plain text or CSV files - Rename or delete files - Get the list of files from a directory - Etc.. |
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
