Questions tagged as 'mysql'

Tagged questions
2
answers

Find frequency in MySQL tables

Here is my doubt. The system (PHP) has 6 identical tables (MySQL) that are the participations of users in certain events. Each entry in the table is unique but the data can be repeated in the tables. What I am not able to do is to search in thos...
asked by 24.11.2016 / 15:47
2
answers

Screen to configure connection with Mysql

I am currently using the following code to execute connections with my DB public class ConexaoDAO { public Connection getConexao() { try { return DriverManager.getConnection("jdbc:mysql://ip:porta/tabela", "usuario", "s...
asked by 22.11.2016 / 14:58
1
answer

Insert in two php database mysql [closed]

I want to insert data from one database into two databases at the same time using PHP / MYSQL. Is there a possibility? . I'm just getting through a connection, when I make the require of two connections nothing happens! I need a code ex...
asked by 15.10.2016 / 22:59
2
answers

avoid error log with mysql connection

Galera I make a connection to mysql using php. I do this: mysqli_connect($ip_bd_mysql, $login_bd_mysql, $senha_bd_mysql, $banco); The problem is that it's time for the BANK name to be wrong, and the system returns an error. How do I hide th...
asked by 19.10.2016 / 13:18
2
answers

Foreign key - Insert ID of table 1 in Table 2 PHP / MYSQL

Good afternoon, I'm a beginner in programming and I have the following difficulty. I have 2 tables: CREATE TABLE produto( id_produto int(10) NOT NULL PRIMARY KEY auto_increment, nome varchar(45) NOT NULL, )ENGINE=InnoDB; and the second...
asked by 05.07.2016 / 19:00
2
answers

Laravel, foreach and database

I have the following table in the database public function up() { Schema::create('cidades', function (Blueprint $table) { $table->increments('id'); $table->integer('uf'); $table->string('nome_uf');...
asked by 20.06.2016 / 19:52
2
answers

How to convert a DataSet to Int32?

I'm having a problem converting an information that is coming from my database to a variable of type Int32 . When I do the select max(cur_id) from tbl_curriculo; I send the id information straight to a Dataset which I call...
asked by 18.06.2016 / 07:07
1
answer

How to avoid the confusion of querys executed at the same time with Php and Mysql?

I have this php function (setBet) that registers the bets in my system based on BetFair, the fact is that I am wanting to expand the business and probably some bettor will make one bet at the same time as another. The function below First regist...
asked by 17.06.2016 / 19:26
2
answers

Sort classification according to the database | PHP

I have the following structure: Ihave3typesofclassification,followingthecoherence:1.0.0,1.1.0,1.1.1,1.1.2-Ihavetodisplayinfrontofthetitles,eachcontentthatbelongstoitsclassification,beingasfollowsatthetimeofdisplayingonscreen:>1.Meuconteud...
asked by 10.10.2016 / 21:21
1
answer

Capture value of last INSERT

I am creating a news system where the user has the option to register the news and put the original link where the news was generated, so far so good, the problem is that I want the user to have the option to register the news with the news link...
asked by 02.05.2016 / 20:29