Questions tagged as 'mysql'

0
answers

XAMPP and Workbench problem

Does anyone have any problem when using the workbench to access a mysql XAMPP database? I'm having trouble with this, when trying to connect to the mysql XAMPP database the workbench issues an error sound, but does not display any messages an...
asked by 20.07.2017 / 21:07
1
answer

PHP MySQLi Insert field checkbox int

I'm trying to do an INSERT, but I'm not sure how to get checkbox fields. THE TABLES ARE CREATED SO:    works tinyint (1)       contract tinyint (1) Using php 7. $inserir = $conexao->query("INSERT INTO cadastro (nome, sobrenom...
asked by 23.07.2017 / 02:03
0
answers

insert custom text into MySQL

I have a textarea that the user can set font size, the text font itself and insert images. My question and how to pass this custom text to MySQL.     
asked by 22.07.2017 / 18:16
1
answer

Access database through MySQL Workbench [duplicate]

I can not access a database through MySQl Workbench. The following message appears: However, with PHPMYADMIN, I can. How do I get access to the MySQL Workbench?     
asked by 21.07.2017 / 22:29
0
answers

I can not display an image that is saved in the BLOB database

I saved an image in the BD in a field type BLOB but at the time of displaying it does not display the image, instead it leaves the screen black with a white square in the middle follows the code: <?php $query = mysqli_query($link, "selec...
asked by 22.07.2017 / 01:07
1
answer

Doubt about Categories / PHP or HTML pages!

Hello, I'm creating a website and I'm not using WordPress because it's not a blog, and I'd like some help, actually asking a question, can I make categories other than folders? type you create a folder in www with name "videos" and in it puts in...
asked by 19.07.2017 / 21:43
1
answer

Rename part of the parameter names of a procedure

I have some procedures where parameter names start with: "p _" . Is it possible to change in a unique way and code all the names of all procedures that start with this abbreviation by: "abc _" for example? Procedure: CREATE DEFINER = '...
asked by 31.07.2017 / 19:05
1
answer

I can not access MySQL through PHP

I have the following problem, I use Ubuntu and I installed mariadb, and when I try to access mysql with: mysql -u root The following error appears: ERROR 1698 (28000): Access denied for user 'root'@'localhost' And then I can access it...
asked by 31.07.2017 / 02:42
0
answers

Using sanitize of filter_var () with pdo, do I need to use the statements?

I would like to know if even using filter_var with sanitize you need to use the pdo statements. Is it safe to do this? or need to use for example bindValue () <?php $con=conectar(); //Recebe número da pagina, caso não exista recebe val...
asked by 16.07.2017 / 02:46
1
answer

Get remaining data through array ID

How do I get the data that was not passed via $ _POST, but are already saved in the same table that I'm getting some data, such as ID, PRODUCT_NAME, etc. in an array, which receives data from multiple products. / p> //POST em array que recebo...
asked by 17.07.2017 / 02:06