Questions tagged as 'mysql'

Tagged questions
0
answers

I need urgent help

how I program a login in php that redirects the user according to the role <?php $usuario = $_POST['usuario']; $pass = $_POST['password']; if(empty($usuario) || empty($pass)){ header(""); exit(); } mysqli_connect('localhost','root','') or...
asked by 08.11.2018 / 02:56
1
answer

Error in PHP Post

I'm doing the final project about forms in my Web programming subject, but when I press the register button it shows me an error that says: Can not POST /register.php Here is my HTML code <!doctype html> <html> <head&...
asked by 11.11.2018 / 04:29
1
answer

help inserts empty data from xml to mysql php database

I have a program in PHP that reads a xml and inserts the data into a mysql database but when I run it inserts only empty data. Next I put the xml and the code that I am using: XML <?xml version="1.0" encoding="utf-8"?&g...
asked by 08.11.2018 / 17:45
0
answers

open port with windows server 2012 r2 digitalocean

Install in the digitalocean vps windows server 2012 r2, but it does not allow me to open ports. I already did it with the firewall configuration and I have disabled the firewall but it does not open any port for me     
asked by 06.11.2018 / 16:48
1
answer

Insert data using PDO

Hi, I'm running the following PHP-mySql codes, but I'm not one of them, and I have the slightest idea why, to see if any of you knows how to help me and thanks in advance Upload.php, this updates perfectly. <?php include_once "con.php";...
asked by 06.11.2018 / 17:04
0
answers

Sum of results in a MySQL procedure

I have the following procedure in a DB in MySQL: BEGIN SELECT(vista_detalle.numero,vista_detalle.id_empleado, vista_detalle.nombre, COUNT( CASE WHEN vista_detalle.tipo = 'S' AND vista_detalle.estatus = 'F'...
asked by 06.11.2018 / 17:09
0
answers

Sum of two columns with inner join

Good morning, someone who could help me, I need the sum of the amounts of two different tables through an inner join. This is the table "inventory_ticket" has as a foreing key the id of the table "inventory_list" this is fk_inventory...
asked by 06.11.2018 / 18:26
0
answers

SQLSTATE [HY093]: Invalid parameter number: number of bound variables does not match number of tokens

I have been working for a while with php and sql in Object oriented programming and I just started using sql tables in this I get this error:    SQLSTATE [HY093]: Invalid parameter number: number of bound variables does not match number of to...
asked by 06.11.2018 / 21:30
0
answers

sql query by multiple MYSQL columns

I want to consult by several columns with a concatenated value, I put the following example to make me understand -- Como se llamaría => CALL sp_getSuperConsulta("%val1% %val2% %val3%"); DROP PROCEDURE IF EXISTS sp_getSuperConsulta; DELIMI...
asked by 20.11.2018 / 22:24
0
answers

Make a system to restore a database using $ _Files

An independent doubt. Is it possible to make a system that restores the database of a website using $ _FILES? The one way I managed to do it was using this open source tool.          <?php /** * This file contains the Restore_Datab...
asked by 06.11.2018 / 12:57