Questions tagged as 'mysql'

Tagged questions
0
answers

Update table after payment completed PHP

Well I'm trying to automate the release of products in my store so I made a purchase status system only that does not update the line that was paid ie create a new line See: link I just do not know how to update a specific line ... Co...
asked by 31.05.2017 / 19:09
1
answer

How to insert data into a MySQL B.D with PHP

This is the form for entering data <html> <head> <title></title> <meta charset="utf-8"> <link rel="stylesheet" href="style.css"> </head> <body> <form action="cadastrando.php"...
asked by 08.06.2017 / 01:10
1
answer

UTF-8 does not work when inserting data [duplicate]

I use utf-8 when inserting the nome field in PHP , like this: $nome = utf8_encode(strtolower($nome)); When checking how insert is before entering, the word is correct, but when accessing the database after insertion,...
asked by 07.06.2017 / 22:15
0
answers

PHP Language Comparison

I need to compare in the table of products if the language esp and ing are filled ... When I register the product it registers as language 1 (by). Then the client has to register the 2 (ing) and 3 (esp). $pdo = db_connect(); $listar = $...
asked by 28.05.2017 / 20:18
0
answers

Duplicate registry in mysql

I'm having problems creating a table and inserting some records so I can work with some queries. As much as I create a test table with only ID and name. When inserting by the same mysql tool it inserts the same record 2 times !! Duplicated....
asked by 30.05.2017 / 17:07
2
answers

INNER JOIN mysql error and JSON view

Hello I need to display the results of a SELECT with INNER JOIN in JSON format, my query is working, because I tested inside PHPMYADMIN, but my page does not work, I've tested everything, what can it be? Does anyone help me to find the error?...
asked by 29.05.2017 / 21:55
0
answers

How do I do paging for categories and tags?

I'm creating a project, news site, and I have to do a paging using categories and tags, a news item has a category and more than one tag. I have a table with the posts of news, and I have the tables with categories and tags, what exactly I wa...
asked by 30.05.2017 / 17:11
1
answer

Login system in java

Then I made this code but it is not happening, it falls directly on the same one with the correct username and password. I made the changes and instantiated the class where the checkLogin method is, but when I execute and push the data it giv...
asked by 26.05.2017 / 20:05
0
answers

Organize pagination

I would like every page to be the results of all games on day "x". Example: OnthispageonlythegamesonJune6,2017,butallgamesinthetableareappearing.OBS*:Iamarrangingtheproformatdatesday/month/yearatthetimeofthedisplay.I'musingthiscode,butit'snotor...
asked by 05.06.2017 / 17:21
0
answers

Select that you paste options from mysql bank

So, I have this code here and I'm not understanding why it is not working. I'm a beginner in PHP and can not seem to make it work. // a conexão com o banco está em outro aquivo, por isso não achei necessário inclui-la aqui <select id="t...
asked by 24.05.2017 / 20:19