Questions tagged as 'mysql'

Tagged questions
1
answer

How to update my MySQL code for MySQLi?

I have codes that use mysql and need to update to mysqli . I need to make two changes, these being the .php pages that insert the data into the database table and data and also the pages that display the data. How to pr...
asked by 22.01.2015 / 15:24
0
answers

How to work with dynamic form in jquery?

I would like to know how I can work simply with this dynamic form, the type comes from the database via jquery and ajax and appears on the screen as a form for the user to select their request. As you can see in my code only the input of the tab...
asked by 05.02.2017 / 21:08
0
answers

Upload buttons selectively via Mysql - Maps API

I have a question about loading pins from a Mysql database. Let's say I have a database that stores several latitudes and longitudes and needs to load some pins from them via the GMaps API. However, this gave me a question: My intention is...
asked by 22.01.2017 / 18:48
2
answers

How do I make a database search appear in a table?

A few days ago I'm trying to make my DB search look inward to a bordered table. However, although the server does not return any errors, no results are shown. I have already made several changes in the syntax regarding the positioning of the tag...
asked by 26.12.2016 / 22:14
2
answers

Data not being written to DB by PHP

I'm studying object-oriented PHP and, from some tutorials taken from the net (pdo, pojo, Dao ...), I made a very simple system in which I get the value entered in <input type="text"> and write to the database. data. By the way, y...
asked by 18.01.2017 / 17:26
1
answer

SQL - Import data from a file

Hello, how are friends? I'm having a problem importing a previously created table: The following return message when I try to perform the import in MySQL: Static analysis:    3 errors were found during analysis.       Unexpected cha...
asked by 18.01.2017 / 04:18
1
answer

Because the form only worked once

Hello, I made a small form and it only worked once, I did not change the code after that and it does not work anymore what could it be? <?php error_reporting(-1); ini_set('display_errors', 'On'); //Criar a conexao $link = new mysqli ("loca...
asked by 18.01.2017 / 21:05
0
answers

SQL Select inside a select with condition

I have 3 tables in the database to control a "news portal", where the tables have the following functions: news - > News Table gallery - > Table with images used in news relationship - > Table relating news stories to images...
asked by 19.12.2016 / 19:20
0
answers

How to perform subquery with autocomplete

Query code: $parametro = (isset($_GET['parametro'])) ? $_GET['parametro'] : ''; if($acao == 'consulta'): $sql = "SELECT codigo,preco FROM produtos "; $sql .= "WHERE descricao LIKE ? LIMIT 1"; try{ $query_select = $conecta->prepare($sq...
asked by 19.12.2016 / 18:24
2
answers

Query creation with Union ALL to merge tables with indexing by table name

I have a problem that they made in a database, which I need to solve temporarily, they created several tables with index in the table name, where the system creates a new table with each new user ... probably the developer created this new probl...
asked by 09.01.2017 / 14:17