Questions tagged as 'mysql'

Tagged questions
0
answers

pymysql.err.OperationalError: (2003), I can not connect to the ubuntu server

I created a ubuntu 18.10 server and made it publicly available. I can access the url xx.x.xxx.xx / phpmyadmin , but when I try to connect through python3 I have the following problem: pymysql.err.OperationalError: (2003, "Can't connect to MyS...
asked by 12.11.2018 / 10:34
1
answer

Help with UPDATE in logic using queries

This is the following, I have two tables, the esc_usuarios table that contains information for registered users and esc_usuarios_slog , which contains the records of the lows, in which they are performed through a button that change...
asked by 09.11.2018 / 20:09
1
answer

Stirring with date and time in PHP

I have a question. I would like to know how I can get the php code to store the time I recorded an activity, but it should be hidden in the form and only visible when this data is visible in a table. ?> <?php require "templates/head...
asked by 09.11.2018 / 19:52
2
answers

SQL: Make comparison between 2 columns and return only 1

I have a client table that includes PF and PJ clients. In this table, if the customer has CPF, they do not have a CNPJ, if they have a CNPJ they do not have a CPF. I need a query that checks which of the two columns is not null and returns only...
asked by 09.11.2018 / 21:52
0
answers

Pagination link returning to index

I have two pages with pagination, using the same method. The first page is home and in it the pagination is working perfectly, already in the page that displays the search results the pagination until it works, however when I click on any pag...
asked by 09.11.2018 / 23:13
1
answer

PHP MySQL error - mysql_num_rows () [duplicate]

I'm having trouble correcting this error, I do not know much about language (almost anything). The error that appears on the page is this: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\...
asked by 19.11.2018 / 07:44
1
answer

Help with project code organization

I entered a project written in php that at first had no idea of the proportion it would take. So I've written so much code that even I'm a little lost to locate some problems. In order to do the project, as I was doing it, I was also learning...
asked by 22.11.2018 / 17:10
0
answers

Create a text box and write in a pdf

Code to display the pdf document: $result_cursos = "SELECT * FROM centrodb.UploadPDF"; $resultado_cursos = mysqli_query($conn, $result_cursos); $tabela1 .= '<div class="teste" id="tabela" style="float: center" table align="center">';...
asked by 22.11.2018 / 16:27
1
answer

How to do replace in all but one field?

I have a table with several fields, and I need to make a insert or replace on each line. I get the data coming from a software and if it does not exist, I insert, if not replaced. I get a array that can have all or just a...
asked by 22.11.2018 / 14:56
0
answers

doubts VIEW MySQL

In a table I have the following columns: nomeAluno , disciplina , numeroDeFaltas . I need a VIEW that I can put the name of the student in the WHERE clause and it returns me the name of the discipline that this student ha...
asked by 22.11.2018 / 17:17