Questions tagged as 'pdo'

Tagged questions
2
answers

$ _SESSION recover data

Good, I have an archiv that retrieves the IDs and makes a login for roles so that: VALIDAR.PHP <?php //Fichero que usara para mandar los datos recibidos más abajo para pasarlos por el controlador. include "../controlador/usuariosControla...
asked by 22.05.2017 / 13:08
1
answer

Gif Images - Giphy Api PHP

Hello stack overflow people I have a problem with this Api of Giphy what happens is that I do not get the image that I'm pining but it does not give me any good error I hope you help me see my error <?php $url = file_get_contents('http...
asked by 08.09.2017 / 18:08
1
answer

How can I update data from a multiple input select in mysql

I have a problem (I do not know how to do an UPDATE) when it comes to updating the student's file since it only changes the name and image of the student, and what I want to do is add or remove the courses in which it is enrolled from a multiple...
asked by 19.03.2017 / 15:12
2
answers

Problem bindValue and NULL values

I have a function like the following: function xxx( $sql, $params ) { $query = $this->con->prepare( $sql ); $num = count( $params ); $pos = 0; for ( $i=1; $i <= $num; $i++ ) { $param = $params[ $pos ];...
asked by 03.04.2017 / 10:43
1
answer

Error: SQLSTATE [42000]: Syntax error or access violation: 1064

I get an error when wanting to generate an action like modify or save . Error:    SQLSTATE [42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve...
asked by 15.12.2016 / 07:43
1
answer

how to convert the results of an array of multiple rows from MySQL into PHP variables

Dear in advance I appreciate your contributions, I am stuck in a logic that probably for many of you is quite simple and is the following: I have a table in MySQL and from it I get a number of records associated with the identification of the us...
asked by 02.09.2018 / 22:09
2
answers

I can not connect my database in my Hosting

This is my connection: Using CodeIgniter $db['mysql'] = array( 'dsn' => 'mysql:host=mysql.hostinger.co;dbname=u201535648_regis', 'hostname' => 'mysql.hostinger.co', 'username' => 'u201535648_germa', 'password' => 'password'...
asked by 23.07.2018 / 22:47
1
answer

I do not receive values from SELECT FROM but from INSERT INTO and if the record exists (MVC, PDO, MYSQL)

Hi, I'm working with PHP and MySql with PDO and the model view controller (MVC) but I have an error when trying to do a SELECT * on the model side. My intrigue is that it works when I do INSERT INTO and when it's a SELECT. what I do is a validat...
asked by 04.07.2018 / 18:39
1
answer

Problems with pdo connection and prepared queries php poo

I get the following error:    Fatal error: Uncaught Error: Call to a member function prepare () on   null in C: \ xampp \ htdocs \ EPWeb \ Admin \ Business \ CapaNegocios.php: 17 Stack   trace: # 0 C: \ xampp \ htdocs \ EPWeb \ Admin \ Presen...
asked by 25.06.2018 / 04:16
3
answers

MySQL storage engine (MyISAM to INNODB)

I have a hosting on GoDaddy, I was testing, perform some tests with (begin, rollback, commit) transactions, which had no effect. I was investigating and I realized that "MyISAM" does not allow transactions, so I assumed that the storage e...
asked by 09.06.2018 / 06:14