Questions tagged as 'mysql'

Tagged questions
1
answer

Show database data that is in another id after the id 0

I want to show data from a database. I already know this, but only everything that is in id 0 of the base table is shown, and now I want to show what is in table 2. For example id dato1 dato2 0 abc def 1 ghi jkl Well, w...
asked by 10.07.2018 / 23:22
0
answers

Folder for MySSQL database in Tomcat

I am creating a web page (as a student) with html / css / jsp pages and servlets hosted on a Tomcat server. (all local in my PC - Windows 7) As part of the exercise you also have to create a MySQL database and access it from jsp / servlets. I...
asked by 19.07.2018 / 10:13
1
answer

How to resolve this SQL query

List name and phone number of drivers who did not drive a vehicle model after the year 2010. WHAT YOU TRY ME SELECT c.nombre, c.telefono FROM chofer as c INNER JOIN viaje as v on c.nro_chofer = v.nro_chofer WHERE NOT EXISTS (SELECT * F...
asked by 16.07.2018 / 00:42
0
answers

Is it possible to carry out an autoincrementable code without repeating in another form at the same time?

I have a form that shows a code, the idea was to increase in the BD with respect to the records, if I have 10 records I would leave 11, my error is what would happen if that form is used by several people and in some cases by Saying it like that...
asked by 09.07.2018 / 15:47
0
answers

How to use a form ID to make a MySQL query

This is the complete code. <div class="right_col" role="main"> <div class="x_panel"> <div class="x_title"> <h2>Gestión de casos</h2> <div class="row"> <?php if (!isset($_SESSION[...
asked by 09.07.2018 / 15:43
1
answer

Intermediate tables and pivot relationships

I have the following 3 tables with the relationships shown in the image In the models of Laravel I am defining the relations with the intermediate table in the following way: Table model discounts ; class Discount extends...
asked by 07.07.2018 / 18:43
1
answer

Check with where in CodeIgniter

I am trying to make a query in which you show me an article in this library using the uri library In the index I show a list of courses, if I click on a course through the recovered id I want to show only that course individually. shows me...
asked by 07.07.2018 / 05:03
0
answers

Query multiple tables on the same table

Hello good day my problem is this: I have a structure similar to this one: table masterTable +------------------------+ | Field | +------------------------+ | id | | idDoc | | doc...
asked by 05.07.2018 / 20:31
0
answers

Upload an image to MySQL by uploading the image through an HTML form via Java

I have a form to update the information of the profile, in this case a new password and the image. The fact is that changing the password works but upload the image to the database no, I already have a medium blob column in my database for the i...
asked by 04.07.2018 / 21:18
1
answer

Delete a file in PHP using your .htaccess alias

I have a htaccess tag, it renames and gives hello name to the v.php file, leaving: www.example.com/hola So, I want to delete this " v.php ", by its name hello (written by htaccess) $e = __DIR__ . "/hola"; $result = unlink($...
asked by 08.07.2018 / 22:14