Questions tagged as 'mysql'

Tagged questions
2
answers

copy table record to another ajax and php

I have the following function which receives an id as parameter: function terminar_tramite(ids) { var ID = ids; console.log(ID); $.ajax({ url: "lib/controladores/tramite_terminado.php", type: 'POST', data:...
asked by 10.04.2018 / 18:44
2
answers

Error connecting: access denied for the user '' @ 'localhost'

I am receiving data from some variables by means of url and I want to insert those same values into a MySQL database, but I'm getting an error:    Warning: mysql_query (): Access denied for user '' @ 'localhost' (using password: NO) in C: \ x...
asked by 01.04.2018 / 23:16
2
answers

what is happening?

I am doing a CRUD and when I finish filling out the form it appears that the "patient has registered", that is what I should say if the records are sent correctly to the table. BUT when going to the table there is nothing (records do not appear)...
asked by 17.04.2018 / 06:32
1
answer

Format date field, when loading text file to mysql

I try to insert massive records from a text file, I try to have the id as autoincremental, when entering the other fields, and to format the date fields of YY / MM / DD at the moment of insertion in the table. Since the format of the date fields...
asked by 04.03.2018 / 06:12
3
answers

Error mysqli_query () expects at least 2 parameters, 1 given in to Insert data

I am making a system in which at the time of entering the data, this error marks me.    Error: Warning: mysqli_query () expects at least 2 parameters, 1 given   in <?php require("connect_db.php"); if (isset($_POST['descripcion']) &&...
asked by 01.02.2018 / 22:28
2
answers

Erro when counting table fields with conditioned SELECT

Greetings. What I'm trying to do is the following. I need to count and show how many students have the payment date on the current day, to show it on an alert that says There are 4 students who must pay today. And I also want to list the names o...
asked by 03.01.2018 / 21:44
4
answers

Problem with the use of count in sql

I have a table with the following data named registers : -------------------------------------------------------------- id_plague | id_production | quadrant -------------------------------------------------------------- 4...
asked by 08.09.2017 / 14:11
1
answer

I put the fields in minuscule but Error 1215 still appears. Can not add foreign key constraint

I'm trying to run the script exported from a relational model I did using MySQL WorkBench , but when I try to create the bd I see an error, which I searched, and it tells me that it is due because the name of some fields are in capital l...
asked by 07.09.2017 / 19:52
3
answers

I need to add a php text

I need to add a text that I define in a textarea that is at the end of the code but when wanting to enter it for the first time I get an indefinite variable as I do to correct this attached code <?php session_start(); if (!isset($_SESSION[...
asked by 28.11.2017 / 16:20
4
answers

Sum of Hours and minutes MySQL in two fields

I am working with a program in PHP with connection to database MySQL everything has gone well except in the section to get the total number of hours between two columns named Entry and Exit. The program captures the hour of entr...
asked by 17.07.2017 / 18:17