In Feburary 2016 22,
Go to the PHP Excel Reader download site, and download the package called 'php-excel-reader' (see Resources).
Unzip the downloaded file by double-clicking on it.
Upload the file called 'excel_reader2.php' to your website. Use FTP or your Web hosting service's file upload service to do this. The file should be placed in a folder where your PHP scripts can find it. You can put it in the same folder as the PHP script you wish to read Excel files in, or you can put it in a folder that is in the 'include path.' The 'include path' is a set of folders where you can put files that your PHP script will always be able to find, even if your script is in a totally different place. Your website might have a folder called 'includes' that is in the include path. If it does, put 'excel_reader2.php' there. If it doesn't, put it in the same folder as the PHP scripts with which you wish to use it.
Read an XLS File
Upload an Excel file to use as an example. Create a simple Excel file, and save it as 'example.xls'. Open the file and fill in the first three columns of the first row with the words 'column 1', 'column 2' and 'column 3'. Then on the second row, fill the first three columns with the text '1-1', '2-1' and '3-1'. Then fill the first three columns of the third row with the text '1-2', '2-2' and '3-2'. Save the file and upload it to the same folder where you uploaded excel_reader2.php.
Open your favorite text editor, and save a text file called 'example.php'. This will be your PHP script for this tutorial.
Write your PHP script to open the Excel file, read the table of data and then print the data out in the user's Web browser. Use this code to do it:
rowcount(); $r++) { //walk through each rowfor ($c = 1; $c
colcount(); $c++) { //walk through each column
echo $xls->raw($r, $c) . ' '; //Display the data in that cell
}echo '\n'; //make a new line at the end of each row} echo '
'; //close the HTML we made earlier?>
Save and upload your PHP file to your website. If you were able to put PHP Excel Reader in the include path, you may put your PHP file wherever you wish. If not, put your PHP file in the same folder as PHP Excel Reader.
To check your work, visit example.php in your Web browser. You should see the table of data from your Excel file printed in your browser window.
In Feburary 2016 22,
Showing posts with label Put. Show all posts
Showing posts with label Put. Show all posts
Monday, 22 February 2016
Saturday, 13 February 2016
How to Connect to an FTP Account From 1And1In Feburary 2016 13,
In Feburary 2016 13,
Click the 'Tools' button to open the 'Tools' drop-down list.
Click 'Internet Options,' and then click 'Advanced.'
Locate 'Use Passive FTP (for firewall and DSL modem capability).' Put a check mark by that option if one is not already there. Click 'OK.'
Connect to FTP Account
Type the following in the browser's address bar where you normally type URLs:ftp://xyz.comReplace xyz.com with your 1And1 domain name.
Press 'Enter.' Internet Explorer will prompt you for your user name and password.
Type those in the appropriate text boxes, and click 'Log On.'
In Feburary 2016 13,
Click the 'Tools' button to open the 'Tools' drop-down list.
Click 'Internet Options,' and then click 'Advanced.'
Locate 'Use Passive FTP (for firewall and DSL modem capability).' Put a check mark by that option if one is not already there. Click 'OK.'
Connect to FTP Account
Type the following in the browser's address bar where you normally type URLs:ftp://xyz.comReplace xyz.com with your 1And1 domain name.
Press 'Enter.' Internet Explorer will prompt you for your user name and password.
Type those in the appropriate text boxes, and click 'Log On.'
In Feburary 2016 13,
Wednesday, 10 February 2016
How to Make a VPS Out of a Dedicated ServerIn Feburary 2016 10,
In Feburary 2016 10,
Check to determine if your physical server meets the hardware requirement of the hypervisor that you want to use. A hypervisor is the operating system that manages the virtual servers. Some hypervisors require specific hardware to install at all.
Save the data and/or configuration of the appliance currently running on the physical server.
Put the disc in the reader and install the hypervisor. Hypervisors install like any other operating system.
Virtual Server
Once installed, you will be able to boot in the hypervisor console. Refer to your manual to create a Virtual Machine (VM). Choose what CPU power, memory and storage amount the VM will have access to. The CPU power, RAM amount and storage amount can be changed after creation if your appliance's needs go up.
Install the operating system using an ISO (image of a disk stored on a hard drive), a disk or the network. The installation and configuration is identical to an installation on a physical server. Install and configure the appliance.
Repeat the process for all of the appliances you want to install in virtual servers on the physical server.
In Feburary 2016 10,
Check to determine if your physical server meets the hardware requirement of the hypervisor that you want to use. A hypervisor is the operating system that manages the virtual servers. Some hypervisors require specific hardware to install at all.
Save the data and/or configuration of the appliance currently running on the physical server.
Put the disc in the reader and install the hypervisor. Hypervisors install like any other operating system.
Virtual Server
Once installed, you will be able to boot in the hypervisor console. Refer to your manual to create a Virtual Machine (VM). Choose what CPU power, memory and storage amount the VM will have access to. The CPU power, RAM amount and storage amount can be changed after creation if your appliance's needs go up.
Install the operating system using an ISO (image of a disk stored on a hard drive), a disk or the network. The installation and configuration is identical to an installation on a physical server. Install and configure the appliance.
Repeat the process for all of the appliances you want to install in virtual servers on the physical server.
In Feburary 2016 10,
Saturday, 6 February 2016
How to Organize a Tournament ChecklistIn Feburary 2016 06,
In Feburary 2016 06,
Brainstorm major tasks that need to be accomplished on and before tournament day. Examples include reserving event space, placing an ad for participants in a local newspaper, purchasing or arranging for prizes, preparing a registration list and collecting entry fees.
Place items in the order of when they need to be accomplished, starting from tournament day and working backward to today. Ask vendors how much time they need to deliver products to determine where to put ordering from those vendors on the time line.
Break the list down into days, weeks or months, depending on how much time you have before tournament day --- a checklist for a simple tournament two weeks away may have the same number of tasks as a major charity function that takes six months of planning, so knowing that certain tasks need to be done today, tomorrow, next Monday, etc. will help you accomplish tasks quickly.
Fotolia.com'>
Separating tasks by when they need to be accomplished will ensure you hit deadlines and keep you from focusing on later tasks at the expense of immediate ones.
Enter the list into a spreadsheet. Spreadsheet software isn't just for complex math equations --- the built-in grid is perfect for formatting a list and can help keep tabs on expenditures and entry fees.
Organizing Checklist by Category
Brainstorm major tasks that need to be accomplished on and before tournament day. Examples include reserving event space, placing an ad for participants in a local newspaper, purchasing or arranging for prizes, preparing a registration list and collecting entry fees.
Separate tasks based on the type of skill they require. For example, tracking entry fees or operating costs would fall under Money/Finance, registering a charity tournament as a 501(c)3 would fall under Legal and building goody bags and making signs for the event would fall under Crafts.
Enter items on the list into a spreadsheet organized by category.
Fotolia.com'>
Computerized spreadsheets offer built-in structure, helpful to organizing your checklist.
If you enlisted help planning your tournament, print the checklist by section and put people in charge of each section based on their skill sets.
In Feburary 2016 06,
Brainstorm major tasks that need to be accomplished on and before tournament day. Examples include reserving event space, placing an ad for participants in a local newspaper, purchasing or arranging for prizes, preparing a registration list and collecting entry fees.
Place items in the order of when they need to be accomplished, starting from tournament day and working backward to today. Ask vendors how much time they need to deliver products to determine where to put ordering from those vendors on the time line.
Break the list down into days, weeks or months, depending on how much time you have before tournament day --- a checklist for a simple tournament two weeks away may have the same number of tasks as a major charity function that takes six months of planning, so knowing that certain tasks need to be done today, tomorrow, next Monday, etc. will help you accomplish tasks quickly.
Fotolia.com'>
Separating tasks by when they need to be accomplished will ensure you hit deadlines and keep you from focusing on later tasks at the expense of immediate ones.
Enter the list into a spreadsheet. Spreadsheet software isn't just for complex math equations --- the built-in grid is perfect for formatting a list and can help keep tabs on expenditures and entry fees.
Organizing Checklist by Category
Brainstorm major tasks that need to be accomplished on and before tournament day. Examples include reserving event space, placing an ad for participants in a local newspaper, purchasing or arranging for prizes, preparing a registration list and collecting entry fees.
Separate tasks based on the type of skill they require. For example, tracking entry fees or operating costs would fall under Money/Finance, registering a charity tournament as a 501(c)3 would fall under Legal and building goody bags and making signs for the event would fall under Crafts.
Enter items on the list into a spreadsheet organized by category.
Fotolia.com'>
Computerized spreadsheets offer built-in structure, helpful to organizing your checklist.
If you enlisted help planning your tournament, print the checklist by section and put people in charge of each section based on their skill sets.
In Feburary 2016 06,
Thursday, 4 February 2016
How to Insert an MPEG Video Into DreamWeaverIn Feburary 2016 04,
In Feburary 2016 04,
Upload the video to your Web page's server. Do this with whatever FTP program you usually use to upload images, objects and HTML files. You can also use Dreamweaver for this. Select the video that you want to upload In the 'Files' palette and click the blue 'Up' button.
Click the 'Code' button at the top of the Dreamweaver interface. This will put you into Code View, allowing you to view and edit the actual HTML code for your Web page.
Find the place in the code where you want to embed the video. This can be tricky if you've never worked with HTML, but you'll have plenty of chances to experiment. Look for text that tips you off to where you are in the page or look for images (represented in HTML by tags, where 'xxx' is the image filename) that do the same.
Insert the following code:
where 'movie.mpeg' is the filename (and path, if it's not the same as the HTML file) of your movie, and the two values under 'width' and 'height' are whatever you want to use. (If you leave these attributes out, the movie will appear in its actual size.) Control the attributes of the embedded movie by adding any number of arguments, separated by spaces, just like the 'width' and 'height' arguments. Here's a partial list:autostart='true' to make the video begin playing automaticallyloop='true' to make the video continue playing forever unless stopped by the userstarttime='00:00' to make the video begin at a particular location (minutes:seconds)align='left'/'right'/'top'/'bottom' to place the video relative to the text around it
Click the 'Design' button to return to the standard Dreamweaver view, then test your video.
In Feburary 2016 04,
Upload the video to your Web page's server. Do this with whatever FTP program you usually use to upload images, objects and HTML files. You can also use Dreamweaver for this. Select the video that you want to upload In the 'Files' palette and click the blue 'Up' button.
Click the 'Code' button at the top of the Dreamweaver interface. This will put you into Code View, allowing you to view and edit the actual HTML code for your Web page.
Find the place in the code where you want to embed the video. This can be tricky if you've never worked with HTML, but you'll have plenty of chances to experiment. Look for text that tips you off to where you are in the page or look for images (represented in HTML by tags, where 'xxx' is the image filename) that do the same.
Insert the following code:
where 'movie.mpeg' is the filename (and path, if it's not the same as the HTML file) of your movie, and the two values under 'width' and 'height' are whatever you want to use. (If you leave these attributes out, the movie will appear in its actual size.) Control the attributes of the embedded movie by adding any number of arguments, separated by spaces, just like the 'width' and 'height' arguments. Here's a partial list:autostart='true' to make the video begin playing automaticallyloop='true' to make the video continue playing forever unless stopped by the userstarttime='00:00' to make the video begin at a particular location (minutes:seconds)align='left'/'right'/'top'/'bottom' to place the video relative to the text around it
Click the 'Design' button to return to the standard Dreamweaver view, then test your video.
In Feburary 2016 04,
Tuesday, 2 February 2016
How to Host a Successful PartyIn Feburary 2016 02,
In Feburary 2016 02,
Pick a theme for your party. It doesn't have to be anything elaborate but it should be the reason friends are gathering to celebrate. A loved one's homecoming, an engagement announcement, or a block party to meet the neighbors are only a few examples of party themes; decide upon yours and plan the rest of the party around the theme.
Send out the invitations. Optimally, guests should receive their invitations 2 weeks before the party. This gives them time to schedule the event into their time frame, arrange for babysitters or make travel arrangements. If a guest will be traveling a long ways, the earlier they get the invitation, the better.
Create the proper atmosphere. Parties should be fun. If you're hosting the party at home, look at your surroundings with a critical eye. Put knickknacks away for a clean look and add a banner or decorations to make the room more festive. Provide adequate seating for your guests.
Schedule the party events. Allow enough time for guest arrival before serving a meal or showing a film. If your party centers around a televised sports event, plan for guests to arrive at least 30 minutes before the event starts. Allow time for latecomers if you're planning a sit-down meal.
Plan your food list and shop a few days ahead of time. Dishes that can be prepared in advance and frozen will save you much-needed time on the day of the party. If you're hiring a caterer, she will need lots of advance notice of your menu and the number of guests you are expecting. Popular caterers are often booked months in advance.
Double-check the details the night before the party by doing a quick walkthrough, starting at your front door, as if you were a guest, and proceeding through your home. Make sure there is an area for guest's coats, extra soap and clean hand towels in the bathroom. Count your serving plates and glasses to make sure there are enough.
Dress early for the party to prevent last minute dashing. Some guests may arrive early and you'll need to be ready. Preparation is the key to a successful party.
Greet all your guests in person, if possible, and welcome them to your home. Follow your schedule, excusing yourself to tend to party needs and relax. Even in the best-planned events, something inevitably goes awry. Smile and focus on having fun.
In Feburary 2016 02,
Pick a theme for your party. It doesn't have to be anything elaborate but it should be the reason friends are gathering to celebrate. A loved one's homecoming, an engagement announcement, or a block party to meet the neighbors are only a few examples of party themes; decide upon yours and plan the rest of the party around the theme.
Send out the invitations. Optimally, guests should receive their invitations 2 weeks before the party. This gives them time to schedule the event into their time frame, arrange for babysitters or make travel arrangements. If a guest will be traveling a long ways, the earlier they get the invitation, the better.
Create the proper atmosphere. Parties should be fun. If you're hosting the party at home, look at your surroundings with a critical eye. Put knickknacks away for a clean look and add a banner or decorations to make the room more festive. Provide adequate seating for your guests.
Schedule the party events. Allow enough time for guest arrival before serving a meal or showing a film. If your party centers around a televised sports event, plan for guests to arrive at least 30 minutes before the event starts. Allow time for latecomers if you're planning a sit-down meal.
Plan your food list and shop a few days ahead of time. Dishes that can be prepared in advance and frozen will save you much-needed time on the day of the party. If you're hiring a caterer, she will need lots of advance notice of your menu and the number of guests you are expecting. Popular caterers are often booked months in advance.
Double-check the details the night before the party by doing a quick walkthrough, starting at your front door, as if you were a guest, and proceeding through your home. Make sure there is an area for guest's coats, extra soap and clean hand towels in the bathroom. Count your serving plates and glasses to make sure there are enough.
Dress early for the party to prevent last minute dashing. Some guests may arrive early and you'll need to be ready. Preparation is the key to a successful party.
Greet all your guests in person, if possible, and welcome them to your home. Follow your schedule, excusing yourself to tend to party needs and relax. Even in the best-planned events, something inevitably goes awry. Smile and focus on having fun.
In Feburary 2016 02,
Subscribe to:
Posts (Atom)