Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "J.O. Aho" Newsgroups: comp.lang.php Subject: Re: Looking for relational database programmed in PHP Date: Sun, 22 Dec 2019 15:35:49 +0100 Lines: 26 Message-ID: References: <9b0999a1-9995-46a3-b976-361345a63665@googlegroups.com> <404fd6b4-386b-45e3-9f12-d584b29c13f2@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net +ud+JbXLFTamKxfz+8d39Aqt9KsBFI5wbBcgiixXEopGxtIXN/ Cancel-Lock: sha1:p98fkYvUHkjW9cJv05KE2m6ZPec= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.3.0 In-Reply-To: <404fd6b4-386b-45e3-9f12-d584b29c13f2@googlegroups.com> Content-Language: en-US-large Xref: csiph.com comp.lang.php:18134 On 21/12/2019 14:20, robamman2019@gmail.com wrote: > reede, 20. detsember 2019 21:28.41 UTC+2 kirjutas J.O. Aho: >> On 20/12/2019 18:44, robamman2019@gmail.com wrote: >> >>> The problem, why I made this topic is mainly because I don't want again to set up the database, when my webpage goes down. I am willing to find a new(free) place for it, but I don't want to start looking out the mysql database address and user name and password and so on. I want everything to be automatic. >> >> Then use sqlite, here it's just a question about the location of the >> database file, which in your case would be the same documentroot >> directory as where you have the php pages at. >> >> $db = new SQLite3("mydatabasefile.db"); >> >> No passwords to be remembered, if you want you can encrypt the database, >> then you need to encryption key. I do recommend that you use .htaccess >> file to deny access to the database file (of course that works only on >> apache web servers that allows user defined configurations). >> > > No. Sqlite requires sqlite extension to be enabled in php.ini. Which is default for php installations on the worlds most popular operating system. -- //Aho