Questions tagged as 'mysql'

Tagged questions
4
answers

Register sale with its retail detail through transactions in a stored procedure MYSQL

I'm trying to register 2 tables through transactions in MySQL and I have a table VENTA , to which I put as a field the field id_venta and is type int autoincrement, plus I have the table DETALLE_VENTA , which has as FK...
asked by 01.07.2016 / 20:01
2
answers

Mysql Query Date (date)

my query: I have a date field in MySQL that is dated, and at the time of inserting it into the table, it does not accept this format: 'dd / MM / yyyy', because I believe that mysql accepts another type of format. CREATE TABLE tb_peliculas (...
asked by 28.05.2016 / 22:53
1
answer

How to create a new page with a format already established in FPDF?

I have an application already prepared in which one of its modules is to generate PDF reports, the report is generated excellent, the detail is that I need every 20 records to generate a new page of this report but it is generated in white and t...
asked by 05.05.2016 / 22:42
1
answer

Save image in MySQL and read it in Android

Well, I have the following problem: I have a web application with which I want to be able to keep records of 2 tables, which must contain images. I want to save those records (with everything and images) in a MySQL server so that later I can...
asked by 18.08.2016 / 02:10
1
answer

PHP: Error: SQLSTATE [HY093]: Invalid parameter number: parameter was not defined

I'm doing a Login method but I can not solve this error, I would really appreciate your help <?php try { $base = new PDO("mysql:host = localhost; dbname = estimasoft", "root", ""); $base->setAttribute(PDO::ATTR_ERRMODE, PDO::ER...
asked by 16.05.2016 / 18:59
1
answer

Create a trigger to execute it before insert

I want to do a Trigger in MySQL that does the following: Background: I have a table called x with 3 columns: id (int), name (varchar) and state (enum). There can only be 1 record with the status Yes (column type enum; Yes, No) When insert...
asked by 03.06.2016 / 23:37
1
answer

show query result

I need to show a query in a database in a table of two columns in html. I've done it that way, but it does not work out: <table border=1> <tr> <th>Nombre</th> <th>Poblacion</th> </...
asked by 24.12.2018 / 17:31
1
answer

two consecutive selections

I need to do this exercise in a single file and only with php. I have two combobox with two buttons, one behind each combo. The first combo loads well from a mysql table. When the first button is clicked, the second combo is loaded with a query...
asked by 23.12.2018 / 16:38
2
answers

Laravel: Consultation with Eloquent using count

I want to make a query that involves a count, and it works. The query is this: $user = Auth::user(); $id = $user->id; $users = DB::table('cuentas as a') ->join('pasajeros as b', 'b.id', '=', 'a.pasajero_id') ->where('b...
asked by 10.07.2016 / 01:51
2
answers

Problems with Mysql in Ubuntu 16.04

I have installed mysql with the xampp and I have it installed separately, I do not want to work with the mysql of the xampp, as I do to be able to work with the other mysql and not with the xampp, if I'm not wrong I must configure the ports to b...
asked by 11.07.2016 / 23:25