Questions tagged as 'mysql'

Tagged questions
0
answers

In python2.7 how to save data in MySQL captured from an interface

Hello colleagues I have this little doubt about how to save this data in my BD I have my connection import mysql.connector db = mysql.connector.connect( host = "127.0.0.1", port = "3307", user = "root",...
asked by 13.11.2018 / 20:18
0
answers

Calculate age in php

How you can get age from date of birth in Date format yyyy-mm-dd while ($fila=$resul1->fetch_assoc()) { $tiempo = strtotime($fila['fecha_nac']); $ahora = time(); $edad = ($ahora-$tiempo)/(60*60*24*365.25); $edadFinal = floor...
asked by 12.11.2018 / 19:45
0
answers

Migrate Triggers to different databases in Laravel

I have a problem, it turns out that I work with laravel and migrate several tables to different databases thanks to Schema :: connection in a normal way, but the problem is that I also have some TRIGGERS and PROCEDURES as migrations using the...
asked by 12.11.2018 / 19:53
1
answer

Copy .sql files from the server to my pc by means of a batch

I have a scheduled task that makes BackUps of my database daily on the server and on my pc I have a bath that runs at a certain time by copying the sql files that are generated on the server and copying them on my pc. With the following code I m...
asked by 12.11.2018 / 17:46
0
answers

Generate RTF with PHP

I have the following code, which works perfectly, just that I need that when executing, this gives me the option of where to save the generated document. I have been reviewing the documentation and some examples on the Internet, but I have not b...
asked by 12.11.2018 / 17:14
0
answers

MYSQL and Java Connection Error

Hello dear, I need help I want to make a connection test between java and mysql and I have this error, here is my source code: package test; import java.sql.*; public class PruebaConexion { public void conexionBD() { try {...
asked by 18.11.2018 / 19:16
0
answers

Change div within the same html

I'm doing a page with forms, and maybe it's one of the easiest things but I can not find documentation to do it, I explain, the page has a form on the left, and I want to get the form to fill in the form in a php document that I have inside a...
asked by 18.11.2018 / 19:58
2
answers

Finder in ajax [closed]

I found this code example in ajax that shows all the data of a table and I want to place a search engine, here my code: <!DOCTYPE html> <html> <head> <title></title> <script src="https://ajax.goo...
asked by 14.11.2018 / 21:09
0
answers

Optimize MYSQL query (very slow records)

good afternoon, I would like to know if you could help me optimize my query. Since in regularly large tables of more than 1000 records it is taking a long time to list the results. My query is as follows: $q_juegos = mysql_query("SELECT * FROM...
asked by 16.11.2018 / 16:29
0
answers

Function PHP Yes Send mail but sometimes Do not save the data in MySQL

I have the following function: function pedido(){ global $db, $username, $usua, $logo, $footer_correo; // Datos recibidos del Formulario $monto = $_POST['monto']; $banco_emisor = $_POST['banc...
asked by 10.11.2018 / 12:17