Contents of the table of MySQL using the module “Spreadsheet_Excel_Writer” of PEAR, it outputs as the document of Excel it introduces the program which.
Advance setting
1. When the installation “of Spreadsheet_Excel_Writer (beta)” still is, it installs.
* Note — As writing point in time n/a with proper edition release not done, beta edition was used, but if proper edition is done release, please use there.
1. (Or appointing file name, it appoints “CMD” to execution,) it starts command prompt from the accessory of the program of the start menu.
C:
After with it inputs, pushes the entering key, changing to C drive, CD xampp php
With it inputs, pushes the entering key
xampp php
It moves to the directory.
pear install –alldeps Spreadsheet_Excel_Writer-beta typing, pushing the entering key, it installs.
*note — the name「Spreadsheet_Excel_Writer」following the「-beta」they are markedbetaversion。
C:xamppphp>pear install –alldeps Spreadsheet_Excel_Writer-beta WARNING: channel “pear.php.net” has updated its protocols, use “channel-update p ear.php.net” to update downloading Spreadsheet_Excel_Writer n/a tgz… Starting to download Spreadsheet_Excel_Writer n/a tgz (55,037 bytes n/a done: 55,037 bytes downloading OLE-1.0.0RC1.tgz… Starting to download OLE-1.0.0RC1.tgz (12,153 bytes)…done: 12,153 bytes install ok: channel://pear.php.net/OLE-1.0.0RC1 install ok: channel://pear.php.net/Spreadsheet_Excel_Writer n/a
「Spreadsheet_Excel_Writer」has been installed。
C:xamppphp>pear list INSTALLED PACKAGES, CHANNEL PEAR.PHP.NET: ========================================= PACKAGE VERSION STATE Archive_Tar n/a stable Calendar n/a beta Console_Getargs n/a stable Console_Getopt n/a stable Date n/a stable OLE 1.0.0RC1 beta PEAR n/a stable PEAR_Info n/a stable Spreadsheet_Excel_Writer n/a beta Structures_Graph n/a stable 「list」inPEARif you check the installation status of package-related「Spreadsheet_Excel_Writer(beta)」has been installed。
2. MySQLdatabase of「workdb」table「tab1」you must have been created。
| （you can click the image for a larger view） |
the above figure「workdb」table of「tab1」program the contents of the「myphp1.php」is an example that you are viewing is。
[the specifications for the sample program]
·「myphp14.php」module「Spreadsheet_Excel_Writer」use theMySQLtable of「tab1」the contents of theExceloutput as documents。
subsequently、input screen on the next page「myphp14.php」to create a。
1. MySQLthe contents of the table ofExcelprogram output as documents(myphp14.php)create a
copy the text editor the contents of the following、the name of the file「myphp14.php」as
「C:xampphtdocstest」and save it in the。
＊caution —「myphp14.php」character code of the file「SJIS」please save to specify the。
PHPeditor and sakura editor it is convenient to use an editor that specifies the character encoding, such as。
<?php //read only once the modules required to create an excel spreadsheet require_once(“Spreadsheet/Excel/Writer.php”); //to set the file name of the excel $filename = “mysql-tab1.xls”; //set the name of excel sheet $sheetname = “tab1″; //to create an object of the excel spreadsheet $workbook = new Spreadsheet_Excel_Writer(); //HTTPto send a header $workbook->send($filename); //to create a worksheet $worksheet = $workbook->addWorksheet($sheetname); //DBconnection is initiated to server name–localhost user name–root password–”karipass $dbHandle = mysql_connect(“localhost”,”root”,”karipass”) or die(“can not connect dbn”); //MySQLthe character code of the clientsjisset to mysql_query(“SET NAMES sjis”) or die(“can not SET NAMES sjis”); //dbto specify the name of $db = “workdb”; //SQLsentence tab1retrieve all rows from the table、numbercolumn to be sorted in ascending order of $sql = “select * from tab1 order by number”; //SQLto execute a statement $rs = mysql_db_query($db,$sql); //to get the number of columns $num = mysql_num_fields($rs); //tab1repeated as many times as the number of columns in the table for ($i=0;$i<$num;$i++){ //Exceloutput the column name $worksheet->write(0,$i,mysql_field_name($rs,$i)); } //to set the counter number of lines $i=1; //tab1repeated as many times as the number of rows in the table while($row=mysql_fetch_array($rs)){ //tab1repeated as many times as the number of columns in the table for($j=0;$j<$num;$j++){ //Exceltotab1to print the contents of the table column $worksheet->write($i,$j,$row[$j]); } //to counter the number of rows1adding the $i = $i + 1; } // Excelto send the sheet $workbook->close(); //unloaded from memory a record result mysql_free_result($rs); //DBdisconnect the connection to the mysql_close($dbHandle); ?> subsequently、 MySQLthe contents of the table ofExcelprogram output as documents(myphp14.php)test the operation of the。
3. MySQLthe contents of the table ofExcelprogram output as documents(myphp14.php)test of
3.1 MySQLthe contents of the table ofExcelto verify the program output as documents
start the browser、in the address field
http://localhost/test/myphp14.php
type、press the enter key。
save file dialog will be displayed。
| （you can click the image for a larger view） |
if you want to save the file「save」press the button、specifies the location of the destination folder。
if you want to open the file without saving「open」press the button。
as shown in the figure aboveMySQLcontents of the table has been outputExcelfile will be created。
Category: It – Hardware & Software • Author: • Views: 0
Latest Posts
-
sequel and final extensionＳＰdrama is proof of success
Category: Leisure – Hobbies & Entertainment Views: 1We send various drama informations with the weekly publication. “With special life chief last time Umemiya parent and child coaction” “'From flower boy 3'?!” “As for rear tear no liter?” Under this “This year young NHK Thursday the period adventure drama” “Tetsu Emori, in sickness connected gong descending/disembarking board” “The upper door saturation it is and others it is, viewing” 2nd page “That you thought whether 'it dies,' it does not die” “'Junior high school st.. Continue Reading
-
"On the stone three years" and the decision whether or not but rather wait three..
Category: Commercial - Business & Economics Views: 1Or graduates job scarcity followed by the percentage of people will quit over a short time joined the long-awaited hard is increasing on the other hand. Percentage of people to retire within three years is also 753 phenomenon is born so that 3% at 5% of the graduates in high school 7 percent in high-school graduates. It is said that's age is now relying on a company, even when not turned like a good social and career himself, should not we continued to keep the marketability. And I don't t.. Continue Reading
-
hotels in italy
Category: Holiday & Tourism – Travel Views: 0The wa [ru] elementary knowledge which it waits at the Italian hotel When the Italian hotel circumstance, it carries with fee and quotation and the equipment which change at season, your wa [ru] story which it waits, at the Italian hotel such as convenient goods and recommendation reservation sight introduction.The information of B&B of popularity.Please in the Italian hotel choosing, and reference in order to lodge skillfully! The italian hotel circumstance The place of the making w.. Continue Reading
-
spring of london fashion friendly fluffy
Category: Holiday & Tourism – Travel Views: 0The fashion report of London madam third time softly kindly the ge is style of the spring. It is the remaining overnight donor whose coordinating which designates monotone as the base is many, but it pours and with color and the design material, lightness and spring seems skillfully you produce. Those where this time it appears vuivuian which slurry and it dresses stylishly the mini- dress of the green and, are two people of kamira whose coordinating the youthful black ## beige is cute. .. Continue Reading
-
do you want most this summer！fragrant taste summer gift
Category: Family Views: 0Already, the person who knows as for Ginza “smoke thing” which is known, furthermore the choice which can receive the smoking item and your tasty liquor which makes the famous nameless gourmet groan it is the store, but you say that it makes with just the smoking rock salt and the smoke, fragrance it forces and in about the nogami mu also set of the original smoking item and seasoning etc is purchase possible with mail order in addition to the paragon bacon. It is full with the feeling which .. Continue Reading
-
drinking water at the desk if i choose？
Category: Health – Medical & Surgical Views: 0The water which is effective to the reduction of the tired eye? 'Last conclusion of the water which is good to karada - as for keyword internal cleaning and detotsukusu' * Last conclusion of the water which is good to reference book 'karada - as for keyword internal cleaning and the detotsukusu' author: Small Haneda Takeo At the small Haneda company, for scientific analysis the water is brought from the domestic various places, so is.Itself, the various chronic diseases there to be .. Continue Reading
-
we recommend the guide tool of sweets now if you buy this mixer！
Category: Leisure – Hobbies & Entertainment Views: 01. As for candy making mixer necessity 2. If now you buy, this mixer 1. As for candy making mixer necessity The occasion where the book of book “+α chiffon cake” from the Kamakura Simoi candy classroom was made, hundreds unit thing chiffon cakes which are called to making on an experimental basis and one for photographing several unit amounts were made. As for chiffon cake workmanship of merenge life. Especially without using the baking powder, when it tries probably .. Continue Reading
-
Group drumming... HealthRHYTHMS to relieve stress
Category: Health – Medical & Surgical Views: 1Do you have experience beat "Tyco"? I think not a chance to play through of the children in time for games and music touch Tyco quite often. But isn't the most opportunities as non-be adults who began playing the taiko drums and percussion, such as through music, touch "Tyco" is not? Pitch sound at the bottom of the constant rhythm of drumming and belly will deduce and resonates with the rhythm of the heartbeat and body, releases the reason brain function, emotions appear in obedie.. Continue Reading
-
school of rural life／want to do the work of mountain-forest！
Category: Home – Garden & Home Improvement Views: 0There is also a method of thinking, “what the school how, as for know-how of work you remember after so long a time directly on site ichiban”.But, when the work which we would like to do in the settlement is decided, acquiring technology and qualification with special school lecture there is a value of examination.Earnings with countryside are made to stabilize and also employment makes profitable, the special school.First obtaining the data, it will try inspecting the details of the school. T.. Continue Reading
-
Umbrella's remake of the eco
Category: Family Views: 3Hand to remake the eco bag with fabric part one of the recycled umbrella. So quite easy to Favorites if you cannot use the umbrella please try! Remake of eco in umbrella making Material?? Umbrella fabric piece Sewing Kit How to make?? Carefully remove 1: Remove the dough part of the umbrella bones cleaned. Dew (on the tip of the bone cover) to Mononoke, near the top of the （ TS ） dough cut the groin last-minute part as much as possible. Feeling that two top and bottom Becaus.. Continue Reading
-
now you're using latex for what？select point of latex
Category: Beauty – Cosmetics & Wellness Views: 1In the fundamental cosmetics, as for supplying the moisture the make-up water, as for replenishment of the oil content when the milky lotion, even then being unsatisfactory, cream…Perhaps with the person who has the image which is said it is.So, function of the fundamental cosmetics is various.Especially in order to diversify purpose and the method of thinking in regard to the milky lotion, you think.This time, from midst of the fundamental cosmetics focusing to the milky lotion, we speak then .. Continue Reading
-
the source of corporate brand？
Category: Commercial - Business & Economics Views: 0- Source (the SONY case study) of enterprise brand This time it collected materials at SONY. By the fact that the employee and organizational culture are felt with the skin, the source of the enterprise brand was visible. As one model, you think that it becomes reference. - From the SONY spirits “Serious null technician no technical skill, most high-level ni showing seshimubeki free ages nishite pleasant null ideal factory no construction” It is the first sentence of the prospectus.. Continue Reading
-
2011 Summer track breaking: also transvestite heroine and twink
Category: Leisure – Hobbies & Entertainment Views: 0Big drama summer topic Japan TV is Monday and Thursday, and established two drama border at midnight. Will be on the flow becomes impossible ratings at the time was 21 and 22 mainly broadcasting drama ever stand viewing habits change, rather favorable after 23: 00. Now introduce the summer drama previously known information. + Twink transvestite heroine Is a twink First TBS of Friday 22: Friday drama remake of the Korean drama 'is a handsome （ twink ）? '. Sister to Sakuraba Yosh.. Continue Reading
-
1and meiotic chromosome-time eye
Category: Leisure – Hobbies & Entertainment Views: 0Keen cone Caen cone and Keen cone Caen cone Everyone of both bulletin fan of entire country, konnichiha! Then, the ma - it does including class.You greet the request stripe -. “Standing up.You pay attention, -.Gratitude!” “The request stripe - it does” High, we ask. Obtaining -, both which from today are here bulletin it was decided that takes charge of the class of the living thing only of the favorite. Chemistry is special Hoshino.We ask may. Before entering into class, you cal.. Continue Reading
-
gotta make the epic software for girls in a hurry
Category: Leisure – Hobbies & Entertainment Views: 0For the girl the end of year beginning of the year trade war where the game is conspicuous It is the game where with simple rule and kawaiikiyarakuta, the girl is easy to play also rhythm heaven, don't you think? The game as for the girl you play enthusiastically, so as for the large quantity it was not to just a little front.Many games placing the man in the main target, being developed, it made had been troubled with man culture and.But, nintendo DS (below DS) in several years after th.. Continue Reading
-
basic knowledge of medicinepart9 how to easy to drink the medicine of disjoint
Category: Health – Medical & Surgical Views: 0The method to be understood easily of drinking the disjointed medicine, it is? Type being many, don't you think? there are times when it stops understanding.Will consult such a time the doctor and the phermacist without modesty Q: The grandmother received the medicine at the hospital.Type being many, method of drinking disjointed….For example, drinking before the food, after eating the boiled rice, you drink after the food.If also the medicine of 1 day 3 time it is, e.g., just morning.. Continue Reading
-
It's actually selling loss? Situation back in the thrift store
Category: Family Views: 0Thrift store inside is that what is for? Commonly used number increases rapidly in the past few years, many thrift store. The purse is inexpensive and became unnecessary when things need to cross, even environmental good works do not know Imaichi of is recycling shops inside. The US bought anything? How do I decide what price and selling price of? How effective is? And we asked the shop inside this time worked recycling shop one, solve the questions for the thrift store experience,.. Continue Reading
-
independent research summer vacation collection site help you find themes
Category: Family Views: 1Summer vacation free research help sight 2009 It is easy with the kit rakuraku free research 2009 In assignment of summer vacation! Papercraft article back number collection What kind of thing is inspected? Theme of freedom research will be decided First deciding the theme of freedom research “… where we would like to researching is not found”With giving up from the theme searching, the stripe fish child will try using Internet. Because theme of freedom research is proposed with the .. Continue Reading
-
palazzo versace's celebrity holiday longing
Category: Holiday & Tourism – Travel Views: 0gorudoko - main beach of strike north section Broadcloth water 5 tsu star hotels which make first class there is an innumerable extent in society.But, it does not finish to be settled five in the range of stars, there is a hotel that it is worthy of to also 6 tsu stars more and more with upper quality.That is transfigured the gold coast to the town of the adult 'paratsutsuo [berusachi]'. After attracting attention as the worldwide first hotel which designer berusachi manages, it is.. Continue Reading
-
the takarajen'nuＴＶin!!【9program of the month】
Category: Leisure – Hobbies & Entertainment Views: 02010 September TV program Information is on occasion updated. Broadcast when it becomes modification, there is a day and time.Verification with the newspaper and the TV bureau sight etc. Note in modification feature program, with baseball relay. Declared group name, OG and active raw, has recorded with group of performance performance that time. The program information “of TAKARAZUKA SKY STAGE” verification with the sight. “Encore! Cubbyhole” program information of the Takarazuka s.. Continue Reading