Questions tagged as 'mysqli'

Tagged questions
1
answer

I can not find the error of this Stored procedure

delimiter $$ create procedure reposta(out mensagem varchar(100)) begin if new.codigo_veiculo != null then set mensagem = "Algum veículo está sendo utilizado"; end $$ delimiter ; error that appears    Code: 1064. You have an error in you...
asked by 12.06.2017 / 14:56
1
answer

What kind of Mysql data should I use to register random numbers for requests

Colleagues. I am creating a registry where a request number is generated for the user. The structure is as follows: $prefixo = "CAD"; $idCadastro = mysqli_insert_id($this->conexao); $rand = rand(100,999); $ano = date("y")...
asked by 15.02.2017 / 00:51
2
answers

database only saving the password [closed]

This is my first post here, I've been following the forum for a long time but I never wanted to interact, today this will came along with a little problem ... To learn html, css, php and etc ... from tutorials, after countless failures...
asked by 14.11.2017 / 10:41
1
answer

Update Mysqli Data

I need to make the DB update the following data from this wireframe via MYSQLi, I would like some tips on how to proceed:     
asked by 18.04.2016 / 20:13
2
answers

How to merge edit / new button?

I would like that, if already there is $nome registered in the table, it gives an update and if it does not exist, it gives an insert. I do not understand what the problem is in my code. $dbconn = mysqli_connect($servername, $username,...
asked by 01.07.2017 / 13:24
1
answer

Error in PHP Code Warning: mysqli_select_db () expects exactly 2 parameters, 1 given [duplicate]

The error of my code is in the Connection to the database, it is the following:    mysqli_select_db () expects exactly 2 parameters, 1 given <?php $servidor='localhost'; $banco='isartes'; $usuario='root'; $senha=''; $co...
asked by 03.11.2016 / 15:17
1
answer

PHP does not save information in MYSqli

I'm doing a simple registration program, but I do not know why Form data is not being saved in the Database (MYSQL). Can someone please give me some help on this? Follow the Gadget: <?php include("conexao.php"); If(isset($_POST['nom...
asked by 15.06.2018 / 18:44
1
answer

How to do a mysql query from a link

I have seen in some sites links that make mysql searches and return results, ie, make a mysql query from a link instead of a field. Assuming the link within the tag to is like this: href="https://www.meulink.com" name="camisas" >Camisa...
asked by 15.06.2016 / 17:55
1
answer

Why is my foreach duplicating my database records?

function DBRead($table, $params = null, $fields = '*'){ $table = DB_PREFIX.'_'.$table; $params = ($params) ? " {$params}" : null; $query = "SELECT {$fields} FROM {$table}{$params}"; $result = DBExecute($query); if(!mysqli_...
asked by 05.09.2018 / 22:12
1
answer

How to make condition with msql number [closed]

Personal I need a lot of help I have an input for the person to make a transfer in cash but if that person has 30 reais of money and she enters a value of 100 reais to make the transfer she will have balance -100 eu I want her to be able to tran...
asked by 24.07.2018 / 03:44