Questions tagged as 'mysql'

Tagged questions
1
answer

values in a html table loaded from mysql

Very good friends, I have a question: I have the following table: <div class="container"> <table class="table"> <thead> <tr> <th scope="col">Fecha</th> <th scope="col">Concepto</th>...
asked by 29.12.2018 / 23:32
1
answer

Problem with function

I am creating a blog and the following function has been created to take the topics of the blog: function getPostTopic($post_id) { global $conn; $sql = "SELECT * FROM topics WHERE id= (SELECT topic_id FROM post_topic WHERE...
asked by 15.11.2018 / 22:00
1
answer

Do you not upload the data from my database to my jsp?

The database is locally I understand that it is placed the libraries are already placed from jdbc and the jar of mysql but does not pull the data     
asked by 14.12.2016 / 18:31
1
answer

Is there a transaction log in Laravel?

I need to make a transaction log for the CRUD of the system. I know it can be done using triggers that trigger the action of saving the record in a transaction table but does Laravel have this functionality?     
asked by 14.11.2018 / 01:39
1
answer

Help Inner Join Mysql

Well it happens the following deal to do an inner join to 2 tables by means of its foreign key but it returns empty and there are 2 registers in serviteca_clientes I have the primary key called cli_identificacion and in serviteca_ventas I hav...
asked by 17.11.2018 / 20:24
2
answers

Open input from icon font awesome

What happens is that I want to click on the fa-paperclip icon to open the window to choose which files I want to attach. I currently have this: <html> <head> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4...
asked by 14.11.2018 / 18:43
1
answer

SQL statement does not work to make a ticket, help

It does not work mark me this error:    1054 - The column 'customers.customer' in field list is unknown Select rentas.idrenta, clientes.idcliente, clientes.nombre as 'Nombre del cliente', autos.marcamodelo from rentas inner join detalle_r...
asked by 15.11.2018 / 17:19
1
answer

Find a table with the name inside another

Sorry for my inexperience but I do not have a concrete idea of how to do the following. In a database table (project_snippets) in a table (code) I have four columns: id, code, author & link and id is the primary key. in the column code I wan...
asked by 10.11.2018 / 20:06
1
answer

Blank spaces in database and in Javascript view

I have a database of books in which in the fields of titles some spaces is another character so it does not identify it as such That makes that in my view when wanting to list books I do not make the line jump As you can see some tit...
asked by 11.11.2018 / 09:27
1
answer

Query that returns mysql value

I would like to know if there is any query in MYSQL that allows to return a value, in case that the query is affirmative, as is the query. select usuario_ad, nombre, asignacion from usuarios where usuario_ad='danielad' and asignancion='paola...
asked by 11.11.2018 / 00:53