- Read data from Excel with PHPExcel - include code
- work: read data from excel and import to web database
// this is my code
Import Data Từ Excel
<?php
include "connect.php";
?>
<?php include 'statisticinsert.php'; ?>
<?php
include "fileinfolder.php";
$today = date("d/m/Y");
?>
<?php
?>
<?php
// Include thư viện PHPExcel_IOFactory vào
include '../Classes/PHPExcel/IOFactory.php';
$inputFileName = 'vandon.xlsx';
// Tiến hành đọc file excel
try {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
} catch(Exception $e) {
die('Lỗi không thể đọc file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());
}
// Lấy thông tin cơ bản của file excel
// Lấy sheet hiện tại
$sheet = $objPHPExcel->getSheet(0);
// Lấy tổng số dòng của file, trong trường hợp này là 6 dòng
$highestRow = $sheet->getHighestRow();
// Lấy tổng số cột của file, trong trường hợp này là 4 dòng
$highestColumn = $sheet->getHighestColumn();
// Khai báo mảng $rowData chứa dữ liệu
// Thực hiện việc lặp qua từng dòng của file, để lấy thông tin
for ($row = 1; $row <= $highestRow; $row++){
// Lấy dữ liệu từng dòng và đưa vào mảng $rowData
$rowData[] = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE,FALSE);
//echo 'read file success!<br>';
}
//In dữ liệu của mảng
echo "<pre>";
//print_r($rowData['1']);
Are you looking to make a website? Starting a website can be a terrifying thought specially when you’re not techy. Don’t worry, you’re not alone. Having helped over 130,000+ people make a website with WordPress, we have decided to create the most comprehensive step by step guide on how to a make a website without learning how to code.
This guide is useful for users of all ages and skill levels. However, if you need help, then you can contact our expert team to help you setup your website for free.
A typical business website can cost as low as $100 per year and can go as high as $30,000 per year.
We recommend all our users to start small and then add more features to your website as your business grows. This way you will save money and minimize potential losses and avoiding overspending.
In this guide, we’ll show you how to build a website for less than $100.
We will also show you how to take it further by adding more features to it in the future.
WordPress is the most popular website platform in the world. It powers nearly 28% of all websites on the internet.
WordPress is free and comes with thousands of website designs and extensions. It is extremely flexible and works with almost every third-party tool and service available to website owners.
We use WordPress to build all our websites including this one, WPBeginner.
How to make the most of this create a website tutorial?
This is a step by step tutorial on how to make a website. We have divided it into different steps, and we’ll walk you through everything from start to finish. Just follow along the instructions, and you’ll have a very professional looking website in the end.
We will also point you in the right direction to take your website to the next level based on your needs.
Have fun creating your website.
Remember, if you need help, you can contact us and we will setup your website for free.
Let’s get started.
How to Create a Website Video Tutorial
Subscribe to WPBeginner
If you don’t like the video or need more instructions, then continue reading.
Step 1. Setup
One of the most common mistakes that beginners make is choosing the wrong website platform. Thankfully, you are here so you will not be making that mistake.
For most users, a self-hosted WordPress.org site is the perfect solution. It comes with thousands of designs and addons which allow you to create any kind of website you can think of. For more on this topic, please see our guide on why you should use WordPress.
WordPress is free for anyone to download and use to build any kind of website without any restrictions.
If WordPress is free, then where is the cost coming from?
WordPress is free because you’ll have to arrange your own domain name and hosting, which costs money. For more on this topic, see our article why is WordPress free?.
A domain name is your website’s address on the internet. This is what your users will type in their browsers to reach your site (For example, wpbeginner.com or google.com).
Next, you’ll need website hosting. All websites on the internet need hosting. This will be your website’s home on the internet.
A domain name typically costs $14.99/year and hosting costs start from $7.99/month.
This is A LOT for most people who are just starting out.
Thankfully, Bluehost, has agreed to offer our users a free domain name and over 60% off on web hosting.
Bluehost is one of the largest hosting companies in the world. They are also an official WordPress recommended hosting partner.
They are working with WordPress since 2005, and are committed to give back to the community. That’s why they have promised us that if you cannot set up your website by following this tutorial, then our expert team will complete the process for you without any cost. They will compensate us, so you don’t have to. Feel free to contact us for free website setup help.
Note: At WPBeginner, we believe in transparency. If you purchase hosting using our referral link, then we will get a small commission at no additional cost to you. In fact, you will get discount on hosting + a free domain name. We would get this commission for recommending any WordPress hosting company, but we only recommend products that we personally use and believe will add value to our readers.
Let’s go ahead and purchase domain name and hosting.
First, you’ll need to go to the Bluehost website in a new browser window and click on the green ‘Get Started Now’ button.
This will bring you to a pricing page where you will need to choose a pricing plan for your website. Basic and plus plans are the most popular choices among our users.
You’ll need to click on select to choose the plan that you like and continue to the next step.
On the next screen, you’ll be asked to select a new domain name.
Ideally you should stick to a .com domain name. Make sure that it is related to your business, easy to pronounce and spell, and easy to remember.
After choosing your domain name, click on the next button to continue.
Now you’ll be asked to provide your account information such as name, address, email, etc.
On this screen, you will also see optional extras that you can purchase. We generally don’t recommend purchasing these extras. You can always add them later on, if you decide that you need them.
Next, you will add your payment information to finish the purchase.
After completing your purchase, you’ll receive an email with details on how to login to your web hosting control panel (cPanel).
This is your hosting dashboard where you manage everything like getting support, setting up emails, etc. Most importantly, this is where you’ll install WordPress.
Step 2. Install WordPress
You will find tons of icons to do different things on your hosting account dashboard (cPanel). You’ll never need to use 95% of them, so you can safely ignore them.
Scroll down to the website section in cPanel and then click on the WordPress icon.
You will now see Bluehost Marketplace Quick Install screen for WordPress. Click on the ‘Get Started’ button to continue.
On the next screen, you will be asked to select the domain name where you want to install WordPress. Choose your domain from the dropdown field and then click Next.
Now you’ll need to enter your website name, admin username, and a password for your website. Don’t worry, you can change them later in WordPress settings if you need to.
You’ll also need to check all the checkboxes on the screen and then click on the ‘Install’ button to continue.
Quick Install will now start installing WordPress on your website. Meanwhile, it will show you some website templates that you can install on your site.
You don’t need to do that right now because we’ll show you how to find and install free WordPress template on your website later in this guide.
Once the installation is over, you’ll see a success message in the top header.
Now you need to click on the ‘Installation Complete’ link, and it will take you to the screen with your WordPress login URL and password.
Congratulations! You have created your first WordPress website.
You can now head over to the WordPress login page. Your login URL will look like this:
http://www.yourdomain.com/wp-admin
You can login to your WordPress site using the admin username and password you entered earlier.
Wasn’t that easy?
Now let’s move on to the next step and choose a design for your website.
Step 3. Select Your Theme
The visual appearance of your WordPress site is controlled by a WordPress theme.
WordPress themes are professionally designed templates that you can install on your website to change its appearance.
By default, each WordPress site comes with a basic theme. If you visit your website, then it will look something like this:
You can change your theme from the WordPress admin dashboard. Visit Appearance » Themes page and then click on the ‘Add New’ button.
On the next screen, you will able to search from 4,492 free WordPress themes that are available in the official WordPress.org themes directory. You can sort them by popular, latest, featured, as well as other feature filters (i.e industry, layout, etc).
For the sake of this guide, we’ll be using Bento. It is a popular multi-purpose free WordPress theme with flexible design options for all kind of websites.
If you know the name of the free theme you want to install, then you can look for it by entering its name in the search field.
WordPress will show you the theme in search results. You will need to take your mouse over to the theme and then click on the Install button.
Once you have installed your theme, you can customize it by clicking on the Customize link under the Appearance menu.
This will launch the theme customizer where you will be able to change your theme settings with live preview of your website.
You don’t need to finalize all theme settings right away. You will be able to customize it much better once you have some content on your website.
Let’s see how to add content to your WordPress site.
Step 4. Add Content to Your Site
WordPress comes with two default content types called posts and pages. Posts are part of a blog and appear in reverse-chronological order (newer items displayed first).
On the other hand, pages are meant to be static “one-off” type content such as your about page, contact page, privacy policy, etc.
By default, WordPress shows your blog posts on the front page of your website. You can change that, and make WordPress show any page as the front-page of your website (we’ll show you how to do that later in this guide).
You can create a separate page for your blog or news section. In fact, you can create a website without any blog section at all.
Having said that, let’s add some content to your website.
You’ll start by adding a few pages to your WordPress site. Don’t worry if you don’t have enough content for these pages at the moment. You can always edit and update them.
Head over to Pages » Add New page in WordPress admin area. This will bring you to the page editor screen, which looks like this:
First you need to provide a title for your page, let’s call this page ‘Home’.
After that you can add content in the text editor below. You can add text, links, images, embed videos, audio, etc.
After adding content to your page, you can click on the publish button to make it live on your website.
You can repeat the process by adding more pages for different sections of your website. For example, an about page, contact us, and a blog page to display blog posts.
Now let’s add a few blog posts as well.
Head over to Posts » Add New in your WordPress admin area.
You will see a screen much like you saw earlier when adding pages.
You can add a post title and then add content in the visual post editor. You’ll also notice some extra options like post formats, categories and tags.
You can click on the save button to store your post as a draft or click on the publish button to make it visible on your site.
For more detailed instructions on how to utilize all these options on post and page edit screens, please see our guide on how to add a new post in WordPress.
Step 5. Customizing and Tweaking Your Website
Now that you have created some content on your website, you will be able to customize and put it all in a nice presentable shape on your website.
Let’s start by setting up a static front Page.
Setting up a Static Front Page
You need to visit the Settings » Reading page in your WordPress admin area. Under the ‘Front page displays’ option click on the static front page and then select ‘Pages’ you created earlier for your home and blog pages.
Don’t forget to click on the ‘Save Changes’ button at the bottom of the page to store your changes.
WordPress will now use the page titled ‘Home’ as your site’s front page and ‘Blog’ page to display your blog posts.
Change Site Title and Tagline
During the installation you get to choose your site’s title. WordPress automatically adds a tag line to your site title that says ‘Just another WordPress site’.
You can change both your site’s title and tagline at any time by visiting Settings » General page.
Your site title will be the name of your website like WPBeginner. The tag line is usually a single line that describes your website. You can also leave the tag line field blank if you want.
Don’t forget to click on the save changes button to store your settings.
Set up Comments Settings
WordPress comes with a built-in comment system allowing your users to leave comments on your posts. This is great for user engagement, but it is targeted by spammers as well.
To deal with this, you’ll need to enable comment moderation on your website.
Visit Settings » Discussions page and scroll down to ‘Before a comment appears’ section. Check the box next to ‘Comment must be manually approved’ option.
Don’t forget to click on the save changes button to store your settings.
Create Navigation Menus
Navigation menus allow your users to browse different pages or sections on your website. WordPress comes with a powerful navigation menu system, and your WordPress theme utilizes this system to display menus.
Let’s add a navigation menu to your website.
First, you need to visit Appearance » Menus page. Enter a name for your navigation menu and click on the create menu button.
WordPress will now create your navigation menu. But it will be empty at the moment.
Next, you need to select the pages you want to display in your menu and then click on add to menu button.
You will notice your selected pages filling the empty area of your navigation menu. You can move them up and down to rearrange their position in the menu.
Now you need to select a display location. These locations are defined by your WordPress theme. Usually, most WordPress themes have a primary menu that appears on top.
Finally, click on the save menu button to store your navigation menu.
You can now visit your website to see the menu in action.
WordPress Plugins are like apps for your WordPress site. They allow you to add features to your WordPress site. Think contact form, photo galleries, etc.
There are currently more than 49,000 free plugins available for WordPress. There are also paid plugins sold by third-party websites and developers.
With this many plugins, how do you find which plugins to install? We got you covered there as well, see our guide on how to choose the best WordPress plugin.
Here is our list of essential plugins that you should install on your site right away. All of them are free.
WPBeginner itself is the largest WordPress resource site on the internet. You will find the following resources on WPBeginner (all of them are completely free).
WPBeginner Blog – This is where we publish our WordPress tutorials, how tos, and step by step guides.
WPBeginner Videos – These step by step videos will help you learn WordPress FAST.
WPBeginner on YouTube – Need more video instructions? Subscribe to our YouTube channel with more than 52,000 subscribers and 7 Million+ views.
WPBeginner Dictionary – The best place for beginners to start and familiarize themselves with the WordPress lingo.
WPBeginner Blueprint – Check out plugins, tools, and services we use on WPBeginner.
WPBeginner Deals – Exclusive discounts on WordPress products and services for WPBeginner users.
Here are few of our guides that you should bookmark right away. It will save you lots of time and money in the future.
Having helped thousands of people start a website, we have answered quite a lot of questions. Below are the answers to the most frequently asked questions about creating a website.
Is WordPress the only way to create a website?
No, there are a lot of other website builders out there. We believe that WordPress is the best and easiest platform to build a website.
How do I make money from my website?
After helping users create a website, this is by far the most commonly asked question. There are a lot of ways to make money online from your website.
We have a list of 25 ways to make money online using WordPress. These aren’t get rich quick schemes. If you’re looking for a way to get rich quick by making money online, then sorry to break the bad news, there’s no such way.
How do I start a website where I can sell products?
Do I need to know HTML / CSS to create and customize my website?
No you don’t need to know HTML / CSS to build a website with WordPress. You can use one of the many drag & drop WordPress page builder plugins to easily customize your websites.
How can I start a website for free?
Some website builders may offer free options, but we don’t recommend using those. Often they will insert their branding and advertisement on your website which doesn’t look professional.
Yes, you can easily create a website like eBay using an auction plugin for WordPress. We have a step by step guide on how to build an online auction website using WordPress that you can follow.
Can I get a free domain for my website?
Yes, some web hosting companies offer a free domain if you choose to start a website with them. Bluehost is an officially recommended WordPress hosting provider, and they’re offering WPBeginner users free domain + 60% off hosting if you choose to build your website using their service.
