Posts by Fernando Mertins • 525 points
24 posts
-
1
votes1
answer88
viewsA: Address of the namespace
Good afternoon, in your file Emailenviardao.php on line 19 you are instantiating the object of Phpmailer as well to do this before you need: Include class, with require, include or etc. Use the…
-
1
votes1
answer660
viewsA: Web Service consumption in SOAP standard with XML sending as parameter in PHP
Hello, in my opinion this is a very complex topic, if it comes to NFS-and it is most likely worth you to use an API/library already ready created by other people, IE, do not try to do everything…
-
-2
votes2
answers636
viewsA: How to call a function only 1 time with mouse scroll?
About debauchery and Throttle in Javascript, recommend this lib: jquery-Throttle-debounce
-
1
votes1
answer52
viewsA: Adjust photo when uploading
Hello, you should resize the image without distorting it. You cannot use fixed width or height as you are doing on lines 3 and 4. Start by recovering the width and height of the image with the…
phpanswered Fernando Mertins 525 -
0
votes1
answer54
viewsA: Format last different Select Mysql result
Hello, use CSS and not PHP or Mysql... Example: ul a { color: blue; } ul li:last-child a { color: red; } <ul> <li><a href="#">Link 1</a></li> <li><a…
-
1
votes1
answer842
viewsA: How to send this XML to webservice via PHP
Good morning, a tip is to search the project Nfephp, class "Tools", it makes use of Curl and also digital certificate, see https://github.com/nfephp-org/nfephp/blob/master/libs/NFe/ToolsNFe.php…
-
1
votes1
answer150
viewsA: Register changes in Mysql
Good morning, I need to record all changes in the database, such as UPDATE, INSERT and etc » I suggest you do it on your own, create a table log or similar to the information desired, such as date…
mysqlanswered Fernando Mertins 525 -
2
votes1
answer165
viewsA: Display return of an SQL query in Excel
Good morning, it is possible to perform SQL command by Excel ==> Yes, through Microsoft Query. See in the Ribbon, Data group, connections from other sources, Microsoft Query. if it is possible to…
-
1
votes1
answer441
viewsA: Chart based on weekly data
you must execute a SELECT by making a count of connection records, disconnect records, join them in separate columns and finally add them, example: mysql> select * from evento;…
-
2
votes1
answer646
viewsA: Import Excell XLS Spreadsheet and write to Mysql database
you can connect to the XLS spreadsheet via an ODBC connection, example: $excel = odbc_connect("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq={$caminhoComplePlanilhaXLS};DefaultDir=C:\\" ,…
-
1
votes1
answer1602
viewsA: How to avoid deletion of relational data through referential integrity in MYSQL?
Good afternoon Thiago, I want to know what it would look like if I wanted both options: When to delete a simulated, cascade out the related questions, or else not allow the simulated one to be…
-
2
votes2
answers79
viewsA: recover BD name of a mysql and php connection
Run an SQL select database() to return the Mysql database name, for example: mysql> select database(); +--------------------+ | database() | +--------------------+ | information_schema |…
-
0
votes2
answers374
viewsA: Error inserting an image into Oracle using PHP PDO
Hello, I suggest you refactor a little more, since you switched from Mysql to Oracle and are inserting record with LOB field. Follow a teaching suggestion: $conn =…
-
1
votes1
answer436
viewsA: How to perform asynchronous tasks in PHP?
Good afternoon Marcelo, ...At the moment the customer logs the order the system sends an email message and also communicates with an API by passing the order data. The problem is that this whole…
-
0
votes1
answer179
viewsA: Dynamic form in PHP and Mysql
Create the inputs with the same attribute name followed by opening and closing brackets, this way in PHP you will have an array ready in $_POST with this information, example: <input type="text"…
-
0
votes1
answer117
viewsA: Alternatives to the page request method by POST
Good afternoon Rafael, the alternative I recommend to the HTTP POST method is HTTP GET, responding more directly to the title of your question. From what I understand, your difficulty is not to…
-
1
votes1
answer104
viewsA: Dealing with nested objects (nesting) using a ORM
Okay, you have the three independent entities isolated from each other. To assemble this tree you need one or two more entities in your database, suggestions according to my point of view: 1)…
-
1
votes1
answer185
viewsA: How to use the Nfephp API without the server having to support Curl 7.22.2
Good afternoon, as the answer seems to be no, there is no. The PHP Curl extension is used directly to access the webservices. In PHP version 5.3.x Curl already has the minimum version, so I believe…
-
4
votes2
answers736
viewsA: Empty nRec upon receiving return from SEFAZ
Good morning, you don’t have the receipt number because you must be using the parameter $indSinc 1 (synchronous mode), so the NF-e authorization is instantaneous, not NF-e Batch or receipt number is…
-
0
votes2
answers568
viewsA: Query creation with Union ALL to join tables with indexing by table name
Good afternoon Ivan, follow a suggestion. <?php $conn = new mysqli('host', 'user', 'password', 'database'); $queryTables = "select * from information_schema.tables where TABLE_NAME like…
-
2
votes1
answer620
viewsA: How to express date and time in "Y-m-d TH:i:sp" format, with UTC zone 03:00
Hello, you are correct to return, we are in Daylight Saving Time. You have set the Time Zone "America/Sao_paulo" which at the moment is -02:00 instead of -03:00. If you want to get at all times…
phpanswered Fernando Mertins 525 -
0
votes1
answer157
viewsA: Incremental number in PHP
Good morning, I suggest you use a large number in the style of NF-e Batch, is a number with 15 digits, this way you generate it from the function microtime(), for example: echo…
-
1
votes1
answer972
viewsA: Error on line 2 at column 1: Extra content at the end of the Document
Hello, the problem seems to be that root tag "xmp" that you concatenate out of XML... I also don’t understand what it means. Testing in Firefox here, it was like this: Just remove that weird tag xmp…
-
1
votes1
answer110
viewsA: Select in Mysql and Insert in Firebird
Hello, you must connect to both databases simultaneously. After running SELECT in Mysql you will have a variable array or object containing the information, done this you connect in Firebird and…