Questions tagged as 'mysqli'

Tagged questions
0
answers

Undefined variable mysqli php

hello I have the following problem with this there is something wrong: $results = $mysqli->query ( " SELECT * fron jose"); print '<table border="1">'; while ($row=$results->fetch_assoc()) { print '<tr>...
asked by 31.10.2018 / 23:50
1
answer

Add all the fields of the same column of several MySQL records

I have a table with several records, and let's say that each one collects the visits it has (for example). How can I get the total of visits? But not of all, but of those who fulfill a condition. That is, if I have: | Cat | Visitas...
asked by 28.10.2018 / 13:03
0
answers

My PHP Script Send incomplete mail with the data of a WHILE

Greetings guys I have a conflict that I explain below: I have the following script <?php $sql2 = "SELECT tarjetas.*, users.nombre, users.email, users.username FROM tarjetas INNER JOIN users ON tarjetas.usuario=users.idusuario WHERE usua...
asked by 01.11.2018 / 19:19
1
answer

MySQL Show all data to the LEFT of a table

I have the following problem. I formulated an SQL query that gives me data of trucks that work during the current week , the problem is that I need to show all the trucks, including those that have not worked during the current week (with data...
asked by 25.10.2018 / 21:47
2
answers

Problem when creating html table from MYSQL with PHP

I am creating a table with data extracted from my MySql database with php but when I want to start showing the data it marks me errors like:    Warning: mysqli_query (): Empty query in   C: \ xampp \ htdocs \ Safety \ table.php on line 29   ...
asked by 23.10.2018 / 18:58
0
answers

Register form multiple php-mysql?

Good day, I need your support, how can I register a series of selected data in radio button and store them in my database, this my code. It is a form of 16 questions each question with 3 answer options. <form method="post" role="form">...
asked by 23.10.2018 / 00:18
1
answer

Validate query result equals a carater

I'm doing a Login project, and what I want to do is that if it's a user on the side and if it's admin between another, I'm already validating the user and password but I have the user-type field in my DB that is A if it is admin and U if you are...
asked by 24.10.2018 / 21:08
2
answers

Table Fields MSQli Variables?

I have to fill in a table, with data collected from a form. The problem is that I do not know which field of the table will be modified, until I receive the PHP variable. Exactly: $updatewin = "UPDATE live_chess SET Round1='1' WHERE Team='$Tea...
asked by 05.11.2018 / 06:28
0
answers

How do I send a route to a Database and then a notification to a Device?

I have an application, which makes a route, and those coordinates I want to send them to a database, either realtime databes of firebase or mysql, but every time I send a new route I want to send a notification to a single cell.     
asked by 21.10.2018 / 05:36
0
answers

Php qualification system mysql

Well here with a doubt: I currently have a user rating system. My question is how could I save the id of the user I want to qualify for, so that after doing a SELECT I bring in console all the comments and the rating that user has. The...
asked by 24.10.2018 / 01:14