Re: How to access MySQL through PHP in windows 2K.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks everybody, especially Praveen and James.  After checking for hidden
file extension, and modifying my path and still not having the working
test.php program, I checked the error log.

The book I am reading from, tells me to put the following line in my php.ini
file

extension=php_mysqli.dll

And I did it.

My PHP was trying to load this module and was not finding it.  It caused all
the problems.

So  everybody, if you are following Welling and Tho9mson book, ignore the
above mentioned line.  And your first program will work fine.

Thanks once again.

nagrik


On Mon, May 4, 2009 at 4:36 AM, James Crow <james@xxxxxxxxxxxxx> wrote:

> Vinay,
>
>  The first thing I would do is turn on file extension display. There is a
> php.ini file in your php folder; Windows is just hiding the file extension.
> Open My Computer and then go to Tools->Folder Options->View and uncheck
> "Hide extensions for know file types". IMO one of the worst ideas in
> Windows. Once that is done you should see the php.ini (although you may have
> renamed it to php.ini.ini) file. You should also be able to find the apache
> log file in case of errors. Praveen was right about everything he wrote.
> Follow that and you should be well on your way.
>
>  I do wonder why you have filenames in your path variable. Normally it is
> only directory names. I would think that you only need "C:\Program
> Files\PHP" as part of your PATH variable.
>
> Cheers,
> James
>
> Vinay Nagrik wrote:
>
>>  Hello Praveen and everybody,
>>
>> Sorry about the name confustion (Parveen only).
>>
>> 1. Here is my path variable.  Take a look at last four env. variables.
>> I am working on php2_2 and there were four of those .dll files, as
>> mentioned
>> in the environment variable.
>>
>> ###########
>> C:\Documents and Settings\Administrator>set path
>> Path=C:\Program
>> Files\PHP\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wb
>> em;C:\Program Files\Intel\DMIX;C:\Program Files\Common Files\Roxio
>> Shared\DLLSha
>> red\;C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared\;c:\Program
>> Files
>> \Microsoft SQL Server\90\Tools\binn\;*C:\Program
>> Files\PHP\php5apache2_2_filter.d
>> ll;C:\Program Files\PHP\php5apache2_2.dll;C:\Program
>> Files\PHP\php5ts.dll;C:\Pro
>> gram Files\PHP\php5apache_hooks.dll*
>> ###########
>>
>> 2. My httpd.conf file has these lines
>>
>> ############
>> #BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL
>> PHPIniDir "C:/Program Files/PHP/"
>> LoadModule php5_module "C:/Program Files/PHP/php5apache2_2.dll"
>> #END PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL
>> AddType applicaton/x-httpd-php .php
>> ############
>>
>> Although book mentions some other .dlls like; (pdflib.dll, gd2.dll, and
>> impa.dll).  But I did not find them in my PHP dir.
>>
>> 3. My test.php looks like and resides in htdocs dir.
>>
>> ##########
>> <?php phpinfo() ?>
>> ##############
>>
>> 4. In the PHP directory, I did not find any "php.ini.recommended or
>> php.ini"
>> file.  The only file I found was "php" without any extension.  However, I
>> provided the extension and it is now "php.ini" instead of "php".
>>
>> 5. My httpd server works fine with .html files, which also reside in
>> htdocs
>> dir.
>>
>> It is still giving me 404 error for any .php file either test.php or any
>> other .php extended file.
>>
>> I am sure it is configuration problem, but can not figure it out myself.
>> Please help.
>>
>> thanks.
>>
>> vinay nagrik.
>> On Thu, Apr 30, 2009 at 10:49 AM, Katiyar (GMail) <katiyar76@xxxxxxxxx
>> >wrote:
>>
>>
>>
>>>   Hi Vinay,
>>>
>>> btw, my name is praveen, and my surname is katiyar and not kalyan.
>>>
>>> I assume that you are doing all this on a windows box. to start apache
>>> automatically it has to be installed as service.
>>> and for executing PHP scripts you need to do several things, only after
>>> that PHP scripts can be executed.
>>>
>>> Add PHP path (where you have unzipped the PHP) to PATH variable so that
>>> windows is able to find these dlls,
>>> these dlls are from *PHP 5.2.8*, if your version is different (say 4.x.x)
>>> the name will be slightly different (php4apache.dll, php4ts.dll).
>>>
>>>   - php5apache.dll
>>>   - php5ts.dll
>>>
>>> in the php folder you will find php.ini-dist and php.ini.recommended
>>>
>>> rename *php.ini.recommended *to* php.ini*
>>> **
>>> now open *httpd.conf* which will be present in [<Apache>\conf]  folder
>>> add
>>> these two lines if they are not present.
>>>
>>> *LoadModule php5_module modules/php5apache.dll*
>>> *AdType application /x-httpd-php .php *
>>> **
>>> So, now configuration is complete.
>>>
>>> Stop and restart web server (apache).
>>>
>>> write a small file as
>>>
>>> <?php
>>>    phpinfo ();
>>> ?>
>>>
>>> save as *test.php* in your web server folder.
>>>
>>> now in the browser put the address as
>>>
>>> http://localhost/test.php
>>>
>>> and it should show the PHP Information. and  I hope that this will be
>>> helpful.
>>>
>>>
>>> praveen.
>>>
>>>
>>> ----- Original Message -----
>>>  *From:* Vinay Nagrik <vnagrik@xxxxxxxxx>
>>> *To:* Katiyar (GMail) <katiyar76@xxxxxxxxx>
>>> *Sent:* Wednesday, April 29, 2009 10:20 PM
>>> *Subject:* Re:  How to access MySQL through PHP in windows 2K.
>>>
>>> Hello Kalyan,
>>>
>>> I am a beginner just like you.  However, it appears that you are few
>>> steps
>>> ahead of me.
>>>
>>> I have httpd Apache web server installed, and it is supposed to start
>>> automatically.  However, it does not start automatically.  Attempts to
>>> start
>>> it manually either as a user or as an administrator fail with error
>>> messages
>>> and requirements of password to start Apache.  I have not set up a
>>> password
>>> for Apache.
>>>
>>> Anyway, it should  have started manually.  Can you tell me what am I
>>> doing
>>> wrong or which file I need to configure.
>>>
>>> I once noticed even if 'apache' was working it only showed .html pages
>>> and
>>> not .php pages.
>>>
>>> Can you help.
>>>
>>> nagrik
>>>
>>> On Tue, Apr 28, 2009 at 4:42 AM, Katiyar (GMail) <katiyar76@xxxxxxxxx
>>> >wrote:
>>>
>>>
>>>
>>>>  Hi List,
>>>>
>>>>
>>>> I am new to PHP and as well as with MySQL,
>>>>
>>>>
>>>>   - I have installed PHP 5.28, on win 2K  (with IIS) and it is installed
>>>>   properly I suppose, as when I call phpinfo (), through a script, it
>>>> shows
>>>>   the PHP Information.
>>>>   - then I installed MySQL 5.1.30, and through MySQL command prompt I
>>>>   am  able to do things (creating tables, making queries etc).
>>>>   - Now I want to use MySQL with PHP, but seems that MySQLI is not
>>>>   installed properly. as when I write a following script in a php page I
>>>> get
>>>>   the error, that 'MySQLi'* *is not installed properly,.
>>>>
>>>>            *<?php
>>>>          $si = function_exists ( 'mysqli_connect' ) ;
>>>>          if ( $si )
>>>>          {
>>>>              echo ' MySQLi appears to be installed correctly ' ;
>>>>          }
>>>>          else
>>>>          {
>>>>              echo 'MySQLi <B> does not </B> appears to be installed. ' ;
>>>>          }
>>>>      ?>*
>>>>
>>>> I understand that it is a configuration error somewhere, as I am new
>>>> here
>>>> in this world I am unable to figure out what ?
>>>>
>>>> I am attaching the php.ini for the reference.
>>>>
>>>>
>>>> Praveen K.
>>>>
>>>> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=
>>>> Praveen Katiyar
>>>>
>>>> Site : http://praveenkatiyar.co.cc
>>>> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=
>>>>
>>>>    PHP Windows Mailing List (http://www.php.net/)
>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>
>>>>
>>>>
>>>
>>> --
>>> Thanks
>>>
>>> Nagrik
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>


-- 
Thanks

Nagrik

[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux