Questions tagged as 'mysqli'

1
answer

Myslqi query of two tables with sum of records

Good to have if I can explain everything; I have two tables in the BD: productos +----+----------+--------+ | id | producto | estado | +----+----------+--------+ | | | | | | | | +----+----------+...
asked by 20.08.2018 / 07:08
0
answers

Update a local folder image and database

I want to update an image but when I try to do it, it gives me an error but it does not show me what it was, please if you can support me. Form to update <form action="actualizarimg.php"> <?php while($registro=$resultado-&...
asked by 08.08.2018 / 01:38
0
answers

fetch_array with 3 parameters?

I was doing a pagination to show one by one the records of a bd but to show the data with the fetch_array it only lets me put two parameters. How can I fix it? $registros = 1; //registros por página $sql = "SELECT * FROM base1"; $result = mysq...
asked by 05.08.2018 / 16:09
1
answer

how to return an output stored procedures MYSQL PHP

Some time ago I am looking for the web on how I can return an OUT in MYSQL with stored procedures in php. PHP mysqli_select_db($conexion, $database_conexion); $query_DatosWeb = sprintf("CALL genera_sesion()"); $DatosWeb = mysqli_query($cone...
asked by 04.08.2018 / 23:52
1
answer

Exists == or === in MYSQL

I have looked for the question, to see if something appears about it, but I think I have not seen it, if so, I apologize in advance. The point is the following, I have a query in mysql where in theory I should show 2 values, otherwise, do not...
asked by 31.07.2018 / 18:08
1
answer

MySQLi -insert_id returns value "0"

I have a management panel in which you can add even more administrators, but when I try to add them, I get an error. I have reviewed multiple times the data sent with die(json_encode($_POST)); and if all the data of the form arrive, but e...
asked by 31.07.2018 / 22:19
1
answer

Use result of an array in another php query

Hello I'm hardly new to PHP and Mysql I want to make a query with the result of another query arrar <?php session_start(); if (isset($_SESSION[' u_usuario'])){ $usuario1 = $_SESSION[' u_usuario']; } else{ header("Location: index.php...
asked by 30.07.2018 / 20:58
1
answer

Problems loading second page in front of my DataTables

In my DataTable I have as functionality to edit the table by clicking on the field (in the style of phpmyadmin) and in turn a button that performs a function . It must be said that my DataTables has the basic configuration to show the 10-in...
asked by 28.07.2018 / 16:12
0
answers

Paging comments mysqli and JSON

I have this code to page comments and answers but does not recognize it: ListaDeComentarios.php: require_once ("Conexion.php"); $memberId = 1; $commentId = $_POST['comentario_id']; $likeOrUnlike = 0; if($_POST['like_unlike'] == 1) { $likeOrUn...
asked by 28.07.2018 / 01:37
0
answers

Problems with databases in godaddy

I am trying to upload an online shopping site in godaddy, the problem here is that some parts of the web pages connect to the database and others do not, it can be said that the site works well on the local server of my computer and in a free ho...
asked by 25.07.2018 / 05:13