Questions tagged as 'mysql'

Tagged questions
1
answer

Problems with utf8 encoding in python

Error getting script: Igetthiserrorbythenamethathas~thatreturnsfromthemysqltable.Ifthe~tableinthetabledoesnotgiveerror,ifyouput~Igetthiserror.Myscript:#!/usr/bin/envpython#coding:utf8importMySQLdbimportpycurlimportbase64importjsonimportdatet...
asked by 14.12.2018 / 15:19
1
answer

Send by mail function of php data coming from a table

Hello Dev's I've been trying to work out a way to send data from a table for the past three days by mail of php. Sending data from just one column is basically easy, but it gets tricky when I want to send data from more than one column. This i...
asked by 03.06.2014 / 00:01
1
answer

Load data from a field after pressing a button

I need to load data from a field in a table. Example: Table (Template), the person is filling out the form and wants to use this template in the Text field, and with that it would click on a button (Load Template) and load this template into...
asked by 05.06.2014 / 14:28
1
answer

Return SQL data mysqli_fetch_assoc organized into a table

I have the following SQL <?php require_once("php/conexao.php"); $strSQL = "SELECT id, titulo FROM questoes ORDER by id DESC"; if($result = mysqli_query($conexao, $strSQL)) { while($row = mysqli_fetch_assoc($result)) {...
asked by 03.09.2015 / 16:16
1
answer

Query on two different tables in the same select

I need to perform a search on two different tables and give echo in the results separately! I think it would look something like this: $consulta = "SELECT * FROM tabela1 T1 UNION (SELECT* FROM tabela2 T2)"; $con = mysqli_query ($db,$con...
asked by 18.11.2018 / 02:01
1
answer

PHP can not process heavy files

I have a system in PHP that reads a TXT file, and performs a REPLACE in the database for each line, it does it well with small files (about 100 lines), however when I do with giant files (more than 1 Million lines) Chrome will have a white scree...
asked by 28.11.2018 / 13:41
1
answer

Insert MySQL Database

I need to insert into the MySQL Database (table fotos ) the path that is set to $target_file_name . I believe that the error is probably at the time of INSERT . File conexao.php :      try { $PDO = new PDO($dsn,...
asked by 11.11.2018 / 21:38
2
answers

Filters UseAgent Via Database

I created a table that receives some visitor information, ID, UseAgent, Address, and proxy. I'm doing a pie chart type and would like to show the amount of visits from Y browsers and X from others. Ex: the 3 most used browsers and the four...
asked by 01.08.2014 / 04:23
1
answer

Search within MYSQL search results [closed]

I have a situation more or less like this: A table with the records, I need to do a search with two references, example select * from CARS where dealership = 'VW' or vehicle = 'VW' AND location = 'Sao Paulo' This search returns me all VW c...
asked by 03.11.2018 / 16:27
1
answer

Send multiple emails in MySQL list with PHPMailer

I'm trying to send some emails with PHPMailer but you always get an error message:    Invalid address: my @ gmail.com, other.cruz @ web.com.br I have already checked everything I know but I still can not, here my list is being mounted and...
asked by 30.10.2018 / 17:29