Questions tagged as 'pdo'

0
answers

'SET ANSI_WARNINGS ON' Laravel 5.4

I'm using Laravel 5.4 with 2 connections, one of them is just to access some Views of a Sql Server bank, and one of them does a LINKED SERVER which forces me to set some settings before making a query. p> Today I can do this in my Controller a...
asked by 09.05.2017 / 18:30
1
answer

Connect Sql Sever bank with PHP on windows 10

I am not able to connect to the SQL server database through PHP. I already downloaded the correct driver for the PHP version (php_pdo_sqlsrv_54_ts.dll) and moved it to the ext folder, set up php.ini to load the driver (extension = php_pdo_sqlsrv...
asked by 20.03.2017 / 17:19
0
answers

What is the advantage of passing the parameter type in bindValue?

Looking at the answer of this question, I noticed that the user recommends passing the parameters by the bindValue function, indicating the parameter type. There are various types of parameters we can pass, but the ones that catch...
asked by 08.03.2017 / 18:48
1
answer

Enable Firebird PDO support for PHP [closed]

I can not install Firebird PDO support in PHP. My machine is running Mac The Sierra. I've already researched macports and homebrew and they do not support it. Some old posts do not explain in detail how to solve this problem. Could someone help...
asked by 24.03.2017 / 12:24
1
answer

Problems with PDO

I'm new to PHP and would like to ask a question: In the code I will show below, I tested the query in the database up to try , the problem is that after try(){} prepare it does not return anything, I tested it with die('');...
asked by 21.02.2017 / 19:28
0
answers

Error connecting to pdo_mysql when using docker with apache and mysql

I'm using docker with apache 5.6 + mysql: MySQL Official Docker PHP Official PHP - Version 5.6 First I ran the mysql image, then ran the following command line to run the apache image, linking the two:    docker run -d -p 80:80...
asked by 03.01.2017 / 12:42
1
answer

How to collect data from two queries in a php object?

I'm doing two DB queries on different tables. With the data from the first query I'm getting data in the other, however, I can not merge all the data into a json object only. <?php include_once("con.php"); $pdo = conectar(); $pegaContaAdm...
asked by 04.01.2017 / 17:01
1
answer

insertion in related tables

Hello, I'm working with some related tables and I can not insert the values in the next rabla, I discovered that I need to retrieve the last id inserted in the I still can not use it, without the relation the tables work perfectly. Follow the com...
asked by 28.12.2016 / 21:34
2
answers

Extended PDO connection does not work

Well, the netbeans does not acknowledge any errors, but when I try to run it always gives an error in the browser, does anyone know what's wrong? can you tell me how to use the pdo connection of the parent class constructor method in the child c...
asked by 20.01.2017 / 11:04
0
answers

Insert with massive amount of data

Hello We are working on a project using PHP and Mysql database, at which time a large range of records (for example, between 5 thousand and 1 million) should be inserted in the database, At the moment, the most basic way to get performance...
asked by 19.01.2017 / 17:41