Pooja_Nayak Posted March 22, 2023 Share Posted March 22, 2023 Need to import excel file data into mysql so I downloaded the php office library using composer Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/ Share on other sites More sharing options...
requinix Posted March 22, 2023 Share Posted March 22, 2023 I'm not sure why you're getting HTML warnings when trying to load an Excel file. And it's just a warning. Is there a problem? Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1606746 Share on other sites More sharing options...
maxxd Posted March 23, 2023 Share Posted March 23, 2023 Downloading the library is the first step; next is implementing it. What have you done so far? Show your code (and please use the '<>' button to paste it here in the thread). Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1606748 Share on other sites More sharing options...
Pooja_Nayak Posted March 23, 2023 Author Share Posted March 23, 2023 I have added the php spreadsheet library using composer and running the code to upload the excel data into database. It gives the warning message but its not uploading the data into the database Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1606749 Share on other sites More sharing options...
dodgeitorelse3 Posted March 23, 2023 Share Posted March 23, 2023 Please do not attach your code as an image. We can't copy the code to run tests with it in our editors. Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1606750 Share on other sites More sharing options...
ginerjm Posted March 23, 2023 Share Posted March 23, 2023 And be sure to point out the line number from the message Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1606754 Share on other sites More sharing options...
maxxd Posted March 23, 2023 Share Posted March 23, 2023 After your initial if(isset($_POST['save_excel_data'])){ add this: die("<pre>".var_export($_FILES, true)."</pre>"); Just check and make sure you've got the data you think you've got. Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1606772 Share on other sites More sharing options...
Pooja_Nayak Posted April 7, 2023 Author Share Posted April 7, 2023 sending mail using swift mailer where i am getting the below error Fatal error: Uncaught Swift_TransportException: Failed to authenticate on SMTP server with username "naikpuja1097@gmail.com" using 3 possible authenticators. Authenticator LOGIN returned Expected response code 235 but got code "535", with message "535-5.7.8 Username and Password not accepted. Learn more at 535 5.7.8 https://support.google.com/mail/?p=BadCredentials s18-20020a170902a51200b0019f39e4f120sm2611923plq.18 - gsmtp ". Authenticator PLAIN returned Expected response code 235 but got code "535", with message "535-5.7.8 Username and Password not accepted. Learn more at 535 5.7.8 https://support.google.com/mail/?p=BadCredentials s18-20020a170902a51200b0019f39e4f120sm2611923plq.18 - gsmtp ". Authenticator XOAUTH2 returned Expected response code 250 but got code "535", with message "535-5.7.8 Username and Password not accepted. Learn more at 535 5.7.8 https://support.google.com/mail/?p=BadCredentials s18-20020a170902a51200b0019f39e4f120sm2611923plq.18 - gsmtp ". in C:\Apache24\htdocs\swiftmailer\vendor\swiftmai in C:\Apache24\htdocs\swiftmailer\vendor\swiftmailer\swiftmailer\lib\classes\Swift\Transport\Esmtp\AuthHandler.php on line 191 Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1607106 Share on other sites More sharing options...
gizmola Posted April 7, 2023 Share Posted April 7, 2023 Make a new thread, because this error has absolutely nothing to do with loading an excel spreadsheet, or any of the code you provided. Quote Link to comment https://forums.phpfreaks.com/topic/316032-warning-domdocumentloadhtml-htmlparseentityref-expecting-in-entity-line-24-in-cwamp64wwwnew_projectprojectvendorphpofficephpspreadsheetsrcphpspreadsheetreaderhtmlph/#findComment-1607107 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.