Questions tagged as 'pdo'

0
answers

Error in search engine in php

I'm doing a search engine, but this is giving a mistake, I'd like to know the solution. Follow the code: <?php require_once 'conect.php'; if(isset($_POST['submit'])){ $nome = $_POST['nome']; $p...
asked by 04.07.2016 / 23:46
0
answers

Error in PHP PDO Class

I'm trying to use the PDO class on one of my systems and this error is showing up, and the PDO class is already installed. Fatal error: Class 'PDO' not found in /home/dfmedica/public_html/cursos/classes/BD.class.php on line 9 Connection cla...
asked by 02.06.2016 / 20:03
0
answers

How to use UTF8 in JSON with PHP?

I am doing a query in a sqlserver database with PHP / PDO then return a JSON to search in Angular JS. $result = $stmt->fetchAll(PDO::FETCH_ASSOC); $json = json_encode($result); print $json; However, the values it contains, for example:...
asked by 02.06.2016 / 18:02
1
answer

Data in JSON format is not shown

Hello, I have the following php code: <?php require("config_local.php"); //conexao com o banco de dados $area = "eua"; $st = "ny"; $sql = $pdo->prepare("SELECT prop,old_no,emissao,area,country,e_name FROM table1 WHERE area = :area AN...
asked by 31.05.2016 / 04:14
0
answers

Get only the final value of the bank

I am using php with pdo to query a database in postgress . Is there any way that when I do query , show the result without having to insert the table name, since the select is unique? select distinct a as origem from b uni...
asked by 23.05.2016 / 17:00
0
answers

Fatal error & PDOException in SELECT POO PDO

I'm trying to do a select, however I get the following messages on the same line: Fatal error: in C:\wamp\www\curso\Crud.class.php on line 24 PDOException: in C:\wamp\www\curso\Crud.class.php on line 24 Errors refer to the following method:...
asked by 11.06.2016 / 19:10
0
answers

PHP Connection Pool: PDO with PostgreSQL, what to use?

Thinking of the following scheme: Linux Server (Can be Ubuntu Server) + PHP using PDO + PostgreSQL + Apache HTTP Server + Some connection pool I would like some pool hint (which is trustworthy) to manage the connections to the database. I...
asked by 13.05.2016 / 03:37
1
answer

bindValue is giving error when registering

Colleagues, I have the following code: include_once("conexao.php"); $sql = $conexao->prepare("INSERT INTO compras_clientes(Produtos) VALUES(:COD_PRODUTOS)"); $sql->bindValue(":COD_PRODUTOS",$produto,PDO::PARAM_STR); $sql->e...
asked by 19.06.2016 / 18:09
0
answers

crypt for javascript

I'm working on a project that I need to use crypt as a method to encrypt the password, but what password do I need to use on the mobile, how do I use something that crypt will understand and which web will it also? What I need i...
asked by 11.05.2016 / 15:42
0
answers

Get Table Id generated by setFetchMode (PDO :: FETCH_ASSOC)

Good afternoon friends, I'm trying to generate a link by sending a parameter that would be the row ID of the clicked table <a href="page?id=echo'.rows['id'].'">Editar</a> This code works in mysqli and mymsql without any problems...
asked by 28.05.2016 / 21:44