1 – Which version of Sqlite generated?
2 – Allows for paging LIMIT ?
SQLite version 2. The standard functions (selectAll() and loadByFields() that pull the data accept the “limit” parameter, as well as “group” for group by and “order” for the order by condition.
Dose this support Sqlite3 ?
I cannot tell you for sure, I only could try in on version 2. If you have v3 supported on your server, you can send me a v3 database and I will test it and tell you if it’s supported. Just contact me by email.
it is not working with sqlite3 version. COuld you help me to solve this
It has only been tested with SQLite v2. Can you send me by email your database under v3 with the default article table?
As I said it to @sibisan, I am ready to see how to adapt it to sqlite3, but I need your help for that because my server is not supporting that version
You can use the same db (database.db) form your example to make the correct calls for sqlite3.
I was getting and error about not finding SQLiteDatabase class so
Ived changed the “new SQLiteDatabase()” to “new SQLite3()” and then the error changed to “Error 2” //db owner different from the web server’s one ‘your comment’
If you can adept this to work with sqlite 3 i well buy it again
If not , well ill just have to wait until i get the chance to use it with normal sqlite.
Nice script btw.
You don’t need to buy it again if you already did. Nice to propose
Will definitely look into it very soon and try to have the 2 versions supported in the same time (by having a version parameter to declare for ex or something like that).
@sibisan support to SQLite3 has been added.
The framework is now supporting SQLite2 as well as SQLite3. You will just need to update the version number to “3” in the “Db_connection.php” file as specified in the documentation to have it working with SQLite3 databases.
Wow , nice.
Thanks yougapi, ill test it tomorrow .
If i’m use custom query.
do i need to gen genClass.php?
i just want create instane for query.
$a1 = $new->DB()
do query with custom query
because if i’m want to join 2 table may be its can not do it.
Any suggest?. Thank
You can try to instantiate the SQLiteTable with
$t1 = new SQLiteTable('your_table_name');
I am creating a Mobile Web App, I have a MySql database. It all works fine, but I want to “sync” or cache a PHP files and/or database, so when a user does not have internet connection, they could still be able to view the information.
Is this the right script for it? Or any tips or links on how to accomplish this.
SQLite still needs a server to be supported. I know that Firefox is using an SQLite database to store user settings etc, but cannot help you more than that. This item needs PHP to run.
The script has a function to create tables and fields?
Yes sure, it has a function that can be used to execute queries.
the example does not work out of the box, and I am tired to check out what is wrong.
PHP Fatal error: Class ‘SQLiteDatabase’ not found in ///Db_connection.php on line 41
You probably forget to include the correct file, please send me a link and temporary FTP and will help you out, you can contact me through my profile page, thanks
Does ist support SQLite through PDO ?
No, it’s using classes (no PDO )
Unfortunately on every shared hosting environment I use, SQLite 3 is only available through PDO . The other access methods connect with the old SQLite 2 version. As I hear, this is very common behaviour. However, this makes your code a less than ideal solution for me, since I want to use SQLite 3…
Cool, please thread your comments using the reply button situated ta the bottom of your first posted comment, thanks
Will continue to support the script, because i see that already more than 3 years of not releasing updates?
The script is still working just fine and we are using it for some of our own projects
What about SQLite3 and PDO?
Currently it’s supporting SQLite2 that’s still running just fine. PDO is not required by this class
Well, i now buy this script, and hope you will develop and maintain and further…
By the way, i can give you a russian version of the documentation for the new buyers of your script.
Good luck in your new sales.
How do i make a request to a database similar to the query mysql mysql_query('set names utf8'); for that to russian words appear correctly in the database?
Now at me instead of russian words – characters…
mysql_query('set names utf8');
I don’t think that would work, nor if sqlite supports that kind of functions. I would suggest to encode the characters in UTF8 before storing them
How to do it?
That really depend on your program and how it’s encoded etc, you need to see with your programmer
i get this error on local-host
Fatal error: Class ‘SQLiteDatabase’ not found in C:\wamp64\www\sqlite\sqlite_framework\Db_connection.php on line 41
I can help you if you put it online and send me a link and temporary FTP access, if you are having the same issue
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Get it now and save up to $2.50
Unlimited downloads only
$29 p/m on Envato Elements
Download over 18,000 items now
Learn almost anything with
Envato Tuts+ for free
9000 free tutorials, 3000 paid courses
Designers matched perfectly to
you on Envato Studio
2000 artists ready to undertake your work