pdo

PHP & PDO PHP Notice: Undefined property: Database::$photo ???

Okay so here is the code that I am using function AddProducts($aTitle, $aDescription, $aPrice, $aQty, $aPhoto) { try { $stmt = $this->pdo->prepare("INSERT INTO products(title, price, description, qty, photo) VALUES(:title, :price, :description, :qty, :photo)"); if(!$stmt){ $err = ...

How to solve Ajax IM PDO Exception error in Go Daddy server?

Hi! I tried to install ajaxim in godaddy hosting server windows hosting account and when I clicked "install" it says: error: Fatal error: Uncaught exception 'PDOException' with message 'couldn't find driver in /.../install.php:332 Stack trace: #0 /.../install.php(332): PDO->__construct('mysql:dbname=rm...', 'rm', 'Co123') #1 {main} th...

[PHP PDO] Database abstraction class design question

Hi SO, I am in the process of designing a web app (really it's a hobby, I'm trying to teach myself design, and what better way is there than doing it :). Anyways, I was thinking about how I would deal with my database. I am comfortable with PDO and I was thinking of leveraging PDO in my abstraction class. I am thinking of making a si...

How to get query created by the prepare statement in PDO

Hi all, We can use prepare method to get the query prepared for multiple time use in PDO. But i want to know that can we see all the queries executed at the DB. For e.g see below: <?php // Cosidering DB connection already set here. With $db. // using named placeholder $db->prepare("select * from user where id=:id"); ...

Will PDO laststatment->fetchAll(PDO::FETCH_COLUMN, $column) rerun the query each call?

I am doing a query which fetches two fields. I need each of those fields into a different array. Will this rerun the query for each call or just re iterate over the result set? $a= Laststatment->fetchAll(PDO::FETCH_COLUMN,0); $b= Laststatment->fetchAll(PDO::FETCH_COLUMN,1); ...

Trouble in PDO and sqlsrv land.

I set up a site on my local system using PDO and a MySQL Database. I used PDO because when the site goes on the live server I have to user SQL Server and I was hoping PDO would take care of all my query conflicts. Now that I'm up on the live server I get an error whenever the application uses the "LIMIT" function. I realize this is a My...

PDO's FETCH_INTO $this class does not working

I want to populate class with constructor using FETCH_INTO of PDO: class user { private $db; private $name; function __construct($id) { $this->db = ...; $q = $this->db->prepare("SELECT name FROM users WHERE id = ?"); $q->setFetchMode(PDO::FETCH_INTO, $this); $q->execute(array($id)); ...

Is this PDO function safe from sql injection

I have the following insert function. Is it safe from a sql injection. If it isn't then how do I make it safe. public function insert($postValues, $table){ $dbh = $this->connect(); try { $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $fields = implode(array_keys($postValues), ','); $val...

random rowcount in PDO

how would i get a random rowcount using PDO? i'm still learning how to use PDO so this is what i tried, but it didn't work because it doesn't randomize the quotes: $sql = "SELECT COUNT(*) AS rows FROM thquotes;"; try { $query = $this->_db->prepare($sql); $query->execute(); ...

PDO SQLite: read-only database

I have a SQLite database that I am using for a website. The problem is that when I try to INSERT INTO it, I get a PDOException SQLSTATE[HY000]: General error: 8 attempt to write a readonly database I SSH'd into the server and checked permissions, and the database has the permissions -rw-rw-r-- I'm not that familiar with *nix permis...

Should I run multiple SELECTs inside a PDO transaction for performance gains?

Are PDO transcations intended just for UPDATE, INSERT and DELETE or can you achieve performance gains if you use a transaction for mulitple SELECT queries? ...

PDO and Microsoft SQL: Must declare the table variable "@P1"

I'm trying to use binding in PDO to select some entries from a Microsoft SQL database. The code I'm using looks like it's similar to what I've found in the documentation. However, when I run it, I get the warning below: Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[42000]: Syntax error or access violation: 1087 [M...

Is there a performance difference between PDO fetch statements?

like in /* Exercise PDOStatement::fetch styles */ print("PDO::FETCH_ASSOC: "); print("Return next row as an array indexed by column name\n"); $result = $sth->fetch(PDO::FETCH_ASSOC); print_r($result); print("\n"); print("PDO::FETCH_BOTH: "); print("Return next row as an array indexed by both column name and number\n"); $result = $sth->...

What does the PDO::PARAM_EVT_* constants do?

I can't find any information on these constants but the sparse bit the documentation gives. What can they be used for, and do I to use them? ...

What are the disadvantages of using persistent connection in PDO

In PDO, a connection can be made persistent using the PDO::ATTR_PERSISTENT attribute. According to the php manual, these connections are not closed at the end of the script, but are cached and re-used when another script requests a connection using the same credential. The persistent connection cache allows someone to avoid the overhead ...

Why the following PDO transaction is committing?

I think the question itself is pretty self-explanatory. The code is given below - <?php $PDO = NULL; $pdo_dsn = 'mysql:host=localhost;dbname=pdo_test'; $pdo_persistence = array( PDO::ATTR_PERSISTENT => true ); $db_user = 'root'; $db_pass = ''; $db_query = "INSERT INTO person(name, address) VA...

Overriding fetch() for PDO when fetching using foreach

I have extended PDOStatement and modified the fetch() method to typecast values of the types timestamp and arrays, in PostgreSQL, to DateTime and native array. This works as intended but I can't override the behaviour when using the statement in a foreach. I have solved this by returning rows into an object implementing ArrayAccess, Ite...

passing search parameter through jquery

i have a form in which if the user enters the search query, its parameter should be passed through jquery and after getting the results it should load the results in the div container. since i'm not very well-versed with jquery, how would i do this? html: //currently the data is being displayed on pageload: $(document).ready(fu...

search using pdo, mysql and php

i'm trying my hand with PDO and would like to know if the following is the correct code to search keywords since it's giving me an error: mysql_real_escape_string(): [2002] A connection attempt failed because connected host has failed to respond. php class: public function searchQuotes() { $search = mysql_real_esc...

PDO: Call to a member function fetch() on a non-object ?

I am just trying out PDO and I get this error, Fatal error: Call to a member function fetch() on a non-object, but isn't it already on the $this->db object? class shoutbox { private $db; function __construct($dbname, $username, $password, $host = "localhost" ) { # db conections try { $this->db = new PD...