Library

Course: PHP: Import CSV File to MySQL

PHP: Import CSV File to MySQL

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

This course Have 3 sections

1st: Main Section:

Transfer data from excel or CSV File to MySQL database table. 

  • Upload CSV File to server
  • Read data from CSV file
  • Write data to PHP array
  • Store Array data inside MySQL Database

2nd: Show Table Data.

  • Displaying table data and split result in-to pages

3rd: Display Folder contains. 

  • Show the contents of the server folder using file name and icons like windows explorer
Basic knowledge

Basic PHP knowledge.

Software Requirements:

  • WAMP Server
  • Dreamweaver CS5 or higher
What you will learn
  • Upload File to server
  • Convert CSV file contents to PHP array
  • Import PHP array to MySQL database
  • Display table data
  • Split long query in to pages
Curriculum
Number of Lecture: 26
Total Duration: 02:17:29
Upload File To Server
  • Connect Dreamweaver with WAMP  
  • Project Files  
  • 2: Create MySQL database  
  • 3 Manipulate CSV File  
  • 4 Insert Array to MySQL Table  
  • 5 HTML Form Handling  
Control File Upload Process
  • 6 Increase upload file size  
  • 7 Display File Size  
  • 8 Limit Uploaded File Size  
  • 9 Control Maximum File Size A  
  • 10 Control Maximum File Size B  
Upload Only CSV Files
  • 11 Error Flag  
  • 12 Upload CSV Files Only - Filter  
  • 13 Upload Form Style  

     * {color:#0F3; background:#000;}

    *, *:before, *:after {

    -moz-box-sizing: border-box;

    -webkit-box-sizing: border-box;

    box-sizing: border-box;

    }

    body {background-color:#000;}

    #bag {margin:0 auto; width:90%; </p> <p> border: 2px dotted #333; </p> <p> background-color:#000; </p> <p> color:#0F0; </p> <p> padding:20px; </p> <p> border:20px solid #121212;}

    .upload-button {

      position: relative;

      overflow: hidden;

      float: left;

      clear: left;

    }

    .upload-cover {

      background-color: #111;

      text-align: center;

    padding:5px;

    font-weight:bold;

      border-radius:1px;

      border: 2px dashed #0f0);

    width:250px;

    height:30px;

      cursor: pointer;

    color:#fff;

    -webkit-transition: all 0.5s ease-in-out;

     -moz-transition: all 0.5s ease-in-out;

     -o-transition: all 0.5s ease-in-out;

     transition: all 0.5s ease-in-out;

    border:1px solid #eee;}

    .upload-button input[type="file"],.upload-button input[type="submit"] {

    display: block;

      position: absolute;

      top: 20px; left: 0;

      margin-left: -75px;

      width: 550px;

      height: 20px;

      opacity: 0;

      cursor: pointer;

      }

    .upload-button:hover .upload-cover {

      background-color: #333;

    color:#0F0;

    border:1px solid #eee;}

    .xupload-button .xupload-cover {

      background-color: #0F0;

    color:#000;

    width:400px;

    border: 2px solid rgba(100,100,100,.1);

    border-radius:20px;

    }

    .xupload-button:hover .xupload-cover {

      background-color: #666;

    color:#0f0;

    border: 2px solid rgba(100,100,100,.1);

    }

    .clear {width: 100%; </p> <p> height:60px; </p> <p> clear:both; </p> <p> margin:0 auto </p> <p> }

    #folder { width:80px; height:70px; background-image:url(img/xfolder.png); }

    #folder:hover { background-image:url(img/folder.png);}

    .main li{ background-color:#ff0; border:10px solid #ff0; color:#000} 

Control Data Display
  • 14 Using GET Method For Pages  
  • 15 Show Table Data  
  • 16 Error  
  • 17 Display Data Using HTML Table  
  • 18 Split Table Data Into Pages  
  • 19 Operate page links  
  • 20 Special Pages  
  • 21 Display Style - CSS  
  • 22 Current Page and Hover Effect  
  • 23 Fix Page Numbers - With Big Tables  
Show Contents of Server Folder
  • 24 Show Contents of Server Folder A  
  • 25 Show contents of server folder B  
Reviews (0)