Questions tagged as 'mysqli'

Tagged questions
2
answers

How do I use variables within this PHP + MySQLi code? [closed]

My code returns the following error:    Parse error: syntax error, unexpected T_VARIABLE in /home/a2015539/public_html/envio.php on line 28 The code is this: // Create connection $conn = new mysqli($servername, $username, $password, $db...
asked by 19.12.2016 / 23:34
2
answers

Display multiple records within a single MySQL [duplicate]

I have a question about assembling a select. I have 3 tables that relate M: N as follows: CurrentlyI'musingthissql:selectp.descricao,(selectdescricaofromitemwhereitem.codigo=c.codigoItem)asitemsfromprodutopinnerjoincomposicaoconc.codi...
asked by 04.01.2019 / 20:43
3
answers

How can I check for equal variables within a while

How can I check for equal variables within a while? Type if there are lines as the same CODE do something ... Low I put my example $bd = new MySQLiConnection(); $sql3 = $bd->prepare( "SELECT * FROM agenda_saidas WHERE id_transfer...
asked by 04.09.2017 / 17:06
2
answers

Insert ID of a Table in another Table [duplicate]

How do I insert the ID of a table into another table? <?php $login_cookie = $_COOKIE['login']; if (!isset($login_cookie)) { header("Location: index.php"); } $con = mysqli_connect('localhost', 'root', '', 'lista'); $paginas...
asked by 02.09.2017 / 21:26
3
answers

Select different values in two tables - SQL and PHP

I have two tables in the tt_order and the request_grade , what I want to do is compare the values in the " request " column of the table and the column " n_pedido " of the request_grade, basically I would like to get the values you have in th...
asked by 22.11.2017 / 17:02
2
answers

Problem in insert does not display error [closed]

Personal beauty all? I've already gone through the entire forum and up to other forums and found no answers about it.  If anyone can take a look and point out my error thank you. Follow the form below: <form action="add.php" method="p...
asked by 27.05.2017 / 16:38
3
answers

How to make more than one select in the same query in different DB tables?

The problem is as follows: I have the tables: Whatareforeignkeysinthefollowingtable: AndIneedtopullallthenamesofthe"connector_model", "connector_name" and "connector_type" columns and concatenate and echo an individual search. To do th...
asked by 06.03.2017 / 19:07
1
answer

MySQL Error 1064

In the insert below I get the following error. INSERT INTO dump1090 ('hex','squawk','flight','lat','lon','validposition','altitude','vert_rate','track','validtrack','speed','messages','seen') VALUES ('e4827e','3670','TAM3754 ','-22.850818','-4...
asked by 28.11.2018 / 17:30
2
answers

Add in MYSQL query in varchar field by removing Strings

asked by 19.09.2018 / 21:23
2
answers

Call to a member function fetch_assoc () on a non-object

I used MySQL and PHP in wampserver, now coma last version it uses MySQLi I'm having problems with the following command:          // Executa uma consulta que pega cinco notícias $sql = "SELECT * FROM 'usuarios'"; $query = $mysqli->query($sq...
asked by 29.02.2016 / 20:21