Questions tagged as 'mysql'

3
answers

Compare Texts in mysql

I need to make an Insert to my database, my table is called "Topic" which keeps an idTema, textTeam and date. The point is that when I want to insert a topic, I must check if a similar theme already exists (in other words). I'm doing something l...
asked by 26.12.2017 / 17:40
0
answers

How can I display the data of my mysql table in a TKinter List text in Python 2.7?

I am trying to develop a graphical interface for my MySQL database with Python 2.7 TKinter. I was checking the tkinter documentation as well as other sources but I can not get the records in my table to be displayed inside the list box instead o...
asked by 20.12.2017 / 21:50
1
answer

Foreach travels PDOStatement object in some cases and in others not. Why is it?

I'm working on a PHP project with connection to MySQL , but I have a problem, when I do select , in some cases foreach can go through the PDOStatement object and in others do not, I do not know if I owe it to the cons...
asked by 20.12.2017 / 16:31
0
answers

Problem with getInt from jsonResponse

I have a Score.php file to update to a field called score of integer type in a mysql database: $con = mysqli_connect("localhost", "root", "", "basededatos"); $user_id = $_POST["id_user"]; $username = $_POST["username"]; $score= $_POST["score"...
asked by 19.12.2017 / 20:12
0
answers

Dilemma Laravel 5.5 ORM and Database

I have a query regarding the logic that I should use to use in production in a real estate system: In a form charge (itero) the environments: // ... formulario @forelse(App\Ambiente::all() as $env) <fieldset class="form-group col-md-...
asked by 02.01.2018 / 22:24
1
answer

Data entry in MySQL using PHP

Good morning everyone. I am studying PHP and I have had a problem entering data in MySQL. I have a contact entry code, I would like you to help me improve it, that I can make inquiries and how to do it, if possible with some practical example...
asked by 18.12.2017 / 14:55
1
answer

Select by default, depending on the value returned in MySQL?

Good afternoon I have the following code: <div class="form-group"> <label for="exampleInputEmail1">Centro de formación: </label> <select class="form-control" name="centroformacion" selected="Cen...
asked by 18.12.2017 / 20:06
0
answers

error (1054, "Unknown column 'useriorol.id' in 'field list'") django 1.10

Good afternoon, as you can see I present the following problem: error (1054, "Unknown column 'useriorol.id' in 'field list'") django 1.10 at the time of entering the administrator I select the useriorol option and I see this error. the admin....
asked by 18.12.2017 / 21:59
1
answer

How to check if a room is available?

I have a database with 6 tables T_cliente , T_hotel , T_reserva , T_tarcre , T_tarifa and T_tiphab . Here is the UML diagram. What I do not know how to do, is to check if the room is available or not....
asked by 12.12.2017 / 16:42
1
answer

error in accepting unicode in django-python 2.7.1o

Good morning for everyone. The error that comes up is the following: At the moment I am trying to connect the database with django using mysql and the version of python 2.7.10 when using python manage.py and makemigrations in the end is as fo...
asked by 11.12.2017 / 15:05