Cheat sheets can increase productivity in programming. How?In a cheat sheet, you can write down different functions [with parameters and syntax] that you use frequently [or all the important functions of a programming language]. Whenever, you are confused, take a quick look at the cheat sheets. Sometimes it can be faster than searching the internet. You can categorize the functions based on the purpose, within a category – sort them alphabetically for easier search\/scan. You can create, many cheat sheets for a particular language. Keep them beside you while you are writing codes. A sample cheat sheet regarding PHP functions to handle MySQL database is provided below. Note, the cheat sheet needs to be improved such as: categorize the functions [like for connection management, retrieving data, keep track of database\/operation status, collecting information about the database [meta-data]], sort the functions alphabetically. Keep the font size small to list more functions in a small space<\/p>\n
\n\n| resource mysql_unbuffered_query ( string $query [, resource $link_identifier ] )<\/td>\n | Send an SQL query to MySQL, without fetching and buffering the result rows <\/td>\n<\/tr>\n |
\n| int mysql_thread_id ([ resource $link_identifier ] )<\/td>\n | Return the current thread ID<\/td>\n<\/tr>\n |
\n| bool mysql_ping ([ resource $link_identifier ] )<\/td>\n | Ping a server connection or reconnect if there is no connection<\/td>\n<\/tr>\n |
\n| resource mysql_list_processes ([ resource $link_identifier ] )<\/td>\n | List MySQL processes<\/td>\n<\/tr>\n |
\n| string mysql_tablename ( resource $result , int $i )<\/td>\n | the table name from a result<\/td>\n<\/tr>\n |
\n| string mysql_stat ([ resource $link_identifier ] )<\/td>\n | Get current system status<\/td>\n<\/tr>\n |
\n| bool mysql_set_charset ( string $charset [, resource $link_identifier ] )<\/td>\n | Sets the default character set for the current connection.<\/td>\n<\/tr>\n |
\n| bool mysql_select_db ( string $database_name [, resource $link_identifier ] )<\/td>\n | Select a MySQL database<\/td>\n<\/tr>\n |
\n| string mysql_result ( resource $result , int $row [, mixed $field ] )<\/td>\n | Retrieves the contents of one cell from a MySQL result set.<\/td>\n<\/tr>\n |
\n| string mysql_real_escape_string ( string $unescaped_string [, resource $link_identifier ] )<\/td>\n | Escapes special characters in the unescaped_string , taking into account the current character set of the connection so that it is safe to place it in a mysql_query(). If binary data is to be inserted, this function must be used<\/td>\n<\/tr>\n |
\n| resource mysql_query ( string $query [, resource $link_identifier ] )<\/td>\n | sends a unique query (multiple queries are not supported) to the currently active database <\/td>\n<\/tr>\n |
\n| resource mysql_pconnect ([ string $server [, string $username [, string $password [, int $client_flags ]]]] )<\/td>\n | Establishes a persistent connection to a MySQL server.<\/td>\n<\/tr>\n |
\n| int mysql_num_rows ( resource $result )<\/td>\n | Retrieves the number of rows from a result set<\/td>\n<\/tr>\n |
\n| int mysql_affected_rows ([ resource $link_identifier ] )<\/td>\n | Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE<\/td>\n<\/tr>\n |
\n| int mysql_num_fields ( resource $result )<\/td>\n | Retrieves the number of fields from a query.<\/td>\n<\/tr>\n |
\n| resource mysql_list_tables ( string $database [, resource $link_identifier ] )<\/td>\n | Retrieves a list of table names from a MySQL database.<\/td>\n<\/tr>\n |
\n| resource mysql_list_fields ( string $database_name , string $table_name [, resource $link_identifier ] )<\/td>\n | Retrieves information about the given table name. <\/td>\n<\/tr>\n |
\n| use mysql_query() to issue a SQL SHOW COLUMNS FROM table<\/td>\n<\/tr>\n |
\n| resource mysql_list_dbs ([ resource $link_identifier ] )<\/td>\n | List databases available on a MySQL server<\/td>\n<\/tr>\n |
\n| int mysql_insert_id ([ resource $link_identifier ] )<\/td>\n | Get the ID generated from the previous INSERT operation<\/td>\n<\/tr>\n |
\n| string mysql_info ([ resource $link_identifier ] )<\/td>\n | Get information about the most recent query<\/td>\n<\/tr>\n |
\n| string mysql_get_server_info ([ resource $link_identifier ] )<\/td>\n | Retrieves the MySQL server version. <\/td>\n<\/tr>\n |
\n| int mysql_get_proto_info ([ resource $link_identifier ] )<\/td>\n | Retrieves the MySQL protocol. <\/td>\n<\/tr>\n |
\n| string mysql_get_host_info ([ resource $link_identifier ] )<\/td>\n | Describes the type of connection in use for the connection, including the server host name.<\/td>\n<\/tr>\n |
\n| string mysql_get_client_info ( void )<\/td>\n | returns a string that represents the client library version. <\/td>\n<\/tr>\n |
\n| bool mysql_free_result ( resource $result )<\/td>\n | free all memory associated with the result identifier result . <\/td>\n<\/tr>\n |
\n| string mysql_field_type ( resource $result , int $field_offset )<\/td>\n | Get the type of the specified field in a result<\/td>\n<\/tr>\n |
\n| string mysql_field_table ( resource $result , int $field_offset )<\/td>\n | Get name of the table the specified field is in<\/td>\n<\/tr>\n |
\n| bool mysql_field_seek ( resource $result , int $field_offset )<\/td>\n | Set result pointer to a specified field offset<\/td>\n<\/tr>\n |
\n| string mysql_field_name ( resource $result , int $field_offset )<\/td>\n | Get the name of the specified field in a result<\/td>\n<\/tr>\n |
\n| int mysql_field_len ( resource $result , int $field_offset )<\/td>\n | returns the length of the specified field. <\/td>\n<\/tr>\n |
\n| string mysql_field_flags ( resource $result , int $field_offset )<\/td>\n | Get the flags associated with the specified field in a result<\/td>\n<\/tr>\n |
\n| array mysql_fetch_row ( resource $result )<\/td>\n | Get a result row as an enumerated array<\/td>\n<\/tr>\n |
\n| object mysql_fetch_object ( resource $result [, string $class_name [, array $params ]] )<\/td>\n | Fetch a result row as an object<\/td>\n<\/tr>\n |
\n| array mysql_fetch_lengths ( resource $result )<\/td>\n | Get the length of each output in a result<\/td>\n<\/tr>\n |
\n| object mysql_fetch_field ( resource $result [, int $field_offset ] )<\/td>\n | Get column information from a result and return as an object<\/td>\n<\/tr>\n |
\n| array mysql_fetch_assoc ( resource $result )<\/td>\n | Fetch a result row as an associative array<\/td>\n<\/tr>\n |
\n| array mysql_fetch_array ( resource $result [, int $result_type ] )<\/td>\n | Fetch a result row as an associative array, a numeric array, or both<\/td>\n<\/tr>\n |
\n| string mysql_escape_string ( string $unescaped_string )<\/td>\n | Escapes a string for use in a mysql_query<\/td>\n<\/tr>\n |
\n| string mysql_error ([ resource $link_identifier ] )<\/td>\n | Returns the text of the error message from previous MySQL operation<\/td>\n<\/tr>\n |
\n| int mysql_errno ([ resource $link_identifier ] )<\/td>\n | Returns the numerical value of the error message from previous MySQL operation<\/td>\n<\/tr>\n |
\n| bool mysql_drop_db ( string $database_name [, resource $link_identifier ] )<\/td>\n | Drop (delete) a MySQL database<\/td>\n<\/tr>\n |
\n| resource mysql_db_query ( string $database , string $query [, resource $link_identifier ] )<\/td>\n | selects a database, and executes a query on it.<\/td>\n<\/tr>\n |
\n| string mysql_db_name ( resource $result , int $row [, mixed $field ] )<\/td>\n | <\/td>\n<\/tr>\n |
\n| bool mysql_data_seek ( resource $result , int $row_number )<\/td>\n | Move internal result pointer<\/td>\n<\/tr>\n |
\n| bool mysql_create_db ( string $database_name [, resource $link_identifier ] <\/td>\n | Create a MySQL database<\/td>\n<\/tr>\n |
\n| resource mysql_connect ([ string $server [, string $username [, string $password [, bool $new_link [, int $client_flags ]]]]] )<\/td>\n | Open a connection to a MySQL Server<\/td>\n<\/tr>\n |
\n| bool mysql_close ([ resource $link_identifier ] )<\/td>\n | Close MySQL connection<\/td>\n<\/tr>\n |
\n| string mysql_client_encoding ([ resource $link_identifier ] )<\/td>\n | Returns the name of the character set<\/td>\n<\/tr>\n |
\n| int mysql_change_user ( string $user , string $password [, string $database [, resource $link_identifier ]] )<\/td>\n | Change logged in user of the active connection<\/td>\n<\/tr>\n |
\n| int mysql_affected_rows ([ resource $link_identifier ] )<\/td>\n | Get number of affected rows in previous MySQL operation<\/td>\n<\/tr>\n<\/table>\n From: http:\/\/sitestree.com\/?p=5139
Categories:16
Tags:
Post Data:2011-11-14 22:16:24<\/p>\n Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n 8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Cheat sheets can increase productivity in programming. How?In a cheat sheet, you can write down different functions [with parameters and syntax] that you use frequently [or all the important functions of a programming language]. Whenever, you are confused, take a quick look at the cheat sheets. Sometimes it can be faster than searching the internet. … <\/p>\n Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-70063","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":17722,"url":"http:\/\/bangla.sitestree.com\/?p=17722","url_meta":{"origin":70063,"position":0},"title":"Calculus: Cheat Sheets: Derivatives: Integration","author":"Sayed","date":"October 16, 2020","format":false,"excerpt":"calculus cheat sheet complete https:\/\/www.anderson1.org\/cms\/lib\/SC01000609\/Centricity\/Domain\/1150\/calculus%20cheat%20sheet%20complete.pdf calculus_cheat_sheet_integrals.pdf https:\/\/tutorial.math.lamar.edu\/pdf\/calculus_cheat_sheet_integrals.pdf Calculus Summary Formulas https:\/\/sites.stat.washington.edu\/people\/handcock\/505\/Lectures\/lec6.pdf Calculus II For Dummies Cheat Sheet https:\/\/www.dummies.com\/education\/math\/calculus\/calculus-ii-for-dummies-cheat-sheet\/ *** . *** *** . *** . *** . *** Courses: http:\/\/Training.SitesTree.com (Big Data, Cloud) Blog: http:\/\/Bangla.SaLearningSchool.com, http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net Online Product Database: http:\/\/www.ShopForSoul.com\/ (Ecommerce Product Database)","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26266,"url":"http:\/\/bangla.sitestree.com\/?p=26266","url_meta":{"origin":70063,"position":1},"title":"Calculus: Cheat Sheets: Derivatives: Integration #Root","author":"Author-Check- Article-or-Video","date":"April 21, 2021","format":false,"excerpt":"calculus cheat sheet complete https:\/\/www.anderson1.org\/cms\/lib\/SC01000609\/Centricity\/Domain\/1150\/calculus%20cheat%20sheet%20complete.pdf calculus_cheat_sheet_integrals.pdf https:\/\/tutorial.math.lamar.edu\/pdf\/calculus_cheat_sheet_integrals.pdf Calculus Summary Formulas https:\/\/sites.stat.washington.edu\/people\/handcock\/505\/Lectures\/lec6.pdf Calculus II For Dummies Cheat Sheet https:\/\/www.dummies.com\/education\/math\/calculus\/calculus-ii-for-dummies-cheat-sheet\/ *** . *** *** . *** . *** . *** Courses: http:\/\/Training.SitesTree.com (Big Data, Cloud) Blog: http:\/\/Bangla.SaLearningSchool.com, http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net Online Product Database: http:\/\/www.ShopForSoul.com\/ (Ecommerce Product Database) From: http:\/\/sitestree.com\/calculus-cheat-sheets-derivatives-integration\/ Categories:RootTags:\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":74723,"url":"http:\/\/bangla.sitestree.com\/?p=74723","url_meta":{"origin":70063,"position":2},"title":"Math and Calculus Tutorials Online","author":"Sayed","date":"May 23, 2022","format":false,"excerpt":"Math and Calculus Tutorials Online Good one: Solving Ordinary (one variable) Differential Equations https:\/\/people.revoledu.com\/kardi\/tutorial\/ODE\/WhatisODE.htm Using Numerical Methods: https:\/\/people.revoledu.com\/kardi\/tutorial\/ODE\/Euler%20Method.htm Introduction to Differential Equations https:\/\/analyzemath.com\/calculus\/Differential_Equations\/introduction.html Mathematical methods for economic theory (+Optimization) https:\/\/mjo.osborne.economics.utoronto.ca\/index.php\/tutorial\/index\/1\/toc Calculus Tutorials: https:\/\/www.midnighttutor.com\/ https:\/\/www.midnighttutor.com\/math_tutor_online.php Math Tutorials: https:\/\/tutorial.math.lamar.edu\/ Math Cheat Sheets: https:\/\/tutorial.math.lamar.edu\/Extras\/CheatSheets_Tables.aspx#CalcSheet FIRST-ORDER DIFFERENTIAL EQUATIONS https:\/\/math.hmc.edu\/calculus\/hmc-mathematics-calculus-online-tutorials\/differential-equations\/first-order-differential-equations\/","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":74724,"url":"http:\/\/bangla.sitestree.com\/?p=74724","url_meta":{"origin":70063,"position":3},"title":"Math and Calculus Tutorials Online","author":"Sayed","date":"May 23, 2022","format":false,"excerpt":"Math and Calculus Tutorials Online Good one: Solving Ordinary (one variable) Differential Equations https:\/\/people.revoledu.com\/kardi\/tutorial\/ODE\/WhatisODE.htm Using Numerical Methods: https:\/\/people.revoledu.com\/kardi\/tutorial\/ODE\/Euler%20Method.htm Introduction to Differential Equations https:\/\/analyzemath.com\/calculus\/Differential_Equations\/introduction.html Mathematical methods for economic theory (+Optimization) https:\/\/mjo.osborne.economics.utoronto.ca\/index.php\/tutorial\/index\/1\/toc Calculus Tutorials: https:\/\/www.midnighttutor.com\/ https:\/\/www.midnighttutor.com\/math_tutor_online.php Math Tutorials: https:\/\/tutorial.math.lamar.edu\/ Math Cheat Sheets: https:\/\/tutorial.math.lamar.edu\/Extras\/CheatSheets_Tables.aspx#CalcSheet FIRST-ORDER DIFFERENTIAL EQUATIONS https:\/\/math.hmc.edu\/calculus\/hmc-mathematics-calculus-online-tutorials\/differential-equations\/first-order-differential-equations\/","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":74777,"url":"http:\/\/bangla.sitestree.com\/?p=74777","url_meta":{"origin":70063,"position":4},"title":"Math and Calculus Tutorials Online","author":"Sayed","date":"May 31, 2022","format":false,"excerpt":"Math and Calculus Tutorials Online Good one: Solving Ordinary (one variable) Differential Equations https:\/\/people.revoledu.com\/kardi\/tutorial\/ODE\/WhatisODE.htm Using Numerical Methods: https:\/\/people.revoledu.com\/kardi\/tutorial\/ODE\/Euler%20Method.htm Introduction to Differential Equations https:\/\/analyzemath.com\/calculus\/Differential_Equations\/introduction.html Mathematical methods for economic theory (+Optimization) https:\/\/mjo.osborne.economics.utoronto.ca\/index.php\/tutorial\/index\/1\/toc Calculus Tutorials: https:\/\/www.midnighttutor.com\/ https:\/\/www.midnighttutor.com\/math_tutor_online.php Math Tutorials: https:\/\/tutorial.math.lamar.edu\/ Math Cheat Sheets: https:\/\/tutorial.math.lamar.edu\/Extras\/CheatSheets_Tables.aspx#CalcSheet FIRST-ORDER DIFFERENTIAL EQUATIONS https:\/\/math.hmc.edu\/calculus\/hmc-mathematics-calculus-online-tutorials\/differential-equations\/first-order-differential-equations\/","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78356,"url":"http:\/\/bangla.sitestree.com\/?p=78356","url_meta":{"origin":70063,"position":5},"title":"Modes of Session State Management","author":"Sayed","date":"August 5, 2025","format":false,"excerpt":"By AI: Here are the 5 modes to store Session State in ASP.NET, each with its own storage location and behavior. This is especially useful for configuring ASP.NET (Framework) Web Forms or MVC applications \u2014 though some modes also apply to ASP.NET Core with slight differences. You can copy and\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70063"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70063\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70063"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
|