{"id":5021,"date":"2013-11-04T05:11:31","date_gmt":"2013-11-03T18:11:31","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=5021"},"modified":"2017-01-09T12:20:32","modified_gmt":"2017-01-09T02:20:32","slug":"apachephpmysql-configuration-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/apachephpmysql-configuration-primer-tutorial\/","title":{"rendered":"Apache\/PHP\/MySql Configuration Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Apache\/PHP\/MySql Configuration Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/PHP_Config_Primer-1of.jpg\" title=\"Apache\/PHP\/MySql Configuration Primer Tutorial\"   \/><\/a><p class=\"wp-caption-text\">Apache\/PHP\/MySql Configuration Primer Tutorial<\/p><\/div>\n<p>Some people like to study things before starting to use it.   Some people tackle things head on straight away.   Either way, as far as Apache\/PHP\/MySql web hosting goes, it is good to understand some of the configuration of this hosting.<\/p>\n<p>Maybe the hosting is already set up and you are curious about how it works.   Think, for this scenario, one of the best places to start is via PHP&#8217;s &#8220;phpinfo();&#8221; command information, which we show you for a local <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=MAMP\">MAMP<\/a> web server, on a Mac laptop, here, with this <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/\">tutorial<\/a>.<\/p>\n<p>The information from phpinfo() can tell you about modules installed for PHP which can be important knowledge to know what your setup is capable of for functionailty you may want to add yourself.   For instance, module <a target=_blank title='PHP gd' href='http:\/\/php.net\/manual\/en\/book.image.php'><i>gd<\/i><\/a> makes working with images much easier.   One of the modules <i>mysql<\/i> or <i>mysqli<\/i> is necessary for MySql database usage.<\/p>\n<p>The information from phpinfo() can tell you about PHP $_SERVER variables, which are invaluable to use.   HTML form processing can use $_POST and\/or $_GET variables and $_SERVER variables to achieve great things.   This information may stop you thinking you have to reinvent the wheel.   Square wheels are so &#8220;last week&#8221;.<\/p>\n<p>As you can imagine the Apache\/PHP\/MySql triad is quite a complex beast and want to help your thirst for knowledge with a list of lookable-uppables with MAMP examples where that might help (<i>help<\/i> being the operative word, please do not think that any of these configuration files should be copied onto your computer system, as they are only intended for perusal and comparison purposes, or for your general interest), in a list below:<\/p>\n<table>\n<tr>\n<td>\n<a target=_blank title='httpd.conf' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/httpd.conf_GETME\">httpd.conf<\/a> Apache <a target=_blank title='httpd.conf' href='http:\/\/en.wikipedia.org\/wiki\/Httpd.conf'>configuration<\/a>\n<\/td>\n<td>\n<a target=_blank title='php.ini' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/php.ini_GETME\">php.ini<\/a> PHP <a target=_blank title='php.ini' href='http:\/\/php.net\/manual\/en\/configuration.file.php'>configuration<\/a>\n<\/td>\n<td>\n<a target=_blank title='my.cnf' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/my.cnf_GETME\">my.cnf<\/a> MySql <a target=_blank title='my.cnf' href='http:\/\/en.wikipedia.org\/wiki\/Wikipedia:Database_dump_import_problems'>configuration<\/a>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>robot.txt <a target=_blank title='Robots exclusion standard' href='http:\/\/en.wikipedia.org\/wiki\/Robots_exclusion_standard'>link<\/a>\n<\/td>\n<td>\n.htaccess <a target=_blank title='.htaccess' href='http:\/\/en.wikipedia.org\/wiki\/Htaccess'>link<\/a>\n<\/td>\n<td>\n<a target=_blank title='mime.types' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/mime.types_GETME\">mime.types<\/a> <a target=_blank title='MIME' href='http:\/\/en.wikipedia.org\/wiki\/MIME'>link<\/a>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>rpm <a target=_blank title='RPM Package Manager' href='http:\/\/en.wikipedia.org\/wiki\/RPM_Package_Manager'>link<\/a>\n<\/td>\n<td>\napt <a target=_blank title='Advanced Packaging Tool' href='http:\/\/en.wikipedia.org\/wiki\/Advanced_Packaging_Tool'>link<\/a>\n<\/td>\n<td>\nyum <a target=_blank title='Yellowdog Updater, Modified' href='http:\/\/en.wikipedia.org\/wiki\/YUM_%28software%29'>link<\/a>\n<\/td>\n<\/tr>\n<tr>\n<td>\ncPanel <a target=_blank title='cPanel' href='http:\/\/en.wikipedia.org\/wiki\/CPanel'>link<\/a>\n<\/td>\n<td>\npecl <a target=_blank title='PHP Extension Community Library' href='http:\/\/en.wikipedia.org\/wiki\/PECL'>link<\/a>\n<\/td>\n<td>\n<a target=_blank title='pear' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/pear.conf_GETME\">pear<\/a> <a target=_blank title='PHP Extension and Application Repository' href='http:\/\/en.wikipedia.org\/wiki\/PEAR'>link<\/a>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>module <a target=_blank title='module' href='http:\/\/pear.php.net\/manual\/en\/package.database.mdb2.intro-module.php'>link<\/a>\n<\/td>\n<td>\nplugin <a target=_blank title='plugin' href='http:\/\/en.wikipedia.org\/wiki\/Plug-in_%28computing%29'>link<\/a>\n<\/td>\n<td>\nextension <a target=_blank title='software extension' href='http:\/\/en.wikipedia.org\/wiki\/Software_extension'>link<\/a>\n<\/td>\n<\/tr>\n<tr>\n<td>\n.inc files <a target=_blank title='.inc files' href='http:\/\/en.wikipedia.org\/wiki\/Server_Side_Includes'>link<\/a>\n<\/td>\n<td>\n$_SERVER variables <a target=_blank title='$_SERVER variables' href='http:\/\/us2.php.net\/reserved.variables.server.php'>link<\/a>\n<\/td>\n<td>\nenvironment variables <a target=_blank title='environment variables' href='http:\/\/php.net\/manual\/en\/reserved.variables.environment.php'>link<\/a>\n<\/td>\n<\/tr>\n<\/table>\n<p>Link to some downloadable PHP programming source code to show phpinfo() information (rename to <a target=_blank title='phpinfo.php' href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/Configuration\/phpinfo.php_GETME\">phpinfo.php<\/a>).<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d785' onclick='var dv=document.getElementById(\"d785\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=PHP\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d5021' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Some people like to study things before starting to use it. Some people tackle things head on straight away. Either way, as far as Apache\/PHP\/MySql web hosting goes, it is good to understand some of the configuration of this hosting. &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/apachephpmysql-configuration-primer-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,12,29,33,37],"tags":[85,249,299,792,827,932,2119,1558,2115,1319,1400,1411],"class_list":["post-5021","post","type-post","status-publish","format-standard","hentry","category-database","category-elearning","category-operating-system","category-software","category-tutorials","tag-apache","tag-configuration","tag-database-2","tag-mime","tag-mysql","tag-php","tag-php-ini","tag-phpinfo","tag-robot-txt","tag-tutorial","tag-web","tag-web-server"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/5021"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=5021"}],"version-history":[{"count":1,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/5021\/revisions"}],"predecessor-version":[{"id":14946,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/5021\/revisions\/14946"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=5021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=5021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=5021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}