dollarnsa.blogg.se

$sql = "INSERT into subject (`SUBJ_CODE`, `SUBJ_DESCRIPTION`, `UNIT`, `PRE_REQUISITE`,COURSE_ID, `AY`, `SEMESTER`) It wiil insert a row to our subject table from our csv file` Next, we’re going to create another PHP file naming “import.php” that we will use to process the data from CSV/Excel to MySQL Database. Import Excel To MySQL Database Using PHP The page Interface will be look like the image below.Īnd here’s the code for the “index.php” file: And this file will load all the list of subjects if the subject table is not empty well as this page will allow the user to import the CSV/Excel file and upload the data to MySQL Database. Next, create another PHP file named “index.php”,and this PHP file will be the first page that will load to our browser when we will access/browse the “excel” folder from our web directory. Next, we need to create a PHP file naming “db.php” that will hold our database connection and here’s the following code: Then inside you htdocs or document root folder create a new folder and name it as “excel”. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=500 `PRE_REQUISITE` VARCHAR(30) NOT NULL DEFAULT 'None',

`SUBJ_DESCRIPTION` VARCHAR(255) NOT NULL, `SUBJ_ID` INT(11) NOT NULL AUTO_INCREMENT, Now, we will create a Database in your PHPMyAdmin named “studentdb” then execute this SQL query to create a new table called “subject”.