Questions tagged as 'mysqli'

Tagged questions
1
answer

Problem with LEFT JOIN in PHP

Hello, friends. I have 3 tables in my mysqli database to register access to a given location: visitor, whose data will always be filled. corporate, whose data will be populated only if the visitor represents a company. Vehicle, w...
asked by 19.09.2018 / 21:21
1
answer

Bring multiple join values into mysql

Well, I have a question about a mysql query using the Codeigniter Framework. I have the following tables: Products Table |--------|-----------------| | id | nome_produto | |--------|-----------------| | 1 | Camisa Tal | |--...
asked by 12.09.2018 / 03:52
0
answers

IONIC 3 how to save image with PHP + MySQLi

I'm new to IONIC and around here. All CRUD is working normal, but when I put the codes to image in BASE64 , I choose the image and it appears in SRC of the page, but the problem is in saving in BD MySql + PHP , becau...
asked by 04.09.2018 / 18:16
1
answer

Insert multiple records in MySql based on an X value and add fixed values

I need to insert multiple records in the database, but without coming from a form. For example: I have a value of 50 (it would be the number of records I need to insert) and a mooring id that needs to be the same for all records. My questi...
asked by 03.09.2018 / 17:21
2
answers

Hide a url

I have a problem, I tried Htaccess but I do not know if I did it right and nothing was right. I have a client registry, and when I am in the clients folder and I am going to make a change in a registry it shows in the url this: link The pro...
asked by 23.08.2018 / 17:45
2
answers

Show first and last record of each date

I would like to search the database for all records according to the "DOCTOR" between two dates DATA_INICIAL and DATA_FINAL Without repeating records of the day. CURRENT RESULTS: BRUNO BARBOSAS 02/04/2018 12:18 02/04/201...
asked by 26.08.2018 / 04:18
0
answers

Because my modal is not getting the post

This is the code that receives the post <?php if (isset($_POST['idModal'])) { $result = mysqli_query($conn, $query="UPDATE tb_cartao SET mtpag=Cartão, doc='$_POST[docModal]' , nome='$_POST[nomeModal]', tpd...
asked by 17.08.2018 / 14:19
1
answer

Provide files according to the client group using php

I need to make available on an Opencart 2 information page files of price lists, where one is for retail and the other for wholesale. The page that will show the link is only accessed if the client is logged in, now I would like it if it is regi...
asked by 02.08.2018 / 02:39
0
answers

Relationship of tables with error 1215

Hello, I'm trying to make a table relationship, it just gives me error ... I have my table tb_conta_fixa and my table users I want to relate the data created from tb_conta_fixa to table users ... I put this quer...
asked by 30.07.2018 / 20:01
1
answer

Warning: mysqli_real_escape_string () expects exactly 2 parameters, 1 given

I'm doing a posting system using PHP and Mysqli, but there are some bugs that I can not fix. Mycodesbelow..PHP<?phpif(isset($_POST['enviar'])){$autor=mysqli_real_escape_string(trim(strip_tags($_POST['autor'])));$titulo=mysqli_real_escape_s...
asked by 24.07.2018 / 00:16