Questions tagged as 'mysql'

Tagged questions
0
answers

MYSQL how to remove a row from a query if at least one of the data does not meet the conditional

Good morning guys, I have a problem with a query that has been very complicated, you see, I have three tables, rooms, reservations and rooms_reservas, the first shows all the information related to the rooms of a hotel, the second is related to...
asked by 06.06.2018 / 01:32
1
answer

Avoid access to the log

What can I do if I am making a web page and I want to avoid that when the session is started it allows access to the log, but it throws me an error? Log code <head> <meta charset="UTF-8"> <title>Frutill...
asked by 06.06.2018 / 03:24
0
answers

Error in impirmir report ireport

When I click the generate report button, it flags this error getWriter () has already been called for this response ireport     
asked by 06.06.2018 / 01:41
1
answer

How to use the SELECT FROM with 2 conditions

Hello, I have a table where I want to show only pending and resolved requests from the state field of my table in my DB. $sql = "SELECT * FROM contribuyente WHERE estado ='Pendiente' AND estado='Resuelto' ORDER BY id     
asked by 05.06.2018 / 00:37
1
answer

Problems with the preparedStatement

Thanks for your attention I would like to ask what the problem is in my code, I am doing a query with Java but when going to the preparedStatement it tells me that the connection is closed and can not execute any more operations (MySQLNonTransie...
asked by 05.06.2018 / 17:04
0
answers

help with this error Trying to get property 'status' of non-object in C: \ xampp \ htdocs \ company2 \ test2 \ Model.php on line 108

THE PHP MODEL <?php class s_permisosModel{ private $pdo; public function __CONSTRUCT(){ try{ $this ->pdo=database::conectar(); }catch(Exception $ex){ die($e->getMessage()); } } //Funcion que ingr...
asked by 05.06.2018 / 16:06
1
answer

Problems when creating a pdf created with fpdf

My problem is that when creating the pdf the table where I create it shows me the cut data As you can see in the image in services performed, it shows me the correlative data and I want you to show them one separated from the other one dow...
asked by 06.06.2018 / 15:51
0
answers

How can I insert multiple records in a single stored procedure?

Hello, how are all my questions? Is it possible to send a stored procedure in this way: CALL SP_CLIENTE((1,'pepito','perez'),(2,'alan','brito')); for (let i = 0; i < xml.length; i++) { datosJSON.push({ 'id': info.replac...
asked by 06.06.2018 / 16:45
1
answer

Problems importing MySQL database to WorkBench and PHPMyAdmin

I'm trying to import a database MySQL , both through WorkBench , and PHPMyAdmin , everything runs correctly, but it does not matter absolutely nothing. Imported in WorkBench Imported PHPMyAdmin    Messages in red...
asked by 01.06.2018 / 05:42
0
answers

How to create WebService on Linux server (eg GoDaddy)

I am currently finding a Linux hosting, Which I can create MySql databases, Now I find the need for my Android application, you can consume this data from the base through a WebService, it could be an Http Post request in Json format,...
asked by 03.06.2018 / 18:47