Questions tagged as 'mysql'

2
answers

Dynamic Connection EF C # Windows Forms Mysql

I have the following problem: EF creates a connectionString in the app.config of the application and always uses that connection, but in case you need to change the server of the bank I will have to change the app.config. I have tried a wa...
asked by 11.03.2016 / 23:27
1
answer

Inner Join - return by id column name of another table

I have two tables in the DB: category table: id_categoria | nome_categoria 1 camisetas 2 estrelas post table: id_post | título | resumo | conteúdo | categoria_id 1 teste lorem ipsum...
asked by 11.03.2016 / 01:57
1
answer

Help with GROUP_CONCAT (MySql)

I would like to use grupo_concat for filename and answer but would not repeat the values of filename and answer Follow sqlfiddle: link It is a question that has 2 images and 4 alternatives of A-D....
asked by 03.08.2018 / 21:21
1
answer

Registration insertion with webservice returns error but inserts into the database

Hello, I have a javascript function that makes an ajax call to a php file that should insert the records into the MySQL database. Well, I'm getting the records but the function is returning an error. Does anyone know the reason for the error? Tha...
asked by 28.09.2016 / 15:40
1
answer

Help to convert from mysql to mysqli

I'm a little bit lazy in PHP and MYSQL, and I'm having an issue needing help converting the connection in MYSQL to MYSQLI follow the codes below: mysql.php <?php Class mysql { public $query; public $fetchAll; public $resu...
asked by 04.06.2016 / 16:05
1
answer

Issue Services Statement

Good afternoon, I'm trying to send an extract of services from my registration. Follow my database CREATE TABLE 'cad_cliente' ( 'id_cliente' smallint(5) UNSIGNED NOT NULL, 'nome_cliente' varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT...
asked by 07.06.2016 / 20:15
0
answers

Filter Products by Category in Opencart

I have code in Opencart , it randomly displays the products in the store. I would like to modify this code to display the products of a specific category through id or in the best way. The original code where I believe the modification can b...
asked by 09.06.2016 / 15:41
1
answer

Mysql, access denied for user, using password: no

When creating a new project in rails using mysql rails new exemplo -d mysql and then rake db:create I have the following error Acess denied for user 'root@localhost' (using password: NO) Please provide root password for your MySQL in...
asked by 26.07.2016 / 17:27
0
answers

Write data to the bank [closed]

Hello, I have a function in javascript that adds fields to my form. And I want to save the values of these fields in my database. The field code is these. <div><input type="radio" name="opcao2" value="Mae"/><label>...
asked by 14.01.2016 / 13:46
0
answers

Implementation of Doctrine 2.5 in Laravel 5.1 using the mysql database configuration

I started using the laravel recently and I was able to set up almost everything , but when configuring the database, right after installing Doctrine, it returns me this error:    SQLSTATE [3D000]: Invalid catalog name: 1046 No database sele...
asked by 21.12.2015 / 16:26