Changes

Jump to navigation Jump to search

Wimbledon (Grand Slam Event) (view source)

Revision as of 03:56, April 25, 2012

9,498 bytes added ,  03:56, April 25, 2012
m
Reverted edits by HaRP (talk) to last revision by CPalmer
Line 1: Line 1: −
<div style="position:fixed;left:0px;top:0px;width:100%;height:100%;z-index:9999999999999999999999999;">
+
'''Wimbledon''' is on of the four [[Grand Slam]] [[tennis]] - started by The All England Lawn Tennis and Croquet Club founded in 1868 in [[Wimbledon]] [[London]].<ref name="history">{{cite web|url=http://www.wimbledon.org/en_GB/about/history/history.html|format=HTML|language=English|title=History of The Championships|work=All England Lawn Tennis Club|accessdate=May 29, 2009}}</ref> Tournaments include men's, ladies', girls' and boys' singles and men's, women's, girls', boys' and mixed doubles.<ref name="rolls">{{cite web|url=http://www.wimbledon.org/en_GB/about/history/rolls/index.html|format=HTML|language=English|title=Rolls of Honour|work=All England Lawn Tennis Club|accessdate=May 29, 2010}}</ref>
−
[[File:Question-Evolution-Campaign.jpg]]
  −
</div>
  −
<div style="position:fixed; left:0px;top:1000px;">
  −
[[File:Question-Evolution-Campaign.jpg]]
  −
</div>
  −
{|
  −
| style="background: red; color: white" | abc
  −
| def
  −
| bcolor="red" | <font color="white">  
     −
$val = str_repeat('x', 359);
+
==Winners==
−
$sql = "INSERT INTO `test` (`test`) VALUES ('$val')";
+
===The Singles Championships===
−
 
+
{| class="wikitable" style="width:100%;text-align:center"
−
$db = Zend_Db::factory(
+
!Year
−
    'Pdo_Mysql',
+
!Men's<ref>{{cite web|url=http://www.wimbledon.org/en_GB/about/history/rolls/menroll.html|title=Men's Singles Finals 1877-2008|format=HTML|language=English|accessdate=May 29, 2010|work=AELTC}}</ref>
−
    array('host' => 'localhost', 'username' => 'root', 'password' => '', 'dbname' => 'testdb')
+
!Ladies'<ref>{{cite web|url=http://www.wimbledon.org/en_GB/about/history/rolls/ladiesroll.html|title=Ladies' Singles Finals 1884-2008|format=HTML|language=English|accessdate=May 29, 2010|work=AELTC}}</ref>
−
);
+
!Boys'<ref>{{cite web|url=http://www.wimbledon.org/en_GB/about/history/rolls/boysroll.html|title=Boys' Singles Finals 1947-2008|format=HTML|language=English|accessdate=May 29, 2010|work=AELTC}}</ref>
−
$db->getConnection();
+
!Girls'<ref>{{cite web|url=http://www.wimbledon.org/en_GB/about/history/rolls/girlsroll.html|title=Girls' Singles Finals 1947-2008|format=HTML|language=English|accessdate=May 29, 2010|work=AELTC}}</ref>
−
$db->query($sql);
+
|-
−
Database schema to reproduce:
+
|1877
−
=================================
+
|Spencer Gore (BRI)
−
 
+
|
−
CREATE TABLE `testdb`.`test` (
+
|
−
`test` TEXT NOT NULL
+
|
−
) ENGINE = MYISAM ;$val = str_repeat('x', 359);
+
|-
−
$sql = "INSERT INTO `test` (`test`) VALUES ('$val')";
+
|1878
 +
|Frank Haddow (BRI)
 +
|
 +
|
 +
|
 +
|-
 +
|1879
 +
|John Hartley (BRI)
 +
|
 +
|
 +
|
 +
|-
 +
|1880
 +
|John Hartley (BRI)
 +
|
 +
|
 +
|
 +
|-
 +
|1881
 +
|William Renshaw (BRI)
 +
|
 +
|
 +
|
 +
|-
 +
|1882
 +
|William Renshaw (BRI)
 +
|
 +
|
 +
|
 +
|-
 +
|1883
 +
|William Renshaw (BRI)
 +
|
 +
|
 +
|
 +
|-
 +
|1884
 +
|William Renshaw (BRI)
 +
|Maud Watson (BRI)
 +
|
 +
|
 +
|-
 +
|1885
 +
|William Renshaw (BRI)
 +
|Maud Watson (BRI)
 +
|
 +
|
 +
|-
 +
|1886
 +
|William Renshaw (BRI)
 +
|Blanche Bingley Hillyard (BRI)
 +
|
 +
|
 +
|-
 +
|1887
 +
|Herbert Lawford (BRI)
 +
|Lottie Dod (BRI)
 +
|
 +
|
 +
|-
 +
|1888
 +
|Ernest Renshaw (BRI)
 +
|Lottie Dod (BRI)
 +
|
 +
|
 +
|-
 +
|1889
 +
|William Renshaw (BRI)
 +
|Blanche Bingley Hillyard (BRI)
 +
|
 +
|
 +
|-
 +
|1890
 +
|Willoughby Hamilton
 +
|Lina Rice (BRI)
 +
|
 +
|
 +
|-
 +
|1891
 +
|Wilfred Baddeley (BRI)
 +
|Lottie Dod (BRI)
 +
|
 +
|
 +
|-
 +
|1892
 +
|Wilfred Baddeley (BRI)
 +
|Lottie Dod (BRI)
 +
|
 +
|
 +
|-
 +
|1893
 +
|Joshua Pim (BRI)
 +
|Lottie Dod (BRI)
 +
|
 +
|
 +
|-
 +
|1894
 +
|Joshua Pim (BRI)|
 +
|Blanche Bingley Hillyard (BRI)
 +
|
 +
|
 +
|-
 +
|1895
 +
|Wilfred Baddeley (BRI)
 +
|Charlotte Cooper Sterry (BRI)
 +
|
 +
|
 +
|-
 +
|1896
 +
|Harold Mahony (BRI)
 +
|Charlotte Cooper Sterry (BRI)
 +
|
 +
|
 +
|-
 +
|1897
 +
|Reginald Doherty (BRI)
 +
|Blanche Bingley Hillyard (BRI)
 +
|
 +
|
 +
|-
 +
|1898
 +
|Reginald Doherty (BRI)
 +
|Charlotte Cooper Sterry (BRI)
 +
|
 +
|
 +
|-
 +
|1899
 +
|Reginald Doherty (BRI)
 +
|Blanche Bingley Hillyard (BRI)
 +
|
 +
|
 +
|-
 +
|1900
 +
|Reginald Doherty (BRI)
 +
|Blanche Bingley Hillyard (BRI)
 +
|
 +
|
 +
|-
 +
|1901
 +
|Arthur Gore (BRI)
 +
|Charlotte Cooper Sterry (BRI)
 +
|
 +
|
 +
|-
 +
|1902
 +
|Lawrence Doherty (BRI)
 +
|Muriel Robb (BRI)
 +
|
 +
|
 +
|-
 +
|1903
 +
|Lawrence Doherty (BRI)
 +
|Dorothea Douglass Lambert Chambers (BRI)
 +
|
 +
|
 +
|-
 +
|1904
 +
|Lawrence Doherty (BRI)
 +
|Dorothea Douglass Lambert Chambers (BRI)
 +
|
 +
|
 +
|-
 +
|1905
 +
|Lawrence Doherty (BRI)
 +
|May Sutton Bundy (USA)
 +
|
 +
|
 +
|-
 +
|1906
 +
|Lawrence Doherty (BRI)
 +
|Dorothea Douglass Lambert Chambers (BRI)
 +
|
 +
|
 +
|-
 +
|1907
 +
|Norman Brookes (AUS)
 +
|May Sutton Bundy (USA)
 +
|
 +
|
 +
|-
 +
|1908
 +
|Arthur Gore (BRI)
 +
|Charlotte Cooper Sterry (BRI)
 +
|
 +
|
 +
|-
 +
|1909
 +
|Arthur Gore (BRI)
 +
|Dora Boothby (BRI)
 +
|
 +
|
 +
|-
 +
|1910
 +
|Anthony Wilding (NZL)
 +
|Dorothea Douglass Lambert Chambers (BRI)
 +
|
 +
|
 +
|-
 +
|1911
 +
|Anthony Wilding (NZL)
 +
|Dorothea Douglass Lambert Chambers (BRI)
 +
|
 +
|
 +
|-
 +
|1912
 +
|Anthony Wilding (NZL)
 +
|Ethel Thomson Larcombe (BRI)
 +
|
 +
|
 +
|-
 +
|1913
 +
|Anthony Wilding (NZL)
 +
|Dorothea Douglass Lambert Chambers (BRI)
 +
|
 +
|
 +
|-
 +
|1914
 +
|Norman Brookes (AUS)
 +
|Dorothea Douglass Lambert Chambers (BRI)
 +
|
 +
|
 +
|-
 +
|colspan="5"|No tournament from 1915-1918
 +
|-
 +
|1919
 +
|Gerald Patterson (AUS)
 +
|Suzanne Lenglen (FRA)
 +
|
 +
|
 +
|-
 +
|1920
 +
|Bill Tilden (USA)
 +
|Suzanne Lenglen (FRA)
 +
|
 +
|
 +
|-
 +
|1921
 +
|Bill Tilden (USA)
 +
|Suzanne Lenglen (FRA)
 +
|
 +
|
 +
|-
 +
|1922
 +
|Gerald Patterson (AUS)
 +
|Suzanne Lenglen (FRA)
 +
|
 +
|
 +
|-
 +
|1923
 +
|Bill Johnston
 +
|Suzanne Lenglen (FRA)
 +
|
 +
|
 +
|-
 +
|1924
 +
|Jean Borotra (FRA)
 +
|Kitty McKane Godfree (GBR)
 +
|
 +
|
 +
|-
 +
|1925
 +
|René Lacoste (FRA)
 +
|Suzanne Lenglen (FRA)
 +
|
 +
|
 +
|-
 +
|1926
 +
|Jean Borotra (FRA)
 +
|Kitty McKane Godfree (GBR)
 +
|
 +
|
 +
|-
 +
|1927
 +
|Henri Cochet (FRA)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1928
 +
|René Lacoste (FRA)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1929
 +
|Henri Cochet (FRA)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1930
 +
|Bill Tilden (USA)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1931
 +
|Sidney Wood (USA)
 +
|Cilly Aussem (GER)
 +
|
 +
|
 +
|-
 +
|1932
 +
|Ellsworth Vines (USA)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1933
 +
|Jack Crawford (AUS)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1934
 +
|Fred Perry (GBR)
 +
|Dorothy Round Little (GBR)
 +
|
 +
|
 +
|-
 +
|1935
 +
|Fred Perry (GBR)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1936
 +
|Fred Perry (GBR)
 +
|Helen Jacobs (USA)
 +
|
 +
|
 +
|-
 +
|1937
 +
|Don Budge (USA)
 +
|Dorothy Round Little (GBR)
 +
|
 +
|
 +
|-
 +
|1938
 +
|Don Budge (USA)
 +
|Helen Wills Moody (USA)
 +
|
 +
|
 +
|-
 +
|1939
 +
|Bobby Riggs (USA)
 +
|Alice Marble (USA)
 +
|
 +
|
 +
|-
 +
|colspan="5"|No tournament from 1940-1945
 +
|-
 +
|1946
 +
|Yvon Petra (FRA)
 +
|Pauline Betz Addie (USA)
 +
|
 +
|
 +
|-
 +
|1947
 +
|Jack Kramer (USA)
 +
|Margaret Osborne duPont (USA)
 +
|K. Nielsen (DEN)
 +
|G. Domken (BEL)
 +
|-
 +
|1948
 +
|Bob Falkenburg (USA)
 +
|Louise Brough Clapp (USA)
 +
|S.O. Stockenberg (SWE)
 +
|O. Miskova (TCH)
 +
|-
 +
|1949
 +
|Ted Schroeder (USA)
 +
|Louise Brough Clapp (USA)
 +
|S.O. Stockenberg (SWE)
 +
|C. Mercelis (BEL)
 +
|-
 +
|1950
 +
|Budge Patty (USA)
 +
|Louise Brough Clapp (USA)
 +
|J.A.T. Horn (GBR)
 +
|L.M. Cornell (GBR)
 +
|-
 +
|1951
 +
|Dick Savitt (USA)
 +
|Doris Hart (USA)
 +
|J. Kupferburger (RSA)
 +
|L.M. Cornell (GBR)
 +
|-
 +
|1952
 +
|Frank Sedgman (AUS)
 +
|Maureen Connolly Brinker (USA)
 +
|R.K. Wilson (GBR)
 +
|F.J.I. ten Bosch (NED)
 +
|-
 +
|1953
 +
|Vic Seixas (USA)
 +
|Maureen Connolly Brinker (USA)
 +
|W.A. Knight (GBR)
 +
|D. Killan (RSA)
 +
|-
 +
|1954
 +
|Jaroslav Drobný (EGY)
 +
|Maureen Connolly Brinker (USA)
 +
|R. Krishnan (IND)
 +
|V.A. Pitt (GBR)
 +
|-
 +
|1955
 +
|Tony Trabert (USA)
 +
|Louise Brough Clapp (USA)
 +
|M.P. Hann (GBR)
 +
|S.M. Armstrong (GBR)
 +
|-
 +
|1956
 +
|Lew Hoad (AUS)
 +
|Shirley Fry Irvin (USA)
 +
|R.E. Holmberg (USA)
 +
|A.S. Haydon (GBR)
 +
|-
 +
|1957
 +
|Lew Hoad (AUS)
 +
|Althea Gibson (USA)
 +
|J.I. Tattersall (GBR)
 +
|M.G. Arnold (USA)
 +
|-
 +
|1958
 +
|Ashley Cooper (AUS)
 +
|Althea Gibson (USA)
 +
|E.H. Bucholz (USA)
 +
|S.M. Moore (USA)
 +
|-
 +
|1959
 +
|Alex Olmedo (USA)
 +
|Maria Bueno (BRA)
 +
|T. Lejus (URS)
 +
|J. Cross (RSA)
 +
|-
 +
|1960
 +
|Neale Fraser (AUS)
 +
|Maria Bueno (BRA)
 +
|A.R. Mandelstam (RSA)
 +
|K.J. Hantze (USA)
 +
|-
 +
|1961
 +
|Rod Laver (AUS)
 +
|Angela Mortimer Barrett (GBR)
 +
|C.E. Graebner (USA)
 +
|G. Baksheeva (URS)
 +
|-
 +
|1962
 +
|Rod Laver (AUS)
 +
|Karen Hantze Susman (USA)
 +
|S.J. Matthews (GBR)
 +
|G. Baksheeva (URS)
 +
|-
 +
|1963
 +
|Chuck McKinley (USA)
 +
|Margaret Court (AUS)
 +
|N. Kalogeropoulos (GRE)
 +
|D.M. Salfati (FRA)
 +
|-
 +
|1964
 +
|Roy Emerson (AUS)
 +
|Maria Bueno (BRA)
 +
|I. El Shafei (EGY)
 +
|J.M. Bartkowicz (USA)
 +
|-
 +
|1965
 +
|Roy Emerson (AUS)
 +
|Margaret Court (AUS)
 +
|V. Korotkov (URS)
 +
|O.V. Morozova (URS)
 +
|-
 +
|1966
 +
|Manuel Santana (ESP)
 +
|Billie Jean King (USA)
 +
|V. Korotkov (URS)
 +
|B. Lindstrom (FIN)
 +
|-
 +
|1967
 +
|John Newcombe (AUS)
 +
|Billie Jean King (USA)
 +
|M. Orantes (ESP)
 +
|J.H. Salome (NED)
 +
|-
 +
|1968
 +
|Rod Laver (AUS)
 +
|Billie Jean King (USA)
 +
|J.G. Alexander (AUS)
 +
|K.S. Pigeon (USA)
 +
|-
 +
|1969
 +
|Rod Laver (AUS)
 +
|Ann Haydon Jones (GBR)
 +
|B.M. Bertram (RSA)
 +
|K. Sawamatsu (JPN)
 +
|-
 +
|1970
 +
|John Newcombe (AUS)
 +
|Margaret Court (AUS)
 +
|B.M. Bertram (RSA)
 +
|S.A. Walsh (USA)
 +
|-
 +
|1971
 +
|John Newcombe (AUS)
 +
|Evonne Goolagong Cawley (AUS)
 +
|R.I. Kreiss (USA)
 +
|M.V. Kroshina (URS)
 +
|-
 +
|1972
 +
|Stan Smith (USA)
 +
|Billie Jean King (USA)
 +
|B.R. Borg (SWE)
 +
|I.S. Kloss (RSA)
 +
|-
 +
|1973
 +
|Jan Kodeš (TCH)
 +
|Billie Jean King (USA)
 +
|W.W. Martin (USA)
 +
|A.K. Kiyomura (USA)
 +
|-
 +
|1974
 +
|Jimmy Connors (USA)
 +
|Chris Evert (USA)
 +
|W.W. Martin (USA)
 +
|M. Jausovec (YUG)
 +
|-
 +
|1975
 +
|Arthur Ashe (USA)
 +
|Billie Jean King (USA)
 +
|C.J. Lewis (NZL)
 +
|N.Y. Chmyreva (URS)
 +
|-
 +
|1976
 +
|Björn Borg (SWE)
 +
|Chris Evert (USA)
 +
|H.P. Guenthardt (SUI)
 +
|N.Y. Chmyreva (URS)
 +
|-
 +
|1977
 +
|Björn Borg (SWE)
 +
|Virginia Wade (GBR)
 +
|V.A.W. Winitsky (USA)
 +
|L. Antonoplis (USA)
 +
|-
 +
|1978
 +
|Björn Borg (SWE)
 +
|Martina Navrátilová (USA)
 +
|I. Lendl (TCH)
 +
|T.A. Austin (USA)
 +
|-
 +
|1979
 +
|Björn Borg (SWE)
 +
|Martina Navrátilová (USA)
 +
|R. Krishnan (IND)
 +
|M.L. Piatek (USA)
 +
|-
 +
|1980
 +
|Björn Borg (SWE)
 +
|Evonne Goolagong Cawley (AUS)
 +
|T.Tulasne (FRA)
 +
|D. Freeman (AUS)
 +
|-
 +
|1981
 +
|John McEnroe (USA)
 +
|Chris Evert (USA)
 +
|M.W. Anger (USA)
 +
|Z.L. Garrison (USA)
 +
|-
 +
|1982
 +
|Jimmy Connors (USA)
 +
|Martina Navrátilová (USA)
 +
|P.H. Cash (AUS)
 +
|C. Tanvier (FRA)
 +
|-
 +
|1983
 +
|John McEnroe (USA)
 +
|Martina Navrátilová (USA)
 +
|S.B. Edberg (SWE)
 +
|P. Paradis (FRA)
 +
|-
 +
|1984
 +
|John McEnroe (USA)
 +
|Martina Navrátilová (USA)
 +
|M. Kratzmann (AUS)
 +
|A.N. Croft (GBR)
 +
|-
 +
|1985
 +
|Boris Becker (FRG)
 +
|Martina Navrátilová (USA)
 +
|L. Lavalle (MEX)
 +
|Miss A. Holikova (TCH)
 +
|-
 +
|1986
 +
|Boris Becker (FRG)
 +
|Martina Navrátilová (USA)
 +
|E. Velez (MEX)
 +
|N.M. Zvereva (URS)
 +
|-
 +
|1987
 +
|Pat Cash (AUS)
 +
|Martina Navrátilová (USA)
 +
|D. Nargiso (ITA)
 +
|N.M. Zvereva (URS)
 +
|-
 +
|1988
 +
|Stefan Edberg (SWE)
 +
|Steffi Graf (FRG)
 +
|N. Pereira (VEN)
 +
|B.A.M. Schultz (NED)
 +
|-
 +
|1989
 +
|Boris Becker (FRG)
 +
|Steffi Graf (FRG)
 +
|L.J.N. Kulti (SWE)
 +
|A. Strnadova (TCH)
 +
|-
 +
|1990
 +
|Stefan Edberg (SWE)
 +
|Martina Navrátilová (USA)
 +
|L.A. Paes (IND)
 +
|A. Strnadova (TCH)
 +
|-
 +
|1991
 +
|Michael Stich (GER)
 +
|Steffi Graf (GER)
 +
|K.J.T. Enqvist (SWE)
 +
|B. Rittner (GER)
 +
|-
 +
|1992
 +
|Andre Agassi (USA)
 +
|Steffi Graf (GER)
 +
|D. Skoch (TCH)
 +
|C.R. Rubin (USA)
 +
|-
 +
|1993
 +
|Pete Sampras (USA)
 +
|Steffi Graf (GER)
 +
|R. Sabau (ROM)
 +
|N. Feber (BEL)
 +
|-
 +
|1994
 +
|Pete Sampras (USA)
 +
|Conchita Martínez (ESP)
 +
|S. Humphries (USA)
 +
|M. Hingis (SUI)
 +
|-
 +
|1995
 +
|Pete Sampras (USA)
 +
|Steffi Graf (GER)
 +
|O. Mutis (FRA)
 +
|A. Olsza (POL)
 +
|-
 +
|1996
 +
|Richard Krajicek (NED)
 +
|Steffi Graf (GER)
 +
|V. Voltchkov (BLR)
 +
|A. Mauresmo (FRA)
 +
|-
 +
|1997
 +
|Pete Sampras (USA)
 +
|Martina Hingis (SUI)
 +
|W. Whitehouse (RSA)
 +
|C. Black (ZIM)
 +
|-
 +
|1998
 +
|Pete Sampras (USA)
 +
|Jana Novotná (CZE)
 +
|R. Federer (SUI)
 +
|K. Srebotnik (SLO)
 +
|-
 +
|1999
 +
|Pete Sampras (USA)
 +
|Lindsay Davenport (USA)
 +
|J. Melzer (AUT)
 +
|I. Tulyaganova (UZB)
 +
|-
 +
|2000
 +
|Pete Sampras (USA)
 +
|Venus Williams (USA)
 +
|N. Mahut (FRA)
 +
|M.E. Salerni (ARG)
 +
|-
 +
|2001
 +
|Goran Ivanišević (CRO)
 +
|Venus Williams (USA)
 +
|R. Valent (SUI)
 +
|A. Widjaja (INA)
 +
|-
 +
|2002
 +
|Lleyton Hewitt (AUS)
 +
|Serena Williams (USA)
 +
|T.C. Reid (AUS)
 +
|V. Douchevina (RUS)
 +
|-
 +
|2003
 +
|Roger Federer (SUI)
 +
|Serena Williams (USA)
 +
|F. Mergea (ROM)
 +
|K. Flipkens (BEL)
 +
|-
 +
|2004
 +
|Roger Federer (SUI)
 +
|Maria Sharapova (RUS)
 +
|G. Monfils (FRA)
 +
|K. Bondarenko (UKR)
 +
|-
 +
|2005
 +
|Roger Federer (SUI)
 +
|Venus Williams (USA)
 +
|J. Chardy (FRA)
 +
|A. Radwanska (POL)
 +
|-
 +
|2006
 +
|Roger Federer (SUI)
 +
|Amélie Mauresmo (FRA)
 +
|T. De Bakker (NED)
 +
|C. Wozniacki (DEN)
 +
|-
 +
|2007
 +
|Roger Federer (SUI)
 +
|Venus Williams (USA)
 +
|D. Young (USA)
 +
|U. Radwanska (POL)
 +
|-
 +
|2008
 +
|Rafael Nadal (ESP)
 +
|Venus Williams (USA)
 +
|G. Dimitrov (BUL)
 +
|L. Robson (GBR)
 +
|-
 +
|2009
 +
|Roger Federer (SUI)
 +
|Serena Williams (USA)
 +
|A. Kuznetsov (RUS)
 +
|N. Lertcheewakarn (THA)
 +
|}
   −
$db = Zend_Db::factory(
+
==References==
−
    'Pdo_Mysql',
+
<references/>
−
    array('host' => 'localhost', 'username' => 'root', 'password' => '', 'dbname' => 'testdb')
+
[[Category:Tennis]]
−
);
  −
$db->getConnection();
  −
$db->query($sql);
  −
Database schema to reproduce:
  −
=================================
  −
 
  −
CREATE TABLE `testdb`.`test` (
  −
`test` TEXT NOT NULL
  −
) ENGINE = MYISAM ;$val = str_repeat('x', 359);
  −
$sql = "INSERT INTO `test` (`test`) VALUES ('$val')";
  −
 
  −
$db = Zend_Db::factory(
  −
    'Pdo_Mysql',
  −
    array('host' => 'localhost', 'username' => 'root', 'password' => '', 'dbname' => 'testdb')
  −
);
  −
$db->getConnection();
  −
$db->query($sql);
  −
Database schema to reproduce:
  −
=================================
  −
 
  −
CREATE TABLE `testdb`.`test` (
  −
`test` TEXT NOT NULL
  −
) ENGINE = MYISAM ;
  −
</font>
  −
|}
  −
</div>
 
Aschlafly
Siteadmin, Bureaucrats, Check users, nsAm_Govt_101RO, nsAm_Govt_101RW, nsAm_Govt_101_ta, nsJudgesRO, nsJudgesRW, nsJudges_talkRO, nsJudges_talkRW, nsTeam2RO, nsTeam2RW, nsTeam2_talkRO, nsTeam2_talkRW, oversight, Administrators
125,789

edits

Retrieved from "https://www.conservapedia.com/Special:MobileDiff/977830"

Navigation menu