| Re: sqlite2 vs sqlite3 [message #185360 is a reply to message #185358] |
Thu, 20 March 2014 08:31   |
shraddha.khandke
Messages: 3
Registered: March 2014
Karma:
|
Junior Member |
|
|
On Thursday, March 20, 2014 1:12:19 PM UTC+5:30, shraddha...@gmail.com wrote:
> On Saturday, August 30, 2008 9:23:46 AM UTC+5:30, john6630 wrote:
>
>> On Aug 29, 2:57 pm, "JC" <jcarl...@127.0.0.1> wrote:
>
>>> "john6630" <john6...@hotmail.com> wrote...
>
>>>
>
>>> : I only find php.ini and php5.ini and I changed both of them. I also
>
>>> : downloaded php_pdo_sqlite.dll and replaced the one in my /ext/
>
>>> : directory.
>
>>> :
>
>>> : What I have found is that if I change my code from
>
>>> :
>
>>> : /*** connect to SQLite database ***/
>
>>> : $dbh = new PDO("sqlite2:./johns.db");
>
>>> :
>
>>> : It does connect via PDO but again using sqlite2. So I am at a loss.
>
>>> : Seems like something wrong in my PHP or DLL. But I do not know about
>
>>> : rebuilding such things.
>
>>> :
>
>>> : Any other suggestions?
>
>>>
>
>>> Try
>
>>> $dbh = new PDO("sqlite3:./johns.db");
>
>>>
>
>>> I believe sqlite: defaults to version 2. The other thing I'll mention
>
>>> is that php5.ini are the suggested settings for PHP version 5. Sounds
>
>>> like you might have a version of XAMPP installed which I think installs
>
>>> two versions of PHP as well as Apache, Perl, MySQL, SQLite, et al.
>
>>>
>
>>> Apache Version 2 (not sure if a specific subversion is required) supports
>
>>> a PHPIniDir directive, see
>
>>>
>
>>> http://www.php.net/manual/en/install.windows.apache2.php
>
>>>
>
>>> for documentation. They show PHPIniDir getting configured inside the
>
>>> httpd.conf file as follows, you will need to change the folder to
>
>>> point to the appropriate folder in which your php.ini file resides:
>
>>>
>
>>> PHPIniDir "C:/php"
>
>>>
>
>>> NOTE, it does NOT provide a way to change the name of PHP.INI, so
>
>>> I can not help in regards as how to configure Apache to use BOTH the
>
>>> PHP4 and PHP5. My understanding has always been that ONE and ONLY ONE
>
>>> version of PHP gets installed, but then again I've never tried to run
>
>>> two different versions at the same time. I just do not see a way to
>
>>> configure the:
>
>>>
>
>>> AddType application/x-httpd-php .php
>
>>>
>
>>> without recompiling and changing that Type string.
>
>>>
>
>>> The php_pdo_sqlite.dll is the file representing version 3 methods for
>
>>> accessing, creating and updating SQLite version 3 data files. And then
>
>>> php_sqlite.dll represents the file for accessing SQLite Version 2 of
>
>>> the data files. I started a webpage last year, but never finished it,
>
>>> detailing how to create and access the different files.
>
>>>
>
>>> http://www.microcosmotalk.com/tech/windows/php/sqlite/
>
>>>
>
>>> The details are accurate but incomplete. If it's helpful, let me know,
>
>>> if something needs to get updated or is confusing, please let me know
>
>>> and I will update it.
>
>>>
>
>>> I'll watch this thread for any and all replies as I need to complete
>
>>> the information there.
>
>>>
>
>>> Can you offer some more information about your Apache/PHP install?
>
>>>
>
>>> --
>
>>> Jim Carlock
>
>>> You Have More Than Five Senseshttp://www.associatedcontent.com/article/381163/more_than_five_senses ...
>
>>
>
>> I found the answer!!! From the XAMP website FAQ
>
>> http://www.apachefriends.org/en/xampp-windows.html
>
>>
>
>>
>
>> * Question 6: Where can I change the configuration?
>
>> You adjust XAMPP settings with plain-text configuration files. The
>
>> following files exist:
>
>>
>
>> * Apache basic configuration: .\xampp\apache\conf\httpd.conf
>
>> * Apache SSL: .\xampp\apache\conf\ssl.conf
>
>> * Apache Perl (only addon): .\xampp\apache\conf\perl.conf
>
>> * Apache Tomcat (only addon): .\xampp\apache\conf\java.conf
>
>> * Apache Python (only addon): .\xampp\apache\conf\python.conf
>
>> * PHP: .\xampp\apache\bin\php.ini
>
>> (with the apache actually running php version)
>
>> * MySQL: .\xampp\mysql\bin\my.cnf
>
>> * phpMyAdmin: .\xampp\phpMyAdmin\config.inc.php
>
>> * FileZilla FTP: .\xampp\FileZillaFTP\FileZilla Server.xml
>
>> * Mercury Mail basic configuration: .\xampp\MercuryMail
>
>> \MERCURY.INI
>
>> * Sendmail: .\xampp\sendmail\sendmail.ini
>
>>
>
>> I suddenly realized I was changing the php.ini file in the EXT
>
>> directory not the ./xampp/apache/bin/ directory!! Changed it by
>
>> uncommenting the php_pdo_sqlite extension and it worked great. So as
>
>> purcaholic said, I was changing the wrong php.ini file! I should have
>
>> went to the XAMPP site to begin with...live and learn. Thanks for
>
>> everyone's help.
>
>>
>
>> John
>
>
>
> I am using mapguide server for gis application in which php is installed and trying to use pdo but having the same problem and it's not working and having eception 'Driver not found'. Also I have checked the apache httpd.config it gives same path.Any help will be apreciated.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]