Tag: sqlite

Laravel 6 PHPUnit Testing – could not find driver (SQL: PRAGMA foreign_keys = ON;)

I’m started to write tests in Laravel. My application works, I can login, run migrations, but when I’m trying to test the login, I’m getting the following error: could not find driver (SQL: PRAGMA foreign_keys = ON;) My DB is in Postgres, and my test is as follows: I’m not worried (for now) if my test is good enough or

How to avoid code repetition with PHP SQL prepared statements?

php prepared-statement sql sql-insert sqlite

In most examples of SQL PHP prepared statements that I see, such as: the field names are nearly repeated … 4 times! once after the INSERT INTO(…): task_name (column name in SQL) once after the VALUES(…): :task_name once in the dictionary key: :task_name once in the dictionary value: $taskName (local variable) I understand that each of these have a different

How do I add a new key value pair to an object in PHP?

arrays object php sqlite

I guess my question is two-fold In Python if I do this I’ve created a dictionary In javaScript if I do the same thing I’ve created an object What is that in PHP? It could just be that I don’t know the terms I’m working on a project with laravel. I basically have an sqlite database which I am accessing.

Trying to upgrade sqlite on Amazon EC2

mediawiki php sqlite

I need SQLite minimum version 3.8 to support a MediaWiki install on Amazon EC2. Amazon Linux is based on CentOS and the latest version available in the yum repository is SQLite 3.7.17. The downloads …

convert sqlite data to json using php

json php sqlite

I’m trying to convert sqlite query into json. I have the following table with two columns name and age. When I print the query the format doesn’t seem to be correct. why am I getting an extra key value pair? output desired output Answer Change query to get only those column which are required: And then use SQLITE3_ASSOC Reference:- SQLite3Result::fetchArray

SQLite3 (PHP Fatal error: Call to a member function exec())

php sqlite

I’ve been innstall and add conf: I have installed the necessary components and added to the configuration file line, maybe in php.ini need to add something? Answer Unless Im missing something your protected $_db may never get set so you cannot call exec() on null. It will never get set if this does not equal true – You should check

Foreach loop not working for sqllite in php

database foreach php sqlite while-loop

I want to use foreach for looping instead of while loop in the below code. But for some reason the foreach loop is not working as I expected. Can please help me with this. THis is the code I Used. Answer This piece of code worked for me.

Sqlite PDO query returns no results

pdo php sql sqlite

Getting no results no matter how broad my query PHP: 5.3 Sqlite3: 3.6 PDO: 5.3.3 I would think this should be a very simple process but even looking around I still don’t know why I’m getting 0 results. Here is my code: Any ideas on what I am doing wrong? The ‘foo’ table will only have four columns, and this

what is the difference between sqlite3 and pdo_sqlite

php sqlite

I’m migrating my web application from MySQL to SQLite database. I found out there are two PHP extensions for communicating with sqlite: php_sqlite3.dll and php_pdo_sqlite.dll. What extension is better? Or another question: what are the basic differences between these extensions? Answer PDO is a wrapper for database connections in PHP. It’s designed to cover the functionality offered by the majority

Check empty select in sqlite?

php sql sqlite

How can i check the result of my query? I try this, but when the result is empty – error doesn’t shows. Answer Note that sqlite_fetch_array() returns a result handle, not the number of rows, so you should not compare it against zero: This function will return a result handle or FALSE on failure. Use sqlite_num_rows() to determine the number