Import Data From Excel To MySQL Using PHP | PHP MySQL Excel Tutorial
Vložit
- čas přidán 21. 03. 2022
- Import Data From Microsoft Excel To MySQL Database In PHP | HTML PHP MySQL Ms Excel Tutorial
Assets (Excel Reader) = github.com/davidsproject/exce...
Export Data From MySQL To Microsoft Excel Using PHP | PHP MySQL Ms Excel Tutorial = • Export Data From MySQL...
More Videos :
- Real Time Data Display Using JavaScript & PHP MySQL | Update Page & Get Data Without Refresh Page = • Real Time Data Display...
- Create A PHP Voting Form & Insert Form Data to MySQL Database | HTML CSS jQuery PHP MySQL = • Create A PHP Voting Fo...
- Upload Images to Website, Store to Database & Display It with Validation Using PHP & MySQL = • How To Upload Image In...
- Complete PHP CRUD Operation (Create Read Update Delete) | Olympic Games PHP Application = • Complete PHP CRUD Oper...
Source Code = drive.google.com/drive/folder...
Contact :
Gmail = davidgarciasaragih7@gmail.com
GitHub = github.com/davidgrcias
Instagram = / davidgrcias
Donate To Support :
- paypal.me/davidgtech
- sociabuzz.com/davidgtech/donate
Music :
1. Track: Syn Cole - Time [NCS Release]
Music provided by NoCopyrightSounds.
Watch: • Syn Cole - Time | Futu...
Free Download / Stream: ncs.io/SCTime
2. Track: Cartoon - On & On (feat. Daniel Levi) [NCS Release]
Music provided by NoCopyrightSounds.
Watch: • Cartoon, Jéja - On & O...
Free Download / Stream: ncs.io/onandon
3. Track: Rival x Cadmium - Seasons (feat. Harley Bird) [NCS Release]
Music provided by NoCopyrightSounds.
Watch: • Rival x Cadmium - Seas...
Free Download / Stream: ncs.io/SeasonsYO
Thank you for watching
Thanks bro. Keep up doing such wonderful tutorials.
Thanks a lot!!!
Thanks, will do!
Very helpful I am Searching for this concept 😃
Glad it was helpful!
kak kalo import ke tabel yangg sudah ada dan importnya menggunakan modal gimana kak
Amigo, buenas, una pregunta, hay alguna manera de que antes de presionar el boton "Import" se vean reflejados los datos del excel en la tabla? digo, como para que se vea lo que vas a importar como segunda capa de seguridad para no subir una mala informacion, ya que ahí muestra la infomacion en la tabla, pero despues de haberla importado¿? gracias.
Hola @user-qz7hd6rq2q,
Sí, es posible mostrar los datos del archivo Excel en la tabla antes de presionar el botón "Importar". Puedes cargar el archivo Excel en el frontend y mostrar los datos en una tabla como una vista previa para verificar antes de importarlos. Esto proporciona una capa adicional de seguridad para asegurar que no se suba información incorrecta. ¡Gracias por tu pregunta! 😊
Thanks it's really very helpful
You're welcome!!! Thanks for watching...
New subscriber here! Your tutorials are great and it really helps me a lot in my current project. Regarding this tutorial, I just want to ask if there's a function that will restrict the data from inserting into the database if there's already a data that has the same value in the new excel file you want to import. Thank you!
Wow, thank you...
Yeah, there is.
stackoverflow.com/questions/19714341/prevent-duplicate-records-to-a-table-using-php
i am unable to get the source code
The source code is in the description of video, thank you for watching!
thanks for the idea it helps alot
You're welcome! I'm really glad to hear that the idea helped you out. If you have any more questions or need further assistance, feel free to ask. Best of luck with your data importing project using PHP and MySQL! 🚀
importnya saya gk berhasil kak
php versi 7.4
apa pengaruh versi phpnya
this works without installing composer into CMD?
Hi David. There are 62 issues open in your code as per GitHub and not yet solved.
Do you still maintain it?
Could you please explain it more? I don't really understand what you mean
Thank you for your help
You're welcome! Thanks for watching...
Thank you sir
You're very welcome! Thanks for watching!
Thanks 😊
You're welcome!
hello ..
Thanks for helping video..
I have a problem when upload Excel file to database..the arabic letters turns to unclear symbols..
how to solve this problem please???
Hello, thanks for watching.
It sounds like you are experiencing an issue with character encoding when uploading an Excel file with Arabic text to a database.
Check the character encoding settings in your database: Make sure that your database is set up to handle Arabic characters correctly. UTF-8 is the most commonly used character encoding for international text, and should be supported by most databases. Check your database documentation to ensure that it is configured correctly.
Thanks greate
You are welcome
Hi, why does it not work when it is online and works fine when its on local machine? is it for offline use only?
Hi, yes it does work online
Hello, Thanks for sharing but,
When uploading no successfuly msg appair the page just reload and nothing happens, also the file save in uploaded files but its not uploaded to db
can you fix it please ?
Hi @MohamedAhmedH93,
I appreciate your feedback and I'm sorry to hear about the issues you're facing. Let's work together to troubleshoot and resolve these problems:
- Success Message Display:
Check if your success message is properly implemented in your PHP code. Ensure it's set to display when the upload and database insertion are successful.
- File Upload to Database:
Double-check the portion of your PHP code responsible for saving data to the database. Verify that all necessary fields are being properly populated.
- Error Handling:
Implement error handling in your PHP code to capture any potential issues during the upload process. Check for error messages that might provide insights into what's going wrong.
- Database Connection:
Confirm that your database connection is correctly configured. Ensure that there are no connection errors preventing the data from being stored in the database.
- File Permissions:
Ensure that the directory where your uploaded files are saved has the correct permissions to allow file writing.
If the issue persists after checking these steps, consider sharing the relevant sections of your PHP code (excluding sensitive information) so I can take a closer look and provide more specific guidance.
Feel free to provide more details, and we'll work together to fix this!
script pushes nothing to database when importing .xls file. when importing .xlsx all works good. what problem can be here?
Hi @oko.b.3085! It sounds like the issue might be with how the script handles different file formats. Ensure your script supports both .xls and .xlsx formats. You might need to use different libraries or settings to handle .xls files correctly.
Thank you
Hi @zigijutemari,
You're welcome! 😊 Glad I could help!
why the content of excel file dont show instead its a defaukt word etc. hope that you can notice thank you
Hi @jastinmagayon3128,
If the content of your Excel file isn't showing correctly, it might be due to how the data is being read or displayed. Ensure you're using the correct library and methods to parse the Excel file. Let me know if you need more help! 😊
in my mac its uploading the excel file to Uploads folder but sql query is not injecting the data to database
ps: there is also no error
Thank you for reaching out and sharing your experience! It sounds like you've successfully uploaded the Excel file to the 'Uploads' folder, but you're facing an issue with the SQL query not injecting the data into the database.
This kind of situation can have a few potential reasons, and I'm here to help you troubleshoot it. Here are a couple of steps you can take to identify and address the issue:
- Check Error Messages: First, make sure to check for any error messages that PHP or MySQL might be generating. These messages can provide valuable insights into what's going wrong. You can enable error reporting in your PHP script or check the MySQL error logs.
- Database Connection: Verify that your database connection is established correctly. Double-check the connection credentials, hostname, username, and password in your PHP code.
- SQL Syntax: Review the SQL query you're using to inject the data into the database. Make sure the query is correctly structured and that the table name and column names match your database schema.
- Data Format: Ensure that the data being extracted from the Excel file is in the expected format and matches the data types of the corresponding columns in your database table.
- Escaping and Security: Be sure to properly escape and sanitize the data before injecting it into the SQL query. This helps prevent SQL injection vulnerabilities and ensures data integrity.
- Permissions: Check the permissions of the 'Uploads' folder and make sure it's writable by the web server. Also, ensure that the MySQL user has the necessary permissions to insert data into the specified table.
If you've reviewed these aspects and are still encountering issues, don't worry. Debugging can sometimes be a process of trial and error. Feel free to share more details about your code or any error messages you're encountering, and I'll do my best to assist you further. Remember, each setup can have its own nuances, so we'll work through this together. Good luck!
bang mau tanya, pas saya upload kan data nya kok ada satu data yang hilang itu kenapa ya?
padalan di table excel nya udah bener. mohon pencerahannya 🙏
Harusnya nggak kaya gitu sih, coba aja lagi dah
if suppose the excel is empty means so what does it means.......
Maybe your codes that aren't fully correct or your Excel version that not supported
Hi David, hi, I have a small problem, the code works correctly, only 15 empty rows are always uploaded to the database after any import. It's a weird problem. Thanks for the reply.
"require" must be together at the beginning, otherwise the import into the DB is not functional
Yes, correct
xls format not getting upload - please suggest
- Check the file size: Some systems may have a limit on the file size that can be uploaded. Make sure your Excel file is within the acceptable file size limit.
- Check the file type: Make sure that the file you are trying to upload is in the correct format. Sometimes the file extension might be incorrect, so try changing the file extension to .xlsx and see if it works.
- Check the file name: Try renaming the file to something shorter and simpler, without any special characters or spaces.
- Check for errors in your code: Make sure there are no errors in your code that could be preventing the file from being uploaded.
- Try uploading a different Excel file: If you're still having trouble, try uploading a different Excel file to see if the issue is with the file itself or with your system.
Bro it show me warning (warning move_uploaded_file(Upload/2023......) Fails to open stream: No such file or directory in C:\xampp\htdocs\upload\index.php on line 56 )
Please help me bro 🙏
I'm sorry to hear that you're experiencing an error message. It sounds like there might be an issue with the file path. Have you tried double-checking the directory and file name to make sure they match the upload code?
Hi data transfer from excel file to database not working, but it stores excel file in the upload folder. Do we need to install the composer in the folder or any other installation needed for successful transfer of data. At present there is no error. While inspecting it shows internal server error. Need help....
So this video is not recommendable for newbie learning at webdev.?
Hi @kirana.g581! If your data transfer is not working but the file uploads correctly, there might be an issue with the script processing the Excel file. Ensure all necessary libraries are installed, such as PHPExcel or PhpSpreadsheet, and verify your server configuration. An internal server error often indicates a server-side issue, so checking your server logs can provide more details. If Composer is needed for your libraries, make sure all dependencies are installed correctly. Let me know if you need further assistance!
Hi @anonymous-ei2pk! This video can still be useful for newbies, but it may require some additional troubleshooting and understanding of server configurations and library installations. If you're new to web development, don't get discouraged. These issues are part of the learning process, and asking for help, like @kirana.g581 did, is a great way to learn and improve! If you have specific questions, feel free to ask!
Hi sir i have some problem, data transfer from excel file to database not working, but it stores excel file in the upload folder. please help
make sure if you have any spelling or other error @7:17 at line 48 to 51
Hi @user-nv5xs8lg3w,
Hi, if the data transfer from the Excel file to the database isn't working but the file is stored in the upload folder, double-check your code that reads and processes the Excel file. Make sure the data is being parsed correctly and the database insert statements are executed properly. Let me know if you need more specific help! 😊
How read all sheets data from multiple sheets xlsx file?
Hi @MarekCzerepowicki! To read data from all sheets in a multi-sheet XLSX file, you can use a library like PHPExcel or PhpSpreadsheet. These libraries provide methods to loop through each sheet and extract data accordingly. If you need more specific instructions or an example, let me know!
I can't upload excel to sql but upload history is saved. Please help me with this problem
I'm sorry to hear that you're experiencing difficulties with uploading Excel files to SQL. Can you please provide me with some additional information about the issue? For example, what type of error message are you receiving? Also, have you checked to ensure that your Excel file is formatted correctly for SQL? Once I have more information, I will do my best to help you find a solution to this problem.
itu kan mengarahkan excel A nya pakai $row[0] nah terus cara mengarahkan ke nomor excel nya bagaimana kak?
Hi @rilannn23! Untuk mengarahkan ke nomor kolom Excel tertentu, kamu bisa menggunakan indeks kolom dalam array $row. Misalnya, jika kamu ingin mengakses kolom B, kamu akan menggunakan $row[1], kolom C menggunakan $row[2], dan seterusnya. Jika ada pertanyaan lebih lanjut, jangan ragu untuk bertanya!
Salam bro, i did everything as you teach on the video, unfortunately the file/data that submitted inti database is not success. There is no data uploaded after i press submit button. Please help me :(
Wa alaikum assalam! It sounds like there might be an issue with the data submission process. Double-check your PHP script to ensure that it correctly processes the form data from the uploaded Excel file and inserts it into the MySQL database. Look for any potential errors or missing steps in your PHP code that could be causing the data not to upload successfully. If you need further assistance, feel free to share more details or specific parts of your code, and I'll do my best to help you troubleshoot and resolve the issue.
gan,kalau input file XLS bisa kah?
Yeah, bisa
@@DavidGTech gan ini pakai xlsx berhasil,ketika pakai file XLS berhasil masuk d folder uploads tp data base cm muncul kotak2 & tnd tny??,,knp ya gan?
Hmm iya sih, saya coba juga begitu, kayanya emang cuman bisa .xlsx saja yang versi excel terbaru
@@DavidGTech wkwkwk pantesan saya cari2 ga bisa
bro i am getting $reader line as error
please could u help me to resolve it
Hey there! I'm sorry to hear that you're encountering an error with the '$reader' line. Let's see if we can figure it out together and get your code working!
To better assist you, could you please provide me with some additional information? Specifically, I'd need to know which part of the code you are referring to, and any error messages or codes that are displayed when you encounter the issue. This will help me pinpoint the problem more accurately.
In the meantime, here are a few general tips that might help you troubleshoot the error:
- Make sure that the variable '$reader' is properly defined before its usage.
- Double-check if the correct libraries or modules are imported or included in your PHP script.
- Verify if the file you are trying to read exists in the specified location.
Once you share more details about the error, I'll be able to provide a more specific solution. Don't worry; we'll get this sorted out together! Feel free to ask any questions, and I'll do my best to assist you.
why it doesn't work on version 8.2.0. I used VS Code
The compatibility of the code shown in the video with version 8.2.0 of your tools (such as VS Code) may vary, as the video might have been created using different versions.
Nice video
Hi @ManulBandara! Thanks! 😊 Glad you enjoyed the video! 🙌
nice song
Thank you
thank you
You're welcome!!! Thanks for watching...
Salam bro, I need help.. why data not appear in database after i press submit button? :(
@Cz-rg2sb
Salam! It seems like there might be an issue with the data submission process. Make sure that your form is correctly configured to send data to the PHP script that processes the form. Check your PHP script for any errors that might prevent data from being inserted into the database. If you're still facing issues, feel free to ask for more specific help, and I'll do my best to assist you!
ka untuk versi 8.1.10 ini ga bisa ya, file excel readernya banyak error
Iyaa, mungkin ini untuk versi PHP 5 sma 7 kek nya kak, kalau di versi 5 bisa kak
Hi @sopianamarlina9785! Jika versi PHP 8.1.10 menyebabkan banyak error pada file Excel reader, pastikan Anda menggunakan versi terbaru dari library seperti PhpSpreadsheet yang kompatibel dengan PHP 8.1.10. Versi library yang lebih lama mungkin tidak sepenuhnya kompatibel dengan versi PHP yang lebih baru. Jika ada pertanyaan lebih lanjut, jangan ragu untuk bertanya!
could you please provide this codeigniter code?
Hi @sithanyak4151! Unfortunately, I can't provide CodeIgniter code directly here, but you can adapt the PHP code to work within the CodeIgniter framework by following their documentation. If you need specific help, feel free to ask!
bro upload ke direktori filenya berhasil, ada filenya, tapi pas post ke database, dia gak masuk, itu kenapa ya ?
Kemungkinan ada yang salah di kode insert ke database phpnya
@@DavidGTech udh fix bro pake library yg lain
@@twj14 pake library apa kalo boleh tau bro?
@@twj14 pake library ap bro?
PHP version ?
>7
@@DavidGTech sudah coba di versi 8 belum? Saya pakai versi 8 data excel masuk masih dianggap null.
Kayanya excelnya, soalnya xls dan xlsx beda
@@DavidGTech udah 2 file dimasukkin, padahal syntaknya masih manual, arraynya di anggap null.
why it doesnt work?
Hi @user-wf8nq7wr5j,
I'd be happy to help you troubleshoot the issue, but I'll need more information to provide a specific solution. Could you please provide details on:
Any error messages you're encountering.
The specific step where you're facing the problem.
Any code snippets related to the part that isn't working.
With this additional information, I'll be better able to assist you in getting your import from Excel to MySQL with PHP up and running. Looking forward to helping you resolve this!
Good Day sir is this permanent ?
Hi @user-nv5xs8lg3w,
Yes, it is. 😊 Once the data is imported into your MySQL database, it will remain there permanently unless you choose to delete or modify it. Let me know if you have any more questions!
Fatal error: Uncaught ValueError: XMLReader::open(): Argument #1 ($uri) cannot be empty in C:\xamp\htdocs\php\excell\excelReader\SpreadsheetReader_XLSX.php:960 Stack trace: #0 C:\xamp\htdocs\php\excell\excelReader\SpreadsheetReader_XLSX.php(960): XMLReader->open('') #1 C:\xamp\htdocs\php\excell\excelReader\SpreadsheetReader.php(238): SpreadsheetReader_XLSX->rewind() #2 C:\xamp\htdocs\php\excell\excell.php(42): SpreadsheetReader->rewind() #3 {main} thrown in C:\xamp\htdocs\php\excell\excelReader\SpreadsheetReader_XLSX.php on line 960
i got this error how can i fix it sir?
Hi @ideamark8787,
I appreciate you reaching out, and I'm sorry to hear about the error you're facing. The error you've mentioned indicates an issue with XMLReader and an empty URI.
Here are a few steps you can take to troubleshoot this:
- Check File Path: Make sure that the file path you're providing to the XMLReader is correct. The error might occur if the file is not found.
- File Existence: Confirm that the Excel file exists at the specified path. If the file is not found, XMLReader might receive an empty URI.
- File Permissions: Ensure that the PHP script has the necessary permissions to read the Excel file. File permissions issues can sometimes lead to this error.
- File Content: Validate that the Excel file is in the correct format and not corrupted. An invalid or corrupted file might cause XMLReader to encounter issues.
If the problem persists, you might want to share the relevant sections of your PHP code where you're using XMLReader and opening the file. This will help me provide more specific assistance.
Feel free to provide more details, and we'll work together to resolve this issue!
i got this error
I'm sorry to hear that you're encountering an error. In order to help you, can you please provide me with more details about the error message you're receiving? This will allow me to better understand the issue and provide more specific guidance on how to resolve it.
please reply me
I apologize for the delay in responding to your comment. I'm here to assist you now. How can I help you?
Vaue😢❤
Qorl😢❤ww 0:12 🎉m
Qe
Thanks for watching!
Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in ...LOCAL\excelReader\SpreadsheetReader_XLSX.php on line 456
Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in ...LOCAL\excelReader\SpreadsheetReader_XLSX.php on line 581
Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in ...LOCAL\excelReader\SpreadsheetReader_XLSX.php on line 1049
Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in ...LOCAL\excelReader\SpreadsheetReader_XLSX.php on line 1083
Fatal error: Uncaught Error: Class "ZipArchive" not found in ...LOCAL\excelReader\SpreadsheetReader_XLSX.php:217 Stack trace: #0 ...LOCAL\excelReader\SpreadsheetReader.php(166): SpreadsheetReader_XLSX->__construct('../private/uplo...') #1 ...LOCAL\Motorpool\vh_list.php(29): SpreadsheetReader->__construct('../private/uplo...') #2 {main} thrown in ...LOCAL\excelReader\SpreadsheetReader_XLSX.php on line 217
Thank you for bringing up the warnings and fatal error you encountered. The warnings you mentioned about the 'continue' statements in the 'SpreadsheetReader_XLSX.php' file are related to changes in PHP versions. The warning suggests using 'continue 2' instead of 'continue' to explicitly continue the outer loop. This adjustment helps to avoid unexpected behavior.
Regarding the fatal error stating that the 'ZipArchive' class is not found, it indicates that the required PHP extension for ZIP file manipulation is missing or not enabled on your server. The 'ZipArchive' class is necessary to handle ZIP files, which are used in the process of reading XLSX files in the example.
To resolve these issues, you can follow these steps:
1. Update the 'SpreadsheetReader_XLSX.php' file by replacing the 'continue' statements with 'continue 2' as suggested in the warning messages.
2. Enable the 'ZipArchive' extension in your PHP configuration. You can do this by locating the 'php.ini' file and uncommenting the line that enables the 'zip' extension (e.g., remove the semicolon at the beginning of the line). If you don't have access to the 'php.ini' file, contact your hosting provider to enable the extension for you.
If you encounter any further issues or need additional assistance, please provide more details, thank you!!!
Hi. Thank you for the Resources but does it work online like 000webhosting
Hi, yes it does work online
I did tried but unfortunately it doesnt work. I check my script and it definitely is correct. why do you think is that. does this still support 000webhosting or the latest php version?