| Re: sqlite2 vs sqlite3 [message #185358] |
Thu, 20 March 2014 07:42  |
shraddha.khandke
Messages: 3
Registered: March 2014
Karma:
|
Junior Member |
|
|
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 map guide server for gis application in which php is installed and trying to use pdo but having the same problem and it's not working. Also I have checked the apache httpd.config it gives same path.Any help will be apreciated
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]