Questions tagged as 'mysql'

Tagged questions
2
answers

Read Excel file with PHP

Good, I need to create a form where users can upload an xlsx file, and the web app validate the file then read it, and finally I need to put the information after evaluating it in a database, I'm using a PHPExcel library , the problem is that it...
asked by 30.03.2017 / 21:43
1
answer

Error "Undefined property:" in php

   (!) Notice: Undefined property: stdClass :: $ documentP in   C: \ wamp64 \ www \ mathematchy \ mathematchy \ controller \ logincontroller.php   online 48 I submit this error when I try to make another login on my page (localhost) ....
asked by 30.03.2017 / 04:28
1
answer

how can I select what I have in my database in this php file?

good! my problem is that I want to put a select of 2 tables but it does not leave my PHP file. this is the code <?php include('conexion.php'); $paginaActual = $_POST['partida']; $nroProductos = mysql_num_rows(mysql_query("SELECT * FROM tip...
asked by 29.03.2017 / 21:13
1
answer

Differences when executing stored procedure in local and server

I have the following stored procedure, which I run locally in Workbench and do what I need; however, I have the same database stored on a test server, and that's where I get the following message when I run it:    MySQL returned an empty resu...
asked by 28.03.2017 / 02:09
1
answer

Extract and save data from several related tables in Laravel

I am developing an enrollment form in Laravel 5.4 , as I have created five tables that have a one-to-many relationship: The main table tblFicha has a one to many relationship with the tables: tblDiocesis , tblRegionales -...
asked by 12.03.2017 / 22:49
1
answer

How to give value to input with a global variable jquery?

I have a select that in a file js is serving me for different things like a change so that I list those cities that depend on the id of the country, it turns out that now I need is that when you click on the option (en el select del pais)...
asked by 21.03.2017 / 23:22
1
answer

How can I update data from a multiple input select in mysql

I have a problem (I do not know how to do an UPDATE) when it comes to updating the student's file since it only changes the name and image of the student, and what I want to do is add or remove the courses in which it is enrolled from a multiple...
asked by 19.03.2017 / 15:12
1
answer

Error in menu with jQuery function

I have the following code: <script type = "text/javascript"> lightbox.option({ 'alwaysShowNavOnTouchDevices': true }); listapremier(); $(function(){ $('a').click(function(e){...
asked by 10.03.2017 / 01:58
4
answers

constraint problem 150 "Foreign Key constraint is incorrectly formed"

I'm doing a table creation in SQL and when executing create table discos_compactos ( id_disco_compacto int, titulo_cd varchar(60) not null, id_disquera int not null, constraint pk_discos_compactos primary key (id_disco_compact...
asked by 10.03.2017 / 08:08
2
answers

Pass data from one database to another with different tables (MySql)

I need to pass data from one table in a database to another database. In addition, in the new database some fields are not called the same but they must contain the same data (for example, in one table the field for cities is called "city" and i...
asked by 06.03.2017 / 11:51