Questions tagged as 'mysql'

Tagged questions
1
answer

How can I put an if in this mysql search when it returns no results?

How to put an if and else in this code for when the search in the database returns no value? include_once("conexao.php"); $sql= "SELECT FROM tb_nome WHERE nome LIKE '$pesquisar%'"; $salvar = mysqli_query($conexao,$sql); while ($linhas = mysqli...
asked by 11.06.2018 / 01:54
1
answer

How to generate random numbers starting from 00000 to 99999 without repeating using MySQL only [closed]

How to generate random numbers starting from 00000 to 99999 without repeating using MySQL only, the numbers can not start in 000, does anyone have any idea how I can do this?     
asked by 26.04.2018 / 15:03
1
answer

Include new table in several Mysql database at one time

I do not know if it would be possible, but we took a PHP / Mysql system from which each client has its own database. But we are creating another tool for this system and of course, it will have a new table in the databases. The problem is that t...
asked by 26.04.2018 / 13:16
1
answer

Query on very large tables delay? Mysql

I'm developing a system that I expect to get big in the future and I'm having a dilemma: storing an array in each user's data or creating a specific table with all that mixed information (Ex: cars of each user) My question is: If I make...
asked by 03.04.2018 / 17:19
1
answer

Fill in combobox, and get value menber vb.net and mysql

I need to populate a combobox with my mysql database, and then get the value menber to insert into the database Att. I am needing help from a person who knows about visual basic.net, I am with a system, for a company that works in software, w...
asked by 01.04.2018 / 21:50
2
answers

HTML / JS / PHP: Transform date entry into dd / mm / yyyy

Good morning. In my mysql database the dates are saved as dd / mm / yyyy, but the html "date" input only returns dates in the format yyyy-mm-dd, so I can not filter the dates of the database, which was my goal. I was using a very simple code, li...
asked by 06.04.2018 / 12:56
1
answer

Form select with Laravel

I have this code working, but I would like to know if I would have a more elegant way of writing the following code in the view, through Laravel's forms: <div class="row"> <div class="col-xs-12 form-group"> <label fo...
asked by 07.05.2018 / 04:06
1
answer

Select MySQL with 3 arrays

I have a MySQL table where the primary entries are 3 columns: YEAR, NUMBER, and PLOT. Home The column NUMERO is a sequential numbering for each YEAR, however it is possible that for a same number there are several PLOTS. I need to perform a SELE...
asked by 05.05.2018 / 13:17
1
answer

Database data for web page

I needed help because I wanted to send the data from my database to the webpage BASE DATA FIELDS: Id_Produto , NomeProduto , PrecoProduto , DescricaoProduto , QuantidadeProduto , CategoriaProduto - TABL...
asked by 29.05.2018 / 16:31
1
answer

Create input of type = submit within the calendar code

Calendar code with checkboxes on each day of the month to book meals: <?php # PHP Calendar (version 2.3), written by Keith Devens function generate_calendar($year, $month, $days = array(), $day_name_length = 3, $month_href = NULL, $first_...
asked by 22.03.2018 / 12:20