Questions tagged as 'mysqli'

Tagged questions
1
answer

Date can not enter the bbdd

Problem: The date of birth, does not enter the bbdd. I cut out as much as possible both the code and the form and the answer it gives me when I want to enter. The reality is that there are 25 fields. And several are date, several are select, oth...
asked by 29.09.2017 / 23:29
2
answers

How can I pass this code to Mysqli [closed]

Muy buena tarde quisiera pasar este codigo para mysqli <?php /* Clase para ejecutar las consultas a la Base de Datos*/ class ejecutarSQL { public static function conectar(){ if(!$con= mysql_connect(SERVER,USER,PASS)){...
asked by 23.09.2017 / 23:52
1
answer

Complicated MySQL query between multiple tables

Greetings! The Query is about users, comments and the action on the comments (LIKE or DISLIKE). I try, but I do not know how to make the following return: comment data, user data, LIKE total, DISLIKE total, action action: this will be of t...
asked by 28.09.2017 / 01:39
0
answers

Sometimes I do not recover the varaible of SESSION in php

I have a ticket system, when doing a registration I have to insert in 3 different tables (sometimes up to 4 tables) from a single form ... One of the data that I have to insert in the Database is a session variable and here is the problem, since...
asked by 05.09.2017 / 16:50
1
answer

Pass 2 or more variables in php

Happy Friday and happy weekend! I have a couple of problems, one could be resolved if I pass at least two variables to the next page. One works well link = '098usredit.php?idusr=' . $row098['98idusr']; Of pure ambition I wanted to spen...
asked by 03.11.2017 / 23:22
1
answer

Load data in an Input when selecting the data of other input

I need to select the document number of an Input from a list that is displayed, load the name to which that document number belongs in another Input. Example, when selecting the document number 12345, load me in another input, for example Pepito...
asked by 05.08.2017 / 02:26
1
answer

Use the same variable in two PHP functions

<?php require_once 'config.php'; // INICIA FUNCION 1 function saveInvoice( array $data){ if( !empty( $data ) ){ global $con; $count = 0; if( isset($data['data'] )){ foreach ($data['data'] as $value) {...
asked by 26.07.2017 / 00:25
2
answers

Mysql query that shows matches and then the rest of the rows

I have a MySql database in which I keep activities with the following structure. id (int) | nombre(varchar) | descripcion(text) | mes(tinyint) What I'm trying to get is to show in php a list of them from the current month. Until...
asked by 05.06.2017 / 01:49
1
answer

How to compare two rows of different tables and get records that meet condition, if not, show null MySQL?

I have two tables with the same fields, but each user inserts different records (there is a range of 78 possible records that each user can insert in their table) what I want to be able to do is obtain in which fields the records are similar and...
asked by 26.06.2017 / 20:08
2
answers

help login android studio, does not show values of $ user because it is not a JSONobject

PHP Code. <?php require('conexion.php'); $User=$_POST['User']; $Pass=$_POST['Pass']; $sql="SELECT User,Pass,TipoUsuario FROM tb_usuario WHERE User=? AND Pass=?"; $stmt = $conn->prepare($sql); if ($stmt->execute(array($User,...
asked by 17.05.2017 / 22:56