Questions tagged as 'mysql'

Tagged questions
1
answer

MYSQL extension error [duplicate]

I put a code page on my site that looks for information from the database but on the file that connects to the DB and pulls the relevant information giving a supposed extension error. This error does not appear in localhost only when it is hos...
asked by 11.10.2016 / 23:19
0
answers

How to insert TAGs in a MYSQL database using PHP?

Good afternoon! I have a knowledge base system where each user can go in there and fill out a form and register the procedure he knows. I need to implement a TAG field in this knowledge registration form, this field will be used to future the do...
asked by 09.10.2016 / 20:06
1
answer

How to concatenate a list of an object in a property of another object?

I have the following template: public class Usuario { public int idUsuario { get; set; } public string Nome { get; set; } public string Email { get; set; } public string Senha { get; set; } public int Permissao { get; set;...
asked by 08.10.2016 / 19:18
0
answers

Mysql - What is the best index to be created in this case

Hello, I have a table in the database with the historical prices of products. This table is very bulky with more than 1 billion records. How can I create an index in this table, to answer the query below: select cd_produto_price,...
asked by 10.10.2016 / 01:26
2
answers

What is the difference of bindValue for an array executed directly in $ pdo-execute ()

I currently use a schedule like this <?php $array = array('nome'=>'Alisson', 'idade'=>20); $query = $conn->prepare("INSERT INTO table (nome,idade) VALUES (:nome, :idade)"); $query->execute($array); ?> What's the differe...
asked by 18.12.2015 / 02:52
0
answers

Php Filter Search Mysql

I have a MySQL database with several tables. Their name below: Table: formacao Table: idiomas Table: usuarios I need to filter information, eg: The person wants the candidate who is a bricklayer, who kno...
asked by 05.10.2016 / 12:25
0
answers

When giving rollback in transition, reset the id to the last id actually inserted

I want to avoid having to jump in auto increment of id , in case there is an error and I make rollback in my transaction. And at the same time I want to make sure that there is no error if I change the auto-increment in case of simu...
asked by 05.10.2016 / 23:43
1
answer

error with MySQLi - not registering in the database

I'm migrating from MySQL to MySQL and have some errors in my script that are not inserting in SQL <?php $host = 'localhost'; $user = 'root'; $pass = ''; $db = 'controleestoque'; // conexão e seleção do banco de dados $con = mysqlI_conne...
asked by 06.11.2016 / 01:38
0
answers

Help to select mount in bank

Hello, I need to set up a query in the database that returns a set of records but since I do not have as much experience in the database I would like you to give me some help. It is as follows: I have the tables tb_partida (id, flag_active,...
asked by 07.11.2016 / 22:44
1
answer

MySql Connector sending null value

I have the following code: MySqlConnection mysql = new MySqlConnection(CONEXAO); mysql.Open(); try { MySqlCommand dbcmd = mysql.CreateCommand(); dbcmd.CommandText = "INSERT INTO robos (id,nome,cabelo,olhos,bracos,boca,cabeca,pernas,cor...
asked by 07.11.2016 / 17:36