install-apache-php-mysql.php.htm

complete details about using SQL applications

        <p> C:\mysql\bin&gt;mysqladmin -u root shutdown</p>
        <p><strong>C:\mysql\bin&gt;mysqld-nt --install</strong><br>
            Service successfully installed. </p>
        <p>C:\mysql\bin&gt;net start mysql</p>
        <p>The MySQL service was started successfully.</p>
        <p><br>
            C:\mysql\bin&gt;mysql<br>
            Welcome to the MySQL monitor. Commands end with ; or \g.<br>
            Your MySQL connection id is 1 to server version: 4.0.18-nt</p>
        <p>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.</p>
        <p>mysql&gt;</p>
    </div><p></p></td>
 </tr>
</tbody></table>
<table align="center" border="0" cellspacing="0" width="650">
 <tbody><tr> 
  <td class="maincell" background="install-apache-php-mysql.php_files/bg2.gif">
    <p><a name="phpconf">&nbsp;</a></p>
    <h2>Modifying PHP Configuration File ( php.ini )</h2>
    <p>PHP stores all kinds of configuration in a file called <span class="courier">php.ini.</span>You 
        can find this file in the directory where you installed PHP. Sometimes 
        you will need to modify this file for example to use a PHP extension. 
        I won't explain each and every configuration available just the ones that 
        often need modification or special attention. </p>
    <p>Some of the configurations are : </p>
    <ol>
        <li>register_globals</li>
        <li>error_reporting and display_errors</li>
        <li>extension and extension_path</li>
        <li>session.save_path</li>
        <li>max_execution_time</li>
    </ol>
    <h3>register_globals</h3>
    <p>Before PHP 4.2.0 the default value for this configuration is <strong>On</strong> 
        and after 4.2.0 the default value is <strong>Off. </strong>The reason 
        for this change is because it is so easy to write <strong>insecure </strong>code 
        with this value on. So make sure that this value is Off in php.ini.</p>
    <h3>error_reporting and display_errors</h3>
    <p>Set the value to <span class="courier">error_reporting = E_ALL</span> during 
        development but after production set the value to <span class="courier">error_reporting 
        = E_NONE</span> . </p>
    <p>The reason to use E_ALL during development is so you can catch most of 
        the nasty bugs in your code. PHP will complain just about any errors you 
        make and spit out all kinds of warning ( for example if you're trying 
        to use an uninitialized variable ). </p>
    <p>However, after production you should change the value to E_NONE so PHP 
        will keep quiet even if there's an error in your code. This way the user 
        won't have to see all kinds of PHP error message when running the script. 
    </p>
    <p>One important thing to note is that you will also need to set the value 
        of <span class="courier">display_erros</span> to On. Even if you set <span class="courier">error_reporting 
        = E_ALL</span> you will not get any error message ( no matter how buggy 
        our script is ) unless <span class="courier">display_errors</span> is 
        set to On.</p>
    <h3>extension and extension_path</h3>
    <p>PHP4 comes with about 51 extensions such as GD library ( for graphics creation 
        and manipulation ), CURL, PostgreSQL support etc. These extensions are 
        not turned on automatically. If you need to use the extension, first you 
        need to specify the location of the extensions and then uncomment the 
        extension you want. </p>
    <p>The value of <span class="courier">extension_path</span> must be set to 
        the directory where the extension is installed which is PHP_INSTALL_DIR/extensions, 
        with PHP_INSTALL_DIR is the directory where you install PHP. For example 
        I installed PHP in <span class="courier">C:\Program Files\Apache Group\Apache2\php</span> 
        so the extensions path is<span class="phpcode"> :<br>
        </span><span class="phpcode"><br>
    </span><span class="courier">extension_path =<span class="courier"> C:/Program 
    Files/Apache Group/Apache2</span>/php/extensions/ </span></p>
    
   <p>Don't forget to add that last slash or it won't work</p>
    <p>After specifying the <span class="courier">extension_path</span> you will 
        need to uncomment the extension you want to use. In <span class="courier">php.ini</span> 
        a comment is started using a semicolon <span class="courier">(;). </span>As 
        an example if you want to use GD library then you must remove the semicolon 
        at the beginning of <span class="courier">;extension=php_gd2.dll</span><span class="phpcode"> 
        </span>to <span class="courier">extension=php_gd2.dll</span></p>
    <h3>session.save_path</h3>
    <p>This configuration tells PHP where to save the session data. You will need 
        to set this value to an existing directory or you will not be able to 
        use session. In Windows you can set this value as <span class="courier">session.save_path 
        = c:/windows/temp/</span></p>
    <h3>max_execution_time</h3>
    <p>The default value for<span class="courier"> max_execution_time</span> is 
        30 ( seconds ). But for some scripts 30 seconds is just not enough to 
        complete it's task. For example a database backup script may need more 
        time to save a huge database.</p>
    <p> If you think your script will need extra time to finish the job you can 
        set this to a higher value. For example to set the maximun script execution 
        time to 15 minutes ( 900 seconds ) you can modify the configuration as<span class="phpcode"> 
        </span><span class="courier">max_execution_time = 900</span></p>
    <p>PHP have a convenient function to modify PHP configuration in runtime, 
        <span class="phpcode">ini_set()</span>. Setting PHP configuration using 
        this function <strong>will not</strong> make the effect permanent. It 
        last only until the script ends. </p>
    <hr align="left" noshade="noshade" width="200">
    <p>That's it, now you have Apache, PHP and MySQL installed and running smoothly. 
        It's time to move on to the next section, <a href="http://www.php-mysql-tutorial.com/php-tutorial.php">PHP 
        Tutorial</a>.</p>
		</td>
 </tr>
</tbody></table>
<!-- google_ad_section_end -->
<!-- google_ad_section_start(weight=ignore) -->
<table align="center" border="0" cellspacing="0" width="650">
 <tbody><tr> 
        <td class="maincell" background="install-apache-php-mysql.php_files/bg2.gif">
		<p>&nbsp;</p>
		<script type="text/javascript"><!--
google_ad_client = "pub-0502328448303498";
google_alternate_ad_url = "http://www.php-mysql-tutorial.com/library/adsense/google_adsense_script.html";
google_ad_width = 234;
google_ad_height = 60;
google_ad_format = "234x60_as";
google_ad_type = "text";
google_ad_channel ="9236520829";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "000080";
google_color_text = "000000";
google_color_url = "666666";
//--></script>
<script type="text/javascript" src="install-apache-php-mysql.php_files/show_ads">
</script><iframe name="google_ads_frame" src="install-apache-php-mysql.php_files/ads_002.htm" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" frameborder="0" height="60" scrolling="no" width="234"></iframe>
<script type="text/javascript"><!--
google_ad_client = "pub-0502328448303498";
google_alternate_ad_url = "http://www.php-mysql-tutorial.com/library/adsense/google_adsense_script.html";
google_ad_width = 234;
google_ad_height = 60;
google_ad_format = "234x60_as";
google_ad_type = "text";
google_ad_channel ="1778144253";
google_color_border = "CC0000";
google_color_bg = "FFFFFF";
google_color_link = "000080";
google_color_text = "000000";
google_color_url = "666666";
//--></script>
<script type="text/javascript" src="install-apache-php-mysql.php_files/show_ads">
</script><iframe name="google_ads_frame" src="install-apache-php-mysql.php_files/ads_003.htm" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" frameborder="0" height="60" scrolling="no" width="234"></iframe></td>
 </tr>
</tbody></table>
<table align="center" background="install-apache-php-mysql.php_files/bg3.gif" border="0" cellpadding="0" cellspacing="0" height="22" width="650">
 <tbody><tr> 
  <td>&nbsp;</td>
 </tr>
</tbody></table>

<p>&nbsp;</p>
<table class="text" align="center" border="0" cellpadding="5" cellspacing="0" width="650">
 <tbody><tr> 
  <td width="30">
  <a href="http://www.php-mysql-tutorial.com/index.php"><img src="install-apache-php-mysql.php_files/prev.gif" border="0" height="20" width="30"></a>
  
  </td>
  <td align="center" width="33%"><a href="http://www.php-mysql-tutorial.com/index.php">HOME</a></td>
  <td width="33%"><strong><a href="http://www.php-mysql-tutorial.com/index.php">PHP MySQL Tutorial</a>  : Installing Apache PHP MySQL</strong></td>
  <td align="center" width="33%"><a href="http://www.php-mysql-tutorial.com/php-tutorial/index.php">PHP Tutorial</a></td>
  <td width="30">
  
  <a href="http://www.php-mysql-tutorial.com/php-tutorial/index.php"><img src="install-apache-php-mysql.php_files/next.gif" border="0" height="20" width="30"></a>
    
  </td>
 </tr>
</tbody></table>
<div align="center">
<!-- SiteSearch Google -->
<form method="get" action="http://www.php-mysql-tutorial.com/search.php" target="_top">
<table bgcolor="#ffffff" border="0">
<tbody><tr><td align="left" height="32" nowrap="nowrap" valign="top">
<a href="http://www.google.com/">
<img src="install-apache-php-mysql.php_files/Logo_25wht.gif" alt="Google" align="middle" border="0"></a>
</td>
<td nowrap="nowrap">
<input name="domains" value="www.php-mysql-tutorial.com" type="hidden">
<input name="q" size="31" maxlength="255" value="" type="text">
<input name="sa" value="Search" type="submit">
</td></tr>
<tr>
<td>&nbsp;</td>
<td nowrap="nowrap">
<table>
<tbody><tr>
<td>
<input name="sitesearch" value="" checked="checked" type="radio">
<font color="#000000" size="-1">Web</font>
</td>
<td>
<input name="sitesearch" value="www.php-mysql-tutorial.com" type="radio">
<font color="#000000" size="-1">www.php-mysql-tutorial.com</font>
</td>
</tr>
</tbody></table>
<input name="client" value="pub-0502328448303498" type="hidden">
<input name="forid" value="1" type="hidden">
<input name="channel" value="3745163033" type="hidden">
<input name="ie" value="ISO-8859-1" type="hidden">
<input name="oe" value="ISO-8859-1" type="hidden">
<input name="safe" value="active" type="hidden">
<input name="cof" value="GALT:#008000;GL:1;DIV:#FFFFFF;VLC:663399;AH:center;BGC:FFFFFF;LBGC:FFFFFF;ALC:0000FF;LC:0000FF;T:000000;GFNT:0000FF;GIMP:0000FF;FORID:11" type="hidden">
<input name="hl" value="en" type="hidden">
</td></tr></tbody></table>
</form>
<!-- SiteSearch Google -->
</div>
<table align="center" background="install-apache-php-mysql.php_files/bg1.gif" border="0" cellpadding="0" cellspacing="0" height="22" width="650">
 <tbody><tr> 
  <td>&nbsp;</td>
 </tr>
</tbody></table>
<table align="center" border="0" cellspacing="0" width="650">
 <tbody><tr> 
        <td class="maincell" background="install-apache-php-mysql.php_files/bg2.gif">This 
            tutorial is far from perfect so if you have any <strong>critiques, 
            questions, comments or problems</strong> about this tutorial please 
            tell me. <a href="http://www.php-mysql-tutorial.com/contact.php">Click here to send your feedback</a>. 
            And if you like this tutorial please link to this site. It will really 
            help a lot :-) </td>
 </tr>
</tbody></table>
<table align="center" background="install-apache-php-mysql.php_files/bg3.gif" border="0" cellpadding="0" cellspacing="0" height="22" width="650">
 <tbody><tr> 
  <td>&nbsp;</td>
 </tr>
</tbody></table>
<p>&nbsp;</p>
 
<p align="center"><a href="http://www.scriptlance.com/cgi-bin/freelancers/r.cgi?arman198" rel="nofollow"><img src="install-apache-php-mysql.php_files/keybanner.gif" alt="Get custom programming done at ScriptLance.com!" border="0" height="60" width="468"></a></p>


<p align="center">&nbsp;</p>
<table style="font-family: Arial,Helvetica,sans-serif; font-size: 12px;" align="center" width="650">
  <tbody><tr>
    <td style="border: 1px dashed rgb(255, 153, 0); padding: 10px;"><p>My Experimental Sites</p>
      <p>1. <a href="http://www.allclothingstore.com/women-apparel/">Women</a>, <a href="http://www.allclothingstore.com/men-apparel/">Men</a>, <a href="http://www.allclothingstore.com/kids-baby-apparel/">Kids &amp; Baby Apparel Store</a> 
                        2. <a href="http://www.alldvdmovie.com/kids-family/characters-series-dvd/crocodile-hunter-dvd/">Crocodile Hunter DVD</a> 
						3. <a href="http://www.kitchenhouse.org/small-appliances/mixers/stand-mixers/">KitchenAid Mixers</a> 
						4. <a href="http://www.funplushtoys.com/action-figures-accessories/">Action Figure Set</a> 
						5. <a href="http://www.allhappybaby.com/baby-clothing-layette/">Baby Clothing &amp; Layette</a> 
						6. <a href="http://www.php-mysql-tutorial.com/book-store/">Computer Book Store</a>
						7. <a href="http://www.plaincart.com/power-tools/">Power Tools</a>
						8. <a href="http://www.whizzgiz.com/">Online Electronic Store</a></p>	  </td>
  </tr>
</tbody></table>

 
<br>
<br>
<p align="center">
 Copyright