Questions tagged as 'mysqli'

Tagged questions
2
answers

How do I show the records in a table?

         Untitled document  Hello, I am very new to php and my teacher has asked us to do a CRUD I have managed to show the records in the database. but, he has asked me to show them in a table and I have no idea how to do it, try to do it...
asked by 05.04.2018 / 00:36
2
answers

Problem mysqli PHP: Access denied for user 'root' @ 'localhost' (using password: YES)

I'm having a problem when doing a test with a PHP code on my server. The code would be: <?php if(isset($_POST["id"]) && is_numeric($_POST["id"])) { $id=$_POST["id"]; } else { $id=1; } $mysqli = new mysqli('[IP de mi servidor]', 'ro...
asked by 05.03.2018 / 00:11
1
answer

MySQL does not collect data

I am trying to collect data to show on my page comments but not the table ... Can you help me? I have attached code and database capture. <?php $host_name = 'dbxxxxxx.db.1and1.com'; $database = 'dbxxxxx'; $user_name = 'dboxxxx'; $pass...
asked by 15.01.2018 / 08:30
1
answer

error query php sql phpmyadmin in data type SET, does not return the data correctly (write error)

I have a conculta to my database function ticketsanulacionpendientesSISTEMAS($conexion){ $pendientes = (mysqli_query($conexion, "SELECT COUNT(*) AS conteo FROM ticket WHERE tipo_solicitud = 1 && status = 1 or status= 2 or stat...
asked by 19.04.2018 / 17:18
2
answers

Doubt with the include php

File nav.php, the one that I use to include it according to the ticket_type of the user after logging in. <?php $active = array(); for($i=0; $i<7; $i++){ if($_GET['active']==$i){ $active[$i] = 'active'; } else{...
asked by 18.04.2018 / 21:00
1
answer

How to verify field in MYSQL before doing UPDATE [closed]

I have a question ... I'm doing a service order system and the customer is given a secret PIN When the technician arrives, he must request the pin to change the status of the PENDING order to IN PROCESS. The PIN is in MYSQL How can I ch...
asked by 12.02.2018 / 09:57
2
answers

Insert multiple rows with a different field and the others equal in php and mysqli

I'm trying to insert several rows in the same query Details: I have several fields in the table, and only one field would have to be different in each row, the other fields would be identical in each row. This is the code I have. but I do...
asked by 22.06.2017 / 01:36
1
answer

Why does a while loop show no existing data when used in PHP 5.3.0?

I have a while cycle to show a list of data using the following code: <?php $stmt = $conexion->prepare("SELECT desc_unix ,cos_unix FROM unidadesx"); $stmt->execute(); $resultados = $stmt->get_result(); $contador =...
asked by 02.05.2017 / 14:50
1
answer

Handle php results from ajax

I have a php file that collects data and sends it through ajax to another php that validates that the data entered are the same as those stored in $ _SESSION If they are the same, make an UPDATE in my database. I want to see if there is a way t...
asked by 20.11.2017 / 16:48
1
answer

SELECT does not work on a database with PHP

I'm trying to make a simple login. The idea is to look in the database for the user and password. The fact is that I have a SELECT that should take the rows with name and user that match those previously entered by the user. The...
asked by 24.08.2017 / 14:57