Top "Pdo" questions

codeigniter 3.1 PDO mysql Error Number: 3D000/1046 No database selected

I had issue with upgrading codeignier 2.xx to 3.xx before and I can not found any completed answer for me. …

mysql pdo codeigniter-3

PDO PHP bindValue doesn't work

I know this has been asked 1000 times, but for some reason I continue to bang my head agains the wall.. …

php mysql pdo bindvalue

PHP PDO MySQL Correct way to check if an update query succeeded when no rows are affected

What is a sure way to tell if an update query succeeded when using php pdo and mysql? In my …

php mysql sql pdo rowcount

Kohana 3.2 ORM and PDO

I am giving Kohana a try and I was trying to use the ORM + PDO + MySQL database, and I don't …

php mysql pdo kohana kohana-orm

Set DSN encoding for ODBC Driver 11 for SQL Server on Windows 10

TL;TR How force this ODBC driver to encode in UTF-8? Detailed description I'm writing PHP 5. 5. application which connects to …

sql-server pdo database-connection connection-string dsn

php postgresql pdo copy from stdin

COPY table_name ( field1, field2, field3) FROM STDIN CSV; 1,2,"q w" 3,4,"a s" 5,6,d \. How to execute this query by …

php postgresql pdo sqlbulkcopy

Parametrized PDO query and `LIMIT` clause - not working

I have query like this: SELECT imageurl FROM entries WHERE thumbdl IS NULL LIMIT 10; It works perfectly with PDO and …

php pdo limit sql-parametrized-query

mySQL auto increment problem: Duplicate entry '4294967295' for key 1

I have a table of emails. The last record in there for an auto increment id is 3780, which is a …

php mysql pdo auto-increment mysql-error-1062

Calculating Great-Circle Distance with SQLite

Here is my problem, I have a SQLite table with locations and latitudes / longitudes. Basically I need to: SELECT location, …

php sqlite pdo geospatial haversine

Insert into a table which has a dash in the name

I have a table called concept-relation and I want to insert into it. for ($i = 0; $i < count($sources); $i++) { $…

php mysql pdo mysql-error-1064