Questions tagged as 'mysql'

1
answer

How to insert data from a form made in Angular2 in a Database?

I'm starting to learn Angular 2, and I have to do a CRUD of a system on series, and I need to store data in a database, I currently know how to use MySQL using Xampp. I need to make the request using Ajax. Here is the function you want to cal...
asked by 03.07.2018 / 02:47
1
answer

Handling error connecting to MySQL with PDO

I would like to handle the error that occurs if the MySQL server is not running, I want only one message to appear so I made the following code: function mensagemErro () { throw new \Exception("Error connecting to database"); } function con...
asked by 03.01.2019 / 16:10
0
answers

I need help with Phreeze

Hello, I'm creating a real estate survey system and I'm using a CRUD (phreeze) generator to get the service up a bit, but I have the following question: I created a table in the database called external area and placed the columns in it:   ID...
asked by 03.01.2019 / 21:31
0
answers

I am not receiving data via $ _POST

I'm doing a 'project' with the MVC architecture and I'm having a problem, I already send data via post and get, but I do not know what's happening that I can not receive in a specific form, it might be silly, but already It took me hours and I d...
asked by 03.01.2019 / 00:27
1
answer

MySQL_Error when resetting MySQL root password_ "Error when establishing a connection to the database"

I'm a beginner and I'm not sure how to fix this Wordpress connection issue with the Mysql database. The error occurs after I reset the mysql root password, the Site crashed and prints the message: "Error establishing a connection to the datab...
asked by 03.01.2019 / 00:55
1
answer

Delete records with various conditions

I need to exclude duplicate records in column bidding_price with the following conditions: Table: bid_account Columns to check:    id = PRIMARY KEY auction_id = ID of each product bidding_price = val...
asked by 16.04.2018 / 03:30
1
answer

Comoresolver error ERROR 1452 (23000) in mysql

I'm trying to popular the following database: DROP DATABASE IF EXISTS library; CREATE DATABASE library; USE library; CREATE TABLE AUTHOR ( NAME VARCHAR(50) NOT NULL, COUNTRY VARCHAR(50) NOT NULL, TITLE VARCHAR(50) NOT NULL, PRIMARY...
asked by 26.03.2018 / 17:05
2
answers

Create combo with names inside input value

I have the input with the name collaborator within the while: while($rows_cursos = mysqli_fetch_array($resultado_cursos)) { $tabela1 .= '<tr>'; $tabela1 .= '<td>'.$rows_cursos['nome'].'</td>'; $tabela1 .= '<td> <in...
asked by 22.03.2018 / 17:58
2
answers

Put form data in Array

Next, I have a database with some items and I display the items in this database using this template: <?php $conexao = mysqli_connect("Host","User","Pass","banco"); if( !$conexao ){ echo "Erooooou."; exit;...
asked by 03.04.2018 / 04:36
2
answers

Delete data from the database [closed]

I'm working with a database that has 2 tables, processes and processmovements, I need to delete a data from the processes table, but the field ID of the process table is a foreing key in the table handlingprocesses. I am using PHP and MYSQL. p>...
asked by 05.04.2018 / 18:41