Tips for easy coding: Example task: How to display a table using PHP
1. Go to google.com and search for all answers to your questions, eg just google ” How to display a table in PHP” and you will find a lot of answers.
2. Go to Youtube.com for videos that will answer your questions. Just search there
3. Search for ‘How to display a table using PHP forums’ and you will get answers from forums. You will also discover some good forums in your niche which you can join
4. search on hotscripts.com for sample code, which you can then customize. DON’T INVENT THE WHEEL. JUST USE IT!
How to Import MS Excel spreadsheet into MySQL using PHPmyadmin
This is How to Import MS Excel spreadsheet into MySQL using PHPmyadmin.
- Create the table in your mySQL database with the same number of fields as the excel spreadsheet
- Now Delete the Column titles on your Excel Spreadsheet
- Save Excel file as ‘CSV’ (go to File, Save as in MSExcel )
- Now Click on ‘Import’ in your Table View (in PHPAdmin)
- Now browse to your ‘CSV’ file and select it for import
- Now check the radio button at the bottom: ‘CSV using LOAD DATA’ and then under options do the following
- Leave the first two boxes: ‘Replace table data with file’ AND ‘Ignore duplicate rows’ BLANK!
- Now put a comma at ‘Fields terminated by’;
- Leave ‘Fields enclosed by’ AND ‘Fields escaped by’ BLANK
- For ‘Lines terminated by’ leave ‘auto’ in the box there as it is
- For the ‘Column names’ type in the column names as in your mySQL database table, seperated by commas, with NO spaces!
- Now Click ‘Go’ and you are done!
Hope this helps you in your efforts to create a mysql database.