Questions tagged as 'mysql'

Tagged questions
2
answers

Error Notice: Array to string conversion in PHP PDO

Could someone help me and say why he sends me that message? Attach the code: <?php try{ $conexion = new PDO('mysql:host=localhost;dbname=organizer', 'root', ''); } catch(PDOexception $e){ echo 'Error ' . $e->getMessage(); }...
asked by 06.04.2018 / 02:00
1
answer

Error generating an excel report in php and msql with PHPExcel

I am using PHPExcel to generate Excel reports with PHP from data obtained from a MySQL database. This is the code I have and file shows this error:    Fatal error : 'break' not in the 'loop' or 'switch' context in    C: \ xampp \ htdocs...
asked by 03.05.2018 / 16:53
1
answer

How to configure CAS with MySQL (or another DB)?

I am trying to configure a basic CAS by pulling a DB (in this case MySQL but I would also use Oracle or Postgresql). I have been following this tutorial but it always gives me the wrong login, also it does not go to BBDD because doing tests...
asked by 17.04.2018 / 11:27
1
answer

Call to Case When (syntax)

I have the following query: select ic14.cantidad_recepcionada as recepcionados from comex_015 ic15 inner join comex_014 ic14 on ic15.invoice=ic14.invoice where ic14.codigo_producto='KO555581012EA40' and ic14.invoice !='0' group by i...
asked by 20.08.2018 / 17:20
3
answers

Duplicate records in mysql

the registration from an html form to my database is a success but now I find the problem that I have left pending because I can not solve to send a message that the registration already exists, try some things but not I find ... .php code to...
asked by 03.04.2018 / 20:07
1
answer

JavaFX - Problem when retrieving a database image

I'm using a mysql database, just like I'm using JavaFx with the Scene Builder. My problem is that I have saved an image in a database and when I try to access it to insert it in an ImageView, I get an error:    ERROR: "incompatible types:...
asked by 03.04.2018 / 04:10
1
answer

Upload image with codeigniter

Controller: public function generate($id,$type){ $method = $_SERVER['REQUEST_METHOD']; if($method != 'POST'){ json_output(400,array('status' => 400,'message' => 'Bad request.')); } else { $...
asked by 22.03.2018 / 08:18
2
answers

search in different fields with different inputs mysql php

Good morning, I have tried to perform a search to a database in the following way .. I have a database with x columns (suppose that for more ease, the database has only two columns, a column that day is called and another called month), what I w...
asked by 22.03.2018 / 01:30
1
answer

Range of dates

I have a range of dates that is checking if the dates entered by a user coincide with some day of offer in the database, to coincide, print the new price, but it gives me two problems: 1) If I have more than two offers in the DB, it prints twice...
asked by 02.04.2018 / 18:44
1
answer

Connect Eloquent ORM to MySQL through a port other than 3306

I have a couple of connections to each of them going to a different MySQL database, the issue is that one connects to a local server itself, but the other goes to a remote server and under "another port ", I handle the connections like this: $...
asked by 22.03.2018 / 23:28