Posts by Ygor Anjos • 174 points
14 posts
-
2
votes2
answers473
viewsA: column with invalid accent
Solution: $query=iconv( 'UTF-8', 'Windows-1252', $query ); Connection to DBMS is not UTF-8. Freetds is Ansi/Windows 1252.
-
0
votes2
answers473
viewsQ: column with invalid accent
I’m assembling a report using the database of a system and PHP with DBLIB, however, who structured the database created the tables and fields accentuated. When I go to make a query in some field…
-
2
votes2
answers1842
viewsA: How to import ACCESS data to MYSQL
Use this Software Access To Mysql Introduction Access to Mysql is a small program that will Convert Microsoft Access Databases to Mysql. > Wizard interface. > Transfer data directly from one…
-
0
votes1
answer187
viewsA: How to query Pdo by date using input Month?
To be able to filter certain records within Mysql, you can do it as follows: Filtering Records by the Day SELECT * FROM tabela WHERE DAY(data) = 'dia_escolhido' Filtering Records by Month SELECT *…
-
1
votes1
answer14
viewsA: Problem deleting a field from the table
The error is saying that the row in question has information linked in the table view_menu, delete what is linked in the table first view_menu so you can delete from the table menu…
-
1
votes1
answer45
viewsA: Sending data to another table
INSERT INTO dbo.WarsEvento (NickName,Status,UserID) SELECT NckName,Status,UserID FROM dbo.Sys_Users_Detail WHERE LoginCount=3
-
2
votes3
answers514
viewsA: Print message on page after echo
I recommend using the POST method HTML - <form method="POST" action="p1.php"> Valor <input type="number" name="ds"/> <input type="submit" value="Envie"/> </form> PHP -…
phpanswered Ygor Anjos 174 -
-1
votes1
answer820
viewsA: How to Filter Table through inputs and click on a button?
You can filter the database query (if using one) using the ORDER BY
-
0
votes2
answers611
viewsA: Ajax does not return the date of requests
Your ajax is waiting for a return of the JSON type, in PHP do the following: echo json_encode("Aqui o que deseja retornar");
-
0
votes1
answer95
viewsA: Insertion of record with webservice returns error but inserts in the database
the error may be here: else if($_POST['operationType'] == "login") { } } else { echo "Formato de requisição inválido! O aplicativo não conseguiu se comunicar " . "de maneira correta com o…
-
1
votes2
answers854
viewsA: Phpmailer shows SMTP error
The path is wrong, look for the wrong line, and erase the beginning that should be phpmailer/class.phpmailer.php, leaves only class.phpmailer.php.
-
0
votes1
answer97
viewsA: Query of sectors in php mysql
Save the result of the two queries in an array and use http://php.net/manual/en/function.array-diff-assoc.php to compare them, depending on the result you leave or do not manage to respond…
-
1
votes1
answer175
viewsA: Form with datetimepicker
use the function: disabledDates [] Disbale all dates in list {disabledDates: ['01.01.2014','02.01.2014','03.01.2014','04.01.2014','05.01.2014','06.01.2014'], formatDate:'d.m.Y'} She’s from the same…
-
2
votes1
answer99
viewsA: PHP BUG - Prepared queries
Good morning, the problem is on that line: $ok=mysqli_stmt_bind_param($resultado, "sssssss", $c_art, $secc, $n_art, $pre, $fec, $imp, $p_ori); according to your query, 7 values are expected and you…