Questions tagged as 'mysql'

Tagged questions
0
answers

How to generate a report in excel with multiple fields

I want to generate a report with excel where the user may or may not enter one or more fields esta es la estrucutura de mi base CREATE TABLE 'tablacompleta' ( 'supertoken_id' bigint(20) NOT NULL, 'num_bug' bigint(15) DEFAULT NULL, 'n_caj...
asked by 24.03.2018 / 01:31
1
answer

how can I save data from an html form to a mysql db

Hello, I need to know how to save data to my mysql database using php: - this is my connection      $con = mysqli_connect($host,$user,$pw,$db) or die ("no conecta al servidor local"); mysqli_select_db($con,$db) or die ("no conecta a la b...
asked by 23.03.2018 / 18:03
1
answer

insert pdf in a mysql database [closed]

you can enter a pdf file in a mysql database and how the process would be, such as the fact that the data was a pdf file, and how it is in a query     
asked by 23.03.2018 / 14:34
0
answers

Use stored procedures to make calculations between 2 tables.

I have these two mysql tables, one of routes. Sales table: What I'm looking for is to implement a stored procedure, so as not to burden the php application so much. Let the process take as inputs: * tabla_rutas.num_corrida,...
asked by 31.03.2018 / 02:28
0
answers

pass variable url to json

good day I'm new to php and I have a calendar code created in php and mysql what I want is to make the calendar in the query apart from filtering by dates filtered by a user that is sent by a variable url attached the code . when I put the varia...
asked by 20.03.2018 / 21:33
1
answer

Error: mysqli_num_rows () expects parameter 1 to be mysqli_result

I have a problem with a query in php and mysql, I do not know why it shows the following error in two lines of my code, it shows it in line 35 and line 45:    Warning: mysqli_num_rows () expects parameter 1 to be mysqli_result,   boolean give...
asked by 20.03.2018 / 21:33
0
answers

I have an error when uploading data to the database

I have a problem when uploading the data, when I register it, it sends me the message that "supposedly" the function execute () returned "true", but when I check my db, nothing of the data appears. I'm using PDO and so I have the codes: contr...
asked by 21.03.2018 / 19:54
1
answer

Use a case with data from a table and have the results of that case save them in a table

I have 1 table called 'CFACTURACOMISION' which has the columns. CLFILIAL, CLCLIENTE, CLASESOR, FOFACTURA, DACHAFACTURA, MNFACTURA, MNDESCUENTO MNIVA, MNTOTAL, FEVENCIMIENTO, CONDICIONESDEPAGO, PROMVENTA. The main objective of this table is...
asked by 20.03.2018 / 18:36
0
answers

Second variable by ajax

I am trying to pass a second variable by ajax to detect the language. But only the predictive text that I enter in the input passes me. I do not know where the fault may be. These are the input of my form: <input type="hidden" id="idio...
asked by 21.03.2018 / 15:13
0
answers

Error sending data to mysql with ajax

I'm trying to send data from a form with JS to PHP through Ajax but I can not get it sent. This is the code of a separate sheet of JS function objetoAjax() { var xmlhttp = false; try { xmlhttp = new ActiveXObject("Msxml2.XM...
asked by 29.03.2018 / 07:01