Questions tagged as 'mysql'

Tagged questions
1
answer

I'm starting to use mysql and Php but my PHP file is blank

When sending my form via php the page is blank and does not show the text outside the php, here I leave the code HTML: <html>     <head>  <meta name ="viewport" content="width=device-width, initial-scale=1.0"> <title>...
asked by 02.07.2018 / 16:57
0
answers

Differences between epoch and timestamp?

I thought that epoch and timestamp represented the same value, with the same number, although getting values with getTime() of class Timestamp in Java, this does not it's like that. The epoch value seems to be the one obta...
asked by 29.06.2018 / 23:56
0
answers

Full text search engine using explode between different tables

How can I fix my code? I need that my search engine can find my posts by entering an array of words but I look for it in 3 different tables that I have in my query, for example if I put 3 words that look for them in my keywords, title or body_va...
asked by 29.06.2018 / 18:24
1
answer

Update database data without updating page [closed]

I have a question: I want to update the data that is seen in my php web that is connected to a database and that what changes in the database is updated on the web without updating. I know it's done with "Ajax" but the only tutorials I found are...
asked by 30.06.2018 / 03:11
1
answer

Checking mysql with Google Chart does not bring data

Sorry I am new in PHP and I am doing graphics with Google chart and it does not bring me the data that I consult to mysql ... I attach data of the query and after the configuration of the script .. The query is to a table that it contains fuel c...
asked by 01.07.2018 / 15:03
0
answers

Error with java.sql.Date.valueOf

In this part of the code: int seleccionado = cbotipo_reserva.getSelectedIndex(); dts.setTipo_reserva((String) cbotipo_reserva.getItemAt(seleccionado)); //fechas Calendar cal; int d,m,a; cal=dcfecha_reserva.getCalendar();...
asked by 30.06.2018 / 03:24
0
answers

Problem with connection from java to mysql

The problem lies in the moment of connecting, it throws me an error, I'm working with workbench 8.0. This is the code: public static Connection getConnection() { Connection conexion = null; try { conexion = null; C...
asked by 30.06.2018 / 04:42
1
answer

Insert multiple records from php and mysql

I have the following code: $cantidadcupos=$_POST['cantidad_cupos']; $idparking=$_POST['idestacionamiento']; for($i=0; $i<=count($cantidadcupos) ;$i++){ $query="INSERT INTO cupos(numero, estado, reserva_id_reserva, estacionamiento_id...
asked by 29.06.2018 / 07:07
0
answers

How to avoid two users repeating the same value in the database?

<?php session_start (); include 'dbh.inc.php'; include 'login.inc.php'; $nuevonick = $_POST['nuevonick']; $userid = $_SESSION['user_id']; if ( isset($_POST['btnactualizar']) ) { $sql = "SELECT * FROM users WHERE user_nick = '$nuevoni...
asked by 29.06.2018 / 01:27
0
answers

ClearDB or Jaws DB?

I am about to set up my SQL database for my application . Heroku seems to offer two types of SQL databases in June 2018: ClearDB MySQL and JawsDB MySQL . I do not know either? Which to choose? I'm new to web deployment and I want the simplest...
asked by 30.06.2018 / 23:46