Questions tagged as 'mysql'

Tagged questions
1
answer

How to get the data of a DB and put them in the input to be able to modify them with Ajax and PHP

$('tbody').on('click', '.modificarBtn', function(){ var vidToUpdate = $(this).data('idest'); $.ajax({ url: 'update.php', type: 'POST', data: {vidToUpdate: vidToUpdate}, success:function(data){ $('tbody')...
asked by 28.09.2017 / 03:25
1
answer

MySql ExecuteReader does not bring results [C #]

good, I have the query, I am with a small project in C #, but I have the problem that a query that when executing it in mysql brings me the results correctly but when it is executed in my code, it recognizes me that it returns a row, but when I...
asked by 23.09.2017 / 23:54
1
answer

Difference of current date between PHP and Database

I have in my database (mysql) that I work with xampp, a Registration Façade field that is automatically fed with a CURRENT_TIMESTAMP . With PHP I consult the current date and time with the sentence date ("Y-m-d H: i: s") . All this in order...
asked by 23.09.2017 / 23:47
1
answer

fatal error: uncaught error: can not use object of type mysqli_result as array

I have this problem when calling the function to dump the data I want. I have created a function to list some items according to their id: function list_item_by_id_controller(){ global $link, $gf_query; $id_types = array('eid','hid...
asked by 22.09.2017 / 17:05
0
answers

Insert in Tables

<title>Cargando...</title> <? session_start(); $num_solicitud= $_POST['num_solicitud']; $num_propuesta= $_POST['num_propuesta']; $fecha_solicitud=$_POST['fecha_solicitud']; $cod_asegurado=$_POST['asegurado']; $nom_asegurado=$_POST[...
asked by 22.09.2017 / 14:19
0
answers

Return variables callbacks and how they are stored in a global variable for validations in sql

I am starting in programming with NodeJs and I have a little problem. I'm doing validations for registering new users on a website. And I'm doing the validation modules so that a certain field is not duplicated. //main.js var mysql=...
asked by 27.09.2017 / 16:05
1
answer

Join variable more word php mysql query

Hello everyone I have a question, how to join a word + a variabla in a mysql query php. $Sql_Query = "select * from usuario where user_email = '$email' and user_password = '$password' "; I want to add to the word user a variable that is lef...
asked by 04.10.2017 / 03:49
1
answer

show values of one method in another method with php oriented to objects

Good, I'm working with an object-oriented php, so I have one class and two methods, in the first method I have a foreach where I extract values from the database public function ambitosController(){ $respuesta = gestorOposicion...
asked by 18.10.2017 / 06:15
0
answers

NodeJs error Mysql throw err;

The error is that when trying to register a user the records are saved correctly in mysql, but in the console it shows me an error web.post('/registro_home', function (req,res){//AQUI INICIA EL REGISTRO DE NUEVOS USUARIOS var data...
asked by 23.09.2017 / 15:25
1
answer

Display bookmarks in google map v3 on android stored in MySQL

I want to know in a MYSQL database, where I have saved the coordinates, latitude and longitude. Use these values and by means of a web service show markadores in a google map v3 in android studio , I followed this t...
asked by 20.09.2017 / 16:14