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 Read. Show all posts
Showing posts with label Read. Show all posts
Monday, 22 February 2016
Tuesday, 16 February 2016
How to Upgrade Your Old Blogger.com AccountIn Feburary 2016 16,
In Feburary 2016 16,
Start at the Blogger.com home page (see the Resources section below).
Take a tour of the new Blogger.com if you are unsure whether or not you want to upgrade your account. Click on the 'Take a Tour' link to start.
Click on the 'Switch Now' link to start the process of upgrading your account.
Provide your old username and password in the text boxes provided.
Read the new 'Terms of Service' by clicking on the link and check the box to agree.
Click on the 'Continue' link.
Create a Google Account to Use the New Blogger.com
Enter your current email address. Creating a Google account does not automatically give you a gmail account.
Choose a password. Passwords should be at least six characters long and include numbers or symbols to make it more difficult to guess.
Reenter the password and type the word you see in the word verification field provided for security purposes.
Agree to the terms of service and click on the 'I accept. Create my account' link.
Use an existing Google account to sign in. If you already have a Google account, you can apply it to your new Blogger.com account and get started.
Upgrade and Use the New Blogger.com
Check your email to confirm your new Google account. Click on the link provided in the email or copy the URL into your address bar.
Sign in to your new Blogger.com account.
Use the new Blogger.com features, which include drag-and-drop editing, privacy options and options for RSS feeds.
In Feburary 2016 16,
Start at the Blogger.com home page (see the Resources section below).
Take a tour of the new Blogger.com if you are unsure whether or not you want to upgrade your account. Click on the 'Take a Tour' link to start.
Click on the 'Switch Now' link to start the process of upgrading your account.
Provide your old username and password in the text boxes provided.
Read the new 'Terms of Service' by clicking on the link and check the box to agree.
Click on the 'Continue' link.
Create a Google Account to Use the New Blogger.com
Enter your current email address. Creating a Google account does not automatically give you a gmail account.
Choose a password. Passwords should be at least six characters long and include numbers or symbols to make it more difficult to guess.
Reenter the password and type the word you see in the word verification field provided for security purposes.
Agree to the terms of service and click on the 'I accept. Create my account' link.
Use an existing Google account to sign in. If you already have a Google account, you can apply it to your new Blogger.com account and get started.
Upgrade and Use the New Blogger.com
Check your email to confirm your new Google account. Click on the link provided in the email or copy the URL into your address bar.
Sign in to your new Blogger.com account.
Use the new Blogger.com features, which include drag-and-drop editing, privacy options and options for RSS feeds.
In Feburary 2016 16,
Sunday, 14 February 2016
What Is a URL Search Hook?In Feburary 2016 14,
In Feburary 2016 14,
A web site's extension is the portion of the URL that is after the last '.' in the address. Examples are .com, .html and .htm. These extensions tell computers what protocol the browser should use to read the web page.
Usage
When the extension is unknown, such as a custom URL, the browser attempts to figure out which protocol to use. A search hook is implemented to determine how the computer should read the web page. Once the search hook has succeeded in reading the page, the new protocol is added to the search hook for future use.
Implementation
The command for a search hook is written into the computer's software as a line of code. The user does not need to perform any special command; the Internet browser will automatically begin to search for a protocol that will read the web page.
In Feburary 2016 14,
A web site's extension is the portion of the URL that is after the last '.' in the address. Examples are .com, .html and .htm. These extensions tell computers what protocol the browser should use to read the web page.
Usage
When the extension is unknown, such as a custom URL, the browser attempts to figure out which protocol to use. A search hook is implemented to determine how the computer should read the web page. Once the search hook has succeeded in reading the page, the new protocol is added to the search hook for future use.
Implementation
The command for a search hook is written into the computer's software as a line of code. The user does not need to perform any special command; the Internet browser will automatically begin to search for a protocol that will read the web page.
In Feburary 2016 14,
Wednesday, 10 February 2016
How to Choose Newlywed Game QuestionsIn Feburary 2016 10,
In Feburary 2016 10,
WATCH VIDEO OF THE OLD NEWLYWED GAME SHOW - Before trying to choose Newlywed game questions from any website, it is important to get into the spirit and mindset. Watch old videos of the Newlywed show on youtube (see resource section for links). Write down any questions you especially enjoyed.
READ THROUGH PREMADE NEWLYWED GAME QUESTIONS - Due to the popularity of the game, there are many resources which include questions upon questions for the Newlywed Game. See resource section below to read through them. These will probably suffice for many if not all of of your games. Consider printing these out and storing them in a labeled plastic baggy with your board games. This way, if you need them at a moments notice, you will be prepared to host.
CREATE YOUR OWN NEWLYWED GAME QUESTIONS - Whether you need to create your own questions or not, this is an extremely fun precursor to the party. Invite your friends over the night before or week before to help plan. While creating newlywed game questions, you can make snacks or decorations for the party or just drink some beverages and relax.Making the questions with your guests before hand will add anticipation to the party and conversations during this time will be priceless. It also makes the party more fun/embarrassing, as their may have been discussion about how a man will answer.If you need help creating questions, think of them in categories such as: in laws, food, sleeping habits, sex, etc. Use premade questions for ideas and build off of them.
In Feburary 2016 10,
WATCH VIDEO OF THE OLD NEWLYWED GAME SHOW - Before trying to choose Newlywed game questions from any website, it is important to get into the spirit and mindset. Watch old videos of the Newlywed show on youtube (see resource section for links). Write down any questions you especially enjoyed.
READ THROUGH PREMADE NEWLYWED GAME QUESTIONS - Due to the popularity of the game, there are many resources which include questions upon questions for the Newlywed Game. See resource section below to read through them. These will probably suffice for many if not all of of your games. Consider printing these out and storing them in a labeled plastic baggy with your board games. This way, if you need them at a moments notice, you will be prepared to host.
CREATE YOUR OWN NEWLYWED GAME QUESTIONS - Whether you need to create your own questions or not, this is an extremely fun precursor to the party. Invite your friends over the night before or week before to help plan. While creating newlywed game questions, you can make snacks or decorations for the party or just drink some beverages and relax.Making the questions with your guests before hand will add anticipation to the party and conversations during this time will be priceless. It also makes the party more fun/embarrassing, as their may have been discussion about how a man will answer.If you need help creating questions, think of them in categories such as: in laws, food, sleeping habits, sex, etc. Use premade questions for ideas and build off of them.
In Feburary 2016 10,
Friday, 5 February 2016
How to Display Text From MySQL in PHPIn Feburary 2016 05,
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Thursday, 4 February 2016
How to Host Your Own DomainIn Feburary 2016 04,
In Feburary 2016 04,
Download a Web server. This is usually necessary since Windows doesn't come with a default Web server. Apache is a good program, but you can also download ABYSS, which is a free program that you can download (see Resources).
Read the documentation that is included with ABYSS to familiarize yourself with the program. This is only necessary if you've never used ABYSS, or if you do not have Apache on your system.
Visit the No-IP website (see Resources). Set up an account while you are on this page. Choose the domain name you want to use.
Download the No-IP client. Click on the Windows operating system download. Download the program and then install it.
Fill in the information the program asks for. Make sure the program runs after installing it. Once all of your information is entered, your IP address will resolve to the domain you chose, which should be something like xxxxxx.hostnameofserver.com (where xxxxxx is the name you chose).
In Feburary 2016 04,
Download a Web server. This is usually necessary since Windows doesn't come with a default Web server. Apache is a good program, but you can also download ABYSS, which is a free program that you can download (see Resources).
Read the documentation that is included with ABYSS to familiarize yourself with the program. This is only necessary if you've never used ABYSS, or if you do not have Apache on your system.
Visit the No-IP website (see Resources). Set up an account while you are on this page. Choose the domain name you want to use.
Download the No-IP client. Click on the Windows operating system download. Download the program and then install it.
Fill in the information the program asks for. Make sure the program runs after installing it. Once all of your information is entered, your IP address will resolve to the domain you chose, which should be something like xxxxxx.hostnameofserver.com (where xxxxxx is the name you chose).
In Feburary 2016 04,
Subscribe to:
Posts (Atom)