Questions tagged as 'pdo'

1
answer

Migrate cod to pdo

Hello friends, I am currently in the process of migrating the codes to PDO , which is why I have seen it as more secure, well I'm going through the validation session for users, I share my code that I used to validate the sessions, what I inten...
asked by 09.12.2016 / 23:36
0
answers

Does not show data in the select query

good morning, I have this query for my front of users, with PDO connection but in SQL SERVER but it does NOT show me any result as if it had nothing in the user table, but when I make an insert it is possible to insert the new user . What could...
asked by 02.01.2019 / 11:04
1
answer

Error creating temporary table Mysql Php Pdo (mysql.column_stats: expected column 'max_value' ...)

I have an extensive procedure that runs directly in mysql works, now when I put it in php I get an error from the beginning that is creating a temporary table from where I will be getting data for the remainder of the report. This is the code th...
asked by 29.11.2018 / 21:46
1
answer

value of option value is lost when updating

friends when I try to update the value of the select does not show me what I had previously registered in the select because the idea is that if you already register a value of the select when there is an update should show you the value you alr...
asked by 13.07.2017 / 14:21
0
answers

Error making a php PDO query with postgresql

Good I am trying to make a web service with php and postgresql as a database, but I want to do it by the PDO method and I get errors. <?php require "database.class.php"; class Users { private $con; public function __construct() { //en...
asked by 12.12.2018 / 22:33
1
answer

Insert data using PDO

Hi, I'm running the following PHP-mySql codes, but I'm not one of them, and I have the slightest idea why, to see if any of you knows how to help me and thanks in advance Upload.php, this updates perfectly. <?php include_once "con.php";...
asked by 06.11.2018 / 18:04
1
answer

Connection php to SQL Server 2012 database from Linux

Good morning, I would like to request your collaboration and knowledge with a problem that has taken me several days and from which I could not get out, I am developing an application with php but I need to connect to a MS SQL SEVER database...
asked by 08.11.2018 / 15:20
0
answers

PHP MySQL Multiples Querys

I have the following code where I run 3 Updates, the strange thing is that when executing it does not appear any error, that is to say that it executes everything well, but when consulting the BD it did not make any change, and if I remove 2 Que...
asked by 02.11.2018 / 15:36
0
answers

Problems generating an excel with phpexcel

I am exporting a MYSQL database to an Excel file using the phpexcel library in PHP. require_once('phpexcel/Classes/PHPExcel.php'); require '../database.php'; $pdo = Database::Conectar(); error_reporting(E_ALL); ini_set('di...
asked by 30.10.2018 / 21:09
0
answers

function defined with variable

I have the following code to define a constant with the value of a variable: define('DB_NAME', $row['co_database_name']); and use it in a connection string $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET ....
asked by 21.10.2018 / 20:46