Questions tagged as 'mysql'

Tagged questions
2
answers

How to order ID's from highest to lowest

I need to show the data of the last one that was uploaded to the last one by means of the id. but the query I have shows me from first to last. function obtener_post_por_id($conexion, $id){ $resultado = $conexion->query("SELECT * FROM a...
asked by 11.06.2018 / 15:49
0
answers

Can you help me, do not execute mysql sentence in php function

Friends I have a php function, donte I have a mysql statement for data insertion, but it does not run Maybe they could help me find the error function RegistrarServicioEP($nombreser,$descripcionser,$fotoser) { //echo $fotoser; $mensa...
asked by 12.06.2018 / 17:11
0
answers

Trigger in MYSQL (Insert)

I'm trying to create a trigger in MYSQL. I was reading the documentation of MYSQL, some examples that I saw out there on the internet and, at the moment of truth (adding it to the console) marks me a syntax error. I do not know what it can be, a...
asked by 10.06.2018 / 23:25
0
answers

Error starting SQL

This is the error when starting SQL Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. systemctl status mysql.service mysql.service - LSB: Start and stop the mysql database server d...
asked by 15.06.2018 / 13:13
0
answers

Generation of MYSQL based reports using PHP

Hello this is my first question in Stackoverflow, as everyone knows now it is quite common to do CRM and billing systems in PHP, someone knows some way of doing reportage using PHP and MYSQL SAP Crystal Report style, the idea is to integrate to...
asked by 19.06.2018 / 18:49
2
answers

error when saving Mysql query in PHP array

The problem is that when I try to save the query sql in a PHP array and then send it as JSON, nothing is sent or a single record is sent. I show you the code. $("#btn-send").click(()=>{ var datos_to_send={data:"estados"}; //Esta i...
asked by 19.06.2018 / 19:16
0
answers

Problems with mysql event and inerjoin not running

I am programming an event but it does not execute it, if it executes other events as simple updates, but when I put the inner join it just does not do it, it can be said that the inerjoin does it if I do it manually for example this event if...
asked by 08.06.2018 / 22:08
1
answer

Servelts, jsp error return true

I'm doing a data maintainer in jsp, so for the user validation part I use servelts to make calls to mysql. In the servelts of consultas.java I have this (it is to do reedireccion 1 is admin 2 is standard): public boolean comprobar (Stri...
asked by 10.06.2018 / 21:05
3
answers

How to insert a database contents from a form in php

I would like to know how to insert content from a PHP form into a MySQL database. Then I show you my code and the error that appears to me. This is the code of the form: <?php include 'menu.php'; ?> <br> <form method="PO...
asked by 10.06.2018 / 21:27
0
answers

CROSS REFERENCES

I am studying sql in an autodidactic way, the manager that I am using is phpmyadmin, I am exactly studying the topic of cross-references, as I understand mysql does not support the PIVOT and TRANSFORM commands, does anyone know how I can make a...
asked by 10.06.2018 / 00:31