Questions tagged as 'mysql'

Tagged questions
0
answers

Update draggable does not work

I have the following code, do not pass the variables to save-position.php to perform the update. index.php: <?php $servername = "localhost"; $username = "root"; $password = "password"; $dbname = "coords"; // Create connection $con = new...
asked by 05.08.2017 / 10:08
1
answer

MYSQL: Can not Connect to Database Server on Mac

I have installed mysql server and mysql workbench but when I enter the workbench and put the password, which was given to me when I finished installing the mysql server, the following sign appears:    Can not Connect to Database Server      ...
asked by 09.08.2017 / 17:56
1
answer

mysqli_fetch_object () expects parameter 1

I have a problem with my php code that sends me the following error    "Warning: mysqli_fetch_object () expects parameter 1 to be   mysqli_result, boolean ", This is my php code where I get an error. <?php include("connecti...
asked by 25.08.2016 / 14:49
0
answers

Avoid modifying tables with a trigger

I have a database where I am adding cards ... it would be something like this tarjetas identificador fecha_expedicion fecha_vencimiento estado saldo_actual where state is Boolean that accepts 0s and 1s ... that is to say 0 inactive and 1 ac...
asked by 03.08.2017 / 12:36
1
answer

Upload temperature data to a SQL database

Hello! I have a small project to upload temperature data to a database from a raspberry pi 3. I have seen several tutorials, but none of them have worked for me until now or the libraries that I download do not work. What should I do to ge...
asked by 31.07.2017 / 21:37
2
answers

Index out of range when performing an update

When executing the statement: ps.setString(i ,text[i].getText()); I get the following error:    java.sql.SQLException Parameter index out of range (1 > number of   parameters, which is 0); This is the code: void Guardar (JTabl...
asked by 02.08.2017 / 00:14
0
answers

Using jquery-ui to perform searches in a head, with suggestions results

I have built a search engine that is issuing suggestions as we enter text in your box, is inserted in a header with styles in Bootstrap, to create it, I have used php, MySQL, Ajax, JQuery and JQuery-UI (with its js and css), the search engine co...
asked by 06.08.2017 / 22:09
2
answers

How do I add the data that a field of a table contains?

Greetings, I need to generate a daily income report, the consultation is not my problem because I would have to select the amounts of the payment table where the payment date is today. My problem is that to make that daily income report I have t...
asked by 29.08.2017 / 02:19
1
answer

Error: Extra content at the end of the document

This is the php code where I want to generate an XML from the queries in MySQL: <?php header('Content-type: text/xml'); $xmlout = "<?xml version=\"1.0\" ?>\n"; $xmlout .= "<persons>\n"; $db = new PDO('mysql:host=xx...
asked by 26.07.2017 / 21:55
1
answer

Problem uploading file to bbdd with sql

I can not get this code to work for uploading the file to the bbdd. If it is saved in the directory but not in the bbdd. Code: <?php $nombre_archivo = $_FILES['archivo'] ['name']; $tipo_archivo = $_FILES['archivo'] ['...
asked by 24.07.2017 / 10:32